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 %

382 192 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
17130000196505L17/debats17171300001951841713000019650410M. Jean-François Rousset793270
17130000196507L17/debats17171300001951841713000019650610M. Yannick Neuder794038ministre
17130000196509L17/debats17171300001951841713000019650810M. Christophe Bentz794434
17130000196511L17/debats17171300001951841713000019651010M. Yannick Neuder794038ministre
17130000196513L17/debats17171300001951841713000019651210M. Philippe Vigier331582
17130000196515L17/debats17171300001951841713000019651410M. Yannick Neuder794038ministre
17130000196517L17/debats17171300001951841713000019651610M. Vincent Descoeur330909
17130000196518L17/debats17171300001951841713000019651620M. Fabrice Brun718838
17130000196520L17/debats17171300001951841713000019651910M. Yannick Neuder794038ministre
17130000196522L17/debats17171300001951841713000019652110Mme Stéphanie Rist720066
17130000196524L17/debats17171300001951841713000019652310M. Jean-François Rousset793270
17130000196526L17/debats17171300001951841713000019652510M. Yannick Neuder794038ministre
17130000196528L17/debats17171300001951841713000019652710Mme Marie Pochon793664
17130000196529L17/debats17171300001951841713000019652720M. Hadrien Clouet793736
17130000196531L17/debats17171300001951841713000019653010M. Yannick Neuder794038ministre
17130000196533L17/debats17171300001951841713000019653210M. Jean-Claude Raux794154
17130000196535L17/debats17171300001951841713000019653410M. Yannick Neuder794038ministre
17130000196537L17/debats17171300001951841713000019653610M. Fabrice Brun718838
17130000196539L17/debats17171300001951841713000019653810M. Yannick Neuder794038ministre
17130000196541L17/debats17171300001951841713000019654010M. Nicolas Sansu605745
17130000196543L17/debats17171300001951841713000019654210M. Yannick Neuder794038ministre
17130000196545L17/debats17171300001951841713000019654410M. Thibault Bazin642847
17130000196547L17/debats17171300001951841713000019654610M. Yannick Neuder794038ministre
17130000196549L17/debats17171300001951841713000019654810M. Thibault Bazin642847
17130000196551L17/debats17171300001951841713000019655010M. Yannick Neuder794038ministre
17130000196553L17/debats17171300001951841713000019655210M. Fabrice Brun718838
17130000196555L17/debats17171300001951841713000019655410M. Yannick Neuder794038ministre
17130000196557L17/debats17171300001951841713000019655610M. Jean-Yves Bony266793
17130000196558L17/debats17171300001951841713000019655620M. Thibault Bazin642847
17130000196560L17/debats17171300001951841713000019655910M. Yannick Neuder794038ministre
17130000196562L17/debats17171300001951841713000019656110M. Jean-Yves Bony266793
17130000196564L17/debats17171300001951841713000019656310M. Yannick Neuder794038ministre
17130000196566L17/debats17171300001951841713000019656510M. Nicolas Sansu605745
17130000196568L17/debats17171300001951841713000019656710M. Yannick Neuder794038ministre
17130000196570L17/debats17171300001951841713000019656910Mme Delphine Batho335999
17130000196572L17/debats17171300001951841713000019657110M. Yannick Neuder794038ministre
17130000196574L17/debats17171300001951841713000019657310M. Fabrice Brun718838
17130000196575L17/debats17171300001951841713000019657320M. Vincent Descoeur330909
17130000196577L17/debats17171300001951841713000019657610M. Yannick Neuder794038ministre
17130000196579L17/debats17171300001951841713000019657810M. Nicolas Sansu605745
17130000196581L17/debats17171300001951841713000019658010M. Yannick Neuder794038ministre
17130000196583L17/debats17171300001951841713000019658210M. le président330008
17130000196630L17/debats17171300001965871713000019662910Mme la présidente795310
17130000196654L17/debats17171300001965871713000019665310Mme la présidente795310
17130000196656L17/debats17171300001965871713000019665510Mme Nathalie Colin-Oesterlé841431
17130000196658L17/debats17171300001965871713000019665710M. Thierry Benoit332228
17130000196660L17/debats17171300001965871713000019665910Mme Nathalie Colin-Oesterlé841431
17130000196662L17/debats17171300001965871713000019666110M. Nicolas Sansu605745
17130000196664L17/debats17171300001965871713000019666310Mme Nathalie Colin-Oesterlé841431
17130000196666L17/debats17171300001965871713000019666510Mme Stéphanie Rist720066