dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 16060000115118 | L16/dossiers | 16 | 16060000115117 | 16060000115117 | 1 | PA736182 | PM736346 |
| 16060000115125 | L16/dossiers | 16 | 16060000115124 | 16060000115124 | 1 | PA736186 | PM736396 |
| 16060000115126 | L16/dossiers | 16 | 16060000115124 | 16060000115124 | 2 | PA415454 | PM785875 |
| 16060000115133 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 1 | PA719408 | PM775520 |
| 16060000115134 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 2 | PA2337 | PM775691 |
| 16060000115135 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 3 | PA736212 | PM736331 |
| 16060000115136 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 4 | PA760322 | PM775649 |
| 16060000115137 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 5 | PA721166 | PM785865 |
| 16060000115138 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 6 | PA736215 | PM736324 |
| 16060000115139 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 7 | PA266812 | PM736265 |
| 16060000115140 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 8 | PA703506 | PM777126 |
| 16060000115141 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 9 | PA429837 | PM736407 |
| 16060000115142 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 10 | PA736159 | PM736361 |
| 16060000115143 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 11 | PA775234 | PM775536 |
| 16060000115144 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 12 | PA736233 | PM736411 |
| 16060000115145 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 13 | PA736165 | PM736376 |
| 16060000115146 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 14 | PA736189 | PM736363 |
| 16060000115147 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 15 | PA429840 | PM736360 |
| 16060000115148 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 16 | PA415499 | PM775655 |
| 16060000115149 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 17 | PA775266 | PM775568 |
| 16060000115150 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 18 | PA736208 | PM736315 |
| 16060000115151 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 19 | PA775278 | PM775564 |
| 16060000115152 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 20 | PA303995 | PM775745 |
| 16060000115153 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 21 | PA736179 | PM736420 |
| 16060000115154 | L16/dossiers | 16 | 16060000115132 | 16060000115132 | 22 | PA703535 | PM793090 |
| 16060000115161 | L16/dossiers | 16 | 16060000115160 | 16060000115160 | 1 | PA721932 | PM797361 |
| 16060000115168 | L16/dossiers | 16 | 16060000115167 | 16060000115167 | 1 | PA775248 | PM775554 |
| 16060000115175 | L16/dossiers | 16 | 16060000115174 | 16060000115174 | 1 | PA793122 | PM796161 |
| 16060000115182 | L16/dossiers | 16 | 16060000115181 | 16060000115181 | 1 | PA794914 | PM797190 |
| 16060000115189 | L16/dossiers | 16 | 16060000115188 | 16060000115188 | 1 | PA605991 | PM796428 |
| 16060000115193 | L16/dossiers | 16 | 16060000115192 | 16060000115192 | 1 | PA793964 | PM796626 |
| 16060000115197 | L16/dossiers | 16 | 16060000115196 | 16060000115196 | 1 | PA346782 | PM797691 |
| 16060000115204 | L16/dossiers | 16 | 16060000115203 | 16060000115203 | 1 | PA720892 | PM797520 |
| 16060000115211 | L16/dossiers | 16 | 16060000115210 | 16060000115210 | 1 | PA794322 | PM796851 |
| 16060000115215 | L16/dossiers | 16 | 16060000115214 | 16060000115214 | 1 | PA346782 | PM797691 |
| 16060000115222 | L16/dossiers | 16 | 16060000115221 | 16060000115221 | 1 | PA775248 | PM775554 |
| 16060000115229 | L16/dossiers | 16 | 16060000115228 | 16060000115228 | 1 | PA794458 | PM796941 |
| 16060000115233 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 1 | PA736235 | PM775795 |
| 16060000115234 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 2 | PA775232 | PM775538 |
| 16060000115235 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 3 | PA775210 | PM775492 |
| 16060000115236 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 4 | PA703527 | PM775709 |
| 16060000115237 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 5 | PA775174 | PM775472 |
| 16060000115238 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 6 | PA775176 | PM775462 |
| 16060000115239 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 7 | PA736231 | PM736381 |
| 16060000115240 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 8 | PA736216 | PM736273 |
| 16060000115241 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 9 | PA775202 | PM775502 |
| 16060000115242 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 10 | PA736245 | PM775821 |
| 16060000115243 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 11 | PA736192 | PM736353 |
| 16060000115244 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 12 | PA775216 | PM775522 |
| 16060000115245 | L16/dossiers | 16 | 16060000115232 | 16060000115232 | 13 | PA775218 | PM775518 |