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 |
|---|---|---|---|---|---|---|---|
| 17060000126125 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 4 | PA827900 | PM828434 |
| 17060000126126 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 5 | PA827902 | PM828442 |
| 17060000126127 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 6 | PA827916 | PM828476 |
| 17060000126128 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 7 | PA304085 | PM829871 |
| 17060000126129 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 8 | PA607489 | PM829715 |
| 17060000126130 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 9 | PA827930 | PM828544 |
| 17060000126131 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 10 | PA267340 | PM775731 |
| 17060000126132 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 11 | PA267241 | PM778080 |
| 17060000126133 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 12 | PA736169 | PM829791 |
| 17060000126134 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 13 | PA267673 | PM775865 |
| 17060000126135 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 14 | PA267387 | PM832620 |
| 17060000126136 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 15 | PA736206 | PM829849 |
| 17060000126137 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 16 | PA703509 | PM775687 |
| 17060000126138 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 17 | PA775244 | PM775534 |
| 17060000126139 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 18 | PA415447 | PM775785 |
| 17060000126140 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 19 | PA703537 | PM775721 |
| 17060000126141 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 20 | PA268048 | PM829731 |
| 17060000126142 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 21 | PA736185 | PM829813 |
| 17060000126143 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 22 | PA827968 | PM828750 |
| 17060000126144 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 23 | PA2197 | PM775755 |
| 17060000126145 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 24 | PA827972 | PM828738 |
| 17060000126146 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 25 | PA827974 | PM828744 |
| 17060000126147 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 26 | PA827980 | PM828710 |
| 17060000126148 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 27 | PA415499 | PM775655 |
| 17060000126149 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 28 | PA827984 | PM828800 |
| 17060000126150 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 29 | PA747422 | PM775753 |
| 17060000126151 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 30 | PA775264 | PM775570 |
| 17060000126152 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 31 | PA775266 | PM775568 |
| 17060000126153 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 32 | PA775278 | PM775564 |
| 17060000126154 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 33 | PA775288 | PM775578 |
| 17060000126155 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 34 | PA736214 | PM829883 |
| 17060000126156 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 35 | PA707706 | PM775741 |
| 17060000126157 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 36 | PA736179 | PM829833 |
| 17060000126158 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 37 | PA775300 | PM775600 |
| 17060000126159 | L17/dossiers | 17 | 17060000126121 | 17060000126121 | 38 | PA828020 | PM828864 |
| 17060000126177 | L17/dossiers | 17 | 17060000126176 | 17060000126176 | 1 | PA368 | PM847741 |
| 17060000126187 | L17/dossiers | 17 | 17060000126186 | 17060000126186 | 1 | PA775270 | PM775572 |
| 17060000126194 | L17/dossiers | 17 | 17060000126193 | 17060000126193 | 1 | PA775178 | PM775460 |
| 17060000126201 | L17/dossiers | 17 | 17060000126200 | 17060000126200 | 1 | PA796070 | PM843746 |
| 17060000126205 | L17/dossiers | 17 | 17060000126204 | 17060000126204 | 1 | PA793756 | PM840282 |
| 17060000126212 | L17/dossiers | 17 | 17060000126211 | 17060000126211 | 1 | PA841207 | PM842798 |
| 17060000126219 | L17/dossiers | 17 | 17060000126218 | 17060000126218 | 1 | PA330240 | PM842357 |
| 17060000126226 | L17/dossiers | 17 | 17060000126225 | 17060000126225 | 1 | PA309643 | PM843545 |
| 17060000126233 | L17/dossiers | 17 | 17060000126232 | 17060000126232 | 1 | PA840979 | PM842588 |
| 17060000126240 | L17/dossiers | 17 | 17060000126239 | 17060000126239 | 1 | PA840979 | PM842588 |
| 17060000126247 | L17/dossiers | 17 | 17060000126246 | 17060000126246 | 1 | PA720154 | PM842852 |
| 17060000126300 | L17/dossiers | 17 | 17060000126299 | 17060000126299 | 1 | PA793780 | PM842714 |
| 17060000126307 | L17/dossiers | 17 | 17060000126306 | 17060000126306 | 1 | PA721960 | PM840378 |
| 17060000126314 | L17/dossiers | 17 | 17060000126313 | 17060000126313 | 1 | PA330008 | PM842366 |
| 17060000126321 | L17/dossiers | 17 | 17060000126320 | 17060000126320 | 1 | PA794502 | PM840324 |