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 |
|---|---|---|---|---|---|---|---|
| 15060000186023 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 10 | PA429858 | PM736268 |
| 15060000186024 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 11 | PA744079 | PM744082 |
| 15060000186025 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 12 | PA736188 | PM736289 |
| 15060000186026 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 13 | PA775176 | PM775462 |
| 15060000186027 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 14 | PA775178 | PM775460 |
| 15060000186028 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 15 | PA773891 | PM773895 |
| 15060000186029 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 16 | PA736202 | PM775775 |
| 15060000186030 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 17 | PA775184 | PM775486 |
| 15060000186031 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 18 | PA736198 | PM736406 |
| 15060000186032 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 19 | PA775190 | PM775488 |
| 15060000186033 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 20 | PA775192 | PM775478 |
| 15060000186034 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 21 | PA703500 | PM775643 |
| 15060000186035 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 22 | PA736244 | PM736333 |
| 15060000186036 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 23 | PA775198 | PM775480 |
| 15060000186037 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 24 | PA736231 | PM736381 |
| 15060000186038 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 25 | PA330684 | PM775859 |
| 15060000186039 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 26 | PA736216 | PM736273 |
| 15060000186040 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 27 | PA775204 | PM775508 |
| 15060000186041 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 28 | PA716 | PM736261 |
| 15060000186042 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 29 | PA703510 | PM775681 |
| 15060000186043 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 30 | PA429870 | PM736309 |
| 15060000186044 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 31 | PA709750 | PM736295 |
| 15060000186045 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 32 | PA703513 | PM775671 |
| 15060000186046 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 33 | PA429854 | PM736335 |
| 15060000186047 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 34 | PA415462 | PM775797 |
| 15060000186048 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 35 | PA736172 | PM736415 |
| 15060000186049 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 36 | PA607489 | PM736390 |
| 15060000186050 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 37 | PA736197 | PM736378 |
| 15060000186051 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 38 | PA720634 | PM736312 |
| 15060000186052 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 39 | PA715745 | PM736297 |
| 15060000186053 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 40 | PA736192 | PM736353 |
| 15060000186054 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 41 | PA267340 | PM775731 |
| 15060000186055 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 42 | PA736160 | PM736359 |
| 15060000186056 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 43 | PA775212 | PM775500 |
| 15060000186057 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 44 | PA267112 | PM775737 |
| 15060000186058 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 45 | PA775216 | PM775522 |
| 15060000186059 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 46 | PA404656 | PM736328 |
| 15060000186060 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 47 | PA775220 | PM775526 |
| 15060000186061 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 48 | PA703520 | PM775705 |
| 15060000186062 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 49 | PA736169 | PM736293 |
| 15060000186063 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 50 | PA775222 | PM775524 |
| 15060000186064 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 51 | PA1344 | PM736383 |
| 15060000186065 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 52 | PA415454 | PM785875 |
| 15060000186066 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 53 | PA776985 | PM777700 |
| 15060000186067 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 54 | PA775228 | PM775516 |
| 15060000186068 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 55 | PA715322 | PM775713 |
| 15060000186069 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 56 | PA778908 | PM778928 |
| 15060000186070 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 57 | PA331381 | PM775739 |
| 15060000186071 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 58 | PA267081 | PM775733 |
| 15060000186072 | L15/dossiers | 15 | 15060000186013 | 15060000186013 | 59 | PA227078 | PM736258 |