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 |
|---|---|---|---|---|---|---|---|
| 15060000184107 | L15/dossiers | 15 | 15060000184106 | 15060000184106 | 1 | PA721210 | PM723204 |
| 15060000184130 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 1 | PA703520 | PM775705 |
| 15060000184131 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 2 | PA775168 | PM775470 |
| 15060000184132 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 3 | PA736247 | PM736281 |
| 15060000184133 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 4 | PA429858 | PM736268 |
| 15060000184134 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 5 | PA744079 | PM744082 |
| 15060000184135 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 6 | PA736188 | PM736289 |
| 15060000184136 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 7 | PA775176 | PM775462 |
| 15060000184137 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 8 | PA736202 | PM775775 |
| 15060000184138 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 9 | PA703522 | PM775701 |
| 15060000184139 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 10 | PA342665 | PM736382 |
| 15060000184140 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 11 | PA703500 | PM775643 |
| 15060000184141 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 12 | PA775192 | PM775478 |
| 15060000184142 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 13 | PA775198 | PM775480 |
| 15060000184143 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 14 | PA736231 | PM736381 |
| 15060000184144 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 15 | PA775204 | PM775508 |
| 15060000184145 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 16 | PA703510 | PM775681 |
| 15060000184146 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 17 | PA304085 | PM736343 |
| 15060000184147 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 18 | PA429870 | PM736309 |
| 15060000184148 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 19 | PA709750 | PM736295 |
| 15060000184149 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 20 | PA703513 | PM775671 |
| 15060000184150 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 21 | PA429854 | PM736335 |
| 15060000184151 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 22 | PA415462 | PM775797 |
| 15060000184152 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 23 | PA736172 | PM736415 |
| 15060000184153 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 24 | PA736197 | PM736378 |
| 15060000184154 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 25 | PA720634 | PM736312 |
| 15060000184155 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 26 | PA715745 | PM736297 |
| 15060000184156 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 27 | PA404656 | PM736328 |
| 15060000184157 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 28 | PA736192 | PM736353 |
| 15060000184158 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 29 | PA1001 | PM736371 |
| 15060000184159 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 30 | PA775212 | PM775500 |
| 15060000184160 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 31 | PA425322 | PM736282 |
| 15060000184161 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 32 | PA267112 | PM775737 |
| 15060000184162 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 33 | PA703494 | PM775651 |
| 15060000184163 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 34 | PA775220 | PM775526 |
| 15060000184164 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 35 | PA736169 | PM736293 |
| 15060000184165 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 36 | PA1344 | PM736383 |
| 15060000184166 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 37 | PA776985 | PM777700 |
| 15060000184167 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 38 | PA775228 | PM775516 |
| 15060000184168 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 39 | PA415486 | PM775813 |
| 15060000184169 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 40 | PA703530 | PM775689 |
| 15060000184170 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 41 | PA267081 | PM775733 |
| 15060000184171 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 42 | PA227078 | PM736258 |
| 15060000184172 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 43 | PA775230 | PM775514 |
| 15060000184173 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 44 | PA415495 | PM775635 |
| 15060000184174 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 45 | PA703515 | PM775663 |
| 15060000184175 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 46 | PA775240 | PM775530 |
| 15060000184176 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 47 | PA205280 | PM736412 |
| 15060000184177 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 48 | PA775242 | PM775528 |
| 15060000184178 | L15/dossiers | 15 | 15060000184129 | 15060000184129 | 49 | PA394676 | PM775769 |