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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000109930 | L16/dossiers | 16 | 16060000109866 | 16060000109929 | 1 | 2 | PA795270 | rapporteur | ||
| 16060000109931 | L16/dossiers | 16 | 16060000109866 | 16060000109929 | 2 | 2 | PA703494 | rapporteur | ||
| 16060000110005 | L16/dossiers | 16 | 16060000109993 | 16060000110004 | 1 | 3 | PA720174 | rapporteur | ||
| 16060000110018 | L16/dossiers | 16 | 16060000109993 | 16060000110017 | 1 | 3 | PA775234 | rapporteur | ||
| 16060000110034 | L16/dossiers | 16 | 16060000110025 | 16060000110033 | 1 | 3 | PA703510 | rapporteur | ||
| 16060000110035 | L16/dossiers | 16 | 16060000110025 | 16060000110033 | 2 | 3 | PA747420 | rapporteur | ||
| 16060000110046 | L16/dossiers | 16 | 16060000110025 | 16060000110045 | 1 | 3 | PA721584 | rapporteur | ||
| 16060000110047 | L16/dossiers | 16 | 16060000110025 | 16060000110045 | 2 | 3 | PA719558 | rapporteur | ||
| 16060000110048 | L16/dossiers | 16 | 16060000110025 | 16060000110045 | 3 | 3 | PA793306 | rapporteur | ||
| 16060000110062 | L16/dossiers | 16 | 16060000110025 | 16060000110061 | 1 | 3 | PA720560 | rapporteur pour avis | ||
| 16060000110093 | L16/dossiers | 16 | 16060000110025 | 16060000110092 | 1 | 2 | PA719558 | rapporteur | ||
| 16060000110094 | L16/dossiers | 16 | 16060000110025 | 16060000110092 | 2 | 2 | PA721584 | rapporteur | ||
| 16060000110095 | L16/dossiers | 16 | 16060000110025 | 16060000110092 | 3 | 2 | PA703510 | rapporteur | ||
| 16060000110096 | L16/dossiers | 16 | 16060000110025 | 16060000110092 | 4 | 2 | PA747420 | rapporteur | ||
| 16060000110122 | L16/dossiers | 16 | 16060000110113 | 16060000110121 | 1 | 3 | PA703510 | rapporteur | ||
| 16060000110123 | L16/dossiers | 16 | 16060000110113 | 16060000110121 | 2 | 3 | PA747420 | rapporteur | ||
| 16060000110134 | L16/dossiers | 16 | 16060000110113 | 16060000110133 | 1 | 3 | PA719202 | rapporteur | ||
| 16060000110173 | L16/dossiers | 16 | 16060000110113 | 16060000110172 | 1 | 2 | PA719202 | rapporteur | ||
| 16060000110174 | L16/dossiers | 16 | 16060000110113 | 16060000110172 | 2 | 2 | PA703510 | rapporteur | ||
| 16060000110175 | L16/dossiers | 16 | 16060000110113 | 16060000110172 | 3 | 2 | PA747420 | rapporteur | ||
| 16060000110201 | L16/dossiers | 16 | 16060000110192 | 16060000110200 | 1 | 3 | PA747422 | rapporteur | ||
| 16060000110212 | L16/dossiers | 16 | 16060000110192 | 16060000110211 | 1 | 3 | PA722038 | rapporteur | ||
| 16060000110243 | L16/dossiers | 16 | 16060000110235 | 16060000110242 | 1 | 3 | PA429858 | rapporteur | ||
| 16060000110271 | L16/dossiers | 16 | 16060000110266 | 16060000110270 | 1 | 2 | PA721852 | rapporteur | ||
| 16060000110272 | L16/dossiers | 16 | 16060000110266 | 16060000110270 | 2 | 2 | PA605745 | rapporteur | ||
| 16060000110278 | L16/dossiers | 16 | 16060000110273 | 16060000110277 | 1 | 2 | PA793306 | rapporteur | ||
| 16060000110279 | L16/dossiers | 16 | 16060000110273 | 16060000110277 | 2 | 2 | PA795966 | rapporteur | ||
| 16060000110302 | L16/dossiers | 16 | 16060000110294 | 16060000110301 | 1 | 3 | PA606639 | rapporteur | ||
| 16060000110382 | L16/dossiers | 16 | 16060000110374 | 16060000110381 | 1 | 3 | PA793382 | rapporteur | ||
| 16060000110484 | L16/dossiers | 16 | 16060000110479 | 16060000110483 | 1 | 2 | PA720900 | rapporteur | ||
| 16060000110485 | L16/dossiers | 16 | 16060000110479 | 16060000110483 | 2 | 2 | PA793904 | rapporteur | ||
| 16060000110508 | L16/dossiers | 16 | 16060000110496 | 16060000110507 | 1 | 3 | PA795326 | rapporteur | ||
| 16060000110522 | L16/dossiers | 16 | 16060000110496 | 16060000110521 | 1 | 3 | PA747422 | rapporteur | ||
| 16060000110576 | L16/dossiers | 16 | 16060000110571 | 16060000110575 | 1 | 2 | PA606507 | rapporteur | ||
| 16060000110655 | L16/dossiers | 16 | 16060000110596 | 16060000110654 | 1 | 3 | PA703511 | rapporteur | ||
| 16060000110675 | L16/dossiers | 16 | 16060000110666 | 16060000110674 | 1 | 3 | PA703513 | rapporteur | ||
| 16060000110676 | L16/dossiers | 16 | 16060000110666 | 16060000110674 | 2 | 3 | PA703492 | rapporteur | ||
| 16060000110687 | L16/dossiers | 16 | 16060000110666 | 16060000110686 | 1 | 3 | PA795664 | rapporteur | ||
| 16060000110688 | L16/dossiers | 16 | 16060000110666 | 16060000110686 | 2 | 3 | PA794810 | rapporteur | ||
| 16060000110689 | L16/dossiers | 16 | 16060000110666 | 16060000110686 | 3 | 3 | PA794426 | rapporteur | ||
| 16060000110690 | L16/dossiers | 16 | 16060000110666 | 16060000110686 | 4 | 3 | PA719294 | rapporteur | ||
| 16060000110691 | L16/dossiers | 16 | 16060000110666 | 16060000110686 | 5 | 3 | PA720146 | rapporteur | ||
| 16060000110726 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 1 | 2 | PA795664 | rapporteur | ||
| 16060000110727 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 2 | 2 | PA794810 | rapporteur | ||
| 16060000110728 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 3 | 2 | PA720146 | rapporteur | ||
| 16060000110729 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 4 | 2 | PA719294 | rapporteur | ||
| 16060000110730 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 5 | 2 | PA703513 | rapporteur | ||
| 16060000110731 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 6 | 2 | PA703492 | rapporteur | ||
| 16060000110732 | L16/dossiers | 16 | 16060000110666 | 16060000110725 | 7 | 2 | PA794426 | rapporteur | ||
| 16060000110824 | L16/dossiers | 16 | 16060000110815 | 16060000110823 | 1 | 3 | PA775288 | rapporteur |