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 |
|---|---|---|---|---|---|---|---|
| 16060000116454 | L16/dossiers | 16 | 16060000116453 | 16060000116453 | 1 | PA721486 | PM797517 |
| 16060000116461 | L16/dossiers | 16 | 16060000116460 | 16060000116460 | 1 | PA796050 | PM797823 |
| 16060000116468 | L16/dossiers | 16 | 16060000116467 | 16060000116467 | 1 | PA642847 | PM796872 |
| 16060000116475 | L16/dossiers | 16 | 16060000116474 | 16060000116474 | 1 | PA795310 | PM797415 |
| 16060000116491 | L16/dossiers | 16 | 16060000116490 | 16060000116490 | 1 | PA793382 | PM796293 |
| 16060000116498 | L16/dossiers | 16 | 16060000116497 | 16060000116497 | 1 | PA794038 | PM796668 |
| 16060000116520 | L16/dossiers | 16 | 16060000116519 | 16060000116519 | 1 | PA794038 | PM796668 |
| 16060000116527 | L16/dossiers | 16 | 16060000116526 | 16060000116526 | 1 | PA793736 | PM796503 |
| 16060000116544 | L16/dossiers | 16 | 16060000116543 | 16060000116543 | 1 | PA793756 | PM796512 |
| 16060000116558 | L16/dossiers | 16 | 16060000116557 | 16060000116557 | 1 | PA643192 | PM797097 |
| 16060000116565 | L16/dossiers | 16 | 16060000116564 | 16060000116564 | 1 | PA721960 | PM797811 |
| 16060000116589 | L16/dossiers | 16 | 16060000116588 | 16060000116588 | 1 | PA795200 | PM797352 |
| 16060000116606 | L16/dossiers | 16 | 16060000116605 | 16060000116605 | 1 | PA774954 | PM796797 |
| 16060000116613 | L16/dossiers | 16 | 16060000116612 | 16060000116612 | 1 | PA793444 | PM796329 |
| 16060000116631 | L16/dossiers | 16 | 16060000116630 | 16060000116630 | 1 | PA795982 | PM797787 |
| 16060000116643 | L16/dossiers | 16 | 16060000116642 | 16060000116642 | 1 | PA415446 | PM775783 |
| 16060000116644 | L16/dossiers | 16 | 16060000116642 | 16060000116642 | 2 | PA747420 | PM775761 |
| 16060000116662 | L16/dossiers | 16 | 16060000116661 | 16060000116661 | 1 | PA795046 | PM802641 |
| 16060000116669 | L16/dossiers | 16 | 16060000116668 | 16060000116668 | 1 | PA717161 | PM791583 |
| 16060000116678 | L16/dossiers | 16 | 16060000116677 | 16060000116677 | 1 | PA608416 | PM797133 |
| 16060000116686 | L16/dossiers | 16 | 16060000116685 | 16060000116685 | 1 | PA793928 | PM796608 |
| 16060000116693 | L16/dossiers | 16 | 16060000116692 | 16060000116692 | 1 | PA717161 | PM791583 |
| 16060000116732 | L16/dossiers | 16 | 16060000116731 | 16060000116731 | 1 | PA736181 | PM829839 |
| 16060000116739 | L16/dossiers | 16 | 16060000116738 | 16060000116738 | 1 | PA719318 | PM796470 |
| 16060000116746 | L16/dossiers | 16 | 16060000116745 | 16060000116745 | 1 | PA793238 | PM796224 |
| 16060000116753 | L16/dossiers | 16 | 16060000116752 | 16060000116752 | 1 | PA793238 | PM796224 |
| 16060000116760 | L16/dossiers | 16 | 16060000116759 | 16060000116759 | 1 | PA608016 | PM797100 |
| 16060000116767 | L16/dossiers | 16 | 16060000116766 | 16060000116766 | 1 | PA642847 | PM796872 |
| 16060000116780 | L16/dossiers | 16 | 16060000116779 | 16060000116779 | 1 | PA721410 | PM797316 |
| 16060000116807 | L16/dossiers | 16 | 16060000116806 | 16060000116806 | 1 | PA796010 | PM797802 |
| 16060000116814 | L16/dossiers | 16 | 16060000116813 | 16060000116813 | 1 | PA795552 | PM797547 |
| 16060000116821 | L16/dossiers | 16 | 16060000116820 | 16060000116820 | 1 | PA793306 | PM796254 |
| 16060000116828 | L16/dossiers | 16 | 16060000116827 | 16060000116827 | 1 | PA794118 | PM796725 |
| 16060000116841 | L16/dossiers | 16 | 16060000116840 | 16060000116840 | 1 | PA794994 | PM797232 |
| 16060000116856 | L16/dossiers | 16 | 16060000116855 | 16060000116855 | 1 | PA794994 | PM797232 |
| 16060000116864 | L16/dossiers | 16 | 16060000116863 | 16060000116863 | 1 | PA720754 | PM797121 |
| 16060000116871 | L16/dossiers | 16 | 16060000116870 | 16060000116870 | 1 | PA720952 | PM797619 |
| 16060000116878 | L16/dossiers | 16 | 16060000116877 | 16060000116877 | 1 | PA720222 | PM796830 |
| 16060000116885 | L16/dossiers | 16 | 16060000116884 | 16060000116884 | 1 | PA736213 | PM775791 |
| 16060000116898 | L16/dossiers | 16 | 16060000116897 | 16060000116897 | 1 | PA703493 | PM775659 |
| 16060000116905 | L16/dossiers | 16 | 16060000116904 | 16060000116904 | 1 | PA415488 | PM775641 |
| 16060000116915 | L16/dossiers | 16 | 16060000116914 | 16060000116914 | 1 | PA717161 | PM791583 |
| 16060000116930 | L16/dossiers | 16 | 16060000116929 | 16060000116929 | 1 | PA795912 | PM797751 |
| 16060000116934 | L16/dossiers | 16 | 16060000116933 | 16060000116933 | 1 | PA785857 | PM785867 |
| 16060000116935 | L16/dossiers | 16 | 16060000116933 | 16060000116933 | 2 | PA827978 | PM828730 |
| 16060000116942 | L16/dossiers | 16 | 16060000116941 | 16060000116941 | 1 | PA793780 | PM796527 |
| 16060000116954 | L16/dossiers | 16 | 16060000116953 | 16060000116953 | 1 | PA719408 | PM775520 |
| 16060000116955 | L16/dossiers | 16 | 16060000116953 | 16060000116953 | 2 | PA415454 | PM785875 |
| 16060000116956 | L16/dossiers | 16 | 16060000116953 | 16060000116953 | 3 | PA2337 | PM775691 |
| 16060000116957 | L16/dossiers | 16 | 16060000116953 | 16060000116953 | 4 | PA827902 | PM828442 |