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 |
|---|---|---|---|---|---|---|---|
| 17060000129334 | L17/dossiers | 17 | 17060000129333 | 17060000129333 | 1 | PA795982 | PM840432 |
| 17060000129341 | L17/dossiers | 17 | 17060000129340 | 17060000129340 | 1 | PA721474 | PM843608 |
| 17060000129348 | L17/dossiers | 17 | 17060000129347 | 17060000129347 | 1 | PA794686 | PM843080 |
| 17060000129355 | L17/dossiers | 17 | 17060000129354 | 17060000129354 | 1 | PA774954 | PM842843 |
| 17060000129362 | L17/dossiers | 17 | 17060000129361 | 17060000129361 | 1 | PA793852 | PM842684 |
| 17060000129369 | L17/dossiers | 17 | 17060000129368 | 17060000129368 | 1 | PA795466 | PM843443 |
| 17060000129376 | L17/dossiers | 17 | 17060000129375 | 17060000129375 | 1 | PA719372 | PM858347 |
| 17060000129399 | L17/dossiers | 17 | 17060000129398 | 17060000129398 | 1 | PA719372 | PM858347 |
| 17060000129412 | L17/dossiers | 17 | 17060000129411 | 17060000129411 | 1 | PA794278 | PM842975 |
| 17060000129427 | L17/dossiers | 17 | 17060000129426 | 17060000129426 | 1 | PA342384 | PM842771 |
| 17060000129434 | L17/dossiers | 17 | 17060000129433 | 17060000129433 | 1 | PA721742 | PM829056 |
| 17060000129464 | L17/dossiers | 17 | 17060000129463 | 17060000129463 | 1 | PA330684 | PM775859 |
| 17060000129483 | L17/dossiers | 17 | 17060000129482 | 17060000129482 | 1 | PA736196 | PM829865 |
| 17060000129484 | L17/dossiers | 17 | 17060000129482 | 17060000129482 | 2 | PA827958 | PM828690 |
| 17060000129491 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 1 | PA827912 | PM828488 |
| 17060000129492 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 2 | PA827962 | PM828676 |
| 17060000129493 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 3 | PA757676 | PM829801 |
| 17060000129494 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 4 | PA775172 | PM775474 |
| 17060000129495 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 5 | PA827898 | PM828454 |
| 17060000129496 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 6 | PA850008 | PM850016 |
| 17060000129497 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 7 | PA756685 | PM775777 |
| 17060000129498 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 8 | PA827930 | PM828544 |
| 17060000129499 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 9 | PA268007 | PM829695 |
| 17060000129500 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 10 | PA429886 | PM829757 |
| 17060000129501 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 11 | PA736195 | PM829855 |
| 17060000129502 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 12 | PA736173 | PM829799 |
| 17060000129503 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 13 | PA775246 | PM775532 |
| 17060000129504 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 14 | PA736243 | PM829929 |
| 17060000129505 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 15 | PA736175 | PM829795 |
| 17060000129506 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 16 | PA828002 | PM828856 |
| 17060000129507 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 17 | PA775296 | PM775596 |
| 17060000129508 | L17/dossiers | 17 | 17060000129490 | 17060000129490 | 18 | PA828020 | PM828864 |
| 17060000129515 | L17/dossiers | 17 | 17060000129514 | 17060000129514 | 1 | PA736211 | PM829879 |
| 17060000129516 | L17/dossiers | 17 | 17060000129514 | 17060000129514 | 2 | PA775260 | PM775550 |
| 17060000129523 | L17/dossiers | 17 | 17060000129522 | 17060000129522 | 1 | PA410 | PM855580 |
| 17060000129545 | L17/dossiers | 17 | 17060000129544 | 17060000129544 | 1 | PA841701 | PM843269 |
| 17060000129546 | L17/dossiers | 17 | 17060000129544 | 17060000129544 | 2 | PA677483 | PM842435 |
| 17060000129553 | L17/dossiers | 17 | 17060000129552 | 17060000129552 | 1 | PA841931 | PM843485 |
| 17060000129576 | L17/dossiers | 17 | 17060000129575 | 17060000129575 | 1 | PA773891 | PM829713 |
| 17060000129583 | L17/dossiers | 17 | 17060000129582 | 17060000129582 | 1 | PA842311 | PM843803 |
| 17060000129590 | L17/dossiers | 17 | 17060000129589 | 17060000129589 | 1 | PA827990 | PM828794 |
| 17060000129597 | L17/dossiers | 17 | 17060000129596 | 17060000129596 | 1 | PA775202 | PM775502 |
| 17060000129604 | L17/dossiers | 17 | 17060000129603 | 17060000129603 | 1 | PA703536 | PM775719 |
| 17060000129605 | L17/dossiers | 17 | 17060000129603 | 17060000129603 | 2 | PA703505 | PM775679 |
| 17060000129606 | L17/dossiers | 17 | 17060000129603 | 17060000129603 | 3 | PA775196 | PM775482 |
| 17060000129607 | L17/dossiers | 17 | 17060000129603 | 17060000129603 | 4 | PA775268 | PM775574 |
| 17060000129608 | L17/dossiers | 17 | 17060000129603 | 17060000129603 | 5 | PA606375 | PM775602 |
| 17060000129615 | L17/dossiers | 17 | 17060000129614 | 17060000129614 | 1 | PA775214 | PM775498 |
| 17060000129616 | L17/dossiers | 17 | 17060000129614 | 17060000129614 | 2 | PA775272 | PM775562 |
| 17060000129617 | L17/dossiers | 17 | 17060000129614 | 17060000129614 | 3 | PA775180 | PM775466 |