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 |
|---|---|---|---|---|---|---|---|
| 17060000139149 | L17/dossiers | 17 | 17060000139140 | 17060000139140 | 9 | PA643028 | PM829316 |
| 17060000139150 | L17/dossiers | 17 | 17060000139140 | 17060000139140 | 10 | PA828022 | PM828870 |
| 17060000139160 | L17/dossiers | 17 | 17060000139159 | 17060000139159 | 1 | PA382672 | PM829681 |
| 17060000139161 | L17/dossiers | 17 | 17060000139159 | 17060000139159 | 2 | PA827934 | PM828532 |
| 17060000139168 | L17/dossiers | 17 | 17060000139167 | 17060000139167 | 1 | PA795808 | PM843644 |
| 17060000139180 | L17/dossiers | 17 | 17060000139179 | 17060000139179 | 1 | PA267340 | PM775731 |
| 17060000139181 | L17/dossiers | 17 | 17060000139179 | 17060000139179 | 2 | PA702993 | PM829493 |
| 17060000139182 | L17/dossiers | 17 | 17060000139179 | 17060000139179 | 3 | PA429832 | PM829723 |
| 17060000139183 | L17/dossiers | 17 | 17060000139179 | 17060000139179 | 4 | PA2042 | PM775815 |
| 17060000139184 | L17/dossiers | 17 | 17060000139179 | 17060000139179 | 5 | PA2337 | PM775691 |
| 17060000139185 | L17/dossiers | 17 | 17060000139179 | 17060000139179 | 6 | PA736190 | PM829825 |
| 17060000139240 | L17/dossiers | 17 | 17060000139239 | 17060000139239 | 1 | PA382672 | PM829681 |
| 17060000139247 | L17/dossiers | 17 | 17060000139246 | 17060000139246 | 1 | PA784534 | PM784544 |
| 17060000139254 | L17/dossiers | 17 | 17060000139253 | 17060000139253 | 1 | PA775268 | PM775574 |
| 17060000139261 | L17/dossiers | 17 | 17060000139260 | 17060000139260 | 1 | PA785855 | PM785869 |
| 17060000139268 | L17/dossiers | 17 | 17060000139267 | 17060000139267 | 1 | PA410 | PM855580 |
| 17060000139275 | L17/dossiers | 17 | 17060000139274 | 17060000139274 | 1 | PA841183 | PM842786 |
| 17060000139282 | L17/dossiers | 17 | 17060000139281 | 17060000139281 | 1 | PA794658 | PM843164 |
| 17060000139286 | L17/dossiers | 17 | 17060000139285 | 17060000139285 | 1 | PA794658 | PM843164 |
| 17060000139290 | L17/dossiers | 17 | 17060000139289 | 17060000139289 | 1 | PA827894 | PM828460 |
| 17060000139297 | L17/dossiers | 17 | 17060000139296 | 17060000139296 | 1 | PA382672 | PM829681 |
| 17060000139298 | L17/dossiers | 17 | 17060000139296 | 17060000139296 | 2 | PA827934 | PM828532 |
| 17060000139317 | L17/dossiers | 17 | 17060000139316 | 17060000139316 | 1 | PA718784 | PM842342 |
| 17060000139325 | L17/dossiers | 17 | 17060000139324 | 17060000139324 | 1 | PA794058 | PM842861 |
| 17060000139329 | L17/dossiers | 17 | 17060000139328 | 17060000139328 | 1 | PA841419 | PM843005 |
| 17060000139333 | L17/dossiers | 17 | 17060000139332 | 17060000139332 | 1 | PA793464 | PM840273 |
| 17060000139340 | L17/dossiers | 17 | 17060000139339 | 17060000139339 | 1 | PA794906 | PM843284 |
| 17060000139355 | L17/dossiers | 17 | 17060000139354 | 17060000139354 | 1 | PA608264 | PM843179 |
| 17060000139372 | L17/dossiers | 17 | 17060000139371 | 17060000139371 | 1 | PA796018 | PM843425 |
| 17060000139376 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 1 | PA720892 | PM840420 |
| 17060000139377 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 2 | PA795228 | PM840447 |
| 17060000139378 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 3 | PA793262 | PM842438 |
| 17060000139379 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 4 | PA794906 | PM843284 |
| 17060000139380 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 5 | PA794138 | PM842909 |
| 17060000139381 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 6 | PA795588 | PM843557 |
| 17060000139382 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 7 | PA793780 | PM842714 |
| 17060000139383 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 8 | PA795084 | PM840369 |
| 17060000139384 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 9 | PA842105 | PM843626 |
| 17060000139385 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 10 | PA588884 | PM840450 |
| 17060000139386 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 11 | PA841657 | PM843224 |
| 17060000139387 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 12 | PA720430 | PM843092 |
| 17060000139388 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 13 | PA793772 | PM842708 |
| 17060000139389 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 14 | PA795616 | PM840462 |
| 17060000139390 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 15 | PA793444 | PM840270 |
| 17060000139391 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 16 | PA794938 | PM843308 |
| 17060000139392 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 17 | PA795318 | PM843689 |
| 17060000139393 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 18 | PA841023 | PM842645 |
| 17060000139394 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 19 | PA796090 | PM840372 |
| 17060000139395 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 20 | PA793912 | PM842795 |
| 17060000139396 | L17/dossiers | 17 | 17060000139375 | 17060000139375 | 21 | PA795868 | PM843722 |