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 |
|---|---|---|---|---|---|---|---|---|---|---|
| 16060000090433 | L16/dossiers | 16 | 16060000090425 | 16060000090432 | 1 | 3 | PA406065 | rapporteur | ||
| 16060000090467 | L16/dossiers | 16 | 16060000090459 | 16060000090466 | 1 | 3 | PA2538 | rapporteur | ||
| 16060000090472 | L16/dossiers | 16 | 16060000090459 | 16060000090471 | 1 | 3 | PA415467 | rapporteur pour avis | ||
| 16060000090506 | L16/dossiers | 16 | 16060000090498 | 16060000090505 | 1 | 3 | PA944 | rapporteur | ||
| 16060000090540 | L16/dossiers | 16 | 16060000090532 | 16060000090539 | 1 | 3 | PA429896 | rapporteur | ||
| 16060000090569 | L16/dossiers | 16 | 16060000090561 | 16060000090568 | 1 | 3 | PA677483 | rapporteur | ||
| 16060000090598 | L16/dossiers | 16 | 16060000090590 | 16060000090597 | 1 | 3 | PA415460 | rapporteur | ||
| 16060000090610 | L16/dossiers | 16 | 16060000090590 | 16060000090609 | 1 | 3 | PA610873 | rapporteur | ||
| 16060000090633 | L16/dossiers | 16 | 16060000090624 | 16060000090632 | 1 | 3 | PA304082 | rapporteur | ||
| 16060000090645 | L16/dossiers | 16 | 16060000090624 | 16060000090644 | 1 | 3 | PA1141 | rapporteur | ||
| 16060000090672 | L16/dossiers | 16 | 16060000090664 | 16060000090671 | 1 | 3 | PA2552 | rapporteur | ||
| 16060000090703 | L16/dossiers | 16 | 16060000090693 | 16060000090702 | 1 | 3 | PA2552 | rapporteur | ||
| 16060000090715 | L16/dossiers | 16 | 16060000090693 | 16060000090714 | 1 | 3 | PA330357 | rapporteur | ||
| 16060000090738 | L16/dossiers | 16 | 16060000090730 | 16060000090737 | 1 | 3 | PA429891 | rapporteur | ||
| 16060000090767 | L16/dossiers | 16 | 16060000090759 | 16060000090766 | 1 | 3 | PA304071 | rapporteur | ||
| 16060000090796 | L16/dossiers | 16 | 16060000090788 | 16060000090795 | 1 | 3 | PA415474 | rapporteur | ||
| 16060000090825 | L16/dossiers | 16 | 16060000090817 | 16060000090824 | 1 | 3 | PA1447 | rapporteur | ||
| 16060000090830 | L16/dossiers | 16 | 16060000090817 | 16060000090829 | 1 | 3 | PA528 | rapporteur pour avis | ||
| 16060000090859 | L16/dossiers | 16 | 16060000090851 | 16060000090858 | 1 | 3 | PA227087 | rapporteur | ||
| 16060000090888 | L16/dossiers | 16 | 16060000090880 | 16060000090887 | 1 | 3 | PA415465 | rapporteur | ||
| 16060000090917 | L16/dossiers | 16 | 16060000090909 | 16060000090916 | 1 | 3 | PA945 | rapporteur | ||
| 16060000090946 | L16/dossiers | 16 | 16060000090938 | 16060000090945 | 1 | 3 | PA2183 | rapporteur | ||
| 16060000090976 | L16/dossiers | 16 | 16060000090968 | 16060000090975 | 1 | 3 | PA1122 | rapporteur | ||
| 16060000091007 | L16/dossiers | 16 | 16060000090999 | 16060000091006 | 1 | 3 | PA333335 | rapporteur | ||
| 16060000091022 | L16/dossiers | 16 | 16060000090999 | 16060000091021 | 1 | 3 | PA703492 | rapporteur | ||
| 16060000091047 | L16/dossiers | 16 | 16060000091038 | 16060000091046 | 1 | 3 | PA267891 | rapporteur | ||
| 16060000091076 | L16/dossiers | 16 | 16060000091068 | 16060000091075 | 1 | 3 | PA415460 | rapporteur | ||
| 16060000091105 | L16/dossiers | 16 | 16060000091097 | 16060000091104 | 1 | 3 | PA1122 | rapporteur | ||
| 16060000091134 | L16/dossiers | 16 | 16060000091126 | 16060000091133 | 1 | 3 | PA267512 | rapporteur | ||
| 16060000091163 | L16/dossiers | 16 | 16060000091155 | 16060000091162 | 1 | 3 | PA703530 | rapporteur | ||
| 16060000091175 | L16/dossiers | 16 | 16060000091155 | 16060000091174 | 1 | 3 | PA267355 | rapporteur | ||
| 16060000091218 | L16/dossiers | 16 | 16060000091210 | 16060000091217 | 1 | 3 | PA605922 | rapporteur | ||
| 16060000091232 | L16/dossiers | 16 | 16060000091210 | 16060000091231 | 1 | 3 | PA429866 | rapporteur | ||
| 16060000091262 | L16/dossiers | 16 | 16060000091254 | 16060000091261 | 1 | 3 | PA2905 | rapporteur | ||
| 16060000091291 | L16/dossiers | 16 | 16060000091283 | 16060000091290 | 1 | 3 | PA2161 | rapporteur | ||
| 16060000091320 | L16/dossiers | 16 | 16060000091312 | 16060000091319 | 1 | 3 | PA267891 | rapporteur | ||
| 16060000091349 | L16/dossiers | 16 | 16060000091341 | 16060000091348 | 1 | 3 | PA1562 | rapporteur | ||
| 16060000091378 | L16/dossiers | 16 | 16060000091370 | 16060000091377 | 1 | 3 | PA703494 | rapporteur | ||
| 16060000091407 | L16/dossiers | 16 | 16060000091399 | 16060000091406 | 1 | 3 | PA429838 | rapporteur | ||
| 16060000091436 | L16/dossiers | 16 | 16060000091428 | 16060000091435 | 1 | 3 | PA406065 | rapporteur | ||
| 16060000091465 | L16/dossiers | 16 | 16060000091457 | 16060000091464 | 1 | 3 | PA267340 | rapporteur | ||
| 16060000091482 | L16/dossiers | 16 | 16060000091457 | 16060000091481 | 1 | 3 | PA718838 | rapporteur | ||
| 16060000091503 | L16/dossiers | 16 | 16060000091495 | 16060000091502 | 1 | 3 | PA426327 | rapporteur | ||
| 16060000091527 | L16/dossiers | 16 | 16060000091519 | 16060000091526 | 1 | 3 | PA736225 | rapporteur | ||
| 16060000091539 | L16/dossiers | 16 | 16060000091519 | 16060000091538 | 1 | 3 | PA607553 | rapporteur | ||
| 16060000091559 | L16/dossiers | 16 | 16060000091551 | 16060000091558 | 1 | 3 | PA703490 | rapporteur | ||
| 16060000091560 | L16/dossiers | 16 | 16060000091551 | 16060000091558 | 2 | 3 | PA303997 | rapporteur | ||
| 16060000091584 | L16/dossiers | 16 | 16060000091576 | 16060000091583 | 1 | 3 | PA703490 | rapporteur | ||
| 16060000091585 | L16/dossiers | 16 | 16060000091576 | 16060000091583 | 2 | 3 | PA303997 | rapporteur | ||
| 16060000091608 | L16/dossiers | 16 | 16060000091600 | 16060000091607 | 1 | 3 | PA703480 | rapporteur |