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 |
|---|---|---|---|---|---|---|---|
| 17060000123246 | L17/dossiers | 17 | 17060000123245 | 17060000123245 | 1 | PA794118 | PM842894 |
| 17060000123253 | L17/dossiers | 17 | 17060000123252 | 17060000123252 | 1 | PA795974 | PM840387 |
| 17060000123260 | L17/dossiers | 17 | 17060000123259 | 17060000123259 | 1 | PA718838 | PM842405 |
| 17060000123267 | L17/dossiers | 17 | 17060000123266 | 17060000123266 | 1 | PA793314 | PM840243 |
| 17060000123274 | L17/dossiers | 17 | 17060000123273 | 17060000123273 | 1 | PA793608 | PM842558 |
| 17060000123281 | L17/dossiers | 17 | 17060000123280 | 17060000123280 | 1 | PA794270 | PM842972 |
| 17060000123289 | L17/dossiers | 17 | 17060000123288 | 17060000123288 | 1 | PA346782 | PM840426 |
| 17060000123296 | L17/dossiers | 17 | 17060000123295 | 17060000123295 | 1 | PA795552 | PM840408 |
| 17060000123303 | L17/dossiers | 17 | 17060000123302 | 17060000123302 | 1 | PA346782 | PM840426 |
| 17060000123310 | L17/dossiers | 17 | 17060000123309 | 17060000123309 | 1 | PA721816 | PM843551 |
| 17060000123317 | L17/dossiers | 17 | 17060000123316 | 17060000123316 | 1 | PA794166 | PM842924 |
| 17060000123330 | L17/dossiers | 17 | 17060000123329 | 17060000123329 | 1 | PA842029 | PM843575 |
| 17060000123337 | L17/dossiers | 17 | 17060000123336 | 17060000123336 | 1 | PA795596 | PM840456 |
| 17060000123350 | L17/dossiers | 17 | 17060000123349 | 17060000123349 | 1 | PA795596 | PM840456 |
| 17060000123357 | L17/dossiers | 17 | 17060000123356 | 17060000123356 | 1 | PA842187 | PM843704 |
| 17060000123370 | L17/dossiers | 17 | 17060000123369 | 17060000123369 | 1 | PA795200 | PM843386 |
| 17060000123382 | L17/dossiers | 17 | 17060000123381 | 17060000123381 | 1 | PA793744 | PM842696 |
| 17060000123395 | L17/dossiers | 17 | 17060000123394 | 17060000123394 | 1 | PA722390 | PM843317 |
| 17060000123402 | L17/dossiers | 17 | 17060000123401 | 17060000123401 | 1 | PA722390 | PM843317 |
| 17060000123409 | L17/dossiers | 17 | 17060000123408 | 17060000123408 | 1 | PA719632 | PM842828 |
| 17060000123417 | L17/dossiers | 17 | 17060000123416 | 17060000123416 | 1 | PA793616 | PM842561 |
| 17060000123424 | L17/dossiers | 17 | 17060000123423 | 17060000123423 | 1 | PA720430 | PM843092 |
| 17060000123431 | L17/dossiers | 17 | 17060000123430 | 17060000123430 | 1 | PA794278 | PM842975 |
| 17060000123438 | L17/dossiers | 17 | 17060000123437 | 17060000123437 | 1 | PA722390 | PM843317 |
| 17060000123445 | L17/dossiers | 17 | 17060000123444 | 17060000123444 | 1 | PA793122 | PM842369 |
| 17060000123452 | L17/dossiers | 17 | 17060000123451 | 17060000123451 | 1 | PA267780 | PM843395 |
| 17060000123459 | L17/dossiers | 17 | 17060000123458 | 17060000123458 | 1 | PA720386 | PM843020 |
| 17060000123466 | L17/dossiers | 17 | 17060000123465 | 17060000123465 | 1 | PA794734 | PM843146 |
| 17060000123473 | L17/dossiers | 17 | 17060000123472 | 17060000123472 | 1 | PA643089 | PM843431 |
| 17060000123480 | L17/dossiers | 17 | 17060000123479 | 17060000123479 | 1 | PA795422 | PM843599 |
| 17060000123493 | L17/dossiers | 17 | 17060000123492 | 17060000123492 | 1 | PA794982 | PM843329 |
| 17060000123500 | L17/dossiers | 17 | 17060000123499 | 17060000123499 | 1 | PA794178 | PM842897 |
| 17060000123507 | L17/dossiers | 17 | 17060000123506 | 17060000123506 | 1 | PA720430 | PM843092 |
| 17060000123524 | L17/dossiers | 17 | 17060000123523 | 17060000123523 | 1 | PA796018 | PM843425 |
| 17060000123531 | L17/dossiers | 17 | 17060000123530 | 17060000123530 | 1 | PA794982 | PM843329 |
| 17060000123587 | L17/dossiers | 17 | 17060000123586 | 17060000123586 | 1 | PA712015 | PM842381 |
| 17060000123594 | L17/dossiers | 17 | 17060000123593 | 17060000123593 | 1 | PA795920 | PM843653 |
| 17060000123602 | L17/dossiers | 17 | 17060000123601 | 17060000123601 | 1 | PA795920 | PM843653 |
| 17060000123630 | L17/dossiers | 17 | 17060000123629 | 17060000123629 | 1 | PA722190 | PM843659 |
| 17060000123689 | L17/dossiers | 17 | 17060000123688 | 17060000123688 | 1 | PA722046 | PM843482 |
| 17060000123697 | L17/dossiers | 17 | 17060000123696 | 17060000123696 | 1 | PA717379 | PM843374 |
| 17060000123783 | L17/dossiers | 17 | 17060000123782 | 17060000123782 | 1 | PA606098 | PM842633 |
| 17060000123790 | L17/dossiers | 17 | 17060000123789 | 17060000123789 | 1 | PA793780 | PM842714 |
| 17060000123797 | L17/dossiers | 17 | 17060000123796 | 17060000123796 | 1 | PA722046 | PM843482 |
| 17060000123804 | L17/dossiers | 17 | 17060000123803 | 17060000123803 | 1 | PA722374 | PM843302 |
| 17060000123811 | L17/dossiers | 17 | 17060000123810 | 17060000123810 | 1 | PA795778 | PM843509 |
| 17060000123818 | L17/dossiers | 17 | 17060000123817 | 17060000123817 | 1 | PA608826 | PM843365 |
| 17060000123825 | L17/dossiers | 17 | 17060000123824 | 17060000123824 | 1 | PA330008 | PM842366 |
| 17060000123832 | L17/dossiers | 17 | 17060000123831 | 17060000123831 | 1 | PA793298 | PM842360 |
| 17060000123839 | L17/dossiers | 17 | 17060000123838 | 17060000123838 | 1 | PA642847 | PM843056 |