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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 14060000108526 | L14/dossiers | 14 | 14060000108518 | 14060000108525 | 1 | 3 | PA2828 | rapporteur | ||
| 14060000108542 | L14/dossiers | 14 | 14060000108533 | 14060000108541 | 1 | 3 | PA631 | rapporteur | ||
| 14060000108554 | L14/dossiers | 14 | 14060000108533 | 14060000108553 | 1 | 3 | PA608686 | rapporteur | ||
| 14060000108584 | L14/dossiers | 14 | 14060000108575 | 14060000108583 | 1 | 3 | PA2528 | rapporteur | ||
| 14060000108596 | L14/dossiers | 14 | 14060000108575 | 14060000108595 | 1 | 3 | PA2191 | rapporteur | ||
| 14060000108614 | L14/dossiers | 14 | 14060000108605 | 14060000108613 | 1 | 3 | PA259 | rapporteur | ||
| 14060000108628 | L14/dossiers | 14 | 14060000108605 | 14060000108627 | 1 | 3 | PA782 | rapporteur | ||
| 14060000108694 | L14/dossiers | 14 | 14060000108684 | 14060000108693 | 1 | 3 | PA259 | rapporteur | ||
| 14060000108823 | L14/dossiers | 14 | 14060000108815 | 14060000108822 | 1 | 3 | PA415454 | rapporteur | ||
| 14060000108846 | L14/dossiers | 14 | 14060000108835 | 14060000108845 | 1 | 3 | PA606555 | rapporteur | ||
| 14060000108862 | L14/dossiers | 14 | 14060000108835 | 14060000108861 | 1 | 3 | PA304002 | rapporteur | ||
| 14060000108874 | L14/dossiers | 14 | 14060000108835 | 14060000108873 | 1 | 2 | PA606555 | rapporteur | ||
| 14060000108875 | L14/dossiers | 14 | 14060000108835 | 14060000108873 | 2 | 2 | PA304002 | rapporteur | ||
| 14060000108910 | L14/dossiers | 14 | 14060000108902 | 14060000108909 | 1 | 3 | PA227092 | rapporteur | ||
| 14060000108951 | L14/dossiers | 14 | 14060000108942 | 14060000108950 | 1 | 3 | PA1931 | rapporteur | ||
| 14060000108963 | L14/dossiers | 14 | 14060000108942 | 14060000108962 | 1 | 3 | PA1037 | rapporteur | ||
| 14060000109001 | L14/dossiers | 14 | 14060000108992 | 14060000109000 | 1 | 3 | PA429835 | rapporteur | ||
| 14060000109020 | L14/dossiers | 14 | 14060000109012 | 14060000109019 | 1 | 3 | PA605922 | rapporteur | ||
| 14060000109034 | L14/dossiers | 14 | 14060000109012 | 14060000109033 | 1 | 3 | PA429866 | rapporteur | ||
| 14060000109105 | L14/dossiers | 14 | 14060000109096 | 14060000109104 | 1 | 3 | PA429887 | rapporteur | ||
| 14060000109117 | L14/dossiers | 14 | 14060000109096 | 14060000109116 | 1 | 3 | PA2801 | rapporteur | ||
| 14060000109143 | L14/dossiers | 14 | 14060000109134 | 14060000109142 | 1 | 3 | PA331594 | rapporteur | ||
| 14060000109151 | L14/dossiers | 14 | 14060000109134 | 14060000109150 | 1 | 3 | PA543 | rapporteur pour avis | ||
| 14060000109166 | L14/dossiers | 14 | 14060000109134 | 14060000109165 | 1 | 3 | PA429846 | rapporteur | ||
| 14060000109171 | L14/dossiers | 14 | 14060000109134 | 14060000109170 | 1 | 3 | PA304017 | rapporteur pour avis | ||
| 14060000109181 | L14/dossiers | 14 | 14060000109134 | 14060000109180 | 1 | 2 | PA610313 | rapporteur | ||
| 14060000109182 | L14/dossiers | 14 | 14060000109134 | 14060000109180 | 2 | 2 | PA429846 | rapporteur | ||
| 14060000109192 | L14/dossiers | 14 | 14060000109134 | 14060000109191 | 1 | 3 | PA610313 | rapporteur | ||
| 14060000109280 | L14/dossiers | 14 | 14060000109272 | 14060000109279 | 1 | 3 | PA1761 | rapporteur | ||
| 14060000109294 | L14/dossiers | 14 | 14060000109272 | 14060000109293 | 1 | 3 | PA304014 | rapporteur | ||
| 14060000109338 | L14/dossiers | 14 | 14060000109330 | 14060000109337 | 1 | 3 | PA406065 | rapporteur | ||
| 14060000109350 | L14/dossiers | 14 | 14060000109330 | 14060000109349 | 1 | 3 | PA606098 | rapporteur | ||
| 14060000109385 | L14/dossiers | 14 | 14060000109375 | 14060000109384 | 1 | 3 | PA2685 | rapporteur | ||
| 14060000109398 | L14/dossiers | 14 | 14060000109375 | 14060000109397 | 1 | 3 | PA429835 | rapporteur | ||
| 14060000109433 | L14/dossiers | 14 | 14060000109423 | 14060000109432 | 1 | 3 | PA2597 | rapporteur | ||
| 14060000109467 | L14/dossiers | 14 | 14060000109457 | 14060000109466 | 1 | 3 | PA1496 | rapporteur | ||
| 14060000109480 | L14/dossiers | 14 | 14060000109457 | 14060000109479 | 1 | 3 | PA382672 | rapporteur | ||
| 14060000109503 | L14/dossiers | 14 | 14060000109495 | 14060000109502 | 1 | 3 | PA429842 | rapporteur | ||
| 14060000109530 | L14/dossiers | 14 | 14060000109521 | 14060000109529 | 1 | 3 | PA429835 | rapporteur | ||
| 14060000109542 | L14/dossiers | 14 | 14060000109521 | 14060000109541 | 1 | 3 | PA642739 | rapporteur | ||
| 14060000109597 | L14/dossiers | 14 | 14060000109589 | 14060000109596 | 1 | 3 | PA2183 | rapporteur | ||
| 14060000109658 | L14/dossiers | 14 | 14060000109649 | 14060000109657 | 1 | 3 | PA543 | rapporteur | ||
| 14060000109676 | L14/dossiers | 14 | 14060000109665 | 14060000109675 | 1 | 3 | PA2073 | rapporteur | ||
| 14060000109690 | L14/dossiers | 14 | 14060000109665 | 14060000109689 | 1 | 3 | PA1037 | rapporteur | ||
| 14060000109722 | L14/dossiers | 14 | 14060000109712 | 14060000109721 | 1 | 3 | PA429840 | rapporteur | ||
| 14060000109735 | L14/dossiers | 14 | 14060000109712 | 14060000109734 | 1 | 3 | PA608264 | rapporteur | ||
| 14060000109755 | L14/dossiers | 14 | 14060000109712 | 14060000109754 | 1 | 2 | PA608264 | rapporteur | ||
| 14060000109756 | L14/dossiers | 14 | 14060000109712 | 14060000109754 | 2 | 2 | PA429840 | rapporteur | ||
| 14060000109835 | L14/dossiers | 14 | 14060000109830 | 14060000109834 | 1 | 2 | PA610354 | rapporteur | ||
| 14060000109869 | L14/dossiers | 14 | 14060000109861 | 14060000109868 | 1 | 3 | PA2552 | rapporteur |