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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000094444 | L16/dossiers | 16 | 16060000094418 | 16060000094443 | 1 | 3 | PA721262 | rapporteur | ||
| 16060000094461 | L16/dossiers | 16 | 16060000094418 | 16060000094460 | 1 | 2 | PA721262 | rapporteur | ||
| 16060000094462 | L16/dossiers | 16 | 16060000094418 | 16060000094460 | 2 | 2 | PA267340 | rapporteur | ||
| 16060000094485 | L16/dossiers | 16 | 16060000094477 | 16060000094484 | 1 | 3 | PA703537 | rapporteur | ||
| 16060000094498 | L16/dossiers | 16 | 16060000094477 | 16060000094497 | 1 | 3 | PA796078 | rapporteur | ||
| 16060000094510 | L16/dossiers | 16 | 16060000094502 | 16060000094509 | 1 | 3 | PA429887 | rapporteur | ||
| 16060000094522 | L16/dossiers | 16 | 16060000094502 | 16060000094521 | 1 | 3 | PA795808 | rapporteur | ||
| 16060000094539 | L16/dossiers | 16 | 16060000094531 | 16060000094538 | 1 | 3 | PA775302 | rapporteur | ||
| 16060000094550 | L16/dossiers | 16 | 16060000094531 | 16060000094549 | 1 | 3 | PA643089 | rapporteur | ||
| 16060000094674 | L16/dossiers | 16 | 16060000094557 | 16060000094673 | 1 | 3 | PA703515 | rapporteur | ||
| 16060000094693 | L16/dossiers | 16 | 16060000094684 | 16060000094692 | 1 | 3 | PA775234 | rapporteur | ||
| 16060000094705 | L16/dossiers | 16 | 16060000094684 | 16060000094704 | 1 | 3 | PA794818 | rapporteur | ||
| 16060000094724 | L16/dossiers | 16 | 16060000094715 | 16060000094723 | 1 | 3 | PA429875 | rapporteur | ||
| 16060000094725 | L16/dossiers | 16 | 16060000094715 | 16060000094723 | 2 | 3 | PA415448 | rapporteur | ||
| 16060000094757 | L16/dossiers | 16 | 16060000094736 | 16060000094756 | 1 | 3 | PA703494 | rapporteur | ||
| 16060000094776 | L16/dossiers | 16 | 16060000094768 | 16060000094775 | 1 | 3 | PA2870 | rapporteur | ||
| 16060000094788 | L16/dossiers | 16 | 16060000094768 | 16060000094787 | 1 | 3 | PA793860 | rapporteur | ||
| 16060000094805 | L16/dossiers | 16 | 16060000094797 | 16060000094804 | 1 | 3 | PA703494 | rapporteur | ||
| 16060000094816 | L16/dossiers | 16 | 16060000094797 | 16060000094815 | 1 | 3 | PA795270 | rapporteur | ||
| 16060000094837 | L16/dossiers | 16 | 16060000094829 | 16060000094836 | 1 | 3 | PA736190 | rapporteur | ||
| 16060000094878 | L16/dossiers | 16 | 16060000094855 | 16060000094877 | 1 | 3 | PA429886 | rapporteur | ||
| 16060000094889 | L16/dossiers | 16 | 16060000094855 | 16060000094888 | 1 | 3 | PA721976 | rapporteur | ||
| 16060000094890 | L16/dossiers | 16 | 16060000094855 | 16060000094888 | 2 | 3 | PA605745 | rapporteur | ||
| 16060000094925 | L16/dossiers | 16 | 16060000094917 | 16060000094924 | 1 | 3 | PA304085 | rapporteur | ||
| 16060000094938 | L16/dossiers | 16 | 16060000094917 | 16060000094937 | 1 | 3 | PA795900 | rapporteur | ||
| 16060000094967 | L16/dossiers | 16 | 16060000094955 | 16060000094966 | 1 | 3 | PA736224 | rapporteur | ||
| 16060000095139 | L16/dossiers | 16 | 16060000095128 | 16060000095138 | 1 | 3 | PA794442 | rapporteur | ||
| 16060000095153 | L16/dossiers | 16 | 16060000095128 | 16060000095152 | 1 | 3 | PA429835 | rapporteur | ||
| 16060000095227 | L16/dossiers | 16 | 16060000095216 | 16060000095226 | 1 | 3 | PA719866 | rapporteur | ||
| 16060000095247 | L16/dossiers | 16 | 16060000095216 | 16060000095246 | 1 | 3 | PA429858 | rapporteur | ||
| 16060000095261 | L16/dossiers | 16 | 16060000095216 | 16060000095260 | 1 | 2 | PA719866 | rapporteur | ||
| 16060000095262 | L16/dossiers | 16 | 16060000095216 | 16060000095260 | 2 | 2 | PA429858 | rapporteur | ||
| 16060000095291 | L16/dossiers | 16 | 16060000095280 | 16060000095290 | 1 | 3 | PA719472 | rapporteur | ||
| 16060000095305 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 1 | 3 | PA429875 | rapporteur | ||
| 16060000095306 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 2 | 3 | PA429869 | rapporteur | ||
| 16060000095307 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 3 | 3 | PA736191 | rapporteur | ||
| 16060000095308 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 4 | 3 | PA775200 | rapporteur | ||
| 16060000095309 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 5 | 3 | PA757678 | rapporteur | ||
| 16060000095310 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 6 | 3 | PA736181 | rapporteur | ||
| 16060000095311 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 7 | 3 | PA703514 | rapporteur | ||
| 16060000095312 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 8 | 3 | PA429895 | rapporteur | ||
| 16060000095313 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 9 | 3 | PA394676 | rapporteur | ||
| 16060000095314 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 10 | 3 | PA775184 | rapporteur | ||
| 16060000095315 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 11 | 3 | PA709298 | rapporteur | ||
| 16060000095316 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 12 | 3 | PA775182 | rapporteur | ||
| 16060000095317 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 13 | 3 | PA429867 | rapporteur | ||
| 16060000095318 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 14 | 3 | PA736208 | rapporteur | ||
| 16060000095319 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 15 | 3 | PA415467 | rapporteur | ||
| 16060000095320 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 16 | 3 | PA775262 | rapporteur | ||
| 16060000095321 | L16/dossiers | 16 | 16060000095280 | 16060000095304 | 17 | 3 | PA736211 | rapporteur |