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 |
|---|---|---|---|---|---|---|---|
| 15060000159034 | L15/dossiers | 15 | 15060000159020 | 15060000159020 | 14 | PA736209 | PM736400 |
| 15060000159053 | L15/dossiers | 15 | 15060000159052 | 15060000159052 | 1 | PA703485 | PM703654 |
| 15060000159060 | L15/dossiers | 15 | 15060000159059 | 15060000159059 | 1 | PA703513 | PM703621 |
| 15060000159067 | L15/dossiers | 15 | 15060000159066 | 15060000159066 | 1 | PA736187 | PM736365 |
| 15060000159074 | L15/dossiers | 15 | 15060000159073 | 15060000159073 | 1 | PA1206 | PM723354 |
| 15060000159081 | L15/dossiers | 15 | 15060000159080 | 15060000159080 | 1 | PA718784 | PM722456 |
| 15060000159088 | L15/dossiers | 15 | 15060000159087 | 15060000159087 | 1 | PA744079 | PM744082 |
| 15060000159095 | L15/dossiers | 15 | 15060000159094 | 15060000159094 | 1 | PA703513 | PM703621 |
| 15060000159102 | L15/dossiers | 15 | 15060000159101 | 15060000159101 | 1 | PA703519 | PM703649 |
| 15060000159121 | L15/dossiers | 15 | 15060000159120 | 15060000159120 | 1 | PA267018 | PM703564 |
| 15060000159128 | L15/dossiers | 15 | 15060000159127 | 15060000159127 | 1 | PA382672 | PM736263 |
| 15060000159135 | L15/dossiers | 15 | 15060000159134 | 15060000159134 | 1 | PA345619 | PM725692 |
| 15060000159136 | L15/dossiers | 15 | 15060000159134 | 15060000159134 | 2 | PA1872 | PM730104 |
| 15060000159171 | L15/dossiers | 15 | 15060000159170 | 15060000159170 | 1 | PA610775 | PM723170 |
| 15060000159192 | L15/dossiers | 15 | 15060000159191 | 15060000159191 | 1 | PA721474 | PM723286 |
| 15060000159199 | L15/dossiers | 15 | 15060000159198 | 15060000159198 | 1 | PA721474 | PM723286 |
| 15060000159206 | L15/dossiers | 15 | 15060000159205 | 15060000159205 | 1 | PA330240 | PM722492 |
| 15060000159213 | L15/dossiers | 15 | 15060000159212 | 15060000159212 | 1 | PA718780 | PM722454 |
| 15060000159220 | L15/dossiers | 15 | 15060000159219 | 15060000159219 | 1 | PA345619 | PM725692 |
| 15060000159251 | L15/dossiers | 15 | 15060000159250 | 15060000159250 | 1 | PA721960 | PM723434 |
| 15060000159258 | L15/dossiers | 15 | 15060000159257 | 15060000159257 | 1 | PA268019 | PM723092 |
| 15060000159265 | L15/dossiers | 15 | 15060000159264 | 15060000159264 | 1 | PA642868 | PM722992 |
| 15060000159272 | L15/dossiers | 15 | 15060000159271 | 15060000159271 | 1 | PA719806 | PM722768 |
| 15060000159289 | L15/dossiers | 15 | 15060000159288 | 15060000159288 | 1 | PA608826 | PM723276 |
| 15060000159296 | L15/dossiers | 15 | 15060000159295 | 15060000159295 | 1 | PA608826 | PM723276 |
| 15060000159303 | L15/dossiers | 15 | 15060000159302 | 15060000159302 | 1 | PA267306 | PM723054 |
| 15060000159310 | L15/dossiers | 15 | 15060000159309 | 15060000159309 | 1 | PA330684 | PM722528 |
| 15060000159317 | L15/dossiers | 15 | 15060000159316 | 15060000159316 | 1 | PA720754 | PM723066 |
| 15060000159359 | L15/dossiers | 15 | 15060000159358 | 15060000159358 | 1 | PA719092 | PM722560 |
| 15060000159366 | L15/dossiers | 15 | 15060000159365 | 15060000159365 | 1 | PA719608 | PM722710 |
| 15060000159373 | L15/dossiers | 15 | 15060000159372 | 15060000159372 | 1 | PA2796 | PM722510 |
| 15060000159383 | L15/dossiers | 15 | 15060000159382 | 15060000159382 | 1 | PA721062 | PM723158 |
| 15060000159390 | L15/dossiers | 15 | 15060000159389 | 15060000159389 | 1 | PA266788 | PM722914 |
| 15060000159397 | L15/dossiers | 15 | 15060000159396 | 15060000159396 | 1 | PA608826 | PM723276 |
| 15060000159404 | L15/dossiers | 15 | 15060000159403 | 15060000159403 | 1 | PA643089 | PM758076 |
| 15060000159411 | L15/dossiers | 15 | 15060000159410 | 15060000159410 | 1 | PA721888 | PM723412 |
| 15060000159418 | L15/dossiers | 15 | 15060000159417 | 15060000159417 | 1 | PA267233 | PM723500 |
| 15060000159425 | L15/dossiers | 15 | 15060000159424 | 15060000159424 | 1 | PA223837 | PM722458 |
| 15060000159432 | L15/dossiers | 15 | 15060000159431 | 15060000159431 | 1 | PA720568 | PM723002 |
| 15060000159439 | L15/dossiers | 15 | 15060000159438 | 15060000159438 | 1 | PA2150 | PM722506 |
| 15060000159446 | L15/dossiers | 15 | 15060000159445 | 15060000159445 | 1 | PA721486 | PM723290 |
| 15060000159453 | L15/dossiers | 15 | 15060000159452 | 15060000159452 | 1 | PA721678 | PM723352 |
| 15060000159460 | L15/dossiers | 15 | 15060000159459 | 15060000159459 | 1 | PA720278 | PM722916 |
| 15060000159467 | L15/dossiers | 15 | 15060000159466 | 15060000159466 | 1 | PA720278 | PM722916 |
| 15060000159477 | L15/dossiers | 15 | 15060000159476 | 15060000159476 | 1 | PA382672 | PM736263 |
| 15060000159499 | L15/dossiers | 15 | 15060000159498 | 15060000159498 | 1 | PA607553 | PM722956 |
| 15060000159503 | L15/dossiers | 15 | 15060000159502 | 15060000159502 | 1 | PA313924 | PM703546 |
| 15060000159522 | L15/dossiers | 15 | 15060000159521 | 15060000159521 | 1 | PA719138 | PM722574 |
| 15060000159553 | L15/dossiers | 15 | 15060000159552 | 15060000159552 | 1 | PA607619 | PM722936 |
| 15060000159602 | L15/dossiers | 15 | 15060000159601 | 15060000159601 | 1 | PA331582 | PM722646 |