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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000115406 | L16/dossiers | 16 | 16060000115396 | 16060000115405 | 1 | 3 | PA775284 | rapporteur | ||
| 16060000115417 | L16/dossiers | 16 | 16060000115396 | 16060000115416 | 1 | 3 | PA719798 | rapporteur | ||
| 16060000115459 | L16/dossiers | 16 | 16060000115442 | 16060000115458 | 1 | 3 | PA775224 | rapporteur | ||
| 16060000115470 | L16/dossiers | 16 | 16060000115442 | 16060000115469 | 1 | 3 | PA793664 | rapporteur | ||
| 16060000115521 | L16/dossiers | 16 | 16060000115499 | 16060000115520 | 1 | 3 | PA775170 | rapporteur | ||
| 16060000115598 | L16/dossiers | 16 | 16060000115590 | 16060000115597 | 1 | 3 | PA795386 | rapporteur | ||
| 16060000115649 | L16/dossiers | 16 | 16060000115641 | 16060000115648 | 1 | 3 | PA335999 | rapporteur | ||
| 16060000115759 | L16/dossiers | 16 | 16060000115746 | 16060000115758 | 1 | 3 | PA795652 | rapporteur | ||
| 16060000115776 | L16/dossiers | 16 | 16060000115746 | 16060000115775 | 1 | 3 | PA703523 | rapporteur | ||
| 16060000115787 | L16/dossiers | 16 | 16060000115746 | 16060000115786 | 1 | 2 | PA795652 | rapporteur | ||
| 16060000115788 | L16/dossiers | 16 | 16060000115746 | 16060000115786 | 2 | 2 | PA703523 | rapporteur | ||
| 16060000115826 | L16/dossiers | 16 | 16060000115806 | 16060000115825 | 1 | 3 | PA720066 | rapporteur | ||
| 16060000115827 | L16/dossiers | 16 | 16060000115806 | 16060000115825 | 2 | 3 | PA642868 | rapporteur | ||
| 16060000115828 | L16/dossiers | 16 | 16060000115806 | 16060000115825 | 3 | 3 | PA722142 | rapporteur | ||
| 16060000115829 | L16/dossiers | 16 | 16060000115806 | 16060000115825 | 4 | 3 | PA720074 | rapporteur | ||
| 16060000115830 | L16/dossiers | 16 | 16060000115806 | 16060000115825 | 5 | 3 | PA722374 | rapporteur | ||
| 16060000115846 | L16/dossiers | 16 | 16060000115806 | 16060000115845 | 1 | 3 | PA720022 | rapporteur pour avis | ||
| 16060000115868 | L16/dossiers | 16 | 16060000115806 | 16060000115867 | 1 | 3 | PA703498 | rapporteur | ||
| 16060000115869 | L16/dossiers | 16 | 16060000115806 | 16060000115867 | 2 | 3 | PA703515 | rapporteur | ||
| 16060000115870 | L16/dossiers | 16 | 16060000115806 | 16060000115867 | 3 | 3 | PA267081 | rapporteur | ||
| 16060000115871 | L16/dossiers | 16 | 16060000115806 | 16060000115867 | 4 | 3 | PA736223 | rapporteur | ||
| 16060000115872 | L16/dossiers | 16 | 16060000115806 | 16060000115867 | 5 | 3 | PA763158 | rapporteur | ||
| 16060000115873 | L16/dossiers | 16 | 16060000115806 | 16060000115867 | 6 | 3 | PA267112 | rapporteur | ||
| 16060000115884 | L16/dossiers | 16 | 16060000115806 | 16060000115883 | 1 | 2 | PA720066 | rapporteur | ||
| 16060000115885 | L16/dossiers | 16 | 16060000115806 | 16060000115883 | 2 | 2 | PA703498 | rapporteur | ||
| 16060000115960 | L16/dossiers | 16 | 16060000115951 | 16060000115959 | 1 | 3 | PA775172 | rapporteur | ||
| 16060000115961 | L16/dossiers | 16 | 16060000115951 | 16060000115959 | 2 | 3 | PA736166 | rapporteur | ||
| 16060000115962 | L16/dossiers | 16 | 16060000115951 | 16060000115959 | 3 | 3 | PA775192 | rapporteur | ||
| 16060000116007 | L16/dossiers | 16 | 16060000115998 | 16060000116006 | 1 | 3 | PA1127 | rapporteur | ||
| 16060000116018 | L16/dossiers | 16 | 16060000115998 | 16060000116017 | 1 | 3 | PA721976 | rapporteur | ||
| 16060000116035 | L16/dossiers | 16 | 16060000115998 | 16060000116034 | 1 | 2 | PA1127 | rapporteur | ||
| 16060000116036 | L16/dossiers | 16 | 16060000115998 | 16060000116034 | 2 | 2 | PA721976 | rapporteur | ||
| 16060000116077 | L16/dossiers | 16 | 16060000116069 | 16060000116076 | 1 | 3 | PA775196 | rapporteur | ||
| 16060000116135 | L16/dossiers | 16 | 16060000116127 | 16060000116134 | 1 | 3 | PA828004 | rapporteur | ||
| 16060000116182 | L16/dossiers | 16 | 16060000116174 | 16060000116181 | 1 | 3 | PA721262 | rapporteur | ||
| 16060000116233 | L16/dossiers | 16 | 16060000116225 | 16060000116232 | 1 | 3 | PA426327 | rapporteur | ||
| 16060000116245 | L16/dossiers | 16 | 16060000116225 | 16060000116244 | 1 | 3 | PA605782 | rapporteur | ||
| 16060000116259 | L16/dossiers | 16 | 16060000116254 | 16060000116258 | 1 | 2 | PA722292 | rapporteur | ||
| 16060000116260 | L16/dossiers | 16 | 16060000116254 | 16060000116258 | 2 | 2 | PA794494 | rapporteur | ||
| 16060000116266 | L16/dossiers | 16 | 16060000116261 | 16060000116265 | 1 | 2 | PA795746 | rapporteur | ||
| 16060000116267 | L16/dossiers | 16 | 16060000116261 | 16060000116265 | 2 | 2 | PA719600 | rapporteur | ||
| 16060000116329 | L16/dossiers | 16 | 16060000116321 | 16060000116328 | 1 | 3 | PA718784 | rapporteur | ||
| 16060000116330 | L16/dossiers | 16 | 16060000116321 | 16060000116328 | 2 | 3 | PA721328 | rapporteur | ||
| 16060000116349 | L16/dossiers | 16 | 16060000116321 | 16060000116348 | 1 | 3 | PA828008 | rapporteur | ||
| 16060000116388 | L16/dossiers | 16 | 16060000116380 | 16060000116387 | 1 | 3 | PA720552 | rapporteur | ||
| 16060000116412 | L16/dossiers | 16 | 16060000116404 | 16060000116411 | 1 | 3 | PA342415 | rapporteur | ||
| 16060000116482 | L16/dossiers | 16 | 16060000116474 | 16060000116481 | 1 | 3 | PA795310 | rapporteur | ||
| 16060000116505 | L16/dossiers | 16 | 16060000116497 | 16060000116504 | 1 | 3 | PA794038 | rapporteur | ||
| 16060000116534 | L16/dossiers | 16 | 16060000116526 | 16060000116533 | 1 | 3 | PA793736 | rapporteur | ||
| 16060000116551 | L16/dossiers | 16 | 16060000116543 | 16060000116550 | 1 | 3 | PA793756 | rapporteur |