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 |
|---|---|---|---|---|---|---|---|
| 17060000150167 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 3 | PA775180 | PM775466 |
| 17060000150168 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 4 | PA827904 | PM828514 |
| 17060000150169 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 5 | PA429845 | PM829729 |
| 17060000150170 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 6 | PA775214 | PM775498 |
| 17060000150171 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 7 | PA775224 | PM775512 |
| 17060000150172 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 8 | PA827946 | PM828614 |
| 17060000150173 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 9 | PA775252 | PM775558 |
| 17060000150174 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 10 | PA827968 | PM828750 |
| 17060000150175 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 11 | PA827978 | PM828730 |
| 17060000150176 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 12 | PA775272 | PM775562 |
| 17060000150177 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 13 | PA775282 | PM775584 |
| 17060000150178 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 14 | PA828000 | PM828850 |
| 17060000150179 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 15 | PA828004 | PM828838 |
| 17060000150180 | L17/dossiers | 17 | 17060000150164 | 17060000150164 | 16 | PA785857 | PM785867 |
| 17060000150187 | L17/dossiers | 17 | 17060000150186 | 17060000150186 | 1 | PA827960 | PM828664 |
| 17060000150194 | L17/dossiers | 17 | 17060000150193 | 17060000150193 | 1 | PA643210 | PM873637 |
| 17060000150220 | L17/dossiers | 17 | 17060000150219 | 17060000150219 | 1 | PA607553 | PM843059 |
| 17060000150236 | L17/dossiers | 17 | 17060000150235 | 17060000150235 | 1 | PA794778 | PM843239 |
| 17060000150243 | L17/dossiers | 17 | 17060000150242 | 17060000150242 | 1 | PA721474 | PM843608 |
| 17060000150256 | L17/dossiers | 17 | 17060000150255 | 17060000150255 | 1 | PA841769 | PM843323 |
| 17060000150260 | L17/dossiers | 17 | 17060000150259 | 17060000150259 | 1 | PA795778 | PM843509 |
| 17060000150267 | L17/dossiers | 17 | 17060000150266 | 17060000150266 | 1 | PA794750 | PM881146 |
| 17060000150271 | L17/dossiers | 17 | 17060000150270 | 17060000150270 | 1 | PA794146 | PM842912 |
| 17060000150278 | L17/dossiers | 17 | 17060000150277 | 17060000150277 | 1 | PA721474 | PM843608 |
| 17060000150285 | L17/dossiers | 17 | 17060000150284 | 17060000150284 | 1 | PA330008 | PM842366 |
| 17060000150292 | L17/dossiers | 17 | 17060000150291 | 17060000150291 | 1 | PA793708 | PM842525 |
| 17060000150299 | L17/dossiers | 17 | 17060000150298 | 17060000150298 | 1 | PA793322 | PM840246 |
| 17060000150306 | L17/dossiers | 17 | 17060000150305 | 17060000150305 | 1 | PA794198 | PM842876 |
| 17060000150313 | L17/dossiers | 17 | 17060000150312 | 17060000150312 | 1 | PA795844 | PM843515 |
| 17060000150320 | L17/dossiers | 17 | 17060000150319 | 17060000150319 | 1 | PA794322 | PM842942 |
| 17060000150327 | L17/dossiers | 17 | 17060000150326 | 17060000150326 | 1 | PA606545 | PM842729 |
| 17060000150334 | L17/dossiers | 17 | 17060000150333 | 17060000150333 | 1 | PA721486 | PM843614 |
| 17060000150347 | L17/dossiers | 17 | 17060000150346 | 17060000150346 | 1 | PA793736 | PM842693 |
| 17060000150354 | L17/dossiers | 17 | 17060000150353 | 17060000150353 | 1 | PA687214 | PM843686 |
| 17060000150361 | L17/dossiers | 17 | 17060000150360 | 17060000150360 | 1 | PA842013 | PM843563 |
| 17060000150368 | L17/dossiers | 17 | 17060000150367 | 17060000150367 | 1 | PA840889 | PM842534 |
| 17060000150375 | L17/dossiers | 17 | 17060000150374 | 17060000150374 | 1 | PA841665 | PM843227 |
| 17060000150382 | L17/dossiers | 17 | 17060000150381 | 17060000150381 | 1 | PA796018 | PM843425 |
| 17060000150389 | L17/dossiers | 17 | 17060000150388 | 17060000150388 | 1 | PA841351 | PM842936 |
| 17060000150396 | L17/dossiers | 17 | 17060000150395 | 17060000150395 | 1 | PA841151 | PM874938 |
| 17060000150403 | L17/dossiers | 17 | 17060000150402 | 17060000150402 | 1 | PA841665 | PM843227 |
| 17060000150410 | L17/dossiers | 17 | 17060000150409 | 17060000150409 | 1 | PA840135 | PM840330 |
| 17060000150417 | L17/dossiers | 17 | 17060000150416 | 17060000150416 | 1 | PA775216 | PM775522 |
| 17060000150430 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 1 | PA757676 | PM829801 |
| 17060000150431 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 2 | PA268007 | PM829695 |
| 17060000150432 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 3 | PA775172 | PM775474 |
| 17060000150433 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 4 | PA827898 | PM828454 |
| 17060000150434 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 5 | PA850008 | PM850016 |
| 17060000150435 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 6 | PA827912 | PM828488 |
| 17060000150436 | L17/dossiers | 17 | 17060000150429 | 17060000150429 | 7 | PA756685 | PM775777 |