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 |
|---|---|---|---|---|---|---|---|
| 16060000101757 | L16/dossiers | 16 | 16060000101756 | 16060000101756 | 1 | PA703532 | PM775699 |
| 16060000101758 | L16/dossiers | 16 | 16060000101756 | 16060000101756 | 2 | PA736187 | PM736365 |
| 16060000101759 | L16/dossiers | 16 | 16060000101756 | 16060000101756 | 3 | PA747420 | PM775761 |
| 16060000101809 | L16/dossiers | 16 | 16060000101808 | 16060000101808 | 1 | PA720630 | PM797094 |
| 16060000101816 | L16/dossiers | 16 | 16060000101815 | 16060000101815 | 1 | PA1327 | PM796632 |
| 16060000101823 | L16/dossiers | 16 | 16060000101822 | 16060000101822 | 1 | PA1206 | PM797637 |
| 16060000101834 | L16/dossiers | 16 | 16060000101833 | 16060000101833 | 1 | PA720838 | PM797865 |
| 16060000101844 | L16/dossiers | 16 | 16060000101843 | 16060000101843 | 1 | PA721722 | PM797502 |
| 16060000101862 | L16/dossiers | 16 | 16060000101861 | 16060000101861 | 1 | PA793342 | PM796269 |
| 16060000101870 | L16/dossiers | 16 | 16060000101869 | 16060000101869 | 1 | PA712014 | PM802637 |
| 16060000101874 | L16/dossiers | 16 | 16060000101873 | 16060000101873 | 1 | PA794590 | PM797007 |
| 16060000101878 | L16/dossiers | 16 | 16060000101877 | 16060000101877 | 1 | PA267762 | PM736366 |
| 16060000101885 | L16/dossiers | 16 | 16060000101884 | 16060000101884 | 1 | PA2116 | PM736339 |
| 16060000101892 | L16/dossiers | 16 | 16060000101891 | 16060000101891 | 1 | PA717161 | PM791583 |
| 16060000101900 | L16/dossiers | 16 | 16060000101899 | 16060000101899 | 1 | PA796062 | PM797832 |
| 16060000101908 | L16/dossiers | 16 | 16060000101907 | 16060000101907 | 1 | PA606098 | PM796449 |
| 16060000101909 | L16/dossiers | 16 | 16060000101907 | 16060000101907 | 2 | PA720684 | PM797082 |
| 16060000101931 | L16/dossiers | 16 | 16060000101930 | 16060000101930 | 1 | PA794906 | PM797187 |
| 16060000101938 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 1 | PA736243 | PM736413 |
| 16060000101939 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 2 | PA757676 | PM757692 |
| 16060000101940 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 3 | PA304082 | PM736354 |
| 16060000101941 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 4 | PA775172 | PM775474 |
| 16060000101942 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 5 | PA429894 | PM736364 |
| 16060000101943 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 6 | PA756685 | PM775777 |
| 16060000101944 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 7 | PA429836 | PM736345 |
| 16060000101945 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 8 | PA429886 | PM736385 |
| 16060000101946 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 9 | PA736195 | PM736357 |
| 16060000101947 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 10 | PA736173 | PM736369 |
| 16060000101948 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 11 | PA775246 | PM775532 |
| 16060000101949 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 12 | PA678263 | PM736330 |
| 16060000101950 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 13 | PA1978 | PM736337 |
| 16060000101951 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 14 | PA736175 | PM736344 |
| 16060000101952 | L16/dossiers | 16 | 16060000101937 | 16060000101937 | 15 | PA775296 | PM775596 |
| 16060000101959 | L16/dossiers | 16 | 16060000101958 | 16060000101958 | 1 | PA382672 | PM736263 |
| 16060000101960 | L16/dossiers | 16 | 16060000101958 | 16060000101958 | 2 | PA736182 | PM736346 |
| 16060000101967 | L16/dossiers | 16 | 16060000101966 | 16060000101966 | 1 | PA717161 | PM791583 |
| 16060000102040 | L16/dossiers | 16 | 16060000102039 | 16060000102039 | 1 | PA711156 | PM736319 |
| 16060000102055 | L16/dossiers | 16 | 16060000102054 | 16060000102054 | 1 | PA795778 | PM797682 |
| 16060000102059 | L16/dossiers | 16 | 16060000102058 | 16060000102058 | 1 | PA720822 | PM797058 |
| 16060000102067 | L16/dossiers | 16 | 16060000102066 | 16060000102066 | 1 | PA266788 | PM796788 |
| 16060000102074 | L16/dossiers | 16 | 16060000102073 | 16060000102073 | 1 | PA266788 | PM796788 |
| 16060000102078 | L16/dossiers | 16 | 16060000102077 | 16060000102077 | 1 | PA2116 | PM736339 |
| 16060000102085 | L16/dossiers | 16 | 16060000102084 | 16060000102084 | 1 | PA794670 | PM797049 |
| 16060000102092 | L16/dossiers | 16 | 16060000102091 | 16060000102091 | 1 | PA267318 | PM797307 |
| 16060000102099 | L16/dossiers | 16 | 16060000102098 | 16060000102098 | 1 | PA1327 | PM796632 |
| 16060000102106 | L16/dossiers | 16 | 16060000102105 | 16060000102105 | 1 | PA721024 | PM797592 |
| 16060000102111 | L16/dossiers | 16 | 16060000102110 | 16060000102110 | 1 | PA794914 | PM797190 |
| 16060000102118 | L16/dossiers | 16 | 16060000102117 | 16060000102117 | 1 | PA266788 | PM796788 |
| 16060000102122 | L16/dossiers | 16 | 16060000102121 | 16060000102121 | 1 | PA719512 | PM796509 |
| 16060000102144 | L16/dossiers | 16 | 16060000102143 | 16060000102143 | 1 | PA720862 | PM797412 |