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 |
|---|---|---|---|---|---|---|---|
| 17060000149002 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 46 | PA736191 | PM829819 |
| 17060000149003 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 47 | PA708633 | PM775669 |
| 17060000149004 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 48 | PA415477 | PM775809 |
| 17060000149005 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 49 | PA415477 | PM775809 |
| 17060000149006 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 50 | PA766947 | PM775799 |
| 17060000149007 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 51 | PA703509 | PM775687 |
| 17060000149008 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 52 | PA736181 | PM829839 |
| 17060000149009 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 53 | PA703536 | PM775719 |
| 17060000149010 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 54 | PA415449 | PM775793 |
| 17060000149011 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 55 | PA2074 | PM775677 |
| 17060000149012 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 56 | PA775254 | PM775556 |
| 17060000149013 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 57 | PA775256 | PM775546 |
| 17060000149014 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 58 | PA703512 | PM775665 |
| 17060000149015 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 59 | PA643211 | PM775749 |
| 17060000149016 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 60 | PA775268 | PM775574 |
| 17060000149017 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 61 | PA703505 | PM775679 |
| 17060000149018 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 62 | PA775274 | PM775560 |
| 17060000149019 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 63 | PA429889 | PM829767 |
| 17060000149020 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 64 | PA429889 | PM829767 |
| 17060000149021 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 65 | PA775290 | PM775576 |
| 17060000149022 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 66 | PA736214 | PM829883 |
| 17060000149023 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 67 | PA828010 | PM828832 |
| 17060000149024 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 68 | PA775294 | PM775580 |
| 17060000149025 | L17/dossiers | 17 | 17060000148956 | 17060000148956 | 69 | PA828014 | PM828818 |
| 17060000149032 | L17/dossiers | 17 | 17060000149031 | 17060000149031 | 1 | PA643210 | PM873637 |
| 17060000149033 | L17/dossiers | 17 | 17060000149031 | 17060000149031 | 2 | PA870010 | PM873706 |
| 17060000149110 | L17/dossiers | 17 | 17060000149109 | 17060000149109 | 1 | PA795808 | PM843644 |
| 17060000149117 | L17/dossiers | 17 | 17060000149116 | 17060000149116 | 1 | PA774958 | PM843389 |
| 17060000149131 | L17/dossiers | 17 | 17060000149130 | 17060000149130 | 1 | PA268048 | PM829731 |
| 17060000149138 | L17/dossiers | 17 | 17060000149137 | 17060000149137 | 1 | PA268048 | PM829731 |
| 17060000149145 | L17/dossiers | 17 | 17060000149144 | 17060000149144 | 1 | PA702992 | PM717139 |
| 17060000149146 | L17/dossiers | 17 | 17060000149144 | 17060000149144 | 2 | PA266795 | PM873694 |
| 17060000149177 | L17/dossiers | 17 | 17060000149176 | 17060000149176 | 1 | PA795808 | PM843644 |
| 17060000149191 | L17/dossiers | 17 | 17060000149190 | 17060000149190 | 1 | PA709298 | PM775773 |
| 17060000149201 | L17/dossiers | 17 | 17060000149200 | 17060000149200 | 1 | PA795410 | PM843440 |
| 17060000149208 | L17/dossiers | 17 | 17060000149207 | 17060000149207 | 1 | PA841717 | PM843278 |
| 17060000149215 | L17/dossiers | 17 | 17060000149214 | 17060000149214 | 1 | PA719024 | PM842390 |
| 17060000149222 | L17/dossiers | 17 | 17060000149221 | 17060000149221 | 1 | PA793322 | PM840246 |
| 17060000149229 | L17/dossiers | 17 | 17060000149228 | 17060000149228 | 1 | PA721896 | PM840405 |
| 17060000149240 | L17/dossiers | 17 | 17060000149239 | 17060000149239 | 1 | PA794486 | PM843110 |
| 17060000149265 | L17/dossiers | 17 | 17060000149264 | 17060000149264 | 1 | PA331973 | PM842624 |
| 17060000149272 | L17/dossiers | 17 | 17060000149271 | 17060000149271 | 1 | PA720838 | PM843671 |
| 17060000149295 | L17/dossiers | 17 | 17060000149294 | 17060000149294 | 1 | PA795164 | PM840444 |
| 17060000149302 | L17/dossiers | 17 | 17060000149301 | 17060000149301 | 1 | PA794198 | PM842876 |
| 17060000149309 | L17/dossiers | 17 | 17060000149308 | 17060000149308 | 1 | PA719558 | PM842663 |
| 17060000149316 | L17/dossiers | 17 | 17060000149315 | 17060000149315 | 1 | PA842121 | PM874932 |
| 17060000149323 | L17/dossiers | 17 | 17060000149322 | 17060000149322 | 1 | PA842121 | PM874932 |
| 17060000149330 | L17/dossiers | 17 | 17060000149329 | 17060000149329 | 1 | PA793736 | PM842693 |
| 17060000149337 | L17/dossiers | 17 | 17060000149336 | 17060000149336 | 1 | PA842121 | PM874932 |
| 17060000149344 | L17/dossiers | 17 | 17060000149343 | 17060000149343 | 1 | PA718884 | PM842420 |