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 |
|---|---|---|---|---|---|---|---|
| 16060000097011 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 86 | PA429887 | PM736274 |
| 16060000097012 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 87 | PA736196 | PM736370 |
| 16060000097013 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 88 | PA703495 | PM775653 |
| 16060000097014 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 89 | PA775266 | PM775568 |
| 16060000097015 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 90 | PA703506 | PM777126 |
| 16060000097016 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 91 | PA703506 | PM777126 |
| 16060000097017 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 92 | PA736208 | PM736315 |
| 16060000097018 | L16/dossiers | 16 | 16060000096925 | 16060000096925 | 93 | PA736209 | PM736400 |
| 16060000097025 | L16/dossiers | 16 | 16060000097024 | 16060000097024 | 1 | PA719408 | PM775520 |
| 16060000097032 | L16/dossiers | 16 | 16060000097031 | 16060000097031 | 1 | PA736231 | PM736381 |
| 16060000097039 | L16/dossiers | 16 | 16060000097038 | 16060000097038 | 1 | PA642847 | PM796872 |
| 16060000097046 | L16/dossiers | 16 | 16060000097045 | 16060000097045 | 1 | PA642847 | PM796872 |
| 16060000097053 | L16/dossiers | 16 | 16060000097052 | 16060000097052 | 1 | PA717161 | PM791583 |
| 16060000097054 | L16/dossiers | 16 | 16060000097052 | 16060000097052 | 2 | PA312976 | PM791676 |
| 16060000097085 | L16/dossiers | 16 | 16060000097084 | 16060000097084 | 1 | PA718784 | PM796266 |
| 16060000097092 | L16/dossiers | 16 | 16060000097091 | 16060000097091 | 1 | PA718838 | PM796197 |
| 16060000097099 | L16/dossiers | 16 | 16060000097098 | 16060000097098 | 1 | PA736214 | PM736290 |
| 16060000097106 | L16/dossiers | 16 | 16060000097105 | 16060000097105 | 1 | PA719608 | PM796593 |
| 16060000097117 | L16/dossiers | 16 | 16060000097116 | 16060000097116 | 1 | PA722150 | PM797445 |
| 16060000097124 | L16/dossiers | 16 | 16060000097123 | 16060000097123 | 1 | PA267042 | PM796932 |
| 16060000097131 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 1 | PA2538 | PM775801 |
| 16060000097132 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 2 | PA736239 | PM736317 |
| 16060000097133 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 3 | PA775168 | PM775470 |
| 16060000097134 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 4 | PA736247 | PM736281 |
| 16060000097135 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 5 | PA429858 | PM736268 |
| 16060000097136 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 6 | PA744079 | PM744082 |
| 16060000097137 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 7 | PA736188 | PM736289 |
| 16060000097138 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 8 | PA775176 | PM775462 |
| 16060000097139 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 9 | PA775178 | PM775460 |
| 16060000097140 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 10 | PA773891 | PM773895 |
| 16060000097141 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 11 | PA736202 | PM775775 |
| 16060000097142 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 12 | PA775184 | PM775486 |
| 16060000097143 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 13 | PA736198 | PM736406 |
| 16060000097144 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 14 | PA703522 | PM775701 |
| 16060000097145 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 15 | PA775192 | PM775478 |
| 16060000097146 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 16 | PA703500 | PM775643 |
| 16060000097147 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 17 | PA747421 | PM775759 |
| 16060000097148 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 18 | PA775198 | PM775480 |
| 16060000097149 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 19 | PA330684 | PM775859 |
| 16060000097150 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 20 | PA736216 | PM736273 |
| 16060000097151 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 21 | PA775202 | PM775502 |
| 16060000097152 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 22 | PA775204 | PM775508 |
| 16060000097153 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 23 | PA716 | PM736261 |
| 16060000097154 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 24 | PA304085 | PM736343 |
| 16060000097155 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 25 | PA703510 | PM775681 |
| 16060000097156 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 26 | PA429870 | PM736309 |
| 16060000097157 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 27 | PA709750 | PM736295 |
| 16060000097158 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 28 | PA429854 | PM736335 |
| 16060000097159 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 29 | PA415462 | PM775797 |
| 16060000097160 | L16/dossiers | 16 | 16060000097130 | 16060000097130 | 30 | PA607489 | PM736390 |