dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 | acteur_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
| 8 | mandat_ref | VARCHAR | dossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 % |
Aperçu
| _id | _source | _legislature | _racine_id | _parent_id | _ordre | acteur_ref | mandat_ref |
|---|---|---|---|---|---|---|---|
| 17060000131624 | L17/dossiers | 17 | 17060000131623 | 17060000131623 | 1 | PA722102 | PM843380 |
| 17060000131713 | L17/dossiers | 17 | 17060000131712 | 17060000131712 | 1 | PA775202 | PM775502 |
| 17060000131727 | L17/dossiers | 17 | 17060000131726 | 17060000131726 | 1 | PA709750 | PM829647 |
| 17060000131728 | L17/dossiers | 17 | 17060000131726 | 17060000131726 | 2 | PA715745 | PM829911 |
| 17060000131746 | L17/dossiers | 17 | 17060000131745 | 17060000131745 | 1 | PA794906 | PM843284 |
| 17060000131763 | L17/dossiers | 17 | 17060000131762 | 17060000131762 | 1 | PA335054 | PM843332 |
| 17060000131786 | L17/dossiers | 17 | 17060000131785 | 17060000131785 | 1 | PA793394 | PM842486 |
| 17060000131805 | L17/dossiers | 17 | 17060000131804 | 17060000131804 | 1 | PA793532 | PM842591 |
| 17060000131812 | L17/dossiers | 17 | 17060000131811 | 17060000131811 | 1 | PA827960 | PM828664 |
| 17060000131819 | L17/dossiers | 17 | 17060000131818 | 17060000131818 | 1 | PA795820 | PM843713 |
| 17060000131826 | L17/dossiers | 17 | 17060000131825 | 17060000131825 | 1 | PA335054 | PM843332 |
| 17060000131833 | L17/dossiers | 17 | 17060000131832 | 17060000131832 | 1 | PA840159 | PM840345 |
| 17060000131837 | L17/dossiers | 17 | 17060000131836 | 17060000131836 | 1 | PA795330 | PM843800 |
| 17060000131841 | L17/dossiers | 17 | 17060000131840 | 17060000131840 | 1 | PA795350 | PM843410 |
| 17060000131845 | L17/dossiers | 17 | 17060000131844 | 17060000131844 | 1 | PA267285 | PM842900 |
| 17060000131852 | L17/dossiers | 17 | 17060000131851 | 17060000131851 | 1 | PA793094 | PM842327 |
| 17060000131859 | L17/dossiers | 17 | 17060000131858 | 17060000131858 | 1 | PA794198 | PM842876 |
| 17060000131863 | L17/dossiers | 17 | 17060000131862 | 17060000131862 | 1 | PA795778 | PM843509 |
| 17060000131870 | L17/dossiers | 17 | 17060000131869 | 17060000131869 | 1 | PA267673 | PM775865 |
| 17060000131871 | L17/dossiers | 17 | 17060000131869 | 17060000131869 | 2 | PA848377 | PM848383 |
| 17060000131911 | L17/dossiers | 17 | 17060000131910 | 17060000131910 | 1 | PA794906 | PM843284 |
| 17060000131919 | L17/dossiers | 17 | 17060000131918 | 17060000131918 | 1 | PA793816 | PM842657 |
| 17060000131926 | L17/dossiers | 17 | 17060000131925 | 17060000131925 | 1 | PA793382 | PM842480 |
| 17060000131933 | L17/dossiers | 17 | 17060000131932 | 17060000131932 | 1 | PA795010 | PM840354 |
| 17060000131940 | L17/dossiers | 17 | 17060000131939 | 17060000131939 | 1 | PA841845 | PM843407 |
| 17060000131947 | L17/dossiers | 17 | 17060000131946 | 17060000131946 | 1 | PA796018 | PM843425 |
| 17060000131954 | L17/dossiers | 17 | 17060000131953 | 17060000131953 | 1 | PA842187 | PM843704 |
| 17060000131961 | L17/dossiers | 17 | 17060000131960 | 17060000131960 | 1 | PA642847 | PM843056 |
| 17060000131968 | L17/dossiers | 17 | 17060000131967 | 17060000131967 | 1 | PA720138 | PM842846 |
| 17060000131992 | L17/dossiers | 17 | 17060000131991 | 17060000131991 | 1 | PA841825 | PM843392 |
| 17060000131999 | L17/dossiers | 17 | 17060000131998 | 17060000131998 | 1 | PA795864 | PM840429 |
| 17060000132022 | L17/dossiers | 17 | 17060000132021 | 17060000132021 | 1 | PA793744 | PM842696 |
| 17060000132029 | L17/dossiers | 17 | 17060000132028 | 17060000132028 | 1 | PA2952 | PM842414 |
| 17060000132036 | L17/dossiers | 17 | 17060000132035 | 17060000132035 | 1 | PA720992 | PM843710 |
| 17060000132060 | L17/dossiers | 17 | 17060000132059 | 17060000132059 | 1 | PA841657 | PM843224 |
| 17060000132067 | L17/dossiers | 17 | 17060000132066 | 17060000132066 | 1 | PA795200 | PM843386 |
| 17060000132074 | L17/dossiers | 17 | 17060000132073 | 17060000132073 | 1 | PA795664 | PM843569 |
| 17060000132081 | L17/dossiers | 17 | 17060000132080 | 17060000132080 | 1 | PA795664 | PM843569 |
| 17060000132106 | L17/dossiers | 17 | 17060000132105 | 17060000132105 | 1 | PA795664 | PM843569 |
| 17060000132113 | L17/dossiers | 17 | 17060000132112 | 17060000132112 | 1 | PA795664 | PM843569 |
| 17060000132120 | L17/dossiers | 17 | 17060000132119 | 17060000132119 | 1 | PA795200 | PM843386 |
| 17060000132127 | L17/dossiers | 17 | 17060000132126 | 17060000132126 | 1 | PA840673 | PM842339 |
| 17060000132134 | L17/dossiers | 17 | 17060000132133 | 17060000132133 | 1 | PA795350 | PM843410 |
| 17060000132141 | L17/dossiers | 17 | 17060000132140 | 17060000132140 | 1 | PA795046 | PM843818 |
| 17060000132163 | L17/dossiers | 17 | 17060000132162 | 17060000132162 | 1 | PA330240 | PM842357 |
| 17060000132171 | L17/dossiers | 17 | 17060000132170 | 17060000132170 | 1 | PA410 | PM855580 |
| 17060000132172 | L17/dossiers | 17 | 17060000132170 | 17060000132170 | 2 | PA721836 | PM855144 |
| 17060000132205 | L17/dossiers | 17 | 17060000132204 | 17060000132204 | 1 | PA791824 | PM840375 |
| 17060000132212 | L17/dossiers | 17 | 17060000132211 | 17060000132211 | 1 | PA736225 | PM829907 |
| 17060000132213 | L17/dossiers | 17 | 17060000132211 | 17060000132211 | 2 | PA827900 | PM828434 |