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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000097861 | L16/dossiers | 16 | 16060000097853 | 16060000097860 | 1 | 3 | PA736205 | rapporteur | ||
| 16060000097899 | L16/dossiers | 16 | 16060000097891 | 16060000097898 | 1 | 3 | PA757678 | rapporteur | ||
| 16060000097974 | L16/dossiers | 16 | 16060000097966 | 16060000097973 | 1 | 3 | PA794198 | rapporteur | ||
| 16060000097991 | L16/dossiers | 16 | 16060000097983 | 16060000097990 | 1 | 3 | PA795144 | rapporteur | ||
| 16060000098105 | L16/dossiers | 16 | 16060000098016 | 16060000098104 | 1 | 3 | PA703510 | rapporteur | ||
| 16060000098126 | L16/dossiers | 16 | 16060000098114 | 16060000098125 | 1 | 3 | PA795884 | rapporteur | ||
| 16060000098150 | L16/dossiers | 16 | 16060000098114 | 16060000098149 | 1 | 3 | PA736239 | rapporteur | ||
| 16060000098151 | L16/dossiers | 16 | 16060000098114 | 16060000098149 | 2 | 3 | PA736223 | rapporteur | ||
| 16060000098162 | L16/dossiers | 16 | 16060000098114 | 16060000098161 | 1 | 2 | PA795884 | rapporteur | ||
| 16060000098163 | L16/dossiers | 16 | 16060000098114 | 16060000098161 | 2 | 2 | PA736239 | rapporteur | ||
| 16060000098164 | L16/dossiers | 16 | 16060000098114 | 16060000098161 | 3 | 2 | PA736223 | rapporteur | ||
| 16060000098205 | L16/dossiers | 16 | 16060000098196 | 16060000098204 | 1 | 3 | PA1001 | rapporteur | ||
| 16060000098206 | L16/dossiers | 16 | 16060000098196 | 16060000098204 | 2 | 3 | PA703492 | rapporteur | ||
| 16060000098217 | L16/dossiers | 16 | 16060000098196 | 16060000098216 | 1 | 3 | PA606507 | rapporteur | ||
| 16060000098232 | L16/dossiers | 16 | 16060000098196 | 16060000098231 | 1 | 3 | PA721522 | rapporteur pour avis | ||
| 16060000098256 | L16/dossiers | 16 | 16060000098196 | 16060000098255 | 1 | 2 | PA1001 | rapporteur | ||
| 16060000098257 | L16/dossiers | 16 | 16060000098196 | 16060000098255 | 2 | 2 | PA703492 | rapporteur | ||
| 16060000098258 | L16/dossiers | 16 | 16060000098196 | 16060000098255 | 3 | 2 | PA606507 | rapporteur | ||
| 16060000098283 | L16/dossiers | 16 | 16060000098275 | 16060000098282 | 1 | 3 | PA736206 | rapporteur | ||
| 16060000098294 | L16/dossiers | 16 | 16060000098275 | 16060000098293 | 1 | 3 | PA793382 | rapporteur | ||
| 16060000098295 | L16/dossiers | 16 | 16060000098275 | 16060000098293 | 2 | 3 | PA720696 | rapporteur | ||
| 16060000098325 | L16/dossiers | 16 | 16060000098316 | 16060000098324 | 1 | 3 | PA784534 | rapporteur | ||
| 16060000098336 | L16/dossiers | 16 | 16060000098316 | 16060000098335 | 1 | 3 | PA607395 | rapporteur | ||
| 16060000098375 | L16/dossiers | 16 | 16060000098367 | 16060000098374 | 1 | 3 | PA793852 | rapporteur | ||
| 16060000098448 | L16/dossiers | 16 | 16060000098440 | 16060000098447 | 1 | 3 | PA775198 | rapporteur | ||
| 16060000098496 | L16/dossiers | 16 | 16060000098491 | 16060000098495 | 1 | 2 | PA795884 | rapporteur | ||
| 16060000098497 | L16/dossiers | 16 | 16060000098491 | 16060000098495 | 2 | 2 | PA1567 | rapporteur | ||
| 16060000098842 | L16/dossiers | 16 | 16060000098830 | 16060000098841 | 1 | 3 | PA719472 | rapporteur | ||
| 16060000098861 | L16/dossiers | 16 | 16060000098830 | 16060000098860 | 1 | 3 | PA429875 | rapporteur | ||
| 16060000098871 | L16/dossiers | 16 | 16060000098830 | 16060000098870 | 1 | 2 | PA719472 | rapporteur | ||
| 16060000098872 | L16/dossiers | 16 | 16060000098830 | 16060000098870 | 2 | 2 | PA429875 | rapporteur | ||
| 16060000098941 | L16/dossiers | 16 | 16060000098924 | 16060000098940 | 1 | 3 | PA720066 | rapporteur | ||
| 16060000098942 | L16/dossiers | 16 | 16060000098924 | 16060000098940 | 2 | 3 | PA720074 | rapporteur | ||
| 16060000098943 | L16/dossiers | 16 | 16060000098924 | 16060000098940 | 3 | 3 | PA642868 | rapporteur | ||
| 16060000098944 | L16/dossiers | 16 | 16060000098924 | 16060000098940 | 4 | 3 | PA722374 | rapporteur | ||
| 16060000098945 | L16/dossiers | 16 | 16060000098924 | 16060000098940 | 5 | 3 | PA642847 | rapporteur | ||
| 16060000098960 | L16/dossiers | 16 | 16060000098924 | 16060000098959 | 1 | 3 | PA720022 | rapporteur pour avis | ||
| 16060000098985 | L16/dossiers | 16 | 16060000098924 | 16060000098984 | 1 | 3 | PA703498 | rapporteur | ||
| 16060000098986 | L16/dossiers | 16 | 16060000098924 | 16060000098984 | 2 | 3 | PA703515 | rapporteur | ||
| 16060000098987 | L16/dossiers | 16 | 16060000098924 | 16060000098984 | 3 | 3 | PA267081 | rapporteur | ||
| 16060000098988 | L16/dossiers | 16 | 16060000098924 | 16060000098984 | 4 | 3 | PA429851 | rapporteur | ||
| 16060000098989 | L16/dossiers | 16 | 16060000098924 | 16060000098984 | 5 | 3 | PA736223 | rapporteur | ||
| 16060000098990 | L16/dossiers | 16 | 16060000098924 | 16060000098984 | 6 | 3 | PA703518 | rapporteur | ||
| 16060000099001 | L16/dossiers | 16 | 16060000098924 | 16060000099000 | 1 | 2 | PA720066 | rapporteur | ||
| 16060000099002 | L16/dossiers | 16 | 16060000098924 | 16060000099000 | 2 | 2 | PA703498 | rapporteur | ||
| 16060000099076 | L16/dossiers | 16 | 16060000099068 | 16060000099075 | 1 | 3 | PA721158 | rapporteur | ||
| 16060000099134 | L16/dossiers | 16 | 16060000099129 | 16060000099133 | 1 | 2 | PA720430 | rapporteur | ||
| 16060000099135 | L16/dossiers | 16 | 16060000099129 | 16060000099133 | 2 | 2 | PA721880 | rapporteur | ||
| 16060000099141 | L16/dossiers | 16 | 16060000099136 | 16060000099140 | 1 | 2 | PA721584 | rapporteur | ||
| 16060000099142 | L16/dossiers | 16 | 16060000099136 | 16060000099140 | 2 | 2 | PA608695 | rapporteur |