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 |
|---|---|---|---|---|---|---|---|
| 15060000150166 | L15/dossiers | 15 | 15060000150165 | 15060000150165 | 1 | PA345619 | PM725692 |
| 15060000150167 | L15/dossiers | 15 | 15060000150165 | 15060000150165 | 2 | PA332747 | PM758790 |
| 15060000150174 | L15/dossiers | 15 | 15060000150173 | 15060000150173 | 1 | PA345619 | PM725692 |
| 15060000150181 | L15/dossiers | 15 | 15060000150180 | 15060000150180 | 1 | PA606171 | PM722632 |
| 15060000150191 | L15/dossiers | 15 | 15060000150190 | 15060000150190 | 1 | PA713448 | PM722452 |
| 15060000150198 | L15/dossiers | 15 | 15060000150197 | 15060000150197 | 1 | PA266788 | PM722914 |
| 15060000150205 | L15/dossiers | 15 | 15060000150204 | 15060000150204 | 1 | PA607553 | PM722956 |
| 15060000150212 | L15/dossiers | 15 | 15060000150211 | 15060000150211 | 1 | PA718926 | PM722502 |
| 15060000150219 | L15/dossiers | 15 | 15060000150218 | 15060000150218 | 1 | PA266788 | PM722914 |
| 15060000150227 | L15/dossiers | 15 | 15060000150226 | 15060000150226 | 1 | PA346218 | PM723348 |
| 15060000150234 | L15/dossiers | 15 | 15060000150233 | 15060000150233 | 1 | PA346054 | PM723510 |
| 15060000150241 | L15/dossiers | 15 | 15060000150240 | 15060000150240 | 1 | PA334843 | PM723534 |
| 15060000150248 | L15/dossiers | 15 | 15060000150247 | 15060000150247 | 1 | PA721474 | PM723286 |
| 15060000150255 | L15/dossiers | 15 | 15060000150254 | 15060000150254 | 1 | PA2377 | PM723550 |
| 15060000150262 | L15/dossiers | 15 | 15060000150261 | 15060000150261 | 1 | PA721932 | PM734586 |
| 15060000150269 | L15/dossiers | 15 | 15060000150268 | 15060000150268 | 1 | PA345619 | PM725692 |
| 15060000150270 | L15/dossiers | 15 | 15060000150268 | 15060000150268 | 2 | PA1872 | PM730104 |
| 15060000150287 | L15/dossiers | 15 | 15060000150286 | 15060000150286 | 1 | PA689 | PM723090 |
| 15060000150298 | L15/dossiers | 15 | 15060000150297 | 15060000150297 | 1 | PA608016 | PM723024 |
| 15060000150308 | L15/dossiers | 15 | 15060000150307 | 15060000150307 | 1 | PA720230 | PM722898 |
| 15060000150316 | L15/dossiers | 15 | 15060000150315 | 15060000150315 | 1 | PA337483 | PM723140 |
| 15060000150328 | L15/dossiers | 15 | 15060000150327 | 15060000150327 | 1 | PA720728 | PM723058 |
| 15060000150335 | L15/dossiers | 15 | 15060000150334 | 15060000150334 | 1 | PA720002 | PM722830 |
| 15060000150343 | L15/dossiers | 15 | 15060000150342 | 15060000150342 | 1 | PA608016 | PM723024 |
| 15060000150351 | L15/dossiers | 15 | 15060000150350 | 15060000150350 | 1 | PA719778 | PM722760 |
| 15060000150359 | L15/dossiers | 15 | 15060000150358 | 15060000150358 | 1 | PA719850 | PM722780 |
| 15060000150367 | L15/dossiers | 15 | 15060000150366 | 15060000150366 | 1 | PA332523 | PM722792 |
| 15060000150375 | L15/dossiers | 15 | 15060000150374 | 15060000150374 | 1 | PA720560 | PM723000 |
| 15060000150383 | L15/dossiers | 15 | 15060000150382 | 15060000150382 | 1 | PA720692 | PM723042 |
| 15060000150391 | L15/dossiers | 15 | 15060000150390 | 15060000150390 | 1 | PA609590 | PM723326 |
| 15060000150399 | L15/dossiers | 15 | 15060000150398 | 15060000150398 | 1 | PA720878 | PM723102 |
| 15060000150407 | L15/dossiers | 15 | 15060000150406 | 15060000150406 | 1 | PA2150 | PM722506 |
| 15060000150415 | L15/dossiers | 15 | 15060000150414 | 15060000150414 | 1 | PA719318 | PM722624 |
| 15060000150422 | L15/dossiers | 15 | 15060000150421 | 15060000150421 | 1 | PA719946 | PM722808 |
| 15060000150429 | L15/dossiers | 15 | 15060000150428 | 15060000150428 | 1 | PA721174 | PM723194 |
| 15060000150436 | L15/dossiers | 15 | 15060000150435 | 15060000150435 | 1 | PA720644 | PM723026 |
| 15060000150443 | L15/dossiers | 15 | 15060000150442 | 15060000150442 | 1 | PA1874 | PM722598 |
| 15060000150450 | L15/dossiers | 15 | 15060000150449 | 15060000150449 | 1 | PA1874 | PM722598 |
| 15060000150457 | L15/dossiers | 15 | 15060000150456 | 15060000150456 | 1 | PA642847 | PM722954 |
| 15060000150464 | L15/dossiers | 15 | 15060000150463 | 15060000150463 | 1 | PA266808 | PM723264 |
| 15060000150471 | L15/dossiers | 15 | 15060000150470 | 15060000150470 | 1 | PA266808 | PM723264 |
| 15060000150481 | L15/dossiers | 15 | 15060000150480 | 15060000150480 | 1 | PA720738 | PM723062 |
| 15060000150482 | L15/dossiers | 15 | 15060000150480 | 15060000150480 | 2 | PA334654 | PM723566 |
| 15060000150498 | L15/dossiers | 15 | 15060000150497 | 15060000150497 | 1 | PA719946 | PM722808 |
| 15060000150505 | L15/dossiers | 15 | 15060000150504 | 15060000150504 | 1 | PA643089 | PM758076 |
| 15060000150512 | L15/dossiers | 15 | 15060000150511 | 15060000150511 | 1 | PA1874 | PM722598 |
| 15060000150519 | L15/dossiers | 15 | 15060000150518 | 15060000150518 | 1 | PA718784 | PM722456 |
| 15060000150526 | L15/dossiers | 15 | 15060000150525 | 15060000150525 | 1 | PA722202 | PM723502 |
| 15060000150533 | L15/dossiers | 15 | 15060000150532 | 15060000150532 | 1 | PA721054 | PM723156 |
| 15060000150540 | L15/dossiers | 15 | 15060000150539 | 15060000150539 | 1 | PA718838 | PM722474 |