Aller au contenu
blackout

debats.compte_rendu_point_paragraphe_orateur

Chemin compteRendu.contenu.point.paragraphe.orateurs.orateur · présence : L17 100 %, L16 100 %, L15 100 %

361 013 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7_parent_recursif_idBIGINT_id de la ligne de même table qui contient celle-ci (structure récursive)
8_niveauBIGINTprofondeur dans la structure récursive (0 = premier niveau)
9nomVARCHARcompteRendu.contenu.point.paragraphe.orateurs.orateur.nom · présence : L17 100 %, L16 100 %, L15 100 %
10idBIGINTcompteRendu.contenu.point.paragraphe.orateurs.orateur.id · présence : L17 100 %, L16 100 %, L15 89 % · XSD 2016 : Identifiant du programme (dans l’amendement ? l'id est local à l'amendement ? je ne pense pas)
11qualiteVARCHARcompteRendu.contenu.point.paragraphe.orateurs.orateur.qualite · présence : L17 100 %, L16 100 %, L15 100 % · XSD 2016 : Rapporteur, rapporteur pour avis, général, spécial, intervenant. Ne pas mettre auteur et cosignataire. Utilisé également pour la spécialité du rapporteur sur le PLF
12acteur_refVARCHARcompteRendu.contenu.point.paragraphe.orateurs.orateur.acteurRef · présence : L15 11 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordre_parent_recursif_id_niveaunomidqualiteacteur_ref
17130000146287L17/debats17171300001460521713000014628610M. Charles Sitzenstuhl794802
17130000146289L17/debats17171300001460521713000014628810Mme Clémentine Autain588884
17130000146291L17/debats17171300001460521713000014629010M. Charles Sitzenstuhl794802
17130000146293L17/debats17171300001460521713000014629210Mme Clémentine Autain588884
17130000146295L17/debats17171300001460521713000014629410M. Emeric Salmon794954
17130000146297L17/debats17171300001460521713000014629610Mme Clémentine Autain588884
17130000146299L17/debats17171300001460521713000014629810M. Mathieu Lefèvre795386
17130000146301L17/debats17171300001460521713000014630010M. Charles Sitzenstuhl794802
17130000146303L17/debats17171300001460521713000014630210Mme Clémentine Autain588884
17130000146305L17/debats17171300001460521713000014630410M. Mathieu Lefèvre795386
17130000146307L17/debats17171300001460521713000014630610Mme Clémentine Autain588884
17130000146309L17/debats17171300001460521713000014630810Mme Sophie Taillé-Polian736201
17130000146311L17/debats17171300001460521713000014631010Mme Clémentine Autain588884
17130000146313L17/debats17171300001460521713000014631210M. Charles Sitzenstuhl794802
17130000146315L17/debats17171300001460521713000014631410M. Alexis Corbière721210
17130000146317L17/debats17171300001460521713000014631610Mme Clémentine Autain588884
17130000146319L17/debats17171300001460521713000014631810M. Alexis Corbière721210
17130000146321L17/debats17171300001460521713000014632010Mme Clémentine Autain588884
17130000146323L17/debats17171300001460521713000014632210Mme Sophie Taillé-Polian736201
17130000146325L17/debats17171300001460521713000014632410Mme Clémentine Autain588884
17130000146327L17/debats17171300001460521713000014632610Mme la présidente795228
17130000146329L17/debats17171300001460521713000014632810M. Alexis Corbière721210
17130000146331L17/debats17171300001460521713000014633010M. Emmanuel Mandon794114
17130000146333L17/debats17171300001460521713000014633210Mme Sandra Regol794778
17130000146335L17/debats17171300001460521713000014633410M. Emmanuel Mandon794114
17130000146337L17/debats17171300001460521713000014633610M. Alexis Corbière721210
17130000146339L17/debats17171300001460521713000014633810M. Emmanuel Mandon794114
17130000146341L17/debats17171300001460521713000014634010Mme Sandra Regol794778
17130000146343L17/debats17171300001460521713000014634210M. Emmanuel Mandon794114
17130000146345L17/debats17171300001460521713000014634410M. Alexis Corbière721210
17130000146347L17/debats17171300001460521713000014634610M. Emmanuel Mandon794114
17130000146349L17/debats17171300001460521713000014634810Mme Sandra Regol794778
17130000146351L17/debats17171300001460521713000014635010M. Emmanuel Mandon794114
17130000146353L17/debats17171300001460521713000014635210M. Alexis Corbière721210
17130000146355L17/debats17171300001460521713000014635410M. Emmanuel Mandon794114
17130000146357L17/debats17171300001460521713000014635610M. Aurélien Le Coq841515
17130000146359L17/debats17171300001460521713000014635810Mme Sandra Regol794778
17130000146361L17/debats17171300001460521713000014636010M. Emmanuel Mandon794114
17130000146363L17/debats17171300001460521713000014636210M. Maxime Laisney795516
17130000146365L17/debats17171300001460521713000014636410M. Emmanuel Mandon794114
17130000146367L17/debats17171300001460521713000014636610Mme Christine Arrighi793780
17130000146369L17/debats17171300001460521713000014636810M. Emmanuel Mandon794114
17130000146371L17/debats17171300001460521713000014637010Mme Christine Arrighi793780
17130000146373L17/debats17171300001460521713000014637210M. Emmanuel Mandon794114
17130000146375L17/debats17171300001460521713000014637410M. Jean-Paul Mattei720728
17130000146377L17/debats17171300001460521713000014637610M. Emmanuel Mandon794114
17130000146379L17/debats17171300001460521713000014637810M. Mathieu Lefèvre795386
17130000146381L17/debats17171300001460521713000014638010M. Emmanuel Mandon794114
17130000146383L17/debats17171300001460521713000014638210M. Alexis Corbière721210
17130000146385L17/debats17171300001460521713000014638410M. Emmanuel Mandon794114