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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 14060000104983 | L14/dossiers | 14 | 14060000104978 | 14060000104982 | 1 | 2 | PA610203 | rapporteur | ||
| 14060000104995 | L14/dossiers | 14 | 14060000104985 | 14060000104994 | 1 | 3 | PA2774 | rapporteur | ||
| 14060000105007 | L14/dossiers | 14 | 14060000104985 | 14060000105006 | 1 | 3 | PA610075 | rapporteur | ||
| 14060000105021 | L14/dossiers | 14 | 14060000104985 | 14060000105020 | 1 | 2 | PA610075 | rapporteur | ||
| 14060000105022 | L14/dossiers | 14 | 14060000104985 | 14060000105020 | 2 | 2 | PA2774 | rapporteur | ||
| 14060000105047 | L14/dossiers | 14 | 14060000105039 | 14060000105046 | 1 | 3 | PA268019 | rapporteur | ||
| 14060000105064 | L14/dossiers | 14 | 14060000105055 | 14060000105063 | 1 | 3 | PA425322 | rapporteur | ||
| 14060000105076 | L14/dossiers | 14 | 14060000105055 | 14060000105075 | 1 | 3 | PA606712 | rapporteur | ||
| 14060000105158 | L14/dossiers | 14 | 14060000105149 | 14060000105157 | 1 | 3 | PA550 | rapporteur | ||
| 14060000105170 | L14/dossiers | 14 | 14060000105149 | 14060000105169 | 1 | 3 | PA2492 | rapporteur | ||
| 14060000105176 | L14/dossiers | 14 | 14060000105149 | 14060000105175 | 1 | 3 | PA331146 | rapporteur pour avis | ||
| 14060000105231 | L14/dossiers | 14 | 14060000105217 | 14060000105230 | 1 | 3 | PA335017 | rapporteur | ||
| 14060000105249 | L14/dossiers | 14 | 14060000105217 | 14060000105248 | 1 | 3 | PA608641 | rapporteur pour avis | ||
| 14060000105270 | L14/dossiers | 14 | 14060000105217 | 14060000105269 | 1 | 3 | PA703535 | rapporteur | ||
| 14060000105271 | L14/dossiers | 14 | 14060000105217 | 14060000105269 | 2 | 3 | PA703487 | rapporteur | ||
| 14060000105272 | L14/dossiers | 14 | 14060000105217 | 14060000105269 | 3 | 3 | PA703504 | rapporteur | ||
| 14060000105293 | L14/dossiers | 14 | 14060000105217 | 14060000105292 | 1 | 2 | PA335017 | rapporteur | ||
| 14060000105294 | L14/dossiers | 14 | 14060000105217 | 14060000105292 | 2 | 2 | PA703535 | rapporteur | ||
| 14060000105349 | L14/dossiers | 14 | 14060000105341 | 14060000105348 | 1 | 3 | PA334906 | rapporteur | ||
| 14060000105362 | L14/dossiers | 14 | 14060000105357 | 14060000105361 | 1 | 2 | PA607395 | rapporteur | ||
| 14060000105425 | L14/dossiers | 14 | 14060000105415 | 14060000105424 | 1 | 3 | PA610936 | rapporteur | ||
| 14060000105453 | L14/dossiers | 14 | 14060000105445 | 14060000105452 | 1 | 3 | PA341981 | rapporteur | ||
| 14060000105466 | L14/dossiers | 14 | 14060000105458 | 14060000105465 | 1 | 3 | PA429860 | rapporteur | ||
| 14060000105471 | L14/dossiers | 14 | 14060000105458 | 14060000105470 | 1 | 3 | PA1134 | rapporteur pour avis | ||
| 14060000105530 | L14/dossiers | 14 | 14060000105522 | 14060000105529 | 1 | 3 | PA335054 | rapporteur | ||
| 14060000105556 | L14/dossiers | 14 | 14060000105548 | 14060000105555 | 1 | 3 | PA335054 | rapporteur | ||
| 14060000105561 | L14/dossiers | 14 | 14060000105548 | 14060000105560 | 1 | 3 | PA335054 | rapporteur | ||
| 14060000105579 | L14/dossiers | 14 | 14060000105571 | 14060000105578 | 1 | 3 | PA607632 | rapporteur | ||
| 14060000105609 | L14/dossiers | 14 | 14060000105599 | 14060000105608 | 1 | 3 | PA1182 | rapporteur | ||
| 14060000105615 | L14/dossiers | 14 | 14060000105599 | 14060000105614 | 1 | 3 | PA330118 | rapporteur pour avis | ||
| 14060000105628 | L14/dossiers | 14 | 14060000105599 | 14060000105627 | 1 | 3 | PA429849 | rapporteur | ||
| 14060000105644 | L14/dossiers | 14 | 14060000105636 | 14060000105643 | 1 | 3 | PA1579 | rapporteur | ||
| 14060000105810 | L14/dossiers | 14 | 14060000105801 | 14060000105809 | 1 | 3 | PA610594 | rapporteur | ||
| 14060000105823 | L14/dossiers | 14 | 14060000105801 | 14060000105822 | 1 | 3 | PA227078 | rapporteur | ||
| 14060000105853 | L14/dossiers | 14 | 14060000105845 | 14060000105852 | 1 | 3 | PA2790 | rapporteur | ||
| 14060000105865 | L14/dossiers | 14 | 14060000105845 | 14060000105864 | 1 | 3 | PA1198 | rapporteur | ||
| 14060000105895 | L14/dossiers | 14 | 14060000105887 | 14060000105894 | 1 | 3 | PA609205 | rapporteur | ||
| 14060000105910 | L14/dossiers | 14 | 14060000105902 | 14060000105909 | 1 | 3 | PA267673 | rapporteur | ||
| 14060000105934 | L14/dossiers | 14 | 14060000105924 | 14060000105933 | 1 | 3 | PA608686 | rapporteur | ||
| 14060000105949 | L14/dossiers | 14 | 14060000105924 | 14060000105948 | 1 | 3 | PA429895 | rapporteur | ||
| 14060000105968 | L14/dossiers | 14 | 14060000105957 | 14060000105967 | 1 | 3 | PA1579 | rapporteur | ||
| 14060000105981 | L14/dossiers | 14 | 14060000105957 | 14060000105980 | 1 | 3 | PA304085 | rapporteur | ||
| 14060000106005 | L14/dossiers | 14 | 14060000105996 | 14060000106004 | 1 | 3 | PA494 | rapporteur | ||
| 14060000106017 | L14/dossiers | 14 | 14060000105996 | 14060000106016 | 1 | 3 | PA2707 | rapporteur | ||
| 14060000106037 | L14/dossiers | 14 | 14060000106029 | 14060000106036 | 1 | 3 | PA267340 | rapporteur | ||
| 14060000106049 | L14/dossiers | 14 | 14060000106029 | 14060000106048 | 1 | 3 | PA610830 | rapporteur | ||
| 14060000106085 | L14/dossiers | 14 | 14060000106080 | 14060000106084 | 1 | 2 | PA381 | rapporteur | ||
| 14060000106129 | L14/dossiers | 14 | 14060000106119 | 14060000106128 | 1 | 3 | PA227099 | rapporteur | ||
| 14060000106141 | L14/dossiers | 14 | 14060000106119 | 14060000106140 | 1 | 3 | PA2503 | rapporteur | ||
| 14060000106160 | L14/dossiers | 14 | 14060000106119 | 14060000106159 | 1 | 2 | PA2503 | rapporteur |