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 |
|---|---|---|---|---|---|---|---|
| 16060000117357 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 11 | PA429886 | PM829757 |
| 16060000117358 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 12 | PA736173 | PM829799 |
| 16060000117359 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 13 | PA775246 | PM775532 |
| 16060000117360 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 14 | PA828002 | PM828856 |
| 16060000117361 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 15 | PA736243 | PM829929 |
| 16060000117362 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 16 | PA736175 | PM829795 |
| 16060000117363 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 17 | PA775296 | PM775596 |
| 16060000117364 | L16/dossiers | 16 | 16060000117346 | 16060000117346 | 18 | PA828020 | PM828864 |
| 16060000117371 | L16/dossiers | 16 | 16060000117370 | 16060000117370 | 1 | PA720446 | PM797031 |
| 16060000117375 | L16/dossiers | 16 | 16060000117374 | 16060000117374 | 1 | PA795636 | PM797601 |
| 16060000117382 | L16/dossiers | 16 | 16060000117381 | 16060000117381 | 1 | PA720286 | PM796878 |
| 16060000117389 | L16/dossiers | 16 | 16060000117388 | 16060000117388 | 1 | PA795552 | PM797547 |
| 16060000117396 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 1 | PA429894 | PM829765 |
| 16060000117397 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 2 | PA736175 | PM829795 |
| 16060000117398 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 3 | PA757676 | PM829801 |
| 16060000117399 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 4 | PA775172 | PM775474 |
| 16060000117400 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 5 | PA827898 | PM828454 |
| 16060000117401 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 6 | PA827912 | PM828488 |
| 16060000117402 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 7 | PA756685 | PM775777 |
| 16060000117403 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 8 | PA827930 | PM828544 |
| 16060000117404 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 9 | PA268007 | PM829695 |
| 16060000117405 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 10 | PA429886 | PM829757 |
| 16060000117406 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 11 | PA736195 | PM829855 |
| 16060000117407 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 12 | PA736173 | PM829799 |
| 16060000117408 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 13 | PA775246 | PM775532 |
| 16060000117409 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 14 | PA827962 | PM828676 |
| 16060000117410 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 15 | PA828002 | PM828856 |
| 16060000117411 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 16 | PA736243 | PM829929 |
| 16060000117412 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 17 | PA775296 | PM775596 |
| 16060000117413 | L16/dossiers | 16 | 16060000117395 | 16060000117395 | 18 | PA828020 | PM828864 |
| 16060000117423 | L16/dossiers | 16 | 16060000117422 | 16060000117422 | 1 | PA608416 | PM797133 |
| 16060000117427 | L16/dossiers | 16 | 16060000117426 | 16060000117426 | 1 | PA795410 | PM797472 |
| 16060000117434 | L16/dossiers | 16 | 16060000117433 | 16060000117433 | 1 | PA736229 | PM829923 |
| 16060000117441 | L16/dossiers | 16 | 16060000117440 | 16060000117440 | 1 | PA717161 | PM791583 |
| 16060000117515 | L16/dossiers | 16 | 16060000117514 | 16060000117514 | 1 | PA717161 | PM791583 |
| 16060000117598 | L16/dossiers | 16 | 16060000117597 | 16060000117597 | 1 | PA736229 | PM829923 |
| 16060000117605 | L16/dossiers | 16 | 16060000117604 | 16060000117604 | 1 | PA429842 | PM829733 |
| 16060000117606 | L16/dossiers | 16 | 16060000117604 | 16060000117604 | 2 | PA736239 | PM829893 |
| 16060000117607 | L16/dossiers | 16 | 16060000117604 | 16060000117604 | 3 | PA775192 | PM775478 |
| 16060000117618 | L16/dossiers | 16 | 16060000117617 | 16060000117617 | 1 | PA717161 | PM791583 |
| 16060000117619 | L16/dossiers | 16 | 16060000117617 | 16060000117617 | 2 | PA331481 | PM791666 |
| 16060000117626 | L16/dossiers | 16 | 16060000117625 | 16060000117625 | 1 | PA795820 | PM797700 |
| 16060000117633 | L16/dossiers | 16 | 16060000117632 | 16060000117632 | 1 | PA346782 | PM797691 |
| 16060000117637 | L16/dossiers | 16 | 16060000117636 | 16060000117636 | 1 | PA720892 | PM797520 |
| 16060000117641 | L16/dossiers | 16 | 16060000117640 | 16060000117640 | 1 | PA785857 | PM785867 |
| 16060000117642 | L16/dossiers | 16 | 16060000117640 | 16060000117640 | 2 | PA775180 | PM775466 |
| 16060000117643 | L16/dossiers | 16 | 16060000117640 | 16060000117640 | 3 | PA827904 | PM828514 |
| 16060000117644 | L16/dossiers | 16 | 16060000117640 | 16060000117640 | 4 | PA429845 | PM829729 |
| 16060000117645 | L16/dossiers | 16 | 16060000117640 | 16060000117640 | 5 | PA775214 | PM775498 |
| 16060000117646 | L16/dossiers | 16 | 16060000117640 | 16060000117640 | 6 | PA775224 | PM775512 |