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 |
|---|---|---|---|---|---|---|---|
| 17060000136457 | L17/dossiers | 17 | 17060000136456 | 17060000136456 | 1 | PA795386 | PM843695 |
| 17060000136464 | L17/dossiers | 17 | 17060000136463 | 17060000136463 | 1 | PA840657 | PM842333 |
| 17060000136471 | L17/dossiers | 17 | 17060000136470 | 17060000136470 | 1 | PA840657 | PM842333 |
| 17060000136478 | L17/dossiers | 17 | 17060000136477 | 17060000136477 | 1 | PA643089 | PM858443 |
| 17060000136485 | L17/dossiers | 17 | 17060000136484 | 17060000136484 | 1 | PA774960 | PM840417 |
| 17060000136492 | L17/dossiers | 17 | 17060000136491 | 17060000136491 | 1 | PA840979 | PM842588 |
| 17060000136505 | L17/dossiers | 17 | 17060000136504 | 17060000136504 | 1 | PA793716 | PM842528 |
| 17060000136512 | L17/dossiers | 17 | 17060000136511 | 17060000136511 | 1 | PA774960 | PM840417 |
| 17060000136519 | L17/dossiers | 17 | 17060000136518 | 17060000136518 | 1 | PA840915 | PM842552 |
| 17060000136526 | L17/dossiers | 17 | 17060000136525 | 17060000136525 | 1 | PA794938 | PM843308 |
| 17060000136533 | L17/dossiers | 17 | 17060000136532 | 17060000136532 | 1 | PA607553 | PM843059 |
| 17060000136540 | L17/dossiers | 17 | 17060000136539 | 17060000136539 | 1 | PA795920 | PM843653 |
| 17060000136547 | L17/dossiers | 17 | 17060000136546 | 17060000136546 | 1 | PA408578 | PM843662 |
| 17060000136566 | L17/dossiers | 17 | 17060000136565 | 17060000136565 | 1 | PA795982 | PM840432 |
| 17060000136607 | L17/dossiers | 17 | 17060000136606 | 17060000136606 | 1 | PA330684 | PM775859 |
| 17060000136614 | L17/dossiers | 17 | 17060000136613 | 17060000136613 | 1 | PA841243 | PM842825 |
| 17060000136624 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 1 | PA775238 | PM775540 |
| 17060000136625 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 2 | PA827918 | PM828482 |
| 17060000136626 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 3 | PA775184 | PM775486 |
| 17060000136627 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 4 | PA341381 | PM775747 |
| 17060000136628 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 5 | PA719408 | PM775520 |
| 17060000136629 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 6 | PA736167 | PM829803 |
| 17060000136630 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 7 | PA736166 | PM775765 |
| 17060000136631 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 8 | PA736236 | PM829899 |
| 17060000136632 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 9 | PA827896 | PM828448 |
| 17060000136633 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 10 | PA827926 | PM828562 |
| 17060000136634 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 11 | PA703514 | PM775661 |
| 17060000136635 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 12 | PA736206 | PM829849 |
| 17060000136636 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 13 | PA703532 | PM775699 |
| 17060000136637 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 14 | PA703500 | PM775643 |
| 17060000136638 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 15 | PA267743 | PM829699 |
| 17060000136639 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 16 | PA736237 | PM829897 |
| 17060000136640 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 17 | PA775278 | PM775564 |
| 17060000136641 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 18 | PA227098 | PM829739 |
| 17060000136642 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 19 | PA415495 | PM775635 |
| 17060000136643 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 20 | PA775234 | PM775536 |
| 17060000136644 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 21 | PA736184 | PM829817 |
| 17060000136645 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 22 | PA827908 | PM828500 |
| 17060000136646 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 23 | PA788192 | PM829697 |
| 17060000136647 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 24 | PA827996 | PM828764 |
| 17060000136648 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 25 | PA784534 | PM784544 |
| 17060000136649 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 26 | PA775250 | PM775552 |
| 17060000136650 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 27 | PA775212 | PM775500 |
| 17060000136651 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 28 | PA736224 | PM829913 |
| 17060000136652 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 29 | PA736158 | PM829783 |
| 17060000136653 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 30 | PA415446 | PM775783 |
| 17060000136654 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 31 | PA703534 | PM775695 |
| 17060000136655 | L17/dossiers | 17 | 17060000136623 | 17060000136623 | 32 | PA313924 | PM775727 |
| 17060000136662 | L17/dossiers | 17 | 17060000136661 | 17060000136661 | 1 | PA827912 | PM828488 |
| 17060000136663 | L17/dossiers | 17 | 17060000136661 | 17060000136661 | 2 | PA736191 | PM829819 |