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 |
|---|---|---|---|---|---|---|---|
| 15060000158075 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 1 | PA736195 | PM736357 |
| 15060000158076 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 2 | PA304082 | PM736354 |
| 15060000158077 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 3 | PA757676 | PM757692 |
| 15060000158078 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 4 | PA429891 | PM736329 |
| 15060000158079 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 5 | PA429894 | PM736364 |
| 15060000158080 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 6 | PA756685 | PM756689 |
| 15060000158081 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 7 | PA429836 | PM736345 |
| 15060000158082 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 8 | PA304071 | PM703676 |
| 15060000158083 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 9 | PA429886 | PM736385 |
| 15060000158084 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 10 | PA736177 | PM736318 |
| 15060000158085 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 11 | PA736173 | PM736369 |
| 15060000158086 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 12 | PA1978 | PM736337 |
| 15060000158087 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 13 | PA678263 | PM736330 |
| 15060000158088 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 14 | PA736243 | PM736413 |
| 15060000158089 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 15 | PA703499 | PM703641 |
| 15060000158090 | L15/dossiers | 15 | 15060000158074 | 15060000158074 | 16 | PA736175 | PM736344 |
| 15060000158097 | L15/dossiers | 15 | 15060000158096 | 15060000158096 | 1 | PA426327 | PM703630 |
| 15060000158104 | L15/dossiers | 15 | 15060000158103 | 15060000158103 | 1 | PA703485 | PM703654 |
| 15060000158111 | L15/dossiers | 15 | 15060000158110 | 15060000158110 | 1 | PA2116 | PM736339 |
| 15060000158118 | L15/dossiers | 15 | 15060000158117 | 15060000158117 | 1 | PA382672 | PM736263 |
| 15060000158125 | L15/dossiers | 15 | 15060000158124 | 15060000158124 | 1 | PA429869 | PM736350 |
| 15060000158132 | L15/dossiers | 15 | 15060000158131 | 15060000158131 | 1 | PA703513 | PM703621 |
| 15060000158139 | L15/dossiers | 15 | 15060000158138 | 15060000158138 | 1 | PA703522 | PM703702 |
| 15060000158146 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 1 | PA756685 | PM756689 |
| 15060000158147 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 2 | PA304082 | PM736354 |
| 15060000158148 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 3 | PA757676 | PM757692 |
| 15060000158149 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 4 | PA429891 | PM736329 |
| 15060000158150 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 5 | PA429894 | PM736364 |
| 15060000158151 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 6 | PA429836 | PM736345 |
| 15060000158152 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 7 | PA304071 | PM703676 |
| 15060000158153 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 8 | PA429886 | PM736385 |
| 15060000158154 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 9 | PA736195 | PM736357 |
| 15060000158155 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 10 | PA736177 | PM736318 |
| 15060000158156 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 11 | PA736173 | PM736369 |
| 15060000158157 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 12 | PA1978 | PM736337 |
| 15060000158158 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 13 | PA678263 | PM736330 |
| 15060000158159 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 14 | PA736243 | PM736413 |
| 15060000158160 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 15 | PA703499 | PM703641 |
| 15060000158161 | L15/dossiers | 15 | 15060000158145 | 15060000158145 | 16 | PA736175 | PM736344 |
| 15060000158168 | L15/dossiers | 15 | 15060000158167 | 15060000158167 | 1 | PA703520 | PM703665 |
| 15060000158175 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 1 | PA343988 | PM736310 |
| 15060000158176 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 2 | PA736247 | PM736281 |
| 15060000158177 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 3 | PA736202 | PM736392 |
| 15060000158178 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 4 | PA703522 | PM703702 |
| 15060000158179 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 5 | PA703513 | PM703621 |
| 15060000158180 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 6 | PA429854 | PM736335 |
| 15060000158181 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 7 | PA703534 | PM703549 |
| 15060000158182 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 8 | PA415462 | PM703628 |
| 15060000158183 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 9 | PA736172 | PM736415 |
| 15060000158184 | L15/dossiers | 15 | 15060000158174 | 15060000158174 | 10 | PA715745 | PM736297 |