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 |
|---|---|---|---|---|---|---|---|
| 17060000147009 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 37 | PA605888 | PM775604 |
| 17060000147010 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 38 | PA607761 | PM828556 |
| 17060000147011 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 39 | PA415449 | PM775793 |
| 17060000147012 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 40 | PA342564 | PM829509 |
| 17060000147013 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 41 | PA268048 | PM829731 |
| 17060000147014 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 42 | PA2074 | PM775677 |
| 17060000147015 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 43 | PA873607 | PM873611 |
| 17060000147016 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 44 | PA775254 | PM775556 |
| 17060000147017 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 45 | PA775256 | PM775546 |
| 17060000147018 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 46 | PA703512 | PM775665 |
| 17060000147019 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 47 | PA643211 | PM775749 |
| 17060000147020 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 48 | PA610850 | PM828634 |
| 17060000147021 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 49 | PA827980 | PM828710 |
| 17060000147022 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 50 | PA827982 | PM828718 |
| 17060000147023 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 51 | PA775268 | PM775574 |
| 17060000147024 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 52 | PA606375 | PM775602 |
| 17060000147025 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 53 | PA703505 | PM775679 |
| 17060000147026 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 54 | PA703511 | PM775685 |
| 17060000147027 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 55 | PA827994 | PM828782 |
| 17060000147028 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 56 | PA643028 | PM829316 |
| 17060000147029 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 57 | PA429889 | PM829767 |
| 17060000147030 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 58 | PA775290 | PM775576 |
| 17060000147031 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 59 | PA736214 | PM829883 |
| 17060000147032 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 60 | PA736217 | PM829873 |
| 17060000147033 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 61 | PA828010 | PM828832 |
| 17060000147034 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 62 | PA775294 | PM775580 |
| 17060000147035 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 63 | PA828014 | PM828818 |
| 17060000147036 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 64 | PA828018 | PM828882 |
| 17060000147037 | L17/dossiers | 17 | 17060000146972 | 17060000146972 | 65 | PA828022 | PM828870 |
| 17060000147055 | L17/dossiers | 17 | 17060000147054 | 17060000147054 | 1 | PA775248 | PM775554 |
| 17060000147062 | L17/dossiers | 17 | 17060000147061 | 17060000147061 | 1 | PA842311 | PM843803 |
| 17060000147069 | L17/dossiers | 17 | 17060000147068 | 17060000147068 | 1 | PA610654 | PM843719 |
| 17060000147076 | L17/dossiers | 17 | 17060000147075 | 17060000147075 | 1 | PA796050 | PM840411 |
| 17060000147083 | L17/dossiers | 17 | 17060000147082 | 17060000147082 | 1 | PA330008 | PM842366 |
| 17060000147090 | L17/dossiers | 17 | 17060000147089 | 17060000147089 | 1 | PA840773 | PM842456 |
| 17060000147097 | L17/dossiers | 17 | 17060000147096 | 17060000147096 | 1 | PA840773 | PM842456 |
| 17060000147104 | L17/dossiers | 17 | 17060000147103 | 17060000147103 | 1 | PA794038 | PM874607 |
| 17060000147111 | L17/dossiers | 17 | 17060000147110 | 17060000147110 | 1 | PA840657 | PM842333 |
| 17060000147118 | L17/dossiers | 17 | 17060000147117 | 17060000147117 | 1 | PA840657 | PM842333 |
| 17060000147125 | L17/dossiers | 17 | 17060000147124 | 17060000147124 | 1 | PA840939 | PM842567 |
| 17060000147132 | L17/dossiers | 17 | 17060000147131 | 17060000147131 | 1 | PA794138 | PM842909 |
| 17060000147139 | L17/dossiers | 17 | 17060000147138 | 17060000147138 | 1 | PA267794 | PM842348 |
| 17060000147146 | L17/dossiers | 17 | 17060000147145 | 17060000147145 | 1 | PA608016 | PM874599 |
| 17060000147153 | L17/dossiers | 17 | 17060000147152 | 17060000147152 | 1 | PA719512 | PM842699 |
| 17060000147160 | L17/dossiers | 17 | 17060000147159 | 17060000147159 | 1 | PA793572 | PM842498 |
| 17060000147167 | L17/dossiers | 17 | 17060000147166 | 17060000147166 | 1 | PA840721 | PM842378 |
| 17060000147174 | L17/dossiers | 17 | 17060000147173 | 17060000147173 | 1 | PA718784 | PM842342 |
| 17060000147181 | L17/dossiers | 17 | 17060000147180 | 17060000147180 | 1 | PA718784 | PM842342 |
| 17060000147188 | L17/dossiers | 17 | 17060000147187 | 17060000147187 | 1 | PA841507 | PM843086 |
| 17060000147195 | L17/dossiers | 17 | 17060000147194 | 17060000147194 | 1 | PA794442 | PM840306 |