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 |
|---|---|---|---|---|---|---|---|
| 15060000163175 | L15/dossiers | 15 | 15060000163174 | 15060000163174 | 1 | PA268019 | PM723092 |
| 15060000163179 | L15/dossiers | 15 | 15060000163178 | 15060000163178 | 1 | PA856 | PM723288 |
| 15060000163186 | L15/dossiers | 15 | 15060000163185 | 15060000163185 | 1 | PA718838 | PM722474 |
| 15060000163193 | L15/dossiers | 15 | 15060000163192 | 15060000163192 | 1 | PA719946 | PM722808 |
| 15060000163197 | L15/dossiers | 15 | 15060000163196 | 15060000163196 | 1 | PA719946 | PM722808 |
| 15060000163201 | L15/dossiers | 15 | 15060000163200 | 15060000163200 | 1 | PA712014 | PM722984 |
| 15060000163205 | L15/dossiers | 15 | 15060000163204 | 15060000163204 | 1 | PA1206 | PM723354 |
| 15060000163212 | L15/dossiers | 15 | 15060000163211 | 15060000163211 | 1 | PA606712 | PM722756 |
| 15060000163219 | L15/dossiers | 15 | 15060000163218 | 15060000163218 | 1 | PA336316 | PM723406 |
| 15060000163226 | L15/dossiers | 15 | 15060000163225 | 15060000163225 | 1 | PA719272 | PM722612 |
| 15060000163233 | L15/dossiers | 15 | 15060000163232 | 15060000163232 | 1 | PA720614 | PM723016 |
| 15060000163240 | L15/dossiers | 15 | 15060000163239 | 15060000163239 | 1 | PA722390 | PM723560 |
| 15060000163247 | L15/dossiers | 15 | 15060000163246 | 15060000163246 | 1 | PA944 | PM703562 |
| 15060000163254 | L15/dossiers | 15 | 15060000163253 | 15060000163253 | 1 | PA330684 | PM722528 |
| 15060000163261 | L15/dossiers | 15 | 15060000163260 | 15060000163260 | 1 | PA720846 | PM723094 |
| 15060000163268 | L15/dossiers | 15 | 15060000163267 | 15060000163267 | 1 | PA334149 | PM723034 |
| 15060000163275 | L15/dossiers | 15 | 15060000163274 | 15060000163274 | 1 | PA719946 | PM722808 |
| 15060000163282 | L15/dossiers | 15 | 15060000163281 | 15060000163281 | 1 | PA719946 | PM722808 |
| 15060000163289 | L15/dossiers | 15 | 15060000163288 | 15060000163288 | 1 | PA342601 | PM761932 |
| 15060000163296 | L15/dossiers | 15 | 15060000163295 | 15060000163295 | 1 | PA643089 | PM758076 |
| 15060000163303 | L15/dossiers | 15 | 15060000163302 | 15060000163302 | 1 | PA345619 | PM725692 |
| 15060000163304 | L15/dossiers | 15 | 15060000163302 | 15060000163302 | 2 | PA607846 | PM730066 |
| 15060000163429 | L15/dossiers | 15 | 15060000163428 | 15060000163428 | 1 | PA345619 | PM725692 |
| 15060000163490 | L15/dossiers | 15 | 15060000163489 | 15060000163489 | 1 | PA415495 | PM703579 |
| 15060000163497 | L15/dossiers | 15 | 15060000163496 | 15060000163496 | 1 | PA720422 | PM722960 |
| 15060000163504 | L15/dossiers | 15 | 15060000163503 | 15060000163503 | 1 | PA605036 | PM722444 |
| 15060000163511 | L15/dossiers | 15 | 15060000163510 | 15060000163510 | 1 | PA342601 | PM761932 |
| 15060000163518 | L15/dossiers | 15 | 15060000163517 | 15060000163517 | 1 | PA2377 | PM723550 |
| 15060000163525 | L15/dossiers | 15 | 15060000163524 | 15060000163524 | 1 | PA721410 | PM723266 |
| 15060000163532 | L15/dossiers | 15 | 15060000163531 | 15060000163531 | 1 | PA721410 | PM723266 |
| 15060000163539 | L15/dossiers | 15 | 15060000163538 | 15060000163538 | 1 | PA346054 | PM723510 |
| 15060000163546 | L15/dossiers | 15 | 15060000163545 | 15060000163545 | 1 | PA1874 | PM722598 |
| 15060000163553 | L15/dossiers | 15 | 15060000163552 | 15060000163552 | 1 | PA266808 | PM723264 |
| 15060000163560 | L15/dossiers | 15 | 15060000163559 | 15060000163559 | 1 | PA719318 | PM722624 |
| 15060000163564 | L15/dossiers | 15 | 15060000163563 | 15060000163563 | 1 | PA719946 | PM722808 |
| 15060000163571 | L15/dossiers | 15 | 15060000163570 | 15060000163570 | 1 | PA642847 | PM722954 |
| 15060000163578 | L15/dossiers | 15 | 15060000163577 | 15060000163577 | 1 | PA719318 | PM722624 |
| 15060000163585 | L15/dossiers | 15 | 15060000163584 | 15060000163584 | 1 | PA721888 | PM723412 |
| 15060000163593 | L15/dossiers | 15 | 15060000163592 | 15060000163592 | 1 | PA268019 | PM723092 |
| 15060000163600 | L15/dossiers | 15 | 15060000163599 | 15060000163599 | 1 | PA268019 | PM723092 |
| 15060000163607 | L15/dossiers | 15 | 15060000163606 | 15060000163606 | 1 | PA268019 | PM723092 |
| 15060000163614 | L15/dossiers | 15 | 15060000163613 | 15060000163613 | 1 | PA268019 | PM723092 |
| 15060000163621 | L15/dossiers | 15 | 15060000163620 | 15060000163620 | 1 | PA266808 | PM723264 |
| 15060000163628 | L15/dossiers | 15 | 15060000163627 | 15060000163627 | 1 | PA732420 | PM763170 |
| 15060000163629 | L15/dossiers | 15 | 15060000163627 | 15060000163627 | 2 | PA732420 | PM763170 |
| 15060000163636 | L15/dossiers | 15 | 15060000163635 | 15060000163635 | 1 | PA718838 | PM722474 |
| 15060000163652 | L15/dossiers | 15 | 15060000163651 | 15060000163651 | 1 | PA721816 | PM748964 |
| 15060000163656 | L15/dossiers | 15 | 15060000163655 | 15060000163655 | 1 | PA334654 | PM723566 |
| 15060000163663 | L15/dossiers | 15 | 15060000163662 | 15060000163662 | 1 | PA345619 | PM725692 |
| 15060000163718 | L15/dossiers | 15 | 15060000163717 | 15060000163717 | 1 | PA415488 | PM703558 |