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 |
|---|---|---|---|---|---|---|---|
| 15060000157170 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 6 | PA267340 | PM703713 |
| 15060000157171 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 7 | PA1001 | PM736371 |
| 15060000157172 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 8 | PA703539 | PM703693 |
| 15060000157173 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 9 | PA736218 | PM736257 |
| 15060000157174 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 10 | PA429875 | PM736302 |
| 15060000157175 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 11 | PA394676 | PM703550 |
| 15060000157176 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 12 | PA736246 | PM736428 |
| 15060000157177 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 13 | PA415451 | PM703594 |
| 15060000157178 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 14 | PA703507 | PM703567 |
| 15060000157179 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 15 | PA304108 | PM736399 |
| 15060000157180 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 16 | PA1993 | PM736402 |
| 15060000157181 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 17 | PA703517 | PM703625 |
| 15060000157182 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 18 | PA343988 | PM736310 |
| 15060000157183 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 19 | PA267328 | PM703547 |
| 15060000157184 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 20 | PA267018 | PM703564 |
| 15060000157185 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 21 | PA429874 | PM736314 |
| 15060000157186 | L15/dossiers | 15 | 15060000157164 | 15060000157164 | 22 | PA703527 | PM703580 |
| 15060000157193 | L15/dossiers | 15 | 15060000157192 | 15060000157192 | 1 | PA415446 | PM703678 |
| 15060000157200 | L15/dossiers | 15 | 15060000157199 | 15060000157199 | 1 | PA266867 | PM703554 |
| 15060000157219 | L15/dossiers | 15 | 15060000157218 | 15060000157218 | 1 | PA736192 | PM736353 |
| 15060000157226 | L15/dossiers | 15 | 15060000157225 | 15060000157225 | 1 | PA267728 | PM736277 |
| 15060000157233 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 1 | PA678263 | PM736330 |
| 15060000157234 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 2 | PA429886 | PM736385 |
| 15060000157235 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 3 | PA304082 | PM736354 |
| 15060000157236 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 4 | PA429891 | PM736329 |
| 15060000157237 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 5 | PA304071 | PM703676 |
| 15060000157238 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 6 | PA429894 | PM736364 |
| 15060000157239 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 7 | PA429836 | PM736345 |
| 15060000157240 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 8 | PA736195 | PM736357 |
| 15060000157241 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 9 | PA736177 | PM736318 |
| 15060000157242 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 10 | PA736173 | PM736369 |
| 15060000157243 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 11 | PA736243 | PM736413 |
| 15060000157244 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 12 | PA703499 | PM703641 |
| 15060000157245 | L15/dossiers | 15 | 15060000157232 | 15060000157232 | 13 | PA736175 | PM736344 |
| 15060000157252 | L15/dossiers | 15 | 15060000157251 | 15060000157251 | 1 | PA2116 | PM736339 |
| 15060000157259 | L15/dossiers | 15 | 15060000157258 | 15060000157258 | 1 | PA415476 | PM703653 |
| 15060000157260 | L15/dossiers | 15 | 15060000157258 | 15060000157258 | 2 | PA736230 | PM736377 |
| 15060000157261 | L15/dossiers | 15 | 15060000157258 | 15060000157258 | 3 | PA703501 | PM703629 |
| 15060000157262 | L15/dossiers | 15 | 15060000157258 | 15060000157258 | 4 | PA415486 | PM703623 |
| 15060000157263 | L15/dossiers | 15 | 15060000157258 | 15060000157258 | 5 | PA227029 | PM736306 |
| 15060000157264 | L15/dossiers | 15 | 15060000157258 | 15060000157258 | 6 | PA703514 | PM703585 |
| 15060000157271 | L15/dossiers | 15 | 15060000157270 | 15060000157270 | 1 | PA227029 | PM736306 |
| 15060000157278 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 1 | PA736206 | PM736351 |
| 15060000157279 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 2 | PA227089 | PM736372 |
| 15060000157280 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 3 | PA227098 | PM736321 |
| 15060000157281 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 4 | PA736204 | PM736338 |
| 15060000157282 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 5 | PA703514 | PM703585 |
| 15060000157283 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 6 | PA267762 | PM736366 |
| 15060000157284 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 7 | PA736230 | PM736377 |
| 15060000157285 | L15/dossiers | 15 | 15060000157277 | 15060000157277 | 8 | PA304108 | PM736399 |