dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 15060000155475 | L15/dossiers | 15 | 15060000155470 | 15060000155470 | 5 | PA678263 | PM678267 |
| 15060000155476 | L15/dossiers | 15 | 15060000155470 | 15060000155470 | 6 | PA703499 | PM703641 |
| 15060000155483 | L15/dossiers | 15 | 15060000155482 | 15060000155482 | 1 | PA227029 | PM736306 |
| 15060000155490 | L15/dossiers | 15 | 15060000155489 | 15060000155489 | 1 | PA736192 | PM736353 |
| 15060000155497 | L15/dossiers | 15 | 15060000155496 | 15060000155496 | 1 | PA382672 | PM429984 |
| 15060000155504 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 1 | PA703534 | PM703549 |
| 15060000155505 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 2 | PA703493 | PM703683 |
| 15060000155506 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 3 | PA2042 | PM703682 |
| 15060000155507 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 4 | PA513 | PM703605 |
| 15060000155508 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 5 | PA736174 | PM736283 |
| 15060000155509 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 6 | PA267762 | PM736366 |
| 15060000155510 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 7 | PA266867 | PM703554 |
| 15060000155511 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 8 | PA429887 | PM736274 |
| 15060000155512 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 9 | PA736220 | PM736267 |
| 15060000155513 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 10 | PA267512 | PM703703 |
| 15060000155514 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 11 | PA304021 | PM736299 |
| 15060000155515 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 12 | PA736196 | PM736370 |
| 15060000155516 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 13 | PA304062 | PM703607 |
| 15060000155517 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 14 | PA703516 | PM703559 |
| 15060000155518 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 15 | PA415446 | PM703678 |
| 15060000155519 | L15/dossiers | 15 | 15060000155503 | 15060000155503 | 16 | PA703507 | PM703567 |
| 15060000155526 | L15/dossiers | 15 | 15060000155525 | 15060000155525 | 1 | PA703497 | PM703569 |
| 15060000155533 | L15/dossiers | 15 | 15060000155532 | 15060000155532 | 1 | PA304108 | PM429994 |
| 15060000155540 | L15/dossiers | 15 | 15060000155539 | 15060000155539 | 1 | PA415495 | PM703579 |
| 15060000155547 | L15/dossiers | 15 | 15060000155546 | 15060000155546 | 1 | PA2116 | PM736339 |
| 15060000155554 | L15/dossiers | 15 | 15060000155553 | 15060000155553 | 1 | PA703513 | PM703621 |
| 15060000155561 | L15/dossiers | 15 | 15060000155560 | 15060000155560 | 1 | PA415476 | PM703653 |
| 15060000155568 | L15/dossiers | 15 | 15060000155567 | 15060000155567 | 1 | PA382672 | PM736263 |
| 15060000155575 | L15/dossiers | 15 | 15060000155574 | 15060000155574 | 1 | PA944 | PM703562 |
| 15060000155582 | L15/dossiers | 15 | 15060000155581 | 15060000155581 | 1 | PA343775 | PM736367 |
| 15060000155589 | L15/dossiers | 15 | 15060000155588 | 15060000155588 | 1 | PA944 | PM703562 |
| 15060000155596 | L15/dossiers | 15 | 15060000155595 | 15060000155595 | 1 | PA944 | PM703562 |
| 15060000155603 | L15/dossiers | 15 | 15060000155602 | 15060000155602 | 1 | PA944 | PM703562 |
| 15060000155610 | L15/dossiers | 15 | 15060000155609 | 15060000155609 | 1 | PA429869 | PM736350 |
| 15060000155617 | L15/dossiers | 15 | 15060000155616 | 15060000155616 | 1 | PA429837 | PM736407 |
| 15060000155624 | L15/dossiers | 15 | 15060000155623 | 15060000155623 | 1 | PA703513 | PM703621 |
| 15060000155631 | L15/dossiers | 15 | 15060000155630 | 15060000155630 | 1 | PA227094 | PM736386 |
| 15060000155638 | L15/dossiers | 15 | 15060000155637 | 15060000155637 | 1 | PA429891 | PM736329 |
| 15060000155645 | L15/dossiers | 15 | 15060000155644 | 15060000155644 | 1 | PA736186 | PM736396 |
| 15060000155652 | L15/dossiers | 15 | 15060000155651 | 15060000155651 | 1 | PA736213 | PM736431 |
| 15060000155659 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 1 | PA703528 | PM703588 |
| 15060000155660 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 2 | PA429866 | PM736287 |
| 15060000155661 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 3 | PA429835 | PM736397 |
| 15060000155662 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 4 | PA340419 | PM703553 |
| 15060000155663 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 5 | PA415468 | PM703648 |
| 15060000155664 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 6 | PA736167 | PM736327 |
| 15060000155665 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 7 | PA736233 | PM736411 |
| 15060000155666 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 8 | PA703509 | PM703687 |
| 15060000155667 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 9 | PA703536 | PM703563 |
| 15060000155668 | L15/dossiers | 15 | 15060000155658 | 15060000155658 | 10 | PA703533 | PM703593 |