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 |
|---|---|---|---|---|---|---|---|
| 16060000111812 | L16/dossiers | 16 | 16060000111811 | 16060000111811 | 1 | PA719778 | PM796713 |
| 16060000111819 | L16/dossiers | 16 | 16060000111818 | 16060000111818 | 1 | PA794214 | PM796782 |
| 16060000111820 | L16/dossiers | 16 | 16060000111818 | 16060000111818 | 2 | PA267324 | PM797538 |
| 16060000111827 | L16/dossiers | 16 | 16060000111826 | 16060000111826 | 1 | PA330240 | PM796155 |
| 16060000111828 | L16/dossiers | 16 | 16060000111826 | 16060000111826 | 2 | PA606098 | PM796449 |
| 16060000111829 | L16/dossiers | 16 | 16060000111826 | 16060000111826 | 3 | PA605991 | PM796428 |
| 16060000111849 | L16/dossiers | 16 | 16060000111848 | 16060000111848 | 1 | PA783457 | PM796992 |
| 16060000111856 | L16/dossiers | 16 | 16060000111855 | 16060000111855 | 1 | PA720892 | PM797520 |
| 16060000111863 | L16/dossiers | 16 | 16060000111862 | 16060000111862 | 1 | PA793608 | PM796434 |
| 16060000111870 | L16/dossiers | 16 | 16060000111869 | 16060000111869 | 1 | PA717161 | PM791583 |
| 16060000111954 | L16/dossiers | 16 | 16060000111953 | 16060000111953 | 1 | PA717161 | PM791583 |
| 16060000111955 | L16/dossiers | 16 | 16060000111953 | 16060000111953 | 2 | PA759832 | PM791710 |
| 16060000111962 | L16/dossiers | 16 | 16060000111961 | 16060000111961 | 1 | PA793696 | PM796482 |
| 16060000111963 | L16/dossiers | 16 | 16060000111961 | 16060000111961 | 2 | PA720614 | PM797055 |
| 16060000111970 | L16/dossiers | 16 | 16060000111969 | 16060000111969 | 1 | PA720644 | PM797103 |
| 16060000111977 | L16/dossiers | 16 | 16060000111976 | 16060000111976 | 1 | PA794198 | PM796776 |
| 16060000111984 | L16/dossiers | 16 | 16060000111983 | 16060000111983 | 1 | PA736236 | PM736341 |
| 16060000111991 | L16/dossiers | 16 | 16060000111990 | 16060000111990 | 1 | PA775286 | PM775588 |
| 16060000111998 | L16/dossiers | 16 | 16060000111997 | 16060000111997 | 1 | PA2116 | PM736339 |
| 16060000112005 | L16/dossiers | 16 | 16060000112004 | 16060000112004 | 1 | PA2116 | PM736339 |
| 16060000112012 | L16/dossiers | 16 | 16060000112011 | 16060000112011 | 1 | PA2116 | PM736339 |
| 16060000112019 | L16/dossiers | 16 | 16060000112018 | 16060000112018 | 1 | PA267762 | PM736366 |
| 16060000112026 | L16/dossiers | 16 | 16060000112025 | 16060000112025 | 1 | PA775236 | PM775542 |
| 16060000112039 | L16/dossiers | 16 | 16060000112038 | 16060000112038 | 1 | PA794118 | PM796725 |
| 16060000112043 | L16/dossiers | 16 | 16060000112042 | 16060000112042 | 1 | PA2116 | PM736339 |
| 16060000112050 | L16/dossiers | 16 | 16060000112049 | 16060000112049 | 1 | PA1327 | PM796632 |
| 16060000112057 | L16/dossiers | 16 | 16060000112056 | 16060000112056 | 1 | PA721816 | PM797571 |
| 16060000112065 | L16/dossiers | 16 | 16060000112064 | 16060000112064 | 1 | PA794094 | PM796710 |
| 16060000112072 | L16/dossiers | 16 | 16060000112071 | 16060000112071 | 1 | PA719578 | PM796620 |
| 16060000112079 | L16/dossiers | 16 | 16060000112078 | 16060000112078 | 1 | PA796050 | PM797823 |
| 16060000112086 | L16/dossiers | 16 | 16060000112085 | 16060000112085 | 1 | PA794410 | PM796911 |
| 16060000112093 | L16/dossiers | 16 | 16060000112092 | 16060000112092 | 1 | PA794786 | PM797118 |
| 16060000112103 | L16/dossiers | 16 | 16060000112102 | 16060000112102 | 1 | PA791824 | PM797808 |
| 16060000112110 | L16/dossiers | 16 | 16060000112109 | 16060000112109 | 1 | PA722252 | PM797610 |
| 16060000112120 | L16/dossiers | 16 | 16060000112119 | 16060000112119 | 1 | PA721158 | PM797460 |
| 16060000112121 | L16/dossiers | 16 | 16060000112119 | 16060000112119 | 2 | PA794146 | PM796737 |
| 16060000112140 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 1 | PA304082 | PM736354 |
| 16060000112141 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 2 | PA429894 | PM736364 |
| 16060000112142 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 3 | PA736175 | PM736344 |
| 16060000112143 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 4 | PA757676 | PM757692 |
| 16060000112144 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 5 | PA775172 | PM775474 |
| 16060000112145 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 6 | PA756685 | PM775777 |
| 16060000112146 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 7 | PA429836 | PM736345 |
| 16060000112147 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 8 | PA429886 | PM736385 |
| 16060000112148 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 9 | PA736195 | PM736357 |
| 16060000112149 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 10 | PA736173 | PM736369 |
| 16060000112150 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 11 | PA775246 | PM775532 |
| 16060000112151 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 12 | PA678263 | PM736330 |
| 16060000112152 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 13 | PA1978 | PM736337 |
| 16060000112153 | L16/dossiers | 16 | 16060000112139 | 16060000112139 | 14 | PA736243 | PM736413 |