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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000108788 | L16/dossiers | 16 | 16060000108780 | 16060000108787 | 1 | 3 | PA795908 | rapporteur | ||
| 16060000108854 | L16/dossiers | 16 | 16060000108846 | 16060000108853 | 1 | 3 | PA721486 | rapporteur | ||
| 16060000108902 | L16/dossiers | 16 | 16060000108893 | 16060000108901 | 1 | 3 | PA719814 | rapporteur | ||
| 16060000108903 | L16/dossiers | 16 | 16060000108893 | 16060000108901 | 2 | 3 | PA718884 | rapporteur | ||
| 16060000108925 | L16/dossiers | 16 | 16060000108917 | 16060000108924 | 1 | 3 | PA793616 | rapporteur | ||
| 16060000109000 | L16/dossiers | 16 | 16060000108992 | 16060000108999 | 1 | 3 | PA793796 | rapporteur | ||
| 16060000109023 | L16/dossiers | 16 | 16060000109014 | 16060000109022 | 1 | 3 | PA415446 | rapporteur | ||
| 16060000109034 | L16/dossiers | 16 | 16060000109014 | 16060000109033 | 1 | 3 | PA794802 | rapporteur | ||
| 16060000109048 | L16/dossiers | 16 | 16060000109014 | 16060000109047 | 1 | 2 | PA415446 | rapporteur | ||
| 16060000109049 | L16/dossiers | 16 | 16060000109014 | 16060000109047 | 2 | 2 | PA794802 | rapporteur | ||
| 16060000109072 | L16/dossiers | 16 | 16060000109063 | 16060000109071 | 1 | 3 | PA778908 | rapporteur | ||
| 16060000109084 | L16/dossiers | 16 | 16060000109063 | 16060000109083 | 1 | 3 | PA719814 | rapporteur | ||
| 16060000109101 | L16/dossiers | 16 | 16060000109063 | 16060000109100 | 1 | 2 | PA719814 | rapporteur | ||
| 16060000109102 | L16/dossiers | 16 | 16060000109063 | 16060000109100 | 2 | 2 | PA778908 | rapporteur | ||
| 16060000109173 | L16/dossiers | 16 | 16060000109117 | 16060000109172 | 1 | 3 | PA429889 | rapporteur | ||
| 16060000109225 | L16/dossiers | 16 | 16060000109217 | 16060000109224 | 1 | 3 | PA794626 | rapporteur | ||
| 16060000109245 | L16/dossiers | 16 | 16060000109237 | 16060000109244 | 1 | 3 | PA720960 | rapporteur | ||
| 16060000109285 | L16/dossiers | 16 | 16060000109276 | 16060000109284 | 1 | 3 | PA2952 | rapporteur | ||
| 16060000109301 | L16/dossiers | 16 | 16060000109276 | 16060000109300 | 1 | 3 | PA736205 | rapporteur | ||
| 16060000109313 | L16/dossiers | 16 | 16060000109276 | 16060000109312 | 1 | 2 | PA2952 | rapporteur | ||
| 16060000109314 | L16/dossiers | 16 | 16060000109276 | 16060000109312 | 2 | 2 | PA736205 | rapporteur | ||
| 16060000109368 | L16/dossiers | 16 | 16060000109360 | 16060000109367 | 1 | 3 | PA719558 | rapporteur | ||
| 16060000109369 | L16/dossiers | 16 | 16060000109360 | 16060000109367 | 2 | 3 | PA607619 | rapporteur | ||
| 16060000109382 | L16/dossiers | 16 | 16060000109374 | 16060000109381 | 1 | 3 | PA942 | rapporteur | ||
| 16060000109407 | L16/dossiers | 16 | 16060000109398 | 16060000109406 | 1 | 3 | PA718962 | rapporteur | ||
| 16060000109423 | L16/dossiers | 16 | 16060000109398 | 16060000109422 | 1 | 3 | PA775292 | rapporteur | ||
| 16060000109434 | L16/dossiers | 16 | 16060000109398 | 16060000109433 | 1 | 2 | PA718962 | rapporteur | ||
| 16060000109435 | L16/dossiers | 16 | 16060000109398 | 16060000109433 | 2 | 2 | PA775292 | rapporteur | ||
| 16060000109508 | L16/dossiers | 16 | 16060000109500 | 16060000109507 | 1 | 3 | PA795692 | rapporteur | ||
| 16060000109554 | L16/dossiers | 16 | 16060000109545 | 16060000109553 | 1 | 3 | PA736237 | rapporteur | ||
| 16060000109580 | L16/dossiers | 16 | 16060000109571 | 16060000109579 | 1 | 3 | PA721760 | rapporteur | ||
| 16060000109594 | L16/dossiers | 16 | 16060000109571 | 16060000109593 | 1 | 3 | PA304085 | rapporteur | ||
| 16060000109618 | L16/dossiers | 16 | 16060000109610 | 16060000109617 | 1 | 3 | PA736238 | rapporteur | ||
| 16060000109629 | L16/dossiers | 16 | 16060000109610 | 16060000109628 | 1 | 3 | PA719814 | rapporteur | ||
| 16060000109630 | L16/dossiers | 16 | 16060000109610 | 16060000109628 | 2 | 3 | PA267324 | rapporteur | ||
| 16060000109688 | L16/dossiers | 16 | 16060000109679 | 16060000109687 | 1 | 3 | PA429869 | rapporteur | ||
| 16060000109700 | L16/dossiers | 16 | 16060000109679 | 16060000109699 | 1 | 3 | PA721844 | rapporteur | ||
| 16060000109722 | L16/dossiers | 16 | 16060000109711 | 16060000109721 | 1 | 3 | PA304017 | rapporteur | ||
| 16060000109733 | L16/dossiers | 16 | 16060000109711 | 16060000109732 | 1 | 3 | PA794206 | rapporteur | ||
| 16060000109751 | L16/dossiers | 16 | 16060000109711 | 16060000109750 | 1 | 2 | PA794206 | rapporteur | ||
| 16060000109752 | L16/dossiers | 16 | 16060000109711 | 16060000109750 | 2 | 2 | PA304017 | rapporteur | ||
| 16060000109775 | L16/dossiers | 16 | 16060000109766 | 16060000109774 | 1 | 3 | PA795350 | rapporteur | ||
| 16060000109798 | L16/dossiers | 16 | 16060000109766 | 16060000109797 | 1 | 3 | PA703515 | rapporteur | ||
| 16060000109809 | L16/dossiers | 16 | 16060000109766 | 16060000109808 | 1 | 2 | PA795350 | rapporteur | ||
| 16060000109810 | L16/dossiers | 16 | 16060000109766 | 16060000109808 | 2 | 2 | PA703515 | rapporteur | ||
| 16060000109833 | L16/dossiers | 16 | 16060000109824 | 16060000109832 | 1 | 3 | PA794854 | rapporteur | ||
| 16060000109834 | L16/dossiers | 16 | 16060000109824 | 16060000109832 | 2 | 3 | PA719388 | rapporteur | ||
| 16060000109851 | L16/dossiers | 16 | 16060000109824 | 16060000109850 | 1 | 3 | PA758716 | rapporteur | ||
| 16060000109901 | L16/dossiers | 16 | 16060000109866 | 16060000109900 | 1 | 3 | PA703494 | rapporteur | ||
| 16060000109912 | L16/dossiers | 16 | 16060000109866 | 16060000109911 | 1 | 3 | PA795270 | rapporteur |