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 |
|---|---|---|---|---|---|---|---|
| 16060000125199 | L16/dossiers | 16 | 16060000125198 | 16060000125198 | 1 | PA267673 | PM775865 |
| 16060000125206 | L16/dossiers | 16 | 16060000125205 | 16060000125205 | 1 | PA736214 | PM829883 |
| 16060000125213 | L16/dossiers | 16 | 16060000125212 | 16060000125212 | 1 | PA266788 | PM796788 |
| 16060000125220 | L16/dossiers | 16 | 16060000125219 | 16060000125219 | 1 | PA343988 | PM829809 |
| 16060000125253 | L16/dossiers | 16 | 16060000125252 | 16060000125252 | 1 | PA303997 | PM775743 |
| 16060000125254 | L16/dossiers | 16 | 16060000125252 | 16060000125252 | 2 | PA569 | PM775717 |
| 16060000125262 | L16/dossiers | 16 | 16060000125261 | 16060000125261 | 1 | PA330684 | PM775859 |
| 16060000125269 | L16/dossiers | 16 | 16060000125268 | 16060000125268 | 1 | PA827986 | PM828806 |
| 16060000125276 | L16/dossiers | 16 | 16060000125275 | 16060000125275 | 1 | PA785193 | PM829743 |
| 16060000125292 | L16/dossiers | 16 | 16060000125291 | 16060000125291 | 1 | PA794450 | PM796938 |
| 16060000125305 | L16/dossiers | 16 | 16060000125304 | 16060000125304 | 1 | PA795636 | PM797601 |
| 16060000125312 | L16/dossiers | 16 | 16060000125311 | 16060000125311 | 1 | PA775202 | PM775502 |
| 16060000125319 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 1 | PA415477 | PM775809 |
| 16060000125320 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 2 | PA415477 | PM775809 |
| 16060000125321 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 3 | PA827900 | PM828434 |
| 16060000125322 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 4 | PA415488 | PM775641 |
| 16060000125323 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 5 | PA775194 | PM775476 |
| 16060000125324 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 6 | PA775196 | PM775482 |
| 16060000125325 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 7 | PA827920 | PM828574 |
| 16060000125326 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 8 | PA590034 | PM775606 |
| 16060000125327 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 9 | PA827924 | PM828550 |
| 16060000125328 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 10 | PA785855 | PM785869 |
| 16060000125329 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 11 | PA429835 | PM829719 |
| 16060000125330 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 12 | PA732419 | PM775647 |
| 16060000125331 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 13 | PA827940 | PM828622 |
| 16060000125332 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 14 | PA642756 | PM775779 |
| 16060000125333 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 15 | PA736241 | PM829931 |
| 16060000125334 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 16 | PA736181 | PM829839 |
| 16060000125335 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 17 | PA703536 | PM775719 |
| 16060000125336 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 18 | PA775256 | PM775546 |
| 16060000125337 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 19 | PA610850 | PM828634 |
| 16060000125338 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 20 | PA775274 | PM775560 |
| 16060000125339 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 21 | PA643028 | PM829316 |
| 16060000125340 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 22 | PA736214 | PM829883 |
| 16060000125341 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 23 | PA736217 | PM829873 |
| 16060000125342 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 24 | PA828014 | PM828818 |
| 16060000125343 | L16/dossiers | 16 | 16060000125318 | 16060000125318 | 25 | PA828018 | PM828882 |
| 16060000125350 | L16/dossiers | 16 | 16060000125349 | 16060000125349 | 1 | PA722190 | PM833697 |
| 16060000125358 | L16/dossiers | 16 | 16060000125357 | 16060000125357 | 1 | PA827904 | PM828514 |
| 16060000125365 | L16/dossiers | 16 | 16060000125364 | 16060000125364 | 1 | PA827894 | PM828460 |
| 16060000125372 | L16/dossiers | 16 | 16060000125371 | 16060000125371 | 1 | PA2162 | PM82321 |
| 16060000125416 | L16/dossiers | 16 | 16060000125415 | 16060000125415 | 1 | PA2332 | PM84873 |
| 15060000129472 | L15/dossiers | 15 | 15060000129471 | 15060000129471 | 1 | PA345619 | PM717221 |
| 15060000129573 | L15/dossiers | 15 | 15060000129572 | 15060000129572 | 1 | PA345619 | PM725692 |
| 15060000129604 | L15/dossiers | 15 | 15060000129603 | 15060000129603 | 1 | PA345619 | PM725692 |
| 15060000129611 | L15/dossiers | 15 | 15060000129610 | 15060000129610 | 1 | PA223837 | PM722458 |
| 15060000129615 | L15/dossiers | 15 | 15060000129614 | 15060000129614 | 1 | PA332747 | PM722798 |
| 15060000129619 | L15/dossiers | 15 | 15060000129618 | 15060000129618 | 1 | PA345619 | PM725692 |
| 15060000129620 | L15/dossiers | 15 | 15060000129618 | 15060000129618 | 2 | PA331481 | PM730094 |
| 15060000129628 | L15/dossiers | 15 | 15060000129627 | 15060000129627 | 1 | PA345619 | PM725692 |