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 %

359 363 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
17130000002053L17/debats17171300000003461713000000205210Mme Dominique Voynet2940
17130000002055L17/debats17171300000003461713000000205410M. Gaëtan Dussausaye842073
17130000002057L17/debats17171300000003461713000000205610M. Benjamin Lucas-Lundy795636
17130000002059L17/debats17171300000003461713000000205810M. Gaëtan Dussausaye842073
17130000002061L17/debats17171300000003461713000000206010Mme Marie Mesmeur841215
17130000002063L17/debats17171300000003461713000000206210M. Gaëtan Dussausaye842073
17130000002065L17/debats17171300000003461713000000206410M. Benjamin Lucas-Lundy795636
17130000002067L17/debats17171300000003461713000000206610M. Gaëtan Dussausaye842073
17130000002069L17/debats17171300000003461713000000206810M. Stéphane Vojetta721170
17130000002071L17/debats17171300000003461713000000207010M. Gaëtan Dussausaye842073
17130000002073L17/debats17171300000003461713000000207210M. Inaki Echaniz794854
17130000002074L17/debats17171300000003461713000000207220M. Benjamin Lucas-Lundy795636
17130000002075L17/debats17171300000003461713000000207230Mme Marie Pochon793664
17130000002077L17/debats17171300000003461713000000207610M. Gaëtan Dussausaye842073
17130000002079L17/debats17171300000003461713000000207810Mme Marie Mesmeur841215
17130000002081L17/debats17171300000003461713000000208010M. Gaëtan Dussausaye842073
17130000002083L17/debats17171300000003461713000000208210M. Benjamin Lucas-Lundy795636
17130000002085L17/debats17171300000003461713000000208410M. Gaëtan Dussausaye842073
17130000002087L17/debats17171300000003461713000000208610M. Jean-Philippe Tanguy795778
17130000002089L17/debats17171300000003461713000000208810M. Gaëtan Dussausaye842073
17130000002091L17/debats17171300000003461713000000209010M. Benjamin Lucas-Lundy795636
17130000002093L17/debats17171300000003461713000000209210M. Gaëtan Dussausaye842073
17130000002095L17/debats17171300000003461713000000209410M. Inaki Echaniz794854
17130000002097L17/debats17171300000003461713000000209610M. Gaëtan Dussausaye842073
17130000002099L17/debats17171300000003461713000000209810Mme Mathilde Panot720892
17130000002101L17/debats17171300000003461713000000210010M. Gaëtan Dussausaye842073
17130000002103L17/debats17171300000003461713000000210210Mme Marie Mesmeur841215
17130000002105L17/debats17171300000003461713000000210410M. Gaëtan Dussausaye842073
17130000002107L17/debats17171300000003461713000000210610Mme la présidente721908
17130000002109L17/debats17171300000003461713000000210810M. Inaki Echaniz794854
17130000002111L17/debats17171300000003461713000000211010M. Stéphane Vojetta (EPR)721170
17130000002113L17/debats17171300000003461713000000211210M. Jean-Philippe Tanguy795778
17130000002115L17/debats17171300000003461713000000211410Mme Constance Le Grip345722
17130000002117L17/debats17171300000003461713000000211610M. Stéphane Vojetta721170
17130000002119L17/debats17171300000003461713000000211810M. Jean-Philippe Tanguy795778
17130000002121L17/debats17171300000003461713000000212010M. Stéphane Vojetta721170
17130000002123L17/debats17171300000003461713000000212210M. Benjamin Lucas-Lundy795636
17130000002125L17/debats17171300000003461713000000212410M. Stéphane Vojetta721170
17130000002127L17/debats17171300000003461713000000212610Mme Mathilde Panot720892
17130000002129L17/debats17171300000003461713000000212810M. Stéphane Vojetta721170
17130000002131L17/debats17171300000003461713000000213010M. Inaki Echaniz794854
17130000002133L17/debats17171300000003461713000000213210M. Stéphane Vojetta721170
17130000002135L17/debats17171300000003461713000000213410M. Inaki Echaniz794854
17130000002137L17/debats17171300000003461713000000213610M. Stéphane Vojetta721170
17130000002139L17/debats17171300000003461713000000213810M. Inaki Echaniz794854
17130000002141L17/debats17171300000003461713000000214010M. Stéphane Vojetta721170
17130000002143L17/debats17171300000003461713000000214210M. Inaki Echaniz794854
17130000002145L17/debats17171300000003461713000000214410M. Stéphane Vojetta721170
17130000002147L17/debats17171300000003461713000000214610M. Benjamin Lucas-Lundy795636
17130000002149L17/debats17171300000003461713000000214810M. Stéphane Vojetta721170