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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000099148 | L16/dossiers | 16 | 16060000099143 | 16060000099147 | 1 | 2 | PA721984 | rapporteur | ||
| 16060000099149 | L16/dossiers | 16 | 16060000099143 | 16060000099147 | 2 | 2 | PA266797 | rapporteur | ||
| 16060000099262 | L16/dossiers | 16 | 16060000099254 | 16060000099261 | 1 | 3 | PA267512 | rapporteur | ||
| 16060000099273 | L16/dossiers | 16 | 16060000099254 | 16060000099272 | 1 | 3 | PA794626 | rapporteur | ||
| 16060000099388 | L16/dossiers | 16 | 16060000099378 | 16060000099387 | 1 | 3 | PA736202 | rapporteur | ||
| 16060000099400 | L16/dossiers | 16 | 16060000099378 | 16060000099399 | 1 | 3 | PA795026 | rapporteur | ||
| 16060000099428 | L16/dossiers | 16 | 16060000099420 | 16060000099427 | 1 | 3 | PA794166 | rapporteur | ||
| 16060000099446 | L16/dossiers | 16 | 16060000099438 | 16060000099445 | 1 | 3 | PA720892 | rapporteur | ||
| 16060000099465 | L16/dossiers | 16 | 16060000099438 | 16060000099464 | 1 | 3 | PA703510 | rapporteur | ||
| 16060000099509 | L16/dossiers | 16 | 16060000099501 | 16060000099508 | 1 | 3 | PA720286 | rapporteur | ||
| 16060000099528 | L16/dossiers | 16 | 16060000099520 | 16060000099527 | 1 | 3 | PA795318 | rapporteur | ||
| 16060000099545 | L16/dossiers | 16 | 16060000099537 | 16060000099544 | 1 | 3 | PA795164 | rapporteur | ||
| 16060000099561 | L16/dossiers | 16 | 16060000099553 | 16060000099560 | 1 | 3 | PA794906 | rapporteur | ||
| 16060000099578 | L16/dossiers | 16 | 16060000099570 | 16060000099577 | 1 | 3 | PA795228 | rapporteur | ||
| 16060000099594 | L16/dossiers | 16 | 16060000099586 | 16060000099593 | 1 | 3 | PA588884 | rapporteur | ||
| 16060000099610 | L16/dossiers | 16 | 16060000099602 | 16060000099609 | 1 | 3 | PA721210 | rapporteur | ||
| 16060000099623 | L16/dossiers | 16 | 16060000099615 | 16060000099622 | 1 | 3 | PA796090 | rapporteur | ||
| 16060000099643 | L16/dossiers | 16 | 16060000099635 | 16060000099642 | 1 | 3 | PA796018 | rapporteur | ||
| 16060000099689 | L16/dossiers | 16 | 16060000099680 | 16060000099688 | 1 | 3 | PA775248 | rapporteur | ||
| 16060000099700 | L16/dossiers | 16 | 16060000099680 | 16060000099699 | 1 | 3 | PA721262 | rapporteur | ||
| 16060000099719 | L16/dossiers | 16 | 16060000099711 | 16060000099718 | 1 | 3 | PA775284 | rapporteur | ||
| 16060000099747 | L16/dossiers | 16 | 16060000099739 | 16060000099746 | 1 | 3 | PA722046 | rapporteur | ||
| 16060000099869 | L16/dossiers | 16 | 16060000099861 | 16060000099868 | 1 | 3 | PA720100 | rapporteur | ||
| 16060000099915 | L16/dossiers | 16 | 16060000099907 | 16060000099914 | 1 | 3 | PA330240 | rapporteur | ||
| 16060000099935 | L16/dossiers | 16 | 16060000099927 | 16060000099934 | 1 | 3 | PA712015 | rapporteur | ||
| 16060000099953 | L16/dossiers | 16 | 16060000099927 | 16060000099952 | 1 | 3 | PA267081 | rapporteur | ||
| 16060000099968 | L16/dossiers | 16 | 16060000099960 | 16060000099967 | 1 | 3 | PA267901 | rapporteur | ||
| 16060000100054 | L16/dossiers | 16 | 16060000100046 | 16060000100053 | 1 | 3 | PA719372 | rapporteur | ||
| 16060000100073 | L16/dossiers | 16 | 16060000100046 | 16060000100072 | 1 | 3 | PA426327 | rapporteur | ||
| 16060000100116 | L16/dossiers | 16 | 16060000100108 | 16060000100115 | 1 | 3 | PA719186 | rapporteur | ||
| 16060000100132 | L16/dossiers | 16 | 16060000100108 | 16060000100131 | 1 | 3 | PA736207 | rapporteur | ||
| 16060000100171 | L16/dossiers | 16 | 16060000100162 | 16060000100170 | 1 | 3 | PA720066 | rapporteur | ||
| 16060000100190 | L16/dossiers | 16 | 16060000100162 | 16060000100189 | 1 | 3 | PA703515 | rapporteur | ||
| 16060000100201 | L16/dossiers | 16 | 16060000100162 | 16060000100200 | 1 | 2 | PA703515 | rapporteur | ||
| 16060000100202 | L16/dossiers | 16 | 16060000100162 | 16060000100200 | 2 | 2 | PA720066 | rapporteur | ||
| 16060000100260 | L16/dossiers | 16 | 16060000100252 | 16060000100259 | 1 | 3 | PA330684 | rapporteur | ||
| 16060000100275 | L16/dossiers | 16 | 16060000100270 | 16060000100274 | 1 | 2 | PA795144 | rapporteur | ||
| 16060000100389 | L16/dossiers | 16 | 16060000100367 | 16060000100388 | 1 | 3 | PA775288 | rapporteur | ||
| 16060000100399 | L16/dossiers | 16 | 16060000100391 | 16060000100398 | 1 | 3 | PA720092 | rapporteur | ||
| 16060000100480 | L16/dossiers | 16 | 16060000100407 | 16060000100479 | 1 | 3 | PA605888 | rapporteur | ||
| 16060000100493 | L16/dossiers | 16 | 16060000100482 | 16060000100492 | 1 | 3 | PA703514 | rapporteur | ||
| 16060000100559 | L16/dossiers | 16 | 16060000100550 | 16060000100558 | 1 | 3 | PA736173 | rapporteur | ||
| 16060000100571 | L16/dossiers | 16 | 16060000100550 | 16060000100570 | 1 | 3 | PA720952 | rapporteur | ||
| 16060000100606 | L16/dossiers | 16 | 16060000100589 | 16060000100605 | 1 | 3 | PA793992 | rapporteur | ||
| 16060000100607 | L16/dossiers | 16 | 16060000100589 | 16060000100605 | 2 | 3 | PA642695 | rapporteur | ||
| 16060000100617 | L16/dossiers | 16 | 16060000100589 | 16060000100616 | 1 | 3 | PA795864 | rapporteur pour avis | ||
| 16060000100618 | L16/dossiers | 16 | 16060000100589 | 16060000100616 | 2 | 3 | PA721530 | rapporteur pour avis | ||
| 16060000100650 | L16/dossiers | 16 | 16060000100589 | 16060000100649 | 1 | 2 | PA793992 | rapporteur | ||
| 16060000100651 | L16/dossiers | 16 | 16060000100589 | 16060000100649 | 2 | 2 | PA642695 | rapporteur | ||
| 16060000100652 | L16/dossiers | 16 | 16060000100589 | 16060000100649 | 3 | 2 | PA795864 | rapporteur |