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 |
|---|---|---|---|---|---|---|---|
| 17060000151507 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 3 | PA775172 | PM775474 |
| 17060000151508 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 4 | PA827898 | PM828454 |
| 17060000151509 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 5 | PA850008 | PM850016 |
| 17060000151510 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 6 | PA756685 | PM775777 |
| 17060000151511 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 7 | PA827930 | PM828544 |
| 17060000151512 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 8 | PA268007 | PM829695 |
| 17060000151513 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 9 | PA429886 | PM829757 |
| 17060000151514 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 10 | PA736195 | PM829855 |
| 17060000151515 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 11 | PA736173 | PM829799 |
| 17060000151516 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 12 | PA775246 | PM775532 |
| 17060000151517 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 13 | PA827962 | PM828676 |
| 17060000151518 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 14 | PA736243 | PM829929 |
| 17060000151519 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 15 | PA736175 | PM829795 |
| 17060000151520 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 16 | PA828002 | PM828856 |
| 17060000151521 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 17 | PA775296 | PM775596 |
| 17060000151522 | L17/dossiers | 17 | 17060000151504 | 17060000151504 | 18 | PA828020 | PM828864 |
| 17060000151529 | L17/dossiers | 17 | 17060000151528 | 17060000151528 | 1 | PA842037 | PM843578 |
| 17060000151542 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 1 | PA773891 | PM829713 |
| 17060000151543 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 2 | PA775270 | PM775572 |
| 17060000151544 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 3 | PA715322 | PM775713 |
| 17060000151545 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 4 | PA703521 | PM775707 |
| 17060000151546 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 5 | PA343988 | PM829809 |
| 17060000151547 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 6 | PA429874 | PM829753 |
| 17060000151548 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 7 | PA703501 | PM775645 |
| 17060000151549 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 8 | PA827914 | PM828494 |
| 17060000151550 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 9 | PA775228 | PM775516 |
| 17060000151551 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 10 | PA736200 | PM829845 |
| 17060000151552 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 11 | PA415447 | PM775785 |
| 17060000151553 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 12 | PA778908 | PM829661 |
| 17060000151554 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 13 | PA775216 | PM775522 |
| 17060000151555 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 14 | PA836345 | PM836353 |
| 17060000151556 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 15 | PA827964 | PM828652 |
| 17060000151557 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 16 | PA827894 | PM828460 |
| 17060000151558 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 17 | PA736202 | PM775775 |
| 17060000151559 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 18 | PA703527 | PM775709 |
| 17060000151560 | L17/dossiers | 17 | 17060000151541 | 17060000151541 | 19 | PA703503 | PM775639 |
| 17060000151567 | L17/dossiers | 17 | 17060000151566 | 17060000151566 | 1 | PA643210 | PM873637 |
| 17060000151575 | L17/dossiers | 17 | 17060000151574 | 17060000151574 | 1 | PA643089 | PM858443 |
| 17060000151582 | L17/dossiers | 17 | 17060000151581 | 17060000151581 | 1 | PA775290 | PM775576 |
| 17060000151592 | L17/dossiers | 17 | 17060000151591 | 17060000151591 | 1 | PA643210 | PM873637 |
| 17060000151600 | L17/dossiers | 17 | 17060000151599 | 17060000151599 | 1 | PA643210 | PM873637 |
| 17060000151608 | L17/dossiers | 17 | 17060000151607 | 17060000151607 | 1 | PA775196 | PM775482 |
| 17060000151615 | L17/dossiers | 17 | 17060000151614 | 17060000151614 | 1 | PA330240 | PM842357 |
| 17060000151622 | L17/dossiers | 17 | 17060000151621 | 17060000151621 | 1 | PA794678 | PM840312 |
| 17060000151629 | L17/dossiers | 17 | 17060000151628 | 17060000151628 | 1 | PA793452 | PM842453 |
| 17060000151636 | L17/dossiers | 17 | 17060000151635 | 17060000151635 | 1 | PA794906 | PM843284 |
| 17060000151643 | L17/dossiers | 17 | 17060000151642 | 17060000151642 | 1 | PA841701 | PM843269 |
| 17060000151650 | L17/dossiers | 17 | 17060000151649 | 17060000151649 | 1 | PA795010 | PM840354 |
| 17060000151657 | L17/dossiers | 17 | 17060000151656 | 17060000151656 | 1 | PA796018 | PM843425 |
| 17060000151664 | L17/dossiers | 17 | 17060000151663 | 17060000151663 | 1 | PA793122 | PM842369 |