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 |
|---|---|---|---|---|---|---|---|
| 17060000128083 | L17/dossiers | 17 | 17060000128082 | 17060000128082 | 1 | PA330240 | PM842357 |
| 17060000128087 | L17/dossiers | 17 | 17060000128086 | 17060000128086 | 1 | PA794590 | PM840303 |
| 17060000128098 | L17/dossiers | 17 | 17060000128097 | 17060000128097 | 1 | PA736206 | PM829849 |
| 17060000128105 | L17/dossiers | 17 | 17060000128104 | 17060000128104 | 1 | PA841023 | PM842645 |
| 17060000128109 | L17/dossiers | 17 | 17060000128108 | 17060000128108 | 1 | PA795982 | PM840432 |
| 17060000128116 | L17/dossiers | 17 | 17060000128115 | 17060000128115 | 1 | PA795982 | PM840432 |
| 17060000128129 | L17/dossiers | 17 | 17060000128128 | 17060000128128 | 1 | PA827894 | PM828460 |
| 17060000128136 | L17/dossiers | 17 | 17060000128135 | 17060000128135 | 1 | PA842187 | PM843704 |
| 17060000128143 | L17/dossiers | 17 | 17060000128142 | 17060000128142 | 1 | PA793736 | PM842693 |
| 17060000128150 | L17/dossiers | 17 | 17060000128149 | 17060000128149 | 1 | PA841067 | PM842687 |
| 17060000128157 | L17/dossiers | 17 | 17060000128156 | 17060000128156 | 1 | PA841431 | PM843017 |
| 17060000128164 | L17/dossiers | 17 | 17060000128163 | 17060000128163 | 1 | PA840713 | PM849139 |
| 17060000128171 | L17/dossiers | 17 | 17060000128170 | 17060000128170 | 1 | PA795136 | PM843353 |
| 17060000128178 | L17/dossiers | 17 | 17060000128177 | 17060000128177 | 1 | PA718784 | PM842342 |
| 17060000128185 | L17/dossiers | 17 | 17060000128184 | 17060000128184 | 1 | PA791812 | PM840384 |
| 17060000128192 | L17/dossiers | 17 | 17060000128191 | 17060000128191 | 1 | PA719778 | PM842744 |
| 17060000128199 | L17/dossiers | 17 | 17060000128198 | 17060000128198 | 1 | PA717379 | PM843374 |
| 17060000128206 | L17/dossiers | 17 | 17060000128205 | 17060000128205 | 1 | PA793322 | PM840246 |
| 17060000128213 | L17/dossiers | 17 | 17060000128212 | 17060000128212 | 1 | PA793322 | PM840246 |
| 17060000128220 | L17/dossiers | 17 | 17060000128219 | 17060000128219 | 1 | PA841633 | PM843182 |
| 17060000128244 | L17/dossiers | 17 | 17060000128243 | 17060000128243 | 1 | PA721984 | PM843536 |
| 17060000128256 | L17/dossiers | 17 | 17060000128255 | 17060000128255 | 1 | PA795552 | PM840408 |
| 17060000128264 | L17/dossiers | 17 | 17060000128263 | 17060000128263 | 1 | PA793736 | PM842693 |
| 17060000128271 | L17/dossiers | 17 | 17060000128270 | 17060000128270 | 1 | PA267780 | PM843395 |
| 17060000128278 | L17/dossiers | 17 | 17060000128277 | 17060000128277 | 1 | PA719632 | PM842828 |
| 17060000128285 | L17/dossiers | 17 | 17060000128284 | 17060000128284 | 1 | PA345722 | PM843650 |
| 17060000128293 | L17/dossiers | 17 | 17060000128292 | 17060000128292 | 1 | PA793322 | PM840246 |
| 17060000128300 | L17/dossiers | 17 | 17060000128299 | 17060000128299 | 1 | PA793174 | PM842384 |
| 17060000128307 | L17/dossiers | 17 | 17060000128306 | 17060000128306 | 1 | PA721336 | PM843281 |
| 17060000128314 | L17/dossiers | 17 | 17060000128313 | 17060000128313 | 1 | PA841067 | PM842687 |
| 17060000128321 | L17/dossiers | 17 | 17060000128320 | 17060000128320 | 1 | PA721336 | PM843281 |
| 17060000128328 | L17/dossiers | 17 | 17060000128327 | 17060000128327 | 1 | PA721336 | PM843281 |
| 17060000128335 | L17/dossiers | 17 | 17060000128334 | 17060000128334 | 1 | PA719756 | PM842813 |
| 17060000128342 | L17/dossiers | 17 | 17060000128341 | 17060000128341 | 1 | PA720334 | PM842996 |
| 17060000128349 | L17/dossiers | 17 | 17060000128348 | 17060000128348 | 1 | PA721182 | PM843815 |
| 17060000128356 | L17/dossiers | 17 | 17060000128355 | 17060000128355 | 1 | PA794830 | PM843209 |
| 17060000128390 | L17/dossiers | 17 | 17060000128389 | 17060000128389 | 1 | PA794810 | PM843194 |
| 17060000128438 | L17/dossiers | 17 | 17060000128437 | 17060000128437 | 1 | PA719558 | PM842663 |
| 17060000128472 | L17/dossiers | 17 | 17060000128471 | 17060000128471 | 1 | PA720256 | PM843041 |
| 17060000128479 | L17/dossiers | 17 | 17060000128478 | 17060000128478 | 1 | PA719024 | PM842390 |
| 17060000128486 | L17/dossiers | 17 | 17060000128485 | 17060000128485 | 1 | PA719024 | PM842390 |
| 17060000128493 | L17/dossiers | 17 | 17060000128492 | 17060000128492 | 1 | PA719024 | PM842390 |
| 17060000128500 | L17/dossiers | 17 | 17060000128499 | 17060000128499 | 1 | PA793520 | PM842582 |
| 17060000128507 | L17/dossiers | 17 | 17060000128506 | 17060000128506 | 1 | PA793520 | PM842582 |
| 17060000128514 | L17/dossiers | 17 | 17060000128513 | 17060000128513 | 1 | PA793716 | PM842528 |
| 17060000128521 | L17/dossiers | 17 | 17060000128520 | 17060000128520 | 1 | PA722284 | PM843221 |
| 17060000128528 | L17/dossiers | 17 | 17060000128527 | 17060000128527 | 1 | PA722374 | PM843302 |
| 17060000128535 | L17/dossiers | 17 | 17060000128534 | 17060000128534 | 1 | PA795100 | PM843335 |
| 17060000128542 | L17/dossiers | 17 | 17060000128541 | 17060000128541 | 1 | PA794702 | PM843248 |
| 17060000128549 | L17/dossiers | 17 | 17060000128548 | 17060000128548 | 1 | PA794702 | PM843248 |