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 |
|---|---|---|---|---|---|---|---|
| 17060000124424 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 20 | PA842037 | PM843578 |
| 17060000124425 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 21 | PA791812 | PM840384 |
| 17060000124426 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 22 | PA793736 | PM842693 |
| 17060000124427 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 23 | PA721202 | PM840435 |
| 17060000124428 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 24 | PA795136 | PM843353 |
| 17060000124429 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 25 | PA793464 | PM840273 |
| 17060000124430 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 26 | PA842155 | PM843674 |
| 17060000124431 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 27 | PA795200 | PM843386 |
| 17060000124432 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 28 | PA795844 | PM843515 |
| 17060000124433 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 29 | PA841251 | PM842837 |
| 17060000124434 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 30 | PA794786 | PM843242 |
| 17060000124435 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 31 | PA794870 | PM843185 |
| 17060000124436 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 32 | PA796070 | PM843746 |
| 17060000124437 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 33 | PA795310 | PM840453 |
| 17060000124438 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 34 | PA794478 | PM843107 |
| 17060000124439 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 35 | PA841947 | PM843503 |
| 17060000124440 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 36 | PA794082 | PM842810 |
| 17060000124441 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 37 | PA794130 | PM840297 |
| 17060000124442 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 38 | PA720846 | PM840441 |
| 17060000124443 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 39 | PA841729 | PM843287 |
| 17060000124444 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 40 | PA795516 | PM843452 |
| 17060000124445 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 41 | PA795672 | PM843752 |
| 17060000124446 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 42 | PA795746 | PM843584 |
| 17060000124447 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 43 | PA795108 | PM843338 |
| 17060000124448 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 44 | PA841515 | PM843089 |
| 17060000124449 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 45 | PA795298 | PM843683 |
| 17060000124450 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 46 | PA791824 | PM840375 |
| 17060000124451 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 47 | PA842029 | PM843575 |
| 17060000124452 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 48 | PA793532 | PM842591 |
| 17060000124453 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 49 | PA342384 | PM842771 |
| 17060000124454 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 50 | PA795422 | PM843599 |
| 17060000124455 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 51 | PA794686 | PM843080 |
| 17060000124456 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 52 | PA841215 | PM842801 |
| 17060000124457 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 53 | PA795482 | PM843605 |
| 17060000124458 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 54 | PA610654 | PM843719 |
| 17060000124459 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 55 | PA841191 | PM842789 |
| 17060000124460 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 56 | PA721960 | PM840378 |
| 17060000124461 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 57 | PA793872 | PM840285 |
| 17060000124462 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 58 | PA817211 | PM842600 |
| 17060000124463 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 59 | PA793756 | PM840282 |
| 17060000124464 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 60 | PA796062 | PM843668 |
| 17060000124465 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 61 | PA719578 | PM842618 |
| 17060000124466 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 62 | PA721062 | PM843740 |
| 17060000124467 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 63 | PA841845 | PM843407 |
| 17060000124468 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 64 | PA795982 | PM840432 |
| 17060000124469 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 65 | PA795466 | PM843443 |
| 17060000124470 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 66 | PA793744 | PM842696 |
| 17060000124471 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 67 | PA720952 | PM843755 |
| 17060000124472 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 68 | PA794106 | PM842885 |
| 17060000124473 | L17/dossiers | 17 | 17060000124404 | 17060000124404 | 69 | PA794166 | PM842924 |