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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000104874 | L16/dossiers | 16 | 16060000104813 | 16060000104873 | 1 | 3 | PA721742 | rapporteur | ||
| 16060000104911 | L16/dossiers | 16 | 16060000104903 | 16060000104910 | 1 | 3 | PA642988 | rapporteur | ||
| 16060000104956 | L16/dossiers | 16 | 16060000104947 | 16060000104955 | 1 | 3 | PA722046 | rapporteur | ||
| 16060000104988 | L16/dossiers | 16 | 16060000104979 | 16060000104987 | 1 | 3 | PA703492 | rapporteur | ||
| 16060000105051 | L16/dossiers | 16 | 16060000105038 | 16060000105050 | 1 | 3 | PA720066 | rapporteur | ||
| 16060000105066 | L16/dossiers | 16 | 16060000105038 | 16060000105065 | 1 | 3 | PA795120 | rapporteur pour avis | ||
| 16060000105074 | L16/dossiers | 16 | 16060000105038 | 16060000105073 | 1 | 3 | PA719512 | rapporteur pour avis | ||
| 16060000105106 | L16/dossiers | 16 | 16060000105038 | 16060000105105 | 1 | 3 | PA703498 | rapporteur | ||
| 16060000105107 | L16/dossiers | 16 | 16060000105038 | 16060000105105 | 2 | 3 | PA429851 | rapporteur | ||
| 16060000105118 | L16/dossiers | 16 | 16060000105038 | 16060000105117 | 1 | 2 | PA720066 | rapporteur | ||
| 16060000105119 | L16/dossiers | 16 | 16060000105038 | 16060000105117 | 2 | 2 | PA703498 | rapporteur | ||
| 16060000105120 | L16/dossiers | 16 | 16060000105038 | 16060000105117 | 3 | 2 | PA429851 | rapporteur | ||
| 16060000105196 | L16/dossiers | 16 | 16060000105188 | 16060000105195 | 1 | 3 | PA722150 | rapporteur | ||
| 16060000105212 | L16/dossiers | 16 | 16060000105188 | 16060000105211 | 1 | 3 | PA703492 | rapporteur | ||
| 16060000105242 | L16/dossiers | 16 | 16060000105233 | 16060000105241 | 1 | 3 | PA721170 | rapporteur | ||
| 16060000105243 | L16/dossiers | 16 | 16060000105233 | 16060000105241 | 2 | 3 | PA793394 | rapporteur | ||
| 16060000105261 | L16/dossiers | 16 | 16060000105233 | 16060000105260 | 1 | 3 | PA788192 | rapporteur | ||
| 16060000105272 | L16/dossiers | 16 | 16060000105233 | 16060000105271 | 1 | 2 | PA721170 | rapporteur | ||
| 16060000105273 | L16/dossiers | 16 | 16060000105233 | 16060000105271 | 2 | 2 | PA793394 | rapporteur | ||
| 16060000105274 | L16/dossiers | 16 | 16060000105233 | 16060000105271 | 3 | 2 | PA788192 | rapporteur | ||
| 16060000105375 | L16/dossiers | 16 | 16060000105367 | 16060000105374 | 1 | 3 | PA719404 | rapporteur | ||
| 16060000105394 | L16/dossiers | 16 | 16060000105367 | 16060000105393 | 1 | 3 | PA304086 | rapporteur | ||
| 16060000105496 | L16/dossiers | 16 | 16060000105491 | 16060000105495 | 1 | 2 | PA796018 | rapporteur | ||
| 16060000105532 | L16/dossiers | 16 | 16060000105523 | 16060000105531 | 1 | 3 | PA736205 | rapporteur | ||
| 16060000105533 | L16/dossiers | 16 | 16060000105523 | 16060000105531 | 2 | 3 | PA569 | rapporteur | ||
| 16060000105545 | L16/dossiers | 16 | 16060000105523 | 16060000105544 | 1 | 3 | PA720370 | rapporteur | ||
| 16060000105546 | L16/dossiers | 16 | 16060000105523 | 16060000105544 | 2 | 3 | PA793306 | rapporteur | ||
| 16060000105547 | L16/dossiers | 16 | 16060000105523 | 16060000105544 | 3 | 3 | PA720960 | rapporteur | ||
| 16060000105548 | L16/dossiers | 16 | 16060000105523 | 16060000105544 | 4 | 3 | PA606507 | rapporteur | ||
| 16060000105549 | L16/dossiers | 16 | 16060000105523 | 16060000105544 | 5 | 3 | PA719874 | rapporteur | ||
| 16060000105569 | L16/dossiers | 16 | 16060000105523 | 16060000105568 | 1 | 3 | PA795958 | rapporteur pour avis | ||
| 16060000105581 | L16/dossiers | 16 | 16060000105523 | 16060000105580 | 1 | 2 | PA736205 | rapporteur | ||
| 16060000105582 | L16/dossiers | 16 | 16060000105523 | 16060000105580 | 2 | 2 | PA569 | rapporteur | ||
| 16060000105583 | L16/dossiers | 16 | 16060000105523 | 16060000105580 | 3 | 2 | PA606507 | rapporteur | ||
| 16060000105584 | L16/dossiers | 16 | 16060000105523 | 16060000105580 | 4 | 2 | PA719874 | rapporteur | ||
| 16060000105794 | L16/dossiers | 16 | 16060000105786 | 16060000105793 | 1 | 3 | PA331381 | rapporteur | ||
| 16060000105816 | L16/dossiers | 16 | 16060000105811 | 16060000105815 | 1 | 2 | PA719600 | rapporteur | ||
| 16060000105817 | L16/dossiers | 16 | 16060000105811 | 16060000105815 | 2 | 2 | PA794022 | rapporteur | ||
| 16060000105823 | L16/dossiers | 16 | 16060000105818 | 16060000105822 | 1 | 2 | PA719866 | rapporteur | ||
| 16060000105824 | L16/dossiers | 16 | 16060000105818 | 16060000105822 | 2 | 2 | PA721896 | rapporteur | ||
| 16060000105830 | L16/dossiers | 16 | 16060000105825 | 16060000105829 | 1 | 2 | PA608695 | rapporteur | ||
| 16060000105831 | L16/dossiers | 16 | 16060000105825 | 16060000105829 | 2 | 2 | PA721466 | rapporteur | ||
| 16060000106050 | L16/dossiers | 16 | 16060000106038 | 16060000106049 | 1 | 3 | PA1008 | rapporteur | ||
| 16060000106063 | L16/dossiers | 16 | 16060000106038 | 16060000106062 | 1 | 3 | PA703525 | rapporteur | ||
| 16060000106080 | L16/dossiers | 16 | 16060000106070 | 16060000106079 | 1 | 3 | PA429842 | rapporteur | ||
| 16060000106105 | L16/dossiers | 16 | 16060000106097 | 16060000106104 | 1 | 3 | PA736201 | rapporteur | ||
| 16060000106117 | L16/dossiers | 16 | 16060000106109 | 16060000106116 | 1 | 3 | PA795058 | rapporteur | ||
| 16060000106131 | L16/dossiers | 16 | 16060000106123 | 16060000106130 | 1 | 3 | PA793980 | rapporteur | ||
| 16060000106143 | L16/dossiers | 16 | 16060000106135 | 16060000106142 | 1 | 3 | PA795076 | rapporteur | ||
| 16060000106159 | L16/dossiers | 16 | 16060000106135 | 16060000106158 | 1 | 3 | PA736211 | rapporteur |