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 |
|---|---|---|---|---|---|---|---|
| 17060000142036 | L17/dossiers | 17 | 17060000142035 | 17060000142035 | 1 | PA331973 | PM842624 |
| 17060000142043 | L17/dossiers | 17 | 17060000142042 | 17060000142042 | 1 | PA840171 | PM840360 |
| 17060000142065 | L17/dossiers | 17 | 17060000142064 | 17060000142064 | 1 | PA330240 | PM842357 |
| 17060000142072 | L17/dossiers | 17 | 17060000142071 | 17060000142071 | 1 | PA841091 | PM842705 |
| 17060000142095 | L17/dossiers | 17 | 17060000142094 | 17060000142094 | 1 | PA841539 | PM843119 |
| 17060000142102 | L17/dossiers | 17 | 17060000142101 | 17060000142101 | 1 | PA342415 | PM842774 |
| 17060000142110 | L17/dossiers | 17 | 17060000142109 | 17060000142109 | 1 | PA841701 | PM843269 |
| 17060000142117 | L17/dossiers | 17 | 17060000142116 | 17060000142116 | 1 | PA841893 | PM843449 |
| 17060000142124 | L17/dossiers | 17 | 17060000142123 | 17060000142123 | 1 | PA643157 | PM843728 |
| 17060000142147 | L17/dossiers | 17 | 17060000142146 | 17060000142146 | 1 | PA841295 | PM842882 |
| 17060000142160 | L17/dossiers | 17 | 17060000142159 | 17060000142159 | 1 | PA719282 | PM858574 |
| 17060000142167 | L17/dossiers | 17 | 17060000142166 | 17060000142166 | 1 | PA841853 | PM843413 |
| 17060000142174 | L17/dossiers | 17 | 17060000142173 | 17060000142173 | 1 | PA720992 | PM843710 |
| 17060000142181 | L17/dossiers | 17 | 17060000142180 | 17060000142180 | 1 | PA841315 | PM842906 |
| 17060000142188 | L17/dossiers | 17 | 17060000142187 | 17060000142187 | 1 | PA720362 | PM843011 |
| 17060000142195 | L17/dossiers | 17 | 17060000142194 | 17060000142194 | 1 | PA795136 | PM843353 |
| 17060000142202 | L17/dossiers | 17 | 17060000142201 | 17060000142201 | 1 | PA841717 | PM843278 |
| 17060000142209 | L17/dossiers | 17 | 17060000142208 | 17060000142208 | 1 | PA840829 | PM842492 |
| 17060000142232 | L17/dossiers | 17 | 17060000142231 | 17060000142231 | 1 | PA793816 | PM842657 |
| 17060000142240 | L17/dossiers | 17 | 17060000142239 | 17060000142239 | 1 | PA794854 | PM843263 |
| 17060000142263 | L17/dossiers | 17 | 17060000142262 | 17060000142262 | 1 | PA841381 | PM842966 |
| 17060000142270 | L17/dossiers | 17 | 17060000142269 | 17060000142269 | 1 | PA842195 | PM843707 |
| 17060000142277 | L17/dossiers | 17 | 17060000142276 | 17060000142276 | 1 | PA842195 | PM843707 |
| 17060000142284 | L17/dossiers | 17 | 17060000142283 | 17060000142283 | 1 | PA720892 | PM840420 |
| 17060000142292 | L17/dossiers | 17 | 17060000142291 | 17060000142291 | 1 | PA720892 | PM840420 |
| 17060000142296 | L17/dossiers | 17 | 17060000142295 | 17060000142295 | 1 | PA643210 | PM873637 |
| 17060000142297 | L17/dossiers | 17 | 17060000142295 | 17060000142295 | 2 | PA721836 | PM873664 |
| 17060000142323 | L17/dossiers | 17 | 17060000142322 | 17060000142322 | 1 | PA643089 | PM858443 |
| 17060000142330 | L17/dossiers | 17 | 17060000142329 | 17060000142329 | 1 | PA342384 | PM842771 |
| 17060000142337 | L17/dossiers | 17 | 17060000142336 | 17060000142336 | 1 | PA774962 | PM843731 |
| 17060000142344 | L17/dossiers | 17 | 17060000142343 | 17060000142343 | 1 | PA643210 | PM873637 |
| 17060000142372 | L17/dossiers | 17 | 17060000142371 | 17060000142371 | 1 | PA643210 | PM873637 |
| 17060000142402 | L17/dossiers | 17 | 17060000142401 | 17060000142401 | 1 | PA267241 | PM778080 |
| 17060000142409 | L17/dossiers | 17 | 17060000142408 | 17060000142408 | 1 | PA736228 | PM829925 |
| 17060000142416 | L17/dossiers | 17 | 17060000142415 | 17060000142415 | 1 | PA775276 | PM775566 |
| 17060000142435 | L17/dossiers | 17 | 17060000142434 | 17060000142434 | 1 | PA736188 | PM829827 |
| 17060000142442 | L17/dossiers | 17 | 17060000142441 | 17060000142441 | 1 | PA267241 | PM778080 |
| 17060000142449 | L17/dossiers | 17 | 17060000142448 | 17060000142448 | 1 | PA267241 | PM778080 |
| 17060000142456 | L17/dossiers | 17 | 17060000142455 | 17060000142455 | 1 | PA313924 | PM775727 |
| 17060000142463 | L17/dossiers | 17 | 17060000142462 | 17060000142462 | 1 | PA775248 | PM775554 |
| 17060000142470 | L17/dossiers | 17 | 17060000142469 | 17060000142469 | 1 | PA719922 | PM842867 |
| 17060000142474 | L17/dossiers | 17 | 17060000142473 | 17060000142473 | 1 | PA736225 | PM829907 |
| 17060000142475 | L17/dossiers | 17 | 17060000142473 | 17060000142473 | 2 | PA827904 | PM828514 |
| 17060000142482 | L17/dossiers | 17 | 17060000142481 | 17060000142481 | 1 | PA827904 | PM828514 |
| 17060000142483 | L17/dossiers | 17 | 17060000142481 | 17060000142481 | 2 | PA736225 | PM829907 |
| 17060000142503 | L17/dossiers | 17 | 17060000142502 | 17060000142502 | 1 | PA720038 | PM842921 |
| 17060000142511 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 1 | PA736177 | PM829835 |
| 17060000142512 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 2 | PA775282 | PM775584 |
| 17060000142513 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 3 | PA827946 | PM828614 |
| 17060000142514 | L17/dossiers | 17 | 17060000142510 | 17060000142510 | 4 | PA827950 | PM828598 |