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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000093510 | L16/dossiers | 16 | 16060000093483 | 16060000093509 | 1 | 3 | PA703523 | rapporteur | ||
| 16060000093521 | L16/dossiers | 16 | 16060000093483 | 16060000093520 | 1 | 2 | PA718876 | rapporteur | ||
| 16060000093522 | L16/dossiers | 16 | 16060000093483 | 16060000093520 | 2 | 2 | PA703523 | rapporteur | ||
| 16060000093547 | L16/dossiers | 16 | 16060000093539 | 16060000093546 | 1 | 3 | PA227094 | rapporteur | ||
| 16060000093567 | L16/dossiers | 16 | 16060000093539 | 16060000093566 | 1 | 3 | PA795466 | rapporteur | ||
| 16060000093586 | L16/dossiers | 16 | 16060000093575 | 16060000093585 | 1 | 3 | PA336439 | rapporteur | ||
| 16060000093599 | L16/dossiers | 16 | 16060000093575 | 16060000093598 | 1 | 3 | PA736240 | rapporteur | ||
| 16060000093615 | L16/dossiers | 16 | 16060000093606 | 16060000093614 | 1 | 3 | PA775232 | rapporteur | ||
| 16060000093636 | L16/dossiers | 16 | 16060000093606 | 16060000093635 | 1 | 3 | PA1008 | rapporteur | ||
| 16060000093652 | L16/dossiers | 16 | 16060000093644 | 16060000093651 | 1 | 3 | PA736190 | rapporteur | ||
| 16060000093679 | L16/dossiers | 16 | 16060000093668 | 16060000093678 | 1 | 3 | PA2492 | rapporteur | ||
| 16060000093685 | L16/dossiers | 16 | 16060000093668 | 16060000093684 | 1 | 3 | PA721916 | rapporteur pour avis | ||
| 16060000093698 | L16/dossiers | 16 | 16060000093668 | 16060000093697 | 1 | 3 | PA415486 | rapporteur | ||
| 16060000093717 | L16/dossiers | 16 | 16060000093706 | 16060000093716 | 1 | 3 | PA724827 | rapporteur | ||
| 16060000093732 | L16/dossiers | 16 | 16060000093706 | 16060000093731 | 1 | 3 | PA590034 | rapporteur | ||
| 16060000093791 | L16/dossiers | 16 | 16060000093740 | 16060000093790 | 1 | 3 | PA429858 | rapporteur | ||
| 16060000093817 | L16/dossiers | 16 | 16060000093806 | 16060000093816 | 1 | 3 | PA721024 | rapporteur | ||
| 16060000093830 | L16/dossiers | 16 | 16060000093806 | 16060000093829 | 1 | 3 | PA736173 | rapporteur | ||
| 16060000093845 | L16/dossiers | 16 | 16060000093837 | 16060000093844 | 1 | 3 | PA719448 | rapporteur | ||
| 16060000093862 | L16/dossiers | 16 | 16060000093837 | 16060000093861 | 1 | 3 | PA775272 | rapporteur | ||
| 16060000093894 | L16/dossiers | 16 | 16060000093882 | 16060000093893 | 1 | 3 | PA335612 | rapporteur | ||
| 16060000093907 | L16/dossiers | 16 | 16060000093882 | 16060000093906 | 1 | 3 | PA267673 | rapporteur | ||
| 16060000093945 | L16/dossiers | 16 | 16060000093914 | 16060000093944 | 1 | 3 | PA304017 | rapporteur | ||
| 16060000093968 | L16/dossiers | 16 | 16060000093960 | 16060000093967 | 1 | 3 | PA775288 | rapporteur | ||
| 16060000093984 | L16/dossiers | 16 | 16060000093960 | 16060000093983 | 1 | 3 | PA720092 | rapporteur | ||
| 16060000094025 | L16/dossiers | 16 | 16060000094017 | 16060000094024 | 1 | 3 | PA775168 | rapporteur | ||
| 16060000094049 | L16/dossiers | 16 | 16060000094041 | 16060000094048 | 1 | 3 | PA720846 | rapporteur | ||
| 16060000094065 | L16/dossiers | 16 | 16060000094041 | 16060000094064 | 1 | 3 | PA736177 | rapporteur | ||
| 16060000094083 | L16/dossiers | 16 | 16060000094075 | 16060000094082 | 1 | 3 | PA736186 | rapporteur | ||
| 16060000094095 | L16/dossiers | 16 | 16060000094075 | 16060000094094 | 1 | 3 | PA721170 | rapporteur | ||
| 16060000094115 | L16/dossiers | 16 | 16060000094104 | 16060000094114 | 1 | 3 | PA719294 | rapporteur | ||
| 16060000094129 | L16/dossiers | 16 | 16060000094104 | 16060000094128 | 1 | 3 | PA720634 | rapporteur | ||
| 16060000094145 | L16/dossiers | 16 | 16060000094137 | 16060000094144 | 1 | 3 | PA736223 | rapporteur | ||
| 16060000094169 | L16/dossiers | 16 | 16060000094160 | 16060000094168 | 1 | 3 | PA736160 | rapporteur | ||
| 16060000094198 | L16/dossiers | 16 | 16060000094185 | 16060000094197 | 1 | 3 | PA720862 | rapporteur | ||
| 16060000094213 | L16/dossiers | 16 | 16060000094185 | 16060000094212 | 1 | 3 | PA736218 | rapporteur | ||
| 16060000094225 | L16/dossiers | 16 | 16060000094185 | 16060000094224 | 1 | 2 | PA720862 | rapporteur | ||
| 16060000094226 | L16/dossiers | 16 | 16060000094185 | 16060000094224 | 2 | 2 | PA736218 | rapporteur | ||
| 16060000094251 | L16/dossiers | 16 | 16060000094243 | 16060000094250 | 1 | 3 | PA340357 | rapporteur | ||
| 16060000094268 | L16/dossiers | 16 | 16060000094243 | 16060000094267 | 1 | 3 | PA703512 | rapporteur | ||
| 16060000094283 | L16/dossiers | 16 | 16060000094275 | 16060000094282 | 1 | 3 | PA708632 | rapporteur | ||
| 16060000094302 | L16/dossiers | 16 | 16060000094293 | 16060000094301 | 1 | 3 | PA718756 | rapporteur | ||
| 16060000094318 | L16/dossiers | 16 | 16060000094293 | 16060000094317 | 1 | 3 | PA426327 | rapporteur | ||
| 16060000094331 | L16/dossiers | 16 | 16060000094293 | 16060000094330 | 1 | 2 | PA382672 | rapporteur | ||
| 16060000094332 | L16/dossiers | 16 | 16060000094293 | 16060000094330 | 2 | 2 | PA795958 | rapporteur | ||
| 16060000094362 | L16/dossiers | 16 | 16060000094350 | 16060000094361 | 1 | 3 | PA720214 | rapporteur | ||
| 16060000094374 | L16/dossiers | 16 | 16060000094350 | 16060000094373 | 1 | 3 | PA227096 | rapporteur | ||
| 16060000094391 | L16/dossiers | 16 | 16060000094382 | 16060000094390 | 1 | 3 | PA703525 | rapporteur | ||
| 16060000094409 | L16/dossiers | 16 | 16060000094382 | 16060000094408 | 1 | 3 | PA721004 | rapporteur | ||
| 16060000094427 | L16/dossiers | 16 | 16060000094418 | 16060000094426 | 1 | 3 | PA267340 | rapporteur |