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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 14060000093954 | L14/dossiers | 14 | 14060000093927 | 14060000093953 | 1 | 3 | PA1401 | rapporteur pour avis | ||
| 14060000094047 | L14/dossiers | 14 | 14060000094037 | 14060000094046 | 1 | 3 | PA607761 | rapporteur | ||
| 14060000094065 | L14/dossiers | 14 | 14060000094037 | 14060000094064 | 1 | 3 | PA415485 | rapporteur | ||
| 14060000094099 | L14/dossiers | 14 | 14060000094093 | 14060000094098 | 1 | 2 | PA267407 | rapporteur | ||
| 14060000094112 | L14/dossiers | 14 | 14060000094101 | 14060000094111 | 1 | 3 | PA609578 | rapporteur | ||
| 14060000094126 | L14/dossiers | 14 | 14060000094101 | 14060000094125 | 1 | 3 | PA429883 | rapporteur | ||
| 14060000094161 | L14/dossiers | 14 | 14060000094152 | 14060000094160 | 1 | 3 | PA703540 | rapporteur | ||
| 14060000094173 | L14/dossiers | 14 | 14060000094152 | 14060000094172 | 1 | 3 | PA1498 | rapporteur | ||
| 14060000094264 | L14/dossiers | 14 | 14060000094255 | 14060000094263 | 1 | 3 | PA1919 | rapporteur | ||
| 14060000094276 | L14/dossiers | 14 | 14060000094255 | 14060000094275 | 1 | 3 | PA608686 | rapporteur | ||
| 14060000094321 | L14/dossiers | 14 | 14060000094310 | 14060000094320 | 1 | 3 | PA335054 | rapporteur | ||
| 14060000094336 | L14/dossiers | 14 | 14060000094310 | 14060000094335 | 1 | 3 | PA2552 | rapporteur | ||
| 14060000094341 | L14/dossiers | 14 | 14060000094310 | 14060000094340 | 1 | 3 | PA415475 | rapporteur | ||
| 14060000094353 | L14/dossiers | 14 | 14060000094310 | 14060000094352 | 1 | 2 | PA335054 | rapporteur | ||
| 14060000094354 | L14/dossiers | 14 | 14060000094310 | 14060000094352 | 2 | 2 | PA2552 | rapporteur | ||
| 14060000094389 | L14/dossiers | 14 | 14060000094381 | 14060000094388 | 1 | 3 | PA605036 | rapporteur | ||
| 14060000094438 | L14/dossiers | 14 | 14060000094430 | 14060000094437 | 1 | 3 | PA331282 | rapporteur | ||
| 14060000094473 | L14/dossiers | 14 | 14060000094462 | 14060000094472 | 1 | 3 | PA606665 | rapporteur | ||
| 14060000094481 | L14/dossiers | 14 | 14060000094462 | 14060000094480 | 1 | 3 | PA609963 | rapporteur pour avis | ||
| 14060000094494 | L14/dossiers | 14 | 14060000094485 | 14060000094493 | 1 | 3 | PA415470 | rapporteur | ||
| 14060000094507 | L14/dossiers | 14 | 14060000094485 | 14060000094506 | 1 | 3 | PA608328 | rapporteur | ||
| 14060000094521 | L14/dossiers | 14 | 14060000094485 | 14060000094520 | 1 | 2 | PA608328 | rapporteur | ||
| 14060000094522 | L14/dossiers | 14 | 14060000094485 | 14060000094520 | 2 | 2 | PA415470 | rapporteur | ||
| 14060000094565 | L14/dossiers | 14 | 14060000094555 | 14060000094564 | 1 | 3 | PA609590 | rapporteur | ||
| 14060000094582 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 1 | 3 | PA415448 | rapporteur | ||
| 14060000094583 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 2 | 3 | PA1142 | rapporteur | ||
| 14060000094584 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 3 | 3 | PA304113 | rapporteur | ||
| 14060000094585 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 4 | 3 | PA429832 | rapporteur | ||
| 14060000094586 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 5 | 3 | PA415495 | rapporteur | ||
| 14060000094587 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 6 | 3 | PA341272 | rapporteur | ||
| 14060000094588 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 7 | 3 | PA303992 | rapporteur | ||
| 14060000094589 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 8 | 3 | PA905 | rapporteur | ||
| 14060000094590 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 9 | 3 | PA394676 | rapporteur | ||
| 14060000094591 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 10 | 3 | PA633 | rapporteur | ||
| 14060000094592 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 11 | 3 | PA733 | rapporteur | ||
| 14060000094593 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 12 | 3 | PA429867 | rapporteur | ||
| 14060000094594 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 13 | 3 | PA429837 | rapporteur | ||
| 14060000094595 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 14 | 3 | PA415467 | rapporteur | ||
| 14060000094596 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 15 | 3 | PA703514 | rapporteur | ||
| 14060000094597 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 16 | 3 | PA429875 | rapporteur | ||
| 14060000094598 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 17 | 3 | PA267419 | rapporteur | ||
| 14060000094599 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 18 | 3 | PA429872 | rapporteur | ||
| 14060000094600 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 19 | 3 | PA703533 | rapporteur | ||
| 14060000094601 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 20 | 3 | PA980 | rapporteur | ||
| 14060000094602 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 21 | 3 | PA304079 | rapporteur | ||
| 14060000094603 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 22 | 3 | PA1993 | rapporteur | ||
| 14060000094604 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 23 | 3 | PA1336 | rapporteur | ||
| 14060000094605 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 24 | 3 | PA205280 | rapporteur | ||
| 14060000094606 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 25 | 3 | PA415447 | rapporteur | ||
| 14060000094607 | L14/dossiers | 14 | 14060000094555 | 14060000094581 | 26 | 3 | PA369 | rapporteur |