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 |
|---|---|---|---|---|---|---|---|
| 17060000141275 | L17/dossiers | 17 | 17060000141274 | 17060000141274 | 1 | PA840171 | PM840360 |
| 17060000141282 | L17/dossiers | 17 | 17060000141281 | 17060000141281 | 1 | PA794486 | PM843110 |
| 17060000141289 | L17/dossiers | 17 | 17060000141288 | 17060000141288 | 1 | PA795998 | PM843737 |
| 17060000141296 | L17/dossiers | 17 | 17060000141295 | 17060000141295 | 1 | PA795998 | PM843737 |
| 17060000141304 | L17/dossiers | 17 | 17060000141303 | 17060000141303 | 1 | PA718884 | PM842420 |
| 17060000141311 | L17/dossiers | 17 | 17060000141310 | 17060000141310 | 1 | PA267200 | PM843098 |
| 17060000141318 | L17/dossiers | 17 | 17060000141317 | 17060000141317 | 1 | PA796090 | PM840372 |
| 17060000141325 | L17/dossiers | 17 | 17060000141324 | 17060000141324 | 1 | PA793394 | PM842486 |
| 17060000141332 | L17/dossiers | 17 | 17060000141331 | 17060000141331 | 1 | PA722102 | PM843380 |
| 17060000141348 | L17/dossiers | 17 | 17060000141347 | 17060000141347 | 1 | PA841359 | PM842939 |
| 17060000141355 | L17/dossiers | 17 | 17060000141354 | 17060000141354 | 1 | PA841359 | PM842939 |
| 17060000141362 | L17/dossiers | 17 | 17060000141361 | 17060000141361 | 1 | PA794058 | PM842861 |
| 17060000141369 | L17/dossiers | 17 | 17060000141368 | 17060000141368 | 1 | PA841419 | PM843005 |
| 17060000141376 | L17/dossiers | 17 | 17060000141375 | 17060000141375 | 1 | PA794058 | PM842861 |
| 17060000141383 | L17/dossiers | 17 | 17060000141382 | 17060000141382 | 1 | PA841047 | PM842675 |
| 17060000141390 | L17/dossiers | 17 | 17060000141389 | 17060000141389 | 1 | PA795240 | PM843785 |
| 17060000141397 | L17/dossiers | 17 | 17060000141396 | 17060000141396 | 1 | PA794686 | PM843080 |
| 17060000141409 | L17/dossiers | 17 | 17060000141408 | 17060000141408 | 1 | PA795136 | PM843353 |
| 17060000141416 | L17/dossiers | 17 | 17060000141415 | 17060000141415 | 1 | PA793772 | PM842708 |
| 17060000141423 | L17/dossiers | 17 | 17060000141422 | 17060000141422 | 1 | PA794686 | PM843080 |
| 17060000141430 | L17/dossiers | 17 | 17060000141429 | 17060000141429 | 1 | PA791812 | PM840384 |
| 17060000141444 | L17/dossiers | 17 | 17060000141443 | 17060000141443 | 1 | PA791812 | PM840384 |
| 17060000141451 | L17/dossiers | 17 | 17060000141450 | 17060000141450 | 1 | PA841023 | PM842645 |
| 17060000141463 | L17/dossiers | 17 | 17060000141462 | 17060000141462 | 1 | PA719578 | PM842618 |
| 17060000141475 | L17/dossiers | 17 | 17060000141474 | 17060000141474 | 1 | PA720838 | PM843671 |
| 17060000141483 | L17/dossiers | 17 | 17060000141482 | 17060000141482 | 1 | PA840765 | PM842447 |
| 17060000141490 | L17/dossiers | 17 | 17060000141489 | 17060000141489 | 1 | PA721062 | PM843740 |
| 17060000141512 | L17/dossiers | 17 | 17060000141511 | 17060000141511 | 1 | PA795164 | PM840444 |
| 17060000141562 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 1 | PA756685 | PM775777 |
| 17060000141563 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 2 | PA828002 | PM828856 |
| 17060000141564 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 3 | PA757676 | PM829801 |
| 17060000141565 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 4 | PA429886 | PM829757 |
| 17060000141566 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 5 | PA775172 | PM775474 |
| 17060000141567 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 6 | PA827898 | PM828454 |
| 17060000141568 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 7 | PA850008 | PM850016 |
| 17060000141569 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 8 | PA827912 | PM828488 |
| 17060000141570 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 9 | PA827930 | PM828544 |
| 17060000141571 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 10 | PA268007 | PM829695 |
| 17060000141572 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 11 | PA736195 | PM829855 |
| 17060000141573 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 12 | PA736173 | PM829799 |
| 17060000141574 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 13 | PA775246 | PM775532 |
| 17060000141575 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 14 | PA827962 | PM828676 |
| 17060000141576 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 15 | PA736243 | PM829929 |
| 17060000141577 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 16 | PA736175 | PM829795 |
| 17060000141578 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 17 | PA775296 | PM775596 |
| 17060000141579 | L17/dossiers | 17 | 17060000141561 | 17060000141561 | 18 | PA828020 | PM828864 |
| 17060000141598 | L17/dossiers | 17 | 17060000141597 | 17060000141597 | 1 | PA643210 | PM873637 |
| 17060000141631 | L17/dossiers | 17 | 17060000141630 | 17060000141630 | 1 | PA643210 | PM873637 |
| 17060000141713 | L17/dossiers | 17 | 17060000141712 | 17060000141712 | 1 | PA827894 | PM828460 |
| 17060000141729 | L17/dossiers | 17 | 17060000141728 | 17060000141728 | 1 | PA643210 | PM873637 |