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 |
|---|---|---|---|---|---|---|---|
| 17060000144472 | L17/dossiers | 17 | 17060000144471 | 17060000144471 | 1 | PA793872 | PM840285 |
| 17060000144476 | L17/dossiers | 17 | 17060000144475 | 17060000144475 | 1 | PA703498 | PM829449 |
| 17060000144483 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 1 | PA736207 | PM829847 |
| 17060000144484 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 2 | PA1001 | PM829905 |
| 17060000144485 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 3 | PA703522 | PM775701 |
| 17060000144486 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 4 | PA736169 | PM829791 |
| 17060000144487 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 5 | PA775258 | PM775544 |
| 17060000144488 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 6 | PA703517 | PM775675 |
| 17060000144489 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 7 | PA775184 | PM775486 |
| 17060000144490 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 8 | PA763158 | PM775683 |
| 17060000144491 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 9 | PA827894 | PM828460 |
| 17060000144492 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 10 | PA736200 | PM829845 |
| 17060000144493 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 11 | PA736185 | PM829813 |
| 17060000144494 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 12 | PA776985 | PM859248 |
| 17060000144495 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 13 | PA775202 | PM775502 |
| 17060000144496 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 14 | PA736188 | PM829827 |
| 17060000144497 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 15 | PA267081 | PM775733 |
| 17060000144498 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 16 | PA775176 | PM775462 |
| 17060000144499 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 17 | PA703520 | PM775705 |
| 17060000144500 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 18 | PA736246 | PM775819 |
| 17060000144501 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 19 | PA703515 | PM775663 |
| 17060000144502 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 20 | PA703510 | PM859251 |
| 17060000144503 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 21 | PA715745 | PM829911 |
| 17060000144504 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 22 | PA775230 | PM775514 |
| 17060000144505 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 23 | PA827954 | PM828704 |
| 17060000144506 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 24 | PA827914 | PM828494 |
| 17060000144507 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 25 | PA827976 | PM828724 |
| 17060000144508 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 26 | PA775264 | PM775570 |
| 17060000144509 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 27 | PA709750 | PM829647 |
| 17060000144510 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 28 | PA775228 | PM775516 |
| 17060000144511 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 29 | PA859244 | PM859246 |
| 17060000144512 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 30 | PA2197 | PM775755 |
| 17060000144513 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 31 | PA415447 | PM775785 |
| 17060000144514 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 32 | PA775220 | PM775526 |
| 17060000144515 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 33 | PA736206 | PM829849 |
| 17060000144516 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 34 | PA703534 | PM775695 |
| 17060000144517 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 35 | PA827926 | PM828562 |
| 17060000144518 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 36 | PA736238 | PM829895 |
| 17060000144519 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 37 | PA703537 | PM775721 |
| 17060000144520 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 38 | PA775288 | PM775578 |
| 17060000144521 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 39 | PA415462 | PM775797 |
| 17060000144522 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 40 | PA827996 | PM828764 |
| 17060000144523 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 41 | PA703541 | PM775725 |
| 17060000144524 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 42 | PA827910 | PM828508 |
| 17060000144525 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 43 | PA736218 | PM829869 |
| 17060000144526 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 44 | PA736202 | PM775775 |
| 17060000144527 | L17/dossiers | 17 | 17060000144482 | 17060000144482 | 45 | PA706108 | PM829553 |
| 17060000144534 | L17/dossiers | 17 | 17060000144533 | 17060000144533 | 1 | PA795310 | PM840453 |
| 17060000144538 | L17/dossiers | 17 | 17060000144537 | 17060000144537 | 1 | PA703498 | PM829449 |
| 17060000144556 | L17/dossiers | 17 | 17060000144555 | 17060000144555 | 1 | PA643210 | PM873637 |