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
17130000098223L17/debats17171300000970351713000009822210M. Boris Vallaud719930
17130000098225L17/debats17171300000970351713000009822410M. Vincent Descoeur330909
17130000098227L17/debats17171300000970351713000009822610M. Boris Vallaud719930
17130000098229L17/debats17171300000970351713000009822810Mme Émilie Bonnivard721410
17130000098231L17/debats17171300000970351713000009823010M. Boris Vallaud719930
17130000098233L17/debats17171300000970351713000009823210M. Vincent Descoeur330909
17130000098235L17/debats17171300000970351713000009823410M. Boris Vallaud719930
17130000098237L17/debats17171300000970351713000009823610M. François Cormier-Bouligeon719118
17130000098239L17/debats17171300000970351713000009823810M. Vincent Descoeur330909
17130000098241L17/debats17171300000970351713000009824010M. Boris Vallaud719930
17130000098243L17/debats17171300000970351713000009824210M. Jean-Yves Bony266793
17130000098245L17/debats17171300000970351713000009824410M. François Cormier-Bouligeon719118
17130000098247L17/debats17171300000970351713000009824610M. Boris Vallaud719930
17130000098249L17/debats17171300000970351713000009824810M. Matthias Tavel794166
17130000098251L17/debats17171300000970351713000009825010M. Boris Vallaud719930
17130000098253L17/debats17171300000970351713000009825210M. Julien Dive712015
17130000098255L17/debats17171300000970351713000009825410M. Boris Vallaud719930
17130000098257L17/debats17171300000970351713000009825610M. Hervé Berville719218
17130000098259L17/debats17171300000970351713000009825810M. François Cormier-Bouligeon719118
17130000098261L17/debats17171300000970351713000009826010M. Boris Vallaud719930
17130000098263L17/debats17171300000970351713000009826210M. Jean-René Cazeneuve719472
17130000098265L17/debats17171300000970351713000009826410M. Boris Vallaud719930
17130000098267L17/debats17171300000970351713000009826610M. François Cormier-Bouligeon719118
17130000098269L17/debats17171300000970351713000009826810M. Boris Vallaud719930
17130000098271L17/debats17171300000970351713000009827010Mme Stéphanie Rist720066
17130000098273L17/debats17171300000970351713000009827210M. Boris Vallaud719930
17130000098275L17/debats17171300000970351713000009827410M. Pierre Cordier718850
17130000098277L17/debats17171300000970351713000009827610M. Boris Vallaud719930
17130000098279L17/debats17171300000970351713000009827810M. Yannick Neuder794038
17130000098281L17/debats17171300000970351713000009828010M. Boris Vallaud719930
17130000098283L17/debats17171300000970351713000009828210Mme Olivia Grégoire721764
17130000098285L17/debats17171300000970351713000009828410M. Philippe Gosselin266797
17130000098287L17/debats17171300000970351713000009828610M. Boris Vallaud719930
17130000098289L17/debats17171300000970351713000009828810M. Antoine Vermorel-Marques794118
17130000098291L17/debats17171300000970351713000009829010M. Hervé Berville719218
17130000098293L17/debats17171300000970351713000009829210M. Boris Vallaud719930
17130000098295L17/debats17171300000970351713000009829410Mme Aurore Bergé722046
17130000098297L17/debats17171300000970351713000009829610M. Hervé Berville719218
17130000098299L17/debats17171300000970351713000009829810M. Boris Vallaud719930
17130000098301L17/debats17171300000970351713000009830010Mme Aurore Bergé722046
17130000098303L17/debats17171300000970351713000009830210M. Boris Vallaud719930
17130000098305L17/debats17171300000970351713000009830410M. Vincent Descoeur330909
17130000098307L17/debats17171300000970351713000009830610M. Boris Vallaud719930
17130000098309L17/debats17171300000970351713000009830810M. Dominique Potier607553
17130000098311L17/debats17171300000970351713000009831010M. Benjamin Dirx722382
17130000098313L17/debats17171300000970351713000009831210M. Boris Vallaud719930
17130000098315L17/debats17171300000970351713000009831410Mme Eliane Kremer722328
17130000098317L17/debats17171300000970351713000009831610M. Boris Vallaud719930
17130000098319L17/debats17171300000970351713000009831810Mme la présidente721908
17130000098321L17/debats17171300000970351713000009832010M. Ian Boucard721816