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 |
|---|---|---|---|---|---|---|---|
| 15060000171080 | L15/dossiers | 15 | 15060000171077 | 15060000171077 | 3 | PA304002 | PM736326 |
| 15060000171081 | L15/dossiers | 15 | 15060000171077 | 15060000171077 | 4 | PA736225 | PM736334 |
| 15060000171088 | L15/dossiers | 15 | 15060000171087 | 15060000171087 | 1 | PA718894 | PM722494 |
| 15060000171092 | L15/dossiers | 15 | 15060000171091 | 15060000171091 | 1 | PA719946 | PM722808 |
| 15060000171096 | L15/dossiers | 15 | 15060000171095 | 15060000171095 | 1 | PA719946 | PM722808 |
| 15060000171100 | L15/dossiers | 15 | 15060000171099 | 15060000171099 | 1 | PA719946 | PM722808 |
| 15060000171104 | L15/dossiers | 15 | 15060000171103 | 15060000171103 | 1 | PA719946 | PM722808 |
| 15060000171108 | L15/dossiers | 15 | 15060000171107 | 15060000171107 | 1 | PA608416 | PM723540 |
| 15060000171112 | L15/dossiers | 15 | 15060000171111 | 15060000171111 | 1 | PA605036 | PM722444 |
| 15060000171121 | L15/dossiers | 15 | 15060000171120 | 15060000171120 | 1 | PA605036 | PM722444 |
| 15060000171129 | L15/dossiers | 15 | 15060000171128 | 15060000171128 | 1 | PA223837 | PM722458 |
| 15060000171133 | L15/dossiers | 15 | 15060000171132 | 15060000171132 | 1 | PA719464 | PM722670 |
| 15060000171140 | L15/dossiers | 15 | 15060000171139 | 15060000171139 | 1 | PA2116 | PM736339 |
| 15060000171147 | L15/dossiers | 15 | 15060000171146 | 15060000171146 | 1 | PA382672 | PM736263 |
| 15060000171154 | L15/dossiers | 15 | 15060000171153 | 15060000171153 | 1 | PA609590 | PM723326 |
| 15060000171158 | L15/dossiers | 15 | 15060000171157 | 15060000171157 | 1 | PA721046 | PM723154 |
| 15060000171165 | L15/dossiers | 15 | 15060000171164 | 15060000171164 | 1 | PA718868 | PM722484 |
| 15060000171172 | L15/dossiers | 15 | 15060000171171 | 15060000171171 | 1 | PA605036 | PM722444 |
| 15060000171179 | L15/dossiers | 15 | 15060000171178 | 15060000171178 | 1 | PA720870 | PM723100 |
| 15060000171186 | L15/dossiers | 15 | 15060000171185 | 15060000171185 | 1 | PA719946 | PM722808 |
| 15060000171193 | L15/dossiers | 15 | 15060000171192 | 15060000171192 | 1 | PA719946 | PM722808 |
| 15060000171200 | L15/dossiers | 15 | 15060000171199 | 15060000171199 | 1 | PA719946 | PM722808 |
| 15060000171207 | L15/dossiers | 15 | 15060000171206 | 15060000171206 | 1 | PA719946 | PM722808 |
| 15060000171214 | L15/dossiers | 15 | 15060000171213 | 15060000171213 | 1 | PA719946 | PM722808 |
| 15060000171221 | L15/dossiers | 15 | 15060000171220 | 15060000171220 | 1 | PA712014 | PM722984 |
| 15060000171228 | L15/dossiers | 15 | 15060000171227 | 15060000171227 | 1 | PA1327 | PM722762 |
| 15060000171235 | L15/dossiers | 15 | 15060000171234 | 15060000171234 | 1 | PA722202 | PM723502 |
| 15060000171239 | L15/dossiers | 15 | 15060000171238 | 15060000171238 | 1 | PA643089 | PM758076 |
| 15060000171246 | L15/dossiers | 15 | 15060000171245 | 15060000171245 | 1 | PA609590 | PM723326 |
| 15060000171250 | L15/dossiers | 15 | 15060000171249 | 15060000171249 | 1 | PA720892 | PM723106 |
| 15060000171257 | L15/dossiers | 15 | 15060000171256 | 15060000171256 | 1 | PA774956 | PM774979 |
| 15060000171264 | L15/dossiers | 15 | 15060000171263 | 15060000171263 | 1 | PA2377 | PM723550 |
| 15060000171271 | L15/dossiers | 15 | 15060000171270 | 15060000171270 | 1 | PA719946 | PM722808 |
| 15060000171278 | L15/dossiers | 15 | 15060000171277 | 15060000171277 | 1 | PA736229 | PM736389 |
| 15060000171285 | L15/dossiers | 15 | 15060000171284 | 15060000171284 | 1 | PA736229 | PM736389 |
| 15060000171292 | L15/dossiers | 15 | 15060000171291 | 15060000171291 | 1 | PA267318 | PM723260 |
| 15060000171299 | L15/dossiers | 15 | 15060000171298 | 15060000171298 | 1 | PA267318 | PM723260 |
| 15060000171306 | L15/dossiers | 15 | 15060000171305 | 15060000171305 | 1 | PA1206 | PM723354 |
| 15060000171313 | L15/dossiers | 15 | 15060000171312 | 15060000171312 | 1 | PA1327 | PM722762 |
| 15060000171320 | L15/dossiers | 15 | 15060000171319 | 15060000171319 | 1 | PA721888 | PM723412 |
| 15060000171327 | L15/dossiers | 15 | 15060000171326 | 15060000171326 | 1 | PA721832 | PM771998 |
| 15060000171334 | L15/dossiers | 15 | 15060000171333 | 15060000171333 | 1 | PA643089 | PM758076 |
| 15060000171341 | L15/dossiers | 15 | 15060000171340 | 15060000171340 | 1 | PA720538 | PM722994 |
| 15060000171353 | L15/dossiers | 15 | 15060000171352 | 15060000171352 | 1 | PA718926 | PM722502 |
| 15060000171357 | L15/dossiers | 15 | 15060000171356 | 15060000171356 | 1 | PA722142 | PM723484 |
| 15060000171361 | L15/dossiers | 15 | 15060000171360 | 15060000171360 | 1 | PA736167 | PM736327 |
| 15060000171362 | L15/dossiers | 15 | 15060000171360 | 15060000171360 | 2 | PA702993 | PM736362 |
| 15060000171363 | L15/dossiers | 15 | 15060000171360 | 15060000171360 | 3 | PA736191 | PM736336 |
| 15060000171364 | L15/dossiers | 15 | 15060000171360 | 15060000171360 | 4 | PA429855 | PM736425 |
| 15060000171365 | L15/dossiers | 15 | 15060000171360 | 15060000171360 | 5 | PA736219 | PM736387 |