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 |
|---|---|---|---|---|---|---|---|
| 15060000178084 | L15/dossiers | 15 | 15060000178083 | 15060000178083 | 1 | PA642847 | PM722954 |
| 15060000178091 | L15/dossiers | 15 | 15060000178090 | 15060000178090 | 1 | PA736178 | PM736296 |
| 15060000178098 | L15/dossiers | 15 | 15060000178097 | 15060000178097 | 1 | PA721832 | PM771998 |
| 15060000178105 | L15/dossiers | 15 | 15060000178104 | 15060000178104 | 1 | PA330008 | PM722416 |
| 15060000178112 | L15/dossiers | 15 | 15060000178111 | 15060000178111 | 1 | PA642847 | PM722954 |
| 15060000178123 | L15/dossiers | 15 | 15060000178122 | 15060000178122 | 1 | PA718780 | PM722454 |
| 15060000178130 | L15/dossiers | 15 | 15060000178129 | 15060000178129 | 1 | PA720386 | PM722948 |
| 15060000178137 | L15/dossiers | 15 | 15060000178136 | 15060000178136 | 1 | PA335999 | PM723480 |
| 15060000178144 | L15/dossiers | 15 | 15060000178143 | 15060000178143 | 1 | PA719778 | PM722760 |
| 15060000178151 | L15/dossiers | 15 | 15060000178150 | 15060000178150 | 1 | PA721474 | PM723286 |
| 15060000178158 | L15/dossiers | 15 | 15060000178157 | 15060000178157 | 1 | PA707706 | PM775741 |
| 15060000178159 | L15/dossiers | 15 | 15060000178157 | 15060000178157 | 2 | PA775278 | PM775564 |
| 15060000178166 | L15/dossiers | 15 | 15060000178165 | 15060000178165 | 1 | PA720916 | PM723112 |
| 15060000178170 | L15/dossiers | 15 | 15060000178169 | 15060000178169 | 1 | PA721046 | PM723154 |
| 15060000178177 | L15/dossiers | 15 | 15060000178176 | 15060000178176 | 1 | PA773441 | PM773491 |
| 15060000178283 | L15/dossiers | 15 | 15060000178282 | 15060000178282 | 1 | PA2116 | PM736339 |
| 15060000178290 | L15/dossiers | 15 | 15060000178289 | 15060000178289 | 1 | PA720560 | PM723000 |
| 15060000178297 | L15/dossiers | 15 | 15060000178296 | 15060000178296 | 1 | PA718784 | PM722456 |
| 15060000178304 | L15/dossiers | 15 | 15060000178303 | 15060000178303 | 1 | PA721202 | PM723202 |
| 15060000178311 | L15/dossiers | 15 | 15060000178310 | 15060000178310 | 1 | PA2116 | PM736339 |
| 15060000178324 | L15/dossiers | 15 | 15060000178323 | 15060000178323 | 1 | PA223837 | PM722458 |
| 15060000178328 | L15/dossiers | 15 | 15060000178327 | 15060000178327 | 1 | PA703536 | PM775719 |
| 15060000178335 | L15/dossiers | 15 | 15060000178334 | 15060000178334 | 1 | PA720846 | PM723094 |
| 15060000178342 | L15/dossiers | 15 | 15060000178341 | 15060000178341 | 1 | PA719092 | PM722560 |
| 15060000178349 | L15/dossiers | 15 | 15060000178348 | 15060000178348 | 1 | PA719778 | PM722760 |
| 15060000178356 | L15/dossiers | 15 | 15060000178355 | 15060000178355 | 1 | PA774954 | PM774972 |
| 15060000178363 | L15/dossiers | 15 | 15060000178362 | 15060000178362 | 1 | PA718884 | PM722488 |
| 15060000178374 | L15/dossiers | 15 | 15060000178373 | 15060000178373 | 1 | PA720870 | PM723100 |
| 15060000178381 | L15/dossiers | 15 | 15060000178380 | 15060000178380 | 1 | PA775272 | PM775562 |
| 15060000178388 | L15/dossiers | 15 | 15060000178387 | 15060000178387 | 1 | PA720692 | PM723042 |
| 15060000178396 | L15/dossiers | 15 | 15060000178395 | 15060000178395 | 1 | PA608016 | PM723024 |
| 15060000178404 | L15/dossiers | 15 | 15060000178403 | 15060000178403 | 1 | PA721024 | PM723144 |
| 15060000178412 | L15/dossiers | 15 | 15060000178411 | 15060000178411 | 1 | PA773441 | PM773491 |
| 15060000178413 | L15/dossiers | 15 | 15060000178411 | 15060000178411 | 2 | PA1872 | PM773455 |
| 15060000178453 | L15/dossiers | 15 | 15060000178452 | 15060000178452 | 1 | PA719608 | PM722710 |
| 15060000178460 | L15/dossiers | 15 | 15060000178459 | 15060000178459 | 1 | PA721486 | PM723290 |
| 15060000178467 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 1 | PA757676 | PM757692 |
| 15060000178468 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 2 | PA429836 | PM736345 |
| 15060000178469 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 3 | PA1978 | PM736337 |
| 15060000178470 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 4 | PA736175 | PM736344 |
| 15060000178471 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 5 | PA304082 | PM736354 |
| 15060000178472 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 6 | PA775172 | PM775474 |
| 15060000178473 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 7 | PA429894 | PM736364 |
| 15060000178474 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 8 | PA756685 | PM775777 |
| 15060000178475 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 9 | PA429886 | PM736385 |
| 15060000178476 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 10 | PA736195 | PM736357 |
| 15060000178477 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 11 | PA736173 | PM736369 |
| 15060000178478 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 12 | PA775246 | PM775532 |
| 15060000178479 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 13 | PA678263 | PM736330 |
| 15060000178480 | L15/dossiers | 15 | 15060000178466 | 15060000178466 | 14 | PA736243 | PM736413 |