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 |
|---|---|---|---|---|---|---|---|
| 15060000155050 | L15/dossiers | 15 | 15060000155049 | 15060000155049 | 1 | PA345619 | PM725692 |
| 15060000155062 | L15/dossiers | 15 | 15060000155061 | 15060000155061 | 1 | PA345619 | PM725692 |
| 15060000155069 | L15/dossiers | 15 | 15060000155068 | 15060000155068 | 1 | PA2538 | PM703570 |
| 15060000155076 | L15/dossiers | 15 | 15060000155075 | 15060000155075 | 1 | PA717379 | PM723282 |
| 15060000155085 | L15/dossiers | 15 | 15060000155084 | 15060000155084 | 1 | PA223837 | PM722458 |
| 15060000155089 | L15/dossiers | 15 | 15060000155088 | 15060000155088 | 1 | PA718868 | PM722484 |
| 15060000155102 | L15/dossiers | 15 | 15060000155101 | 15060000155101 | 1 | PA722030 | PM723454 |
| 15060000155109 | L15/dossiers | 15 | 15060000155108 | 15060000155108 | 1 | PA345619 | PM725692 |
| 15060000155110 | L15/dossiers | 15 | 15060000155108 | 15060000155108 | 2 | PA717169 | PM730074 |
| 15060000155120 | L15/dossiers | 15 | 15060000155119 | 15060000155119 | 1 | PA721062 | PM723158 |
| 15060000155131 | L15/dossiers | 15 | 15060000155130 | 15060000155130 | 1 | PA331567 | PM722644 |
| 15060000155138 | L15/dossiers | 15 | 15060000155137 | 15060000155137 | 1 | PA719388 | PM722648 |
| 15060000155145 | L15/dossiers | 15 | 15060000155144 | 15060000155144 | 1 | PA605518 | PM722518 |
| 15060000155152 | L15/dossiers | 15 | 15060000155151 | 15060000155151 | 1 | PA720210 | PM722892 |
| 15060000155159 | L15/dossiers | 15 | 15060000155158 | 15060000155158 | 1 | PA721474 | PM723286 |
| 15060000155166 | L15/dossiers | 15 | 15060000155165 | 15060000155165 | 1 | PA719318 | PM722624 |
| 15060000155173 | L15/dossiers | 15 | 15060000155172 | 15060000155172 | 1 | PA441 | PM723152 |
| 15060000155180 | L15/dossiers | 15 | 15060000155179 | 15060000155179 | 1 | PA345619 | PM725692 |
| 15060000155234 | L15/dossiers | 15 | 15060000155233 | 15060000155233 | 1 | PA345619 | PM725692 |
| 15060000155291 | L15/dossiers | 15 | 15060000155290 | 15060000155290 | 1 | PA703539 | PM703693 |
| 15060000155306 | L15/dossiers | 15 | 15060000155305 | 15060000155305 | 1 | PA343775 | PM736367 |
| 15060000155313 | L15/dossiers | 15 | 15060000155312 | 15060000155312 | 1 | PA343775 | PM736367 |
| 15060000155320 | L15/dossiers | 15 | 15060000155319 | 15060000155319 | 1 | PA343775 | PM736367 |
| 15060000155327 | L15/dossiers | 15 | 15060000155326 | 15060000155326 | 1 | PA345619 | PM725692 |
| 15060000155328 | L15/dossiers | 15 | 15060000155326 | 15060000155326 | 2 | PA1872 | PM730104 |
| 15060000155362 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 1 | PA227089 | PM736372 |
| 15060000155363 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 2 | PA736189 | PM736363 |
| 15060000155364 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 3 | PA736223 | PM736368 |
| 15060000155365 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 4 | PA1001 | PM736371 |
| 15060000155366 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 5 | PA267762 | PM736366 |
| 15060000155367 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 6 | PA736196 | PM736370 |
| 15060000155368 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 7 | PA429894 | PM736364 |
| 15060000155369 | L15/dossiers | 15 | 15060000155361 | 15060000155361 | 8 | PA343775 | PM736367 |
| 15060000155410 | L15/dossiers | 15 | 15060000155409 | 15060000155409 | 1 | PA342665 | PM736382 |
| 15060000155417 | L15/dossiers | 15 | 15060000155416 | 15060000155416 | 1 | PA705750 | PM705821 |
| 15060000155418 | L15/dossiers | 15 | 15060000155416 | 15060000155416 | 2 | PA2197 | PM703640 |
| 15060000155425 | L15/dossiers | 15 | 15060000155424 | 15060000155424 | 1 | PA266867 | PM703554 |
| 15060000155438 | L15/dossiers | 15 | 15060000155437 | 15060000155437 | 1 | PA744079 | PM744082 |
| 15060000155445 | L15/dossiers | 15 | 15060000155444 | 15060000155444 | 1 | PA1883 | PM736286 |
| 15060000155452 | L15/dossiers | 15 | 15060000155451 | 15060000155451 | 1 | PA703482 | PM703642 |
| 15060000155459 | L15/dossiers | 15 | 15060000155458 | 15060000155458 | 1 | PA429836 | PM430049 |
| 15060000155460 | L15/dossiers | 15 | 15060000155458 | 15060000155458 | 2 | PA304082 | PM430056 |
| 15060000155461 | L15/dossiers | 15 | 15060000155458 | 15060000155458 | 3 | PA429894 | PM429941 |
| 15060000155462 | L15/dossiers | 15 | 15060000155458 | 15060000155458 | 4 | PA429886 | PM430018 |
| 15060000155463 | L15/dossiers | 15 | 15060000155458 | 15060000155458 | 5 | PA678263 | PM678267 |
| 15060000155464 | L15/dossiers | 15 | 15060000155458 | 15060000155458 | 6 | PA703499 | PM703641 |
| 15060000155471 | L15/dossiers | 15 | 15060000155470 | 15060000155470 | 1 | PA304082 | PM430056 |
| 15060000155472 | L15/dossiers | 15 | 15060000155470 | 15060000155470 | 2 | PA429894 | PM429941 |
| 15060000155473 | L15/dossiers | 15 | 15060000155470 | 15060000155470 | 3 | PA429836 | PM430049 |
| 15060000155474 | L15/dossiers | 15 | 15060000155470 | 15060000155470 | 4 | PA429886 | PM430018 |