Aller au contenu
blackout

debats.compte_rendu_point_inter_extraction_paragraphe_orateur

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

961 072 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.interExtraction.paragraphe.orateurs.orateur.nom · présence : L17 89 %, L16 99 %, L15 100 %
10idBIGINTcompteRendu.contenu.point.interExtraction.paragraphe.orateurs.orateur.id · présence : L17 89 %, L16 99 %, L15 88 % · XSD 2016 : Identifiant du programme (dans l’amendement ? l'id est local à l'amendement ? je ne pense pas)
11qualiteVARCHARcompteRendu.contenu.point.interExtraction.paragraphe.orateurs.orateur.qualite · présence : L17 89 %, L16 99 %, 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.interExtraction.paragraphe.orateurs.orateur.acteurRef · présence : L15 11 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordre_parent_recursif_id_niveaunomidqualiteacteur_ref
16130000002142L16/debats16161300000017001613000000214110M. Erwan Balanant719558
16130000002144L16/debats16161300000017001613000000214310M. Olivier Faure609332
16130000002146L16/debats16161300000017001613000000214510M. Bruno Millienne721976
16130000002148L16/debats16161300000017001613000000214710M. Rémy Rebeyrotte722398
16130000002150L16/debats16161300000017001613000000214910M. Olivier Faure609332
16130000002152L16/debats16161300000017001613000000215110M. Laurent Croizier793716
16130000002154L16/debats16161300000017001613000000215310M. Rémy Rebeyrotte722398
16130000002156L16/debats16161300000017001613000000215510M. Olivier Faure609332
16130000002158L16/debats16161300000017001613000000215710Mme Caroline Parmentier794670
16130000002160L16/debats16161300000017001613000000215910M. Olivier Faure609332
16130000002162L16/debats16161300000017001613000000216110M. Jocelyn Dessigny793166
16130000002164L16/debats16161300000017001613000000216310M. Olivier Faure609332
16130000002166L16/debats16161300000017001613000000216510Mme Caroline Parmentier794670
16130000002168L16/debats16161300000017001613000000216710M. Olivier Faure609332
16130000002170L16/debats16161300000017001613000000216910M. Jocelyn Dessigny793166
16130000002172L16/debats16161300000017001613000000217110M. Olivier Faure609332
16130000002174L16/debats16161300000017001613000000217310M. Bruno Millienne721976
16130000002176L16/debats16161300000017001613000000217510M. Olivier Faure609332
16130000002178L16/debats16161300000017001613000000217710M. Jocelyn Dessigny793166
16130000002180L16/debats16161300000017001613000000217910M. Olivier Faure609332
16130000002182L16/debats16161300000017001613000000218110M. Bruno Millienne721976
16130000002184L16/debats16161300000017001613000000218310M. Olivier Faure609332
16130000002186L16/debats16161300000017001613000000218510M. Rémy Rebeyrotte722398
16130000002188L16/debats16161300000017001613000000218710M. Olivier Faure609332
16130000002190L16/debats16161300000017001613000000218910M. Jocelyn Dessigny793166
16130000002192L16/debats16161300000017001613000000219110M. Olivier Faure609332
16130000002194L16/debats16161300000017001613000000219310M. Frédéric Cabrolier795836
16130000002196L16/debats16161300000017001613000000219510M. Jocelyn Dessigny793166
16130000002198L16/debats16161300000017001613000000219710M. Olivier Faure609332
16130000002200L16/debats16161300000017001613000000219910M. Jocelyn Dessigny793166
16130000002202L16/debats16161300000017001613000000220110M. Olivier Faure609332
16130000002204L16/debats16161300000017001613000000220310M. Rémy Rebeyrotte722398
16130000002206L16/debats16161300000017001613000000220510M. Olivier Faure609332
16130000002208L16/debats16161300000017001613000000220710M. Maxime Minot720630
16130000002210L16/debats16161300000017001613000000220910M. Olivier Faure609332
16130000002212L16/debats16161300000017001613000000221110M. Jocelyn Dessigny793166
16130000002214L16/debats16161300000017001613000000221310M. Olivier Faure609332
16130000002216L16/debats16161300000017001613000000221510M. Jocelyn Dessigny793166
16130000002218L16/debats16161300000017001613000000221710M. Olivier Faure609332
16130000002220L16/debats16161300000017001613000000221910M. Jocelyn Dessigny793166
16130000002222L16/debats16161300000017001613000000222110M. Julien Odoul795552
16130000002224L16/debats16161300000017001613000000222310M. Olivier Faure609332
16130000002226L16/debats16161300000017001613000000222510M. Julien Odoul795552
16130000002228L16/debats16161300000017001613000000222710M. Olivier Faure609332
16130000002230L16/debats16161300000017001613000000222910M. Jocelyn Dessigny793166
16130000002232L16/debats16161300000017001613000000223110M. Olivier Faure609332
16130000002234L16/debats16161300000017001613000000223310Mme la présidente721908
16130000002236L16/debats16161300000017001613000000223510M. Olivier Faure609332
16130000002238L16/debats16161300000017001613000000223710Mme la présidente721908
16130000002240L16/debats16161300000017001613000000223910M. Olivier Faure609332