dossiers.dossier_parlementaire_acte_legislatif_rapporteur
Chemin dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur · présence : L17 23 %, L16 19 %, L15 16 %, L14 23 %
8 818 lignes (estimation)
Colonnes
| # | Colonne | Type | Commentaire |
|---|---|---|---|
| 1 | _id | BIGINT | identifiant : code de la source × 10¹⁰ + rang |
| 2 | _source | VARCHAR | source du catalogue (catalogue.py) |
| 3 | _legislature | BIGINT | colonne constante de la source |
| 4 | _racine_id | BIGINT | _id de la ligne racine |
| 5 | _parent_id | BIGINT | _id de la ligne parente |
| 6 | _ordre | BIGINT | rang dans le tableau d'origine (1…) |
| 7 | _parent_recursif_id | BIGINT | _id de la ligne de même table qui contient celle-ci (structure récursive) |
| 8 | _niveau | BIGINT | profondeur dans la structure récursive (0 = premier niveau) |
| 9 | acteur_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur.acteurRef · présence : L17 23 %, L16 19 %, L15 16 %, L14 23 % |
| 10 | type_rapporteur | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur.typeRapporteur · présence : L17 23 %, L16 19 %, L15 16 %, L14 23 % |
| 11 | etude_plf_ref | VARCHAR | dossierParlementaire.actesLegislatifs.acteLegislatif.rapporteurs.rapporteur.etudePLFRef · présence : L17 0 %, L16 0 %, L15 0 %, L14 0 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | _parent_recursif_id | _niveau | acteur_ref | type_rapporteur | etude_plf_ref |
|---|---|---|---|---|---|---|---|---|---|---|
| 17060000145928 | L17/dossiers | 17 | 17060000145907 | 17060000145927 | 1 | 3 | PA793194 | rapporteur | ||
| 17060000145996 | L17/dossiers | 17 | 17060000145988 | 17060000145995 | 1 | 3 | PA794830 | rapporteur | ||
| 17060000146027 | L17/dossiers | 17 | 17060000146019 | 17060000146026 | 1 | 3 | PA722374 | rapporteur | ||
| 17060000146062 | L17/dossiers | 17 | 17060000146054 | 17060000146061 | 1 | 3 | PA720728 | rapporteur | ||
| 17060000146125 | L17/dossiers | 17 | 17060000146120 | 17060000146124 | 1 | 2 | PA795026 | rapporteur | ||
| 17060000146126 | L17/dossiers | 17 | 17060000146120 | 17060000146124 | 2 | 2 | PA795430 | rapporteur | ||
| 17060000146150 | L17/dossiers | 17 | 17060000146141 | 17060000146149 | 1 | 3 | PA703506 | rapporteur | ||
| 17060000146163 | L17/dossiers | 17 | 17060000146141 | 17060000146162 | 1 | 3 | PA793314 | rapporteur | ||
| 17060000146200 | L17/dossiers | 17 | 17060000146192 | 17060000146199 | 1 | 3 | PA719822 | rapporteur | ||
| 17060000146244 | L17/dossiers | 17 | 17060000146232 | 17060000146243 | 1 | 3 | PA840955 | rapporteur | ||
| 17060000146415 | L17/dossiers | 17 | 17060000146407 | 17060000146414 | 1 | 3 | PA842125 | rapporteur | ||
| 17060000146438 | L17/dossiers | 17 | 17060000146430 | 17060000146437 | 1 | 3 | PA687214 | rapporteur | ||
| 17060000146454 | L17/dossiers | 17 | 17060000146445 | 17060000146453 | 1 | 3 | PA841431 | rapporteur | ||
| 17060000146468 | L17/dossiers | 17 | 17060000146460 | 17060000146467 | 1 | 3 | PA794234 | rapporteur | ||
| 17060000146479 | L17/dossiers | 17 | 17060000146471 | 17060000146478 | 1 | 3 | PA793398 | rapporteur | ||
| 17060000146490 | L17/dossiers | 17 | 17060000146482 | 17060000146489 | 1 | 3 | PA722070 | rapporteur | ||
| 17060000146576 | L17/dossiers | 17 | 17060000146567 | 17060000146575 | 1 | 3 | PA703497 | rapporteur | ||
| 17060000146587 | L17/dossiers | 17 | 17060000146567 | 17060000146586 | 1 | 3 | PA718674 | rapporteur | ||
| 17060000146599 | L17/dossiers | 17 | 17060000146567 | 17060000146598 | 1 | 3 | PA793780 | rapporteur pour avis | ||
| 17060000146616 | L17/dossiers | 17 | 17060000146608 | 17060000146615 | 1 | 3 | PA849528 | rapporteur | ||
| 17060000146641 | L17/dossiers | 17 | 17060000146633 | 17060000146640 | 1 | 3 | PA840903 | rapporteur | ||
| 17060000146724 | L17/dossiers | 17 | 17060000146719 | 17060000146723 | 1 | 2 | PA942 | rapporteur | ||
| 17060000146760 | L17/dossiers | 17 | 17060000146752 | 17060000146759 | 1 | 3 | PA794270 | rapporteur | ||
| 17060000146781 | L17/dossiers | 17 | 17060000146773 | 17060000146780 | 1 | 3 | PA708632 | rapporteur | ||
| 17060000146782 | L17/dossiers | 17 | 17060000146773 | 17060000146780 | 2 | 3 | PA827990 | rapporteur | ||
| 17060000146865 | L17/dossiers | 17 | 17060000146856 | 17060000146864 | 1 | 3 | PA267907 | rapporteur | ||
| 17060000146878 | L17/dossiers | 17 | 17060000146856 | 17060000146877 | 1 | 3 | PA721612 | rapporteur | ||
| 17060000146904 | L17/dossiers | 17 | 17060000146895 | 17060000146903 | 1 | 3 | PA736246 | rapporteur | ||
| 17060000146932 | L17/dossiers | 17 | 17060000146923 | 17060000146931 | 1 | 3 | PA736173 | rapporteur | ||
| 17060000146944 | L17/dossiers | 17 | 17060000146923 | 17060000146943 | 1 | 3 | PA719032 | rapporteur | ||
| 17060000146962 | L17/dossiers | 17 | 17060000146954 | 17060000146961 | 1 | 3 | PA774962 | rapporteur | ||
| 17060000147044 | L17/dossiers | 17 | 17060000146972 | 17060000147043 | 1 | 3 | PA345916 | rapporteur | ||
| 17060000147245 | L17/dossiers | 17 | 17060000147236 | 17060000147244 | 1 | 3 | PA606507 | rapporteur | ||
| 17060000147258 | L17/dossiers | 17 | 17060000147249 | 17060000147257 | 1 | 3 | PA606507 | rapporteur | ||
| 17060000147398 | L17/dossiers | 17 | 17060000147386 | 17060000147397 | 1 | 3 | PA342564 | rapporteur | ||
| 17060000147410 | L17/dossiers | 17 | 17060000147386 | 17060000147409 | 1 | 3 | PA722102 | rapporteur | ||
| 17060000147490 | L17/dossiers | 17 | 17060000147481 | 17060000147489 | 1 | 3 | PA703510 | rapporteur | ||
| 17060000147545 | L17/dossiers | 17 | 17060000147536 | 17060000147544 | 1 | 3 | PA866550 | rapporteur | ||
| 17060000147546 | L17/dossiers | 17 | 17060000147536 | 17060000147544 | 2 | 3 | PA747420 | rapporteur | ||
| 17060000147558 | L17/dossiers | 17 | 17060000147536 | 17060000147557 | 1 | 3 | PA817203 | rapporteur | ||
| 17060000147559 | L17/dossiers | 17 | 17060000147536 | 17060000147557 | 2 | 3 | PA805166 | rapporteur | ||
| 17060000147582 | L17/dossiers | 17 | 17060000147536 | 17060000147581 | 1 | 2 | PA866550 | rapporteur | ||
| 17060000147583 | L17/dossiers | 17 | 17060000147536 | 17060000147581 | 2 | 2 | PA747420 | rapporteur | ||
| 17060000147584 | L17/dossiers | 17 | 17060000147536 | 17060000147581 | 3 | 2 | PA805166 | rapporteur | ||
| 17060000147655 | L17/dossiers | 17 | 17060000147646 | 17060000147654 | 1 | 3 | PA866550 | rapporteur | ||
| 17060000147656 | L17/dossiers | 17 | 17060000147646 | 17060000147654 | 2 | 3 | PA747420 | rapporteur | ||
| 17060000147668 | L17/dossiers | 17 | 17060000147646 | 17060000147667 | 1 | 3 | PA817203 | rapporteur | ||
| 17060000147669 | L17/dossiers | 17 | 17060000147646 | 17060000147667 | 2 | 3 | PA805166 | rapporteur | ||
| 17060000147692 | L17/dossiers | 17 | 17060000147646 | 17060000147691 | 1 | 2 | PA866550 | rapporteur | ||
| 17060000147693 | L17/dossiers | 17 | 17060000147646 | 17060000147691 | 2 | 2 | PA747420 | rapporteur |