dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000108773 | L16/dossiers | 16 | 16060000108770 | 16060000108770 | 3 | PA266795 | PM775711 |
| 16060000108774 | L16/dossiers | 16 | 16060000108770 | 16060000108770 | 4 | PA703513 | PM775671 |
| 16060000108781 | L16/dossiers | 16 | 16060000108780 | 16060000108780 | 1 | PA795908 | PM797748 |
| 16060000108808 | L16/dossiers | 16 | 16060000108807 | 16060000108807 | 1 | PA605036 | PM796170 |
| 16060000108812 | L16/dossiers | 16 | 16060000108811 | 16060000108811 | 1 | PA793322 | PM796260 |
| 16060000108819 | L16/dossiers | 16 | 16060000108818 | 16060000108818 | 1 | PA774958 | PM797355 |
| 16060000108826 | L16/dossiers | 16 | 16060000108825 | 16060000108825 | 1 | PA721474 | PM797511 |
| 16060000108833 | L16/dossiers | 16 | 16060000108832 | 16060000108832 | 1 | PA721262 | PM797550 |
| 16060000108840 | L16/dossiers | 16 | 16060000108839 | 16060000108839 | 1 | PA721486 | PM797517 |
| 16060000108847 | L16/dossiers | 16 | 16060000108846 | 16060000108846 | 1 | PA721486 | PM797517 |
| 16060000108862 | L16/dossiers | 16 | 16060000108861 | 16060000108861 | 1 | PA712015 | PM796176 |
| 16060000108869 | L16/dossiers | 16 | 16060000108868 | 16060000108868 | 1 | PA712015 | PM796176 |
| 16060000108876 | L16/dossiers | 16 | 16060000108875 | 16060000108875 | 1 | PA2952 | PM796206 |
| 16060000108883 | L16/dossiers | 16 | 16060000108882 | 16060000108882 | 1 | PA266797 | PM796812 |
| 16060000108887 | L16/dossiers | 16 | 16060000108886 | 16060000108886 | 1 | PA794522 | PM796971 |
| 16060000108894 | L16/dossiers | 16 | 16060000108893 | 16060000108893 | 1 | PA719814 | PM796644 |
| 16060000108895 | L16/dossiers | 16 | 16060000108893 | 16060000108893 | 2 | PA718884 | PM796218 |
| 16060000108918 | L16/dossiers | 16 | 16060000108917 | 16060000108917 | 1 | PA795912 | PM797751 |
| 16060000108933 | L16/dossiers | 16 | 16060000108932 | 16060000108932 | 1 | PA608416 | PM797133 |
| 16060000108937 | L16/dossiers | 16 | 16060000108936 | 16060000108936 | 1 | PA793928 | PM796608 |
| 16060000108944 | L16/dossiers | 16 | 16060000108943 | 16060000108943 | 1 | PA2952 | PM796206 |
| 16060000108951 | L16/dossiers | 16 | 16060000108950 | 16060000108950 | 1 | PA795310 | PM797415 |
| 16060000108958 | L16/dossiers | 16 | 16060000108957 | 16060000108957 | 1 | PA795084 | PM797292 |
| 16060000108965 | L16/dossiers | 16 | 16060000108964 | 16060000108964 | 1 | PA712014 | PM802637 |
| 16060000108972 | L16/dossiers | 16 | 16060000108971 | 16060000108971 | 1 | PA266797 | PM796812 |
| 16060000108979 | L16/dossiers | 16 | 16060000108978 | 16060000108978 | 1 | PA719930 | PM796770 |
| 16060000108986 | L16/dossiers | 16 | 16060000108985 | 16060000108985 | 1 | PA333421 | PM796881 |
| 16060000108993 | L16/dossiers | 16 | 16060000108992 | 16060000108992 | 1 | PA793796 | PM796536 |
| 16060000109007 | L16/dossiers | 16 | 16060000109006 | 16060000109006 | 1 | PA717161 | PM791583 |
| 16060000109008 | L16/dossiers | 16 | 16060000109006 | 16060000109006 | 2 | PA801862 | PM801948 |
| 16060000109015 | L16/dossiers | 16 | 16060000109014 | 16060000109014 | 1 | PA717161 | PM791583 |
| 16060000109064 | L16/dossiers | 16 | 16060000109063 | 16060000109063 | 1 | PA717161 | PM791583 |
| 16060000109118 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 1 | PA429835 | PM736397 |
| 16060000109119 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 2 | PA429835 | PM736397 |
| 16060000109120 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 3 | PA429889 | PM736313 |
| 16060000109121 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 4 | PA702993 | PM736362 |
| 16060000109122 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 5 | PA775196 | PM775482 |
| 16060000109123 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 6 | PA775200 | PM775504 |
| 16060000109124 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 7 | PA736167 | PM736327 |
| 16060000109125 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 8 | PA703512 | PM775665 |
| 16060000109126 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 9 | PA703511 | PM775685 |
| 16060000109127 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 10 | PA736219 | PM736387 |
| 16060000109128 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 11 | PA775186 | PM775484 |
| 16060000109129 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 12 | PA415488 | PM775641 |
| 16060000109130 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 13 | PA775194 | PM775476 |
| 16060000109131 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 14 | PA775206 | PM775506 |
| 16060000109132 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 15 | PA590034 | PM775606 |
| 16060000109133 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 16 | PA785855 | PM785869 |
| 16060000109134 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 17 | PA736234 | PM736424 |
| 16060000109135 | L16/dossiers | 16 | 16060000109117 | 16060000109117 | 18 | PA775210 | PM775492 |