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 |
|---|---|---|---|---|---|---|---|
| 15060000167254 | L15/dossiers | 15 | 15060000167253 | 15060000167253 | 1 | PA720644 | PM723026 |
| 15060000167261 | L15/dossiers | 15 | 15060000167260 | 15060000167260 | 1 | PA643089 | PM758076 |
| 15060000167268 | L15/dossiers | 15 | 15060000167267 | 15060000167267 | 1 | PA722118 | PM723476 |
| 15060000167275 | L15/dossiers | 15 | 15060000167274 | 15060000167274 | 1 | PA773441 | PM773491 |
| 15060000167282 | L15/dossiers | 15 | 15060000167281 | 15060000167281 | 1 | PA721210 | PM723204 |
| 15060000167289 | L15/dossiers | 15 | 15060000167288 | 15060000167288 | 1 | PA722390 | PM723560 |
| 15060000167296 | L15/dossiers | 15 | 15060000167295 | 15060000167295 | 1 | PA718850 | PM722478 |
| 15060000167303 | L15/dossiers | 15 | 15060000167302 | 15060000167302 | 1 | PA709315 | PM722526 |
| 15060000167310 | L15/dossiers | 15 | 15060000167309 | 15060000167309 | 1 | PA718884 | PM722488 |
| 15060000167317 | L15/dossiers | 15 | 15060000167316 | 15060000167316 | 1 | PA718894 | PM722494 |
| 15060000167324 | L15/dossiers | 15 | 15060000167323 | 15060000167323 | 1 | PA335612 | PM723506 |
| 15060000167340 | L15/dossiers | 15 | 15060000167339 | 15060000167339 | 1 | PA721486 | PM723290 |
| 15060000167347 | L15/dossiers | 15 | 15060000167346 | 15060000167346 | 1 | PA713448 | PM722452 |
| 15060000167354 | L15/dossiers | 15 | 15060000167353 | 15060000167353 | 1 | PA718744 | PM722442 |
| 15060000167361 | L15/dossiers | 15 | 15060000167360 | 15060000167360 | 1 | PA719608 | PM722710 |
| 15060000167368 | L15/dossiers | 15 | 15060000167367 | 15060000167367 | 1 | PA719608 | PM722710 |
| 15060000167375 | L15/dossiers | 15 | 15060000167374 | 15060000167374 | 1 | PA718744 | PM722442 |
| 15060000167382 | L15/dossiers | 15 | 15060000167381 | 15060000167381 | 1 | PA720468 | PM722972 |
| 15060000167389 | L15/dossiers | 15 | 15060000167388 | 15060000167388 | 1 | PA721174 | PM723194 |
| 15060000167396 | L15/dossiers | 15 | 15060000167395 | 15060000167395 | 1 | PA267780 | PM723504 |
| 15060000167403 | L15/dossiers | 15 | 15060000167402 | 15060000167402 | 1 | PA268019 | PM723092 |
| 15060000167407 | L15/dossiers | 15 | 15060000167406 | 15060000167406 | 1 | PA642868 | PM722992 |
| 15060000167414 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 1 | PA429836 | PM736345 |
| 15060000167415 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 2 | PA757676 | PM757692 |
| 15060000167416 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 3 | PA736173 | PM736369 |
| 15060000167417 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 4 | PA304082 | PM736354 |
| 15060000167418 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 5 | PA429891 | PM736329 |
| 15060000167419 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 6 | PA429894 | PM736364 |
| 15060000167420 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 7 | PA756685 | PM756689 |
| 15060000167421 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 8 | PA304071 | PM703676 |
| 15060000167422 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 9 | PA429886 | PM736385 |
| 15060000167423 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 10 | PA736195 | PM736357 |
| 15060000167424 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 11 | PA736177 | PM736318 |
| 15060000167425 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 12 | PA1978 | PM736337 |
| 15060000167426 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 13 | PA678263 | PM736330 |
| 15060000167427 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 14 | PA736243 | PM736413 |
| 15060000167428 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 15 | PA703499 | PM703641 |
| 15060000167429 | L15/dossiers | 15 | 15060000167413 | 15060000167413 | 16 | PA736175 | PM736344 |
| 15060000167442 | L15/dossiers | 15 | 15060000167441 | 15060000167441 | 1 | PA773441 | PM773491 |
| 15060000167443 | L15/dossiers | 15 | 15060000167441 | 15060000167441 | 2 | PA331481 | PM773459 |
| 15060000167444 | L15/dossiers | 15 | 15060000167441 | 15060000167441 | 3 | PA330357 | PM773447 |
| 15060000168136 | L15/dossiers | 15 | 15060000168135 | 15060000168135 | 1 | PA720278 | PM722916 |
| 15060000168146 | L15/dossiers | 15 | 15060000168145 | 15060000168145 | 1 | PA266788 | PM722914 |
| 15060000168150 | L15/dossiers | 15 | 15060000168149 | 15060000168149 | 1 | PA429858 | PM736268 |
| 15060000168151 | L15/dossiers | 15 | 15060000168149 | 15060000168149 | 2 | PA550 | PM703612 |
| 15060000168158 | L15/dossiers | 15 | 15060000168157 | 15060000168157 | 1 | PA429858 | PM736268 |
| 15060000168178 | L15/dossiers | 15 | 15060000168177 | 15060000168177 | 1 | PA429858 | PM736268 |
| 15060000168197 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 1 | PA736177 | PM736318 |
| 15060000168198 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 2 | PA757676 | PM757692 |
| 15060000168199 | L15/dossiers | 15 | 15060000168196 | 15060000168196 | 3 | PA429891 | PM736329 |