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 |
|---|---|---|---|---|---|---|---|
| 17060000145111 | L17/dossiers | 17 | 17060000145110 | 17060000145110 | 1 | PA794938 | PM843308 |
| 17060000145118 | L17/dossiers | 17 | 17060000145117 | 17060000145117 | 1 | PA793464 | PM840273 |
| 17060000145125 | L17/dossiers | 17 | 17060000145124 | 17060000145124 | 1 | PA793464 | PM840273 |
| 17060000145132 | L17/dossiers | 17 | 17060000145131 | 17060000145131 | 1 | PA719578 | PM842618 |
| 17060000145139 | L17/dossiers | 17 | 17060000145138 | 17060000145138 | 1 | PA267200 | PM843098 |
| 17060000145151 | L17/dossiers | 17 | 17060000145150 | 17060000145150 | 1 | PA793736 | PM842693 |
| 17060000145158 | L17/dossiers | 17 | 17060000145157 | 17060000145157 | 1 | PA342384 | PM842771 |
| 17060000145165 | L17/dossiers | 17 | 17060000145164 | 17060000145164 | 1 | PA793246 | PM842429 |
| 17060000145172 | L17/dossiers | 17 | 17060000145171 | 17060000145171 | 1 | PA794486 | PM843110 |
| 17060000145179 | L17/dossiers | 17 | 17060000145178 | 17060000145178 | 1 | PA840979 | PM842588 |
| 17060000145186 | L17/dossiers | 17 | 17060000145185 | 17060000145185 | 1 | PA841657 | PM843224 |
| 17060000145193 | L17/dossiers | 17 | 17060000145192 | 17060000145192 | 1 | PA342415 | PM842774 |
| 17060000145194 | L17/dossiers | 17 | 17060000145192 | 17060000145192 | 2 | PA720162 | PM843068 |
| 17060000145252 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 1 | PA429886 | PM829757 |
| 17060000145253 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 2 | PA757676 | PM829801 |
| 17060000145254 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 3 | PA775172 | PM775474 |
| 17060000145255 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 4 | PA827898 | PM828454 |
| 17060000145256 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 5 | PA850008 | PM850016 |
| 17060000145257 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 6 | PA827912 | PM828488 |
| 17060000145258 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 7 | PA756685 | PM775777 |
| 17060000145259 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 8 | PA827930 | PM828544 |
| 17060000145260 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 9 | PA268007 | PM829695 |
| 17060000145261 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 10 | PA736195 | PM829855 |
| 17060000145262 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 11 | PA736173 | PM829799 |
| 17060000145263 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 12 | PA775246 | PM775532 |
| 17060000145264 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 13 | PA827962 | PM828676 |
| 17060000145265 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 14 | PA736243 | PM829929 |
| 17060000145266 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 15 | PA736175 | PM829795 |
| 17060000145267 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 16 | PA828002 | PM828856 |
| 17060000145268 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 17 | PA775296 | PM775596 |
| 17060000145269 | L17/dossiers | 17 | 17060000145251 | 17060000145251 | 18 | PA828020 | PM828864 |
| 17060000145279 | L17/dossiers | 17 | 17060000145278 | 17060000145278 | 1 | PA703534 | PM775695 |
| 17060000145280 | L17/dossiers | 17 | 17060000145278 | 17060000145278 | 2 | PA827958 | PM828690 |
| 17060000145294 | L17/dossiers | 17 | 17060000145293 | 17060000145293 | 1 | PA827938 | PM828646 |
| 17060000145301 | L17/dossiers | 17 | 17060000145300 | 17060000145300 | 1 | PA775240 | PM775530 |
| 17060000145308 | L17/dossiers | 17 | 17060000145307 | 17060000145307 | 1 | PA841845 | PM843407 |
| 17060000145312 | L17/dossiers | 17 | 17060000145311 | 17060000145311 | 1 | PA382672 | PM829681 |
| 17060000145319 | L17/dossiers | 17 | 17060000145318 | 17060000145318 | 1 | PA763158 | PM775683 |
| 17060000145320 | L17/dossiers | 17 | 17060000145318 | 17060000145318 | 2 | PA708632 | PM775667 |
| 17060000145327 | L17/dossiers | 17 | 17060000145326 | 17060000145326 | 1 | PA827966 | PM828658 |
| 17060000145345 | L17/dossiers | 17 | 17060000145344 | 17060000145344 | 1 | PA608016 | PM874599 |
| 17060000145352 | L17/dossiers | 17 | 17060000145351 | 17060000145351 | 1 | PA330240 | PM842357 |
| 17060000145356 | L17/dossiers | 17 | 17060000145355 | 17060000145355 | 1 | PA795310 | PM840453 |
| 17060000145360 | L17/dossiers | 17 | 17060000145359 | 17060000145359 | 1 | PA643210 | PM873637 |
| 17060000145371 | L17/dossiers | 17 | 17060000145370 | 17060000145370 | 1 | PA719578 | PM842618 |
| 17060000145381 | L17/dossiers | 17 | 17060000145380 | 17060000145380 | 1 | PA643210 | PM873637 |
| 17060000145413 | L17/dossiers | 17 | 17060000145412 | 17060000145412 | 1 | PA775300 | PM775600 |
| 17060000145420 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 1 | PA756685 | PM775777 |
| 17060000145421 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 2 | PA757676 | PM829801 |
| 17060000145422 | L17/dossiers | 17 | 17060000145419 | 17060000145419 | 3 | PA429886 | PM829757 |