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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000106177 | L16/dossiers | 16 | 16060000106169 | 16060000106176 | 1 | 3 | PA795794 | rapporteur | ||
| 16060000106197 | L16/dossiers | 16 | 16060000106189 | 16060000106196 | 1 | 3 | PA720952 | rapporteur | ||
| 16060000106241 | L16/dossiers | 16 | 16060000106233 | 16060000106240 | 1 | 3 | PA335999 | rapporteur | ||
| 16060000106251 | L16/dossiers | 16 | 16060000106246 | 16060000106250 | 1 | 2 | PA795828 | rapporteur | ||
| 16060000106258 | L16/dossiers | 16 | 16060000106253 | 16060000106257 | 1 | 2 | PA793672 | rapporteur | ||
| 16060000106268 | L16/dossiers | 16 | 16060000106259 | 16060000106267 | 1 | 3 | PA827954 | rapporteur | ||
| 16060000106400 | L16/dossiers | 16 | 16060000106390 | 16060000106399 | 1 | 3 | PA703522 | rapporteur | ||
| 16060000106411 | L16/dossiers | 16 | 16060000106390 | 16060000106410 | 1 | 3 | PA720138 | rapporteur | ||
| 16060000106412 | L16/dossiers | 16 | 16060000106390 | 16060000106410 | 2 | 3 | PA719272 | rapporteur | ||
| 16060000106449 | L16/dossiers | 16 | 16060000106437 | 16060000106448 | 1 | 3 | PA720684 | rapporteur | ||
| 16060000106463 | L16/dossiers | 16 | 16060000106437 | 16060000106462 | 1 | 3 | PA415479 | rapporteur | ||
| 16060000106499 | L16/dossiers | 16 | 16060000106490 | 16060000106498 | 1 | 3 | PA703536 | rapporteur | ||
| 16060000106511 | L16/dossiers | 16 | 16060000106490 | 16060000106510 | 1 | 3 | PA1008 | rapporteur | ||
| 16060000106740 | L16/dossiers | 16 | 16060000106731 | 16060000106739 | 1 | 3 | PA736247 | rapporteur | ||
| 16060000106875 | L16/dossiers | 16 | 16060000106870 | 16060000106874 | 1 | 2 | PA794146 | rapporteur | ||
| 16060000106876 | L16/dossiers | 16 | 16060000106870 | 16060000106874 | 2 | 2 | PA719882 | rapporteur | ||
| 16060000106904 | L16/dossiers | 16 | 16060000106896 | 16060000106903 | 1 | 3 | PA794022 | rapporteur | ||
| 16060000107113 | L16/dossiers | 16 | 16060000107105 | 16060000107112 | 1 | 3 | PA795868 | rapporteur | ||
| 16060000107136 | L16/dossiers | 16 | 16060000107128 | 16060000107135 | 1 | 3 | PA794650 | rapporteur | ||
| 16060000107200 | L16/dossiers | 16 | 16060000107192 | 16060000107199 | 1 | 3 | PA721270 | rapporteur | ||
| 16060000107213 | L16/dossiers | 16 | 16060000107205 | 16060000107212 | 1 | 3 | PA795998 | rapporteur | ||
| 16060000107226 | L16/dossiers | 16 | 16060000107218 | 16060000107225 | 1 | 3 | PA722110 | rapporteur | ||
| 16060000107508 | L16/dossiers | 16 | 16060000107499 | 16060000107507 | 1 | 3 | PA1573 | rapporteur | ||
| 16060000107520 | L16/dossiers | 16 | 16060000107499 | 16060000107519 | 1 | 3 | PA795330 | rapporteur | ||
| 16060000107551 | L16/dossiers | 16 | 16060000107543 | 16060000107550 | 1 | 3 | PA795386 | rapporteur | ||
| 16060000107582 | L16/dossiers | 16 | 16060000107574 | 16060000107581 | 1 | 3 | PA736235 | rapporteur | ||
| 16060000107622 | L16/dossiers | 16 | 16060000107614 | 16060000107621 | 1 | 3 | PA775226 | rapporteur | ||
| 16060000107693 | L16/dossiers | 16 | 16060000107685 | 16060000107692 | 1 | 3 | PA721158 | rapporteur | ||
| 16060000107719 | L16/dossiers | 16 | 16060000107711 | 16060000107718 | 1 | 3 | PA793992 | rapporteur | ||
| 16060000107938 | L16/dossiers | 16 | 16060000107926 | 16060000107937 | 1 | 3 | PA720354 | rapporteur | ||
| 16060000107953 | L16/dossiers | 16 | 16060000107926 | 16060000107952 | 1 | 3 | PA720138 | rapporteur pour avis | ||
| 16060000107959 | L16/dossiers | 16 | 16060000107926 | 16060000107958 | 1 | 3 | PA793572 | rapporteur pour avis | ||
| 16060000107966 | L16/dossiers | 16 | 16060000107926 | 16060000107965 | 1 | 3 | PA719822 | rapporteur pour avis | ||
| 16060000107998 | L16/dossiers | 16 | 16060000107926 | 16060000107997 | 1 | 3 | PA304085 | rapporteur | ||
| 16060000108009 | L16/dossiers | 16 | 16060000107926 | 16060000108008 | 1 | 2 | PA720354 | rapporteur | ||
| 16060000108010 | L16/dossiers | 16 | 16060000107926 | 16060000108008 | 2 | 2 | PA304085 | rapporteur | ||
| 16060000108011 | L16/dossiers | 16 | 16060000107926 | 16060000108008 | 3 | 2 | PA719822 | rapporteur | ||
| 16060000108038 | L16/dossiers | 16 | 16060000108030 | 16060000108037 | 1 | 3 | PA606507 | rapporteur | ||
| 16060000108095 | L16/dossiers | 16 | 16060000108072 | 16060000108094 | 1 | 3 | PA703511 | rapporteur | ||
| 16060000108106 | L16/dossiers | 16 | 16060000108072 | 16060000108105 | 1 | 3 | PA795828 | rapporteur | ||
| 16060000108107 | L16/dossiers | 16 | 16060000108072 | 16060000108105 | 2 | 3 | PA721234 | rapporteur | ||
| 16060000108129 | L16/dossiers | 16 | 16060000108120 | 16060000108128 | 1 | 3 | PA429858 | rapporteur | ||
| 16060000108154 | L16/dossiers | 16 | 16060000108146 | 16060000108153 | 1 | 3 | PA703520 | rapporteur | ||
| 16060000108226 | L16/dossiers | 16 | 16060000108218 | 16060000108225 | 1 | 3 | PA267766 | rapporteur | ||
| 16060000108432 | L16/dossiers | 16 | 16060000108409 | 16060000108431 | 1 | 3 | PA429875 | rapporteur | ||
| 16060000108448 | L16/dossiers | 16 | 16060000108437 | 16060000108447 | 1 | 3 | PA719472 | rapporteur | ||
| 16060000108462 | L16/dossiers | 16 | 16060000108437 | 16060000108461 | 1 | 3 | PA429875 | rapporteur | ||
| 16060000108463 | L16/dossiers | 16 | 16060000108437 | 16060000108461 | 2 | 3 | PA429869 | rapporteur | ||
| 16060000108464 | L16/dossiers | 16 | 16060000108437 | 16060000108461 | 3 | 3 | PA736191 | rapporteur | ||
| 16060000108465 | L16/dossiers | 16 | 16060000108437 | 16060000108461 | 4 | 3 | PA775200 | rapporteur |