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 |
|---|---|---|---|---|---|---|---|
| 17060000137287 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 7 | PA850008 | PM850016 |
| 17060000137288 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 8 | PA827912 | PM828488 |
| 17060000137289 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 9 | PA756685 | PM775777 |
| 17060000137290 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 10 | PA827930 | PM828544 |
| 17060000137291 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 11 | PA268007 | PM829695 |
| 17060000137292 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 12 | PA429886 | PM829757 |
| 17060000137293 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 13 | PA736173 | PM829799 |
| 17060000137294 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 14 | PA736243 | PM829929 |
| 17060000137295 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 15 | PA736175 | PM829795 |
| 17060000137296 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 16 | PA828002 | PM828856 |
| 17060000137297 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 17 | PA775296 | PM775596 |
| 17060000137298 | L17/dossiers | 17 | 17060000137280 | 17060000137280 | 18 | PA828020 | PM828864 |
| 17060000137305 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 1 | PA736200 | PM829845 |
| 17060000137306 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 2 | PA267340 | PM775731 |
| 17060000137307 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 3 | PA736216 | PM829875 |
| 17060000137308 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 4 | PA827894 | PM828460 |
| 17060000137309 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 5 | PA703540 | PM775723 |
| 17060000137310 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 6 | PA775168 | PM775470 |
| 17060000137311 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 7 | PA775176 | PM775462 |
| 17060000137312 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 8 | PA836345 | PM836353 |
| 17060000137313 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 9 | PA775178 | PM775460 |
| 17060000137314 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 10 | PA773891 | PM829713 |
| 17060000137315 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 11 | PA736202 | PM775775 |
| 17060000137316 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 12 | PA267075 | PM775610 |
| 17060000137317 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 13 | PA775184 | PM775486 |
| 17060000137318 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 14 | PA736198 | PM829861 |
| 17060000137319 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 15 | PA703522 | PM775701 |
| 17060000137320 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 16 | PA775192 | PM775478 |
| 17060000137321 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 17 | PA736231 | PM829915 |
| 17060000137322 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 18 | PA330684 | PM775859 |
| 17060000137323 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 19 | PA827914 | PM828494 |
| 17060000137324 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 20 | PA775202 | PM775502 |
| 17060000137325 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 21 | PA304085 | PM829871 |
| 17060000137326 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 22 | PA703510 | PM859251 |
| 17060000137327 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 23 | PA703510 | PM859251 |
| 17060000137328 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 24 | PA827922 | PM856930 |
| 17060000137329 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 25 | PA709750 | PM829647 |
| 17060000137330 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 26 | PA703513 | PM775671 |
| 17060000137331 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 27 | PA415462 | PM775797 |
| 17060000137332 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 28 | PA827928 | PM828538 |
| 17060000137333 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 29 | PA715745 | PM829911 |
| 17060000137334 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 30 | PA1001 | PM829905 |
| 17060000137335 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 31 | PA736197 | PM829863 |
| 17060000137336 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 32 | PA415467 | PM775803 |
| 17060000137337 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 33 | PA703503 | PM775639 |
| 17060000137338 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 34 | PA775212 | PM775500 |
| 17060000137339 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 35 | PA267112 | PM775737 |
| 17060000137340 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 36 | PA703494 | PM775651 |
| 17060000137341 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 37 | PA775216 | PM775522 |
| 17060000137342 | L17/dossiers | 17 | 17060000137304 | 17060000137304 | 38 | PA404656 | PM829669 |