dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 15060000185861 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 20 | PA775192 | PM775478 |
| 15060000185862 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 21 | PA775204 | PM775508 |
| 15060000185863 | L15/dossiers | 15 | 15060000185841 | 15060000185841 | 22 | PA415447 | PM775785 |
| 15060000185876 | L15/dossiers | 15 | 15060000185875 | 15060000185875 | 1 | PA718780 | PM722454 |
| 15060000185883 | L15/dossiers | 15 | 15060000185882 | 15060000185882 | 1 | PA718784 | PM722456 |
| 15060000185890 | L15/dossiers | 15 | 15060000185889 | 15060000185889 | 1 | PA721314 | PM723236 |
| 15060000185894 | L15/dossiers | 15 | 15060000185893 | 15060000185893 | 1 | PA773441 | PM773491 |
| 15060000185901 | L15/dossiers | 15 | 15060000185900 | 15060000185900 | 1 | PA773441 | PM773491 |
| 15060000185908 | L15/dossiers | 15 | 15060000185907 | 15060000185907 | 1 | PA722268 | PM723522 |
| 15060000185915 | L15/dossiers | 15 | 15060000185914 | 15060000185914 | 1 | PA721486 | PM723290 |
| 15060000185922 | L15/dossiers | 15 | 15060000185921 | 15060000185921 | 1 | PA721142 | PM723186 |
| 15060000185932 | L15/dossiers | 15 | 15060000185931 | 15060000185931 | 1 | PA267081 | PM775733 |
| 15060000185939 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 1 | PA330684 | PM775859 |
| 15060000185940 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 2 | PA715322 | PM775713 |
| 15060000185941 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 3 | PA744079 | PM744082 |
| 15060000185942 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 4 | PA703541 | PM775725 |
| 15060000185943 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 5 | PA703517 | PM775675 |
| 15060000185944 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 6 | PA736172 | PM736415 |
| 15060000185945 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 7 | PA703500 | PM775643 |
| 15060000185946 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 8 | PA267081 | PM775733 |
| 15060000185947 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 9 | PA736194 | PM736291 |
| 15060000185948 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 10 | PA404656 | PM736328 |
| 15060000185949 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 11 | PA785193 | PM785197 |
| 15060000185950 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 12 | PA775204 | PM775508 |
| 15060000185951 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 13 | PA415454 | PM785875 |
| 15060000185952 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 14 | PA775192 | PM775478 |
| 15060000185953 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 15 | PA703537 | PM775721 |
| 15060000185954 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 16 | PA736198 | PM736406 |
| 15060000185955 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 17 | PA1344 | PM736383 |
| 15060000185956 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 18 | PA775248 | PM775554 |
| 15060000185957 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 19 | PA304108 | PM736399 |
| 15060000185958 | L15/dossiers | 15 | 15060000185938 | 15060000185938 | 20 | PA394676 | PM775769 |
| 15060000185965 | L15/dossiers | 15 | 15060000185964 | 15060000185964 | 1 | PA267762 | PM736366 |
| 15060000185966 | L15/dossiers | 15 | 15060000185964 | 15060000185964 | 2 | PA736196 | PM736370 |
| 15060000185973 | L15/dossiers | 15 | 15060000185972 | 15060000185972 | 1 | PA703520 | PM775705 |
| 15060000185980 | L15/dossiers | 15 | 15060000185979 | 15060000185979 | 1 | PA267762 | PM736366 |
| 15060000185981 | L15/dossiers | 15 | 15060000185979 | 15060000185979 | 2 | PA736196 | PM736370 |
| 15060000185988 | L15/dossiers | 15 | 15060000185987 | 15060000185987 | 1 | PA345722 | PM723428 |
| 15060000185995 | L15/dossiers | 15 | 15060000185994 | 15060000185994 | 1 | PA721486 | PM723290 |
| 15060000186002 | L15/dossiers | 15 | 15060000186001 | 15060000186001 | 1 | PA721474 | PM723286 |
| 15060000186006 | L15/dossiers | 15 | 15060000186005 | 15060000186005 | 1 | PA721024 | PM723144 |
| 15060000186014 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 1 | PA2538 | PM775801 |
| 15060000186015 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 2 | PA425322 | PM736282 |
| 15060000186016 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 3 | PA775284 | PM775590 |
| 15060000186017 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 4 | PA703540 | PM775723 |
| 15060000186018 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 5 | PA775168 | PM775470 |
| 15060000186019 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 6 | PA736247 | PM736281 |
| 15060000186020 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 7 | PA775174 | PM775472 |
| 15060000186021 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 8 | PA736180 | PM785871 |
| 15060000186022 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 9 | PA736180 | PM785871 |