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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 14060000106161 | L14/dossiers | 14 | 14060000106119 | 14060000106159 | 2 | 2 | PA227099 | rapporteur | ||
| 14060000106248 | L14/dossiers | 14 | 14060000106240 | 14060000106247 | 1 | 3 | PA606495 | rapporteur | ||
| 14060000106263 | L14/dossiers | 14 | 14060000106255 | 14060000106262 | 1 | 3 | PA267340 | rapporteur | ||
| 14060000106275 | L14/dossiers | 14 | 14060000106255 | 14060000106274 | 1 | 3 | PA610775 | rapporteur | ||
| 14060000106356 | L14/dossiers | 14 | 14060000106348 | 14060000106355 | 1 | 3 | PA1459 | rapporteur | ||
| 14060000106376 | L14/dossiers | 14 | 14060000106367 | 14060000106375 | 1 | 3 | PA304108 | rapporteur | ||
| 14060000106388 | L14/dossiers | 14 | 14060000106367 | 14060000106387 | 1 | 3 | PA335543 | rapporteur | ||
| 14060000106420 | L14/dossiers | 14 | 14060000106411 | 14060000106419 | 1 | 3 | PA227097 | rapporteur | ||
| 14060000106432 | L14/dossiers | 14 | 14060000106411 | 14060000106431 | 1 | 3 | PA606161 | rapporteur | ||
| 14060000106575 | L14/dossiers | 14 | 14060000106567 | 14060000106574 | 1 | 3 | PA2183 | rapporteur | ||
| 14060000106608 | L14/dossiers | 14 | 14060000106598 | 14060000106607 | 1 | 3 | PA606161 | rapporteur | ||
| 14060000106620 | L14/dossiers | 14 | 14060000106598 | 14060000106619 | 1 | 3 | PA703493 | rapporteur | ||
| 14060000106671 | L14/dossiers | 14 | 14060000106662 | 14060000106670 | 1 | 3 | PA2371 | rapporteur | ||
| 14060000106688 | L14/dossiers | 14 | 14060000106662 | 14060000106687 | 1 | 3 | PA721486 | rapporteur | ||
| 14060000106706 | L14/dossiers | 14 | 14060000106698 | 14060000106705 | 1 | 3 | PA1142 | rapporteur | ||
| 14060000106718 | L14/dossiers | 14 | 14060000106698 | 14060000106717 | 1 | 3 | PA721166 | rapporteur | ||
| 14060000106743 | L14/dossiers | 14 | 14060000106735 | 14060000106742 | 1 | 3 | PA2611 | rapporteur | ||
| 14060000106775 | L14/dossiers | 14 | 14060000106764 | 14060000106774 | 1 | 3 | PA735 | rapporteur | ||
| 14060000106790 | L14/dossiers | 14 | 14060000106764 | 14060000106789 | 1 | 3 | PA304113 | rapporteur | ||
| 14060000106802 | L14/dossiers | 14 | 14060000106764 | 14060000106801 | 1 | 2 | PA735 | rapporteur | ||
| 14060000106803 | L14/dossiers | 14 | 14060000106764 | 14060000106801 | 2 | 2 | PA304113 | rapporteur | ||
| 14060000106825 | L14/dossiers | 14 | 14060000106817 | 14060000106824 | 1 | 3 | PA304090 | rapporteur | ||
| 14060000106837 | L14/dossiers | 14 | 14060000106817 | 14060000106836 | 1 | 3 | PA337483 | rapporteur | ||
| 14060000106882 | L14/dossiers | 14 | 14060000106874 | 14060000106881 | 1 | 3 | PA1122 | rapporteur | ||
| 14060000106918 | L14/dossiers | 14 | 14060000106910 | 14060000106917 | 1 | 3 | PA1617 | rapporteur | ||
| 14060000106958 | L14/dossiers | 14 | 14060000106949 | 14060000106957 | 1 | 3 | PA267091 | rapporteur | ||
| 14060000106972 | L14/dossiers | 14 | 14060000106949 | 14060000106971 | 1 | 3 | PA1308 | rapporteur | ||
| 14060000107006 | L14/dossiers | 14 | 14060000106995 | 14060000107005 | 1 | 3 | PA642743 | rapporteur | ||
| 14060000107017 | L14/dossiers | 14 | 14060000106995 | 14060000107016 | 1 | 3 | PA642788 | rapporteur pour avis | ||
| 14060000107024 | L14/dossiers | 14 | 14060000106995 | 14060000107023 | 1 | 3 | PA606363 | rapporteur pour avis | ||
| 14060000107044 | L14/dossiers | 14 | 14060000106995 | 14060000107043 | 1 | 3 | PA1476 | rapporteur | ||
| 14060000107049 | L14/dossiers | 14 | 14060000106995 | 14060000107048 | 1 | 3 | PA227089 | rapporteur pour avis | ||
| 14060000107054 | L14/dossiers | 14 | 14060000106995 | 14060000107053 | 1 | 3 | PA415464 | rapporteur | ||
| 14060000107068 | L14/dossiers | 14 | 14060000106995 | 14060000107067 | 1 | 2 | PA642743 | rapporteur | ||
| 14060000107069 | L14/dossiers | 14 | 14060000106995 | 14060000107067 | 2 | 2 | PA1476 | rapporteur | ||
| 14060000107105 | L14/dossiers | 14 | 14060000107100 | 14060000107104 | 1 | 2 | PA332305 | rapporteur | ||
| 14060000107127 | L14/dossiers | 14 | 14060000107121 | 14060000107126 | 1 | 2 | PA605606 | rapporteur | ||
| 14060000107186 | L14/dossiers | 14 | 14060000107177 | 14060000107185 | 1 | 3 | PA267835 | rapporteur | ||
| 14060000107193 | L14/dossiers | 14 | 14060000107177 | 14060000107192 | 1 | 3 | PA606495 | rapporteur pour avis | ||
| 14060000107212 | L14/dossiers | 14 | 14060000107177 | 14060000107211 | 1 | 3 | PA2803 | rapporteur | ||
| 14060000107225 | L14/dossiers | 14 | 14060000107177 | 14060000107224 | 1 | 2 | PA606495 | rapporteur | ||
| 14060000107226 | L14/dossiers | 14 | 14060000107177 | 14060000107224 | 2 | 2 | PA2803 | rapporteur | ||
| 14060000107294 | L14/dossiers | 14 | 14060000107285 | 14060000107293 | 1 | 3 | PA415495 | rapporteur | ||
| 14060000107306 | L14/dossiers | 14 | 14060000107285 | 14060000107305 | 1 | 3 | PA267233 | rapporteur | ||
| 14060000107331 | L14/dossiers | 14 | 14060000107321 | 14060000107330 | 1 | 3 | PA1710 | rapporteur | ||
| 14060000107345 | L14/dossiers | 14 | 14060000107321 | 14060000107344 | 1 | 3 | PA227097 | rapporteur | ||
| 14060000107393 | L14/dossiers | 14 | 14060000107385 | 14060000107392 | 1 | 3 | PA267289 | rapporteur | ||
| 14060000107418 | L14/dossiers | 14 | 14060000107409 | 14060000107417 | 1 | 3 | PA1142 | rapporteur | ||
| 14060000107430 | L14/dossiers | 14 | 14060000107409 | 14060000107429 | 1 | 3 | PA609218 | rapporteur | ||
| 14060000107450 | L14/dossiers | 14 | 14060000107440 | 14060000107449 | 1 | 3 | PA1931 | rapporteur |