AN · données ouvertes
Explorateur / debats

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
17130000101326L17/debats17171300001006511713000010132510M. Pierre Cordier718850
17130000101328L17/debats17171300001006511713000010132710Mme Mathilde Panot720892
17130000101330L17/debats17171300001006511713000010132910M. François Cormier-Bouligeon719118
17130000101332L17/debats17171300001006511713000010133110M. Pierre Cordier718850
17130000101334L17/debats17171300001006511713000010133310Mme Mathilde Panot720892
17130000101336L17/debats17171300001006511713000010133510M. Emeric Salmon794954
17130000101338L17/debats17171300001006511713000010133710Mme Mathilde Panot720892
17130000101340L17/debats17171300001006511713000010133910Mme Olivia Grégoire721764
17130000101342L17/debats17171300001006511713000010134110Mme Mathilde Panot720892
17130000101344L17/debats17171300001006511713000010134310Mme Sophia Chikirou791812
17130000101346L17/debats17171300001006511713000010134510Mme Mathilde Panot720892
17130000101348L17/debats17171300001006511713000010134710M. Pierre Cordier718850
17130000101350L17/debats17171300001006511713000010134910Mme Mathilde Panot720892
17130000101352L17/debats17171300001006511713000010135110M. Philippe Vigier331582
17130000101354L17/debats17171300001006511713000010135310M. Pierre Cordier718850
17130000101356L17/debats17171300001006511713000010135510Mme Mathilde Panot720892
17130000101358L17/debats17171300001006511713000010135710M. François Cormier-Bouligeon719118
17130000101360L17/debats17171300001006511713000010135910Mme Mathilde Panot720892
17130000101362L17/debats17171300001006511713000010136110Mme Marie Mesmeur841215
17130000101364L17/debats17171300001006511713000010136310Mme Mathilde Panot720892
17130000101366L17/debats17171300001006511713000010136510M. Laurent Croizier793716
17130000101368L17/debats17171300001006511713000010136710Mme Mathilde Panot720892
17130000101370L17/debats17171300001006511713000010136910M. François Cormier-Bouligeon719118
17130000101372L17/debats17171300001006511713000010137110Mme Mathilde Panot720892
17130000101374L17/debats17171300001006511713000010137310M. Pierre Cordier718850
17130000101376L17/debats17171300001006511713000010137510Mme Mathilde Panot720892
17130000101378L17/debats17171300001006511713000010137710Mme Sophia Chikirou791812
17130000101380L17/debats17171300001006511713000010137910Mme Mathilde Panot720892
17130000101382L17/debats17171300001006511713000010138110M. Pierre Cordier718850
17130000101384L17/debats17171300001006511713000010138310Mme Mathilde Panot720892
17130000101386L17/debats17171300001006511713000010138510Mme la présidente721908
17130000101388L17/debats17171300001006511713000010138710M. Boris Vallaud (SOC)719930
17130000101390L17/debats17171300001006511713000010138910Plusieurs députés du groupe DR0
17130000101392L17/debats17171300001006511713000010139110M. Boris Vallaud719930
17130000101394L17/debats17171300001006511713000010139310Mme Marie-Christine Dalloz332523
17130000101396L17/debats17171300001006511713000010139510M. Boris Vallaud719930
17130000101398L17/debats17171300001006511713000010139710M. Pierre Cordier718850
17130000101400L17/debats17171300001006511713000010139910M. Boris Vallaud719930
17130000101402L17/debats17171300001006511713000010140110M. Hervé Berville719218
17130000101404L17/debats17171300001006511713000010140310M. Boris Vallaud719930
17130000101406L17/debats17171300001006511713000010140510M. Hervé Berville719218
17130000101408L17/debats17171300001006511713000010140710M. Boris Vallaud719930
17130000101410L17/debats17171300001006511713000010140910M. Pierre Cordier718850
17130000101412L17/debats17171300001006511713000010141110M. Boris Vallaud719930
17130000101414L17/debats17171300001006511713000010141310M. Hervé Berville719218
17130000101416L17/debats17171300001006511713000010141510M. Boris Vallaud719930
17130000101418L17/debats17171300001006511713000010141710Mme Nadège Abomangoli795228
17130000101420L17/debats17171300001006511713000010141910M. Boris Vallaud719930
17130000101422L17/debats17171300001006511713000010142110Mme Clémence Guetté795310
17130000101424L17/debats17171300001006511713000010142310M. Boris Vallaud719930