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 |
|---|---|---|---|---|---|---|---|
| 17060000122038 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 17 | PA775296 | PM775596 |
| 17060000122039 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 18 | PA828020 | PM828864 |
| 17060000122049 | L17/dossiers | 17 | 17060000122048 | 17060000122048 | 1 | PA702993 | PM829493 |
| 17060000122050 | L17/dossiers | 17 | 17060000122048 | 17060000122048 | 2 | PA610850 | PM828634 |
| 17060000122051 | L17/dossiers | 17 | 17060000122048 | 17060000122048 | 3 | PA736219 | PM829867 |
| 17060000122052 | L17/dossiers | 17 | 17060000122048 | 17060000122048 | 4 | PA736214 | PM829883 |
| 17060000122089 | L17/dossiers | 17 | 17060000122088 | 17060000122088 | 1 | PA795778 | PM843509 |
| 17060000122093 | L17/dossiers | 17 | 17060000122092 | 17060000122092 | 1 | PA793664 | PM842549 |
| 17060000122101 | L17/dossiers | 17 | 17060000122100 | 17060000122100 | 1 | PA794322 | PM842942 |
| 17060000122128 | L17/dossiers | 17 | 17060000122127 | 17060000122127 | 1 | PA841893 | PM843449 |
| 17060000122137 | L17/dossiers | 17 | 17060000122136 | 17060000122136 | 1 | PA791824 | PM840375 |
| 17060000122144 | L17/dossiers | 17 | 17060000122143 | 17060000122143 | 1 | PA607553 | PM843059 |
| 17060000122168 | L17/dossiers | 17 | 17060000122167 | 17060000122167 | 1 | PA736229 | PM829923 |
| 17060000122178 | L17/dossiers | 17 | 17060000122177 | 17060000122177 | 1 | PA721896 | PM840405 |
| 17060000122185 | L17/dossiers | 17 | 17060000122184 | 17060000122184 | 1 | PA795636 | PM843476 |
| 17060000122192 | L17/dossiers | 17 | 17060000122191 | 17060000122191 | 1 | PA795588 | PM843557 |
| 17060000122199 | L17/dossiers | 17 | 17060000122198 | 17060000122198 | 1 | PA313924 | PM775727 |
| 17060000122213 | L17/dossiers | 17 | 17060000122212 | 17060000122212 | 1 | PA793342 | PM842345 |
| 17060000122217 | L17/dossiers | 17 | 17060000122216 | 17060000122216 | 1 | PA266797 | PM843071 |
| 17060000122221 | L17/dossiers | 17 | 17060000122220 | 17060000122220 | 1 | PA793532 | PM842591 |
| 17060000122225 | L17/dossiers | 17 | 17060000122224 | 17060000122224 | 1 | PA796078 | PM840459 |
| 17060000122232 | L17/dossiers | 17 | 17060000122231 | 17060000122231 | 1 | PA795982 | PM840432 |
| 17060000122239 | L17/dossiers | 17 | 17060000122238 | 17060000122238 | 1 | PA775294 | PM775580 |
| 17060000122246 | L17/dossiers | 17 | 17060000122245 | 17060000122245 | 1 | PA721816 | PM843551 |
| 17060000122250 | L17/dossiers | 17 | 17060000122249 | 17060000122249 | 1 | PA721816 | PM843551 |
| 17060000122254 | L17/dossiers | 17 | 17060000122253 | 17060000122253 | 1 | PA368 | PM847741 |
| 17060000122255 | L17/dossiers | 17 | 17060000122253 | 17060000122253 | 2 | PA795144 | PM847769 |
| 17060000122262 | L17/dossiers | 17 | 17060000122261 | 17060000122261 | 1 | PA775260 | PM775550 |
| 17060000122275 | L17/dossiers | 17 | 17060000122274 | 17060000122274 | 1 | PA841587 | PM843149 |
| 17060000122282 | L17/dossiers | 17 | 17060000122281 | 17060000122281 | 1 | PA841769 | PM843323 |
| 17060000122286 | L17/dossiers | 17 | 17060000122285 | 17060000122285 | 1 | PA841769 | PM843323 |
| 17060000122293 | L17/dossiers | 17 | 17060000122292 | 17060000122292 | 1 | PA795912 | PM840402 |
| 17060000122297 | L17/dossiers | 17 | 17060000122296 | 17060000122296 | 1 | PA720430 | PM843092 |
| 17060000122304 | L17/dossiers | 17 | 17060000122303 | 17060000122303 | 1 | PA775248 | PM775554 |
| 17060000122311 | L17/dossiers | 17 | 17060000122310 | 17060000122310 | 1 | PA304017 | PM775757 |
| 17060000122312 | L17/dossiers | 17 | 17060000122310 | 17060000122310 | 2 | PA736243 | PM829929 |
| 17060000122313 | L17/dossiers | 17 | 17060000122310 | 17060000122310 | 3 | PA736216 | PM829875 |
| 17060000122343 | L17/dossiers | 17 | 17060000122342 | 17060000122342 | 1 | PA775284 | PM775590 |
| 17060000122357 | L17/dossiers | 17 | 17060000122356 | 17060000122356 | 1 | PA795240 | PM843785 |
| 17060000122368 | L17/dossiers | 17 | 17060000122367 | 17060000122367 | 1 | PA722142 | PM843500 |
| 17060000122381 | L17/dossiers | 17 | 17060000122380 | 17060000122380 | 1 | PA720846 | PM840441 |
| 17060000122388 | L17/dossiers | 17 | 17060000122387 | 17060000122387 | 1 | PA841439 | PM843023 |
| 17060000122392 | L17/dossiers | 17 | 17060000122391 | 17060000122391 | 1 | PA793298 | PM842360 |
| 17060000122399 | L17/dossiers | 17 | 17060000122398 | 17060000122398 | 1 | PA775178 | PM775460 |
| 17060000122400 | L17/dossiers | 17 | 17060000122398 | 17060000122398 | 2 | PA736229 | PM829923 |
| 17060000122401 | L17/dossiers | 17 | 17060000122398 | 17060000122398 | 3 | PA736166 | PM775765 |
| 17060000122402 | L17/dossiers | 17 | 17060000122398 | 17060000122398 | 4 | PA736208 | PM829881 |
| 17060000122409 | L17/dossiers | 17 | 17060000122408 | 17060000122408 | 1 | PA775178 | PM775460 |
| 17060000122410 | L17/dossiers | 17 | 17060000122408 | 17060000122408 | 2 | PA736229 | PM829923 |
| 17060000122411 | L17/dossiers | 17 | 17060000122408 | 17060000122408 | 3 | PA736166 | PM775765 |