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 |
|---|---|---|---|---|---|---|---|
| 15060000188229 | L15/dossiers | 15 | 15060000188228 | 15060000188228 | 1 | PA775258 | PM775544 |
| 15060000188230 | L15/dossiers | 15 | 15060000188228 | 15060000188228 | 2 | PA426327 | PM775735 |
| 15060000188237 | L15/dossiers | 15 | 15060000188236 | 15060000188236 | 1 | PA719946 | PM722808 |
| 15060000188244 | L15/dossiers | 15 | 15060000188243 | 15060000188243 | 1 | PA720278 | PM722916 |
| 15060000188251 | L15/dossiers | 15 | 15060000188250 | 15060000188250 | 1 | PA719946 | PM722808 |
| 15060000188258 | L15/dossiers | 15 | 15060000188257 | 15060000188257 | 1 | PA267289 | PM754301 |
| 15060000188265 | L15/dossiers | 15 | 15060000188264 | 15060000188264 | 1 | PA604 | PM774354 |
| 15060000188272 | L15/dossiers | 15 | 15060000188271 | 15060000188271 | 1 | PA717161 | PM791583 |
| 15060000188279 | L15/dossiers | 15 | 15060000188278 | 15060000188278 | 1 | PA717161 | PM791583 |
| 15060000188286 | L15/dossiers | 15 | 15060000188285 | 15060000188285 | 1 | PA267289 | PM754301 |
| 15060000188293 | L15/dossiers | 15 | 15060000188292 | 15060000188292 | 1 | PA267762 | PM736366 |
| 15060000188294 | L15/dossiers | 15 | 15060000188292 | 15060000188292 | 2 | PA703534 | PM775695 |
| 15060000188301 | L15/dossiers | 15 | 15060000188300 | 15060000188300 | 1 | PA429895 | PM736262 |
| 15060000188308 | L15/dossiers | 15 | 15060000188307 | 15060000188307 | 1 | PA717161 | PM791583 |
| 15060000188316 | L15/dossiers | 15 | 15060000188315 | 15060000188315 | 1 | PA717161 | PM791583 |
| 14060000089132 | L14/dossiers | 14 | 14060000089131 | 14060000089131 | 1 | PA1886 | PM645099 |
| 14060000089140 | L14/dossiers | 14 | 14060000089139 | 14060000089139 | 1 | PA267622 | PM702957 |
| 14060000089148 | L14/dossiers | 14 | 14060000089147 | 14060000089147 | 1 | PA332305 | PM645562 |
| 14060000089152 | L14/dossiers | 14 | 14060000089151 | 14060000089151 | 1 | PA328 | PM653228 |
| 14060000089153 | L14/dossiers | 14 | 14060000089151 | 14060000089151 | 2 | PA2342 | PM653301 |
| 14060000089242 | L14/dossiers | 14 | 14060000089241 | 14060000089241 | 1 | PA1942 | PM429985 |
| 14060000089299 | L14/dossiers | 14 | 14060000089298 | 14060000089298 | 1 | PA1871 | PM645374 |
| 14060000089306 | L14/dossiers | 14 | 14060000089305 | 14060000089305 | 1 | PA230 | PM645553 |
| 14060000089311 | L14/dossiers | 14 | 14060000089310 | 14060000089310 | 1 | PA346886 | PM695110 |
| 14060000089318 | L14/dossiers | 14 | 14060000089317 | 14060000089317 | 1 | PA610427 | PM645158 |
| 14060000089325 | L14/dossiers | 14 | 14060000089324 | 14060000089324 | 1 | PA267622 | PM700712 |
| 14060000089326 | L14/dossiers | 14 | 14060000089324 | 14060000089324 | 2 | PA2679 | PM700726 |
| 14060000089333 | L14/dossiers | 14 | 14060000089332 | 14060000089332 | 1 | PA1654 | PM703255 |
| 14060000089334 | L14/dossiers | 14 | 14060000089332 | 14060000089332 | 2 | PA2791 | PM653325 |
| 14060000089382 | L14/dossiers | 14 | 14060000089381 | 14060000089381 | 1 | PA703507 | PM703567 |
| 14060000089406 | L14/dossiers | 14 | 14060000089405 | 14060000089405 | 1 | PA267622 | PM702957 |
| 14060000089407 | L14/dossiers | 14 | 14060000089405 | 14060000089405 | 2 | PA1268 | PM702961 |
| 14060000089447 | L14/dossiers | 14 | 14060000089446 | 14060000089446 | 1 | PA336316 | PM645298 |
| 14060000089454 | L14/dossiers | 14 | 14060000089453 | 14060000089453 | 1 | PA267042 | PM645368 |
| 14060000089461 | L14/dossiers | 14 | 14060000089460 | 14060000089460 | 1 | PA267204 | PM645551 |
| 14060000089471 | L14/dossiers | 14 | 14060000089470 | 14060000089470 | 1 | PA1874 | PM645474 |
| 14060000089478 | L14/dossiers | 14 | 14060000089477 | 14060000089477 | 1 | PA330240 | PM645425 |
| 14060000089485 | L14/dossiers | 14 | 14060000089484 | 14060000089484 | 1 | PA1695 | PM645157 |
| 14060000089493 | L14/dossiers | 14 | 14060000089492 | 14060000089492 | 1 | PA429869 | PM429926 |
| 14060000089505 | L14/dossiers | 14 | 14060000089504 | 14060000089504 | 1 | PA304113 | PM304267 |
| 14060000089548 | L14/dossiers | 14 | 14060000089547 | 14060000089547 | 1 | PA328 | PM653228 |
| 14060000089549 | L14/dossiers | 14 | 14060000089547 | 14060000089547 | 2 | PA1268 | PM653525 |
| 14060000089585 | L14/dossiers | 14 | 14060000089584 | 14060000089584 | 1 | PA267433 | PM645316 |
| 14060000089596 | L14/dossiers | 14 | 14060000089595 | 14060000089595 | 1 | PA1695 | PM645157 |
| 14060000089601 | L14/dossiers | 14 | 14060000089600 | 14060000089600 | 1 | PA415483 | PM415580 |
| 14060000089608 | L14/dossiers | 14 | 14060000089607 | 14060000089607 | 1 | PA267728 | PM645216 |
| 14060000089615 | L14/dossiers | 14 | 14060000089614 | 14060000089614 | 1 | PA1037 | PM415531 |
| 14060000089625 | L14/dossiers | 14 | 14060000089624 | 14060000089624 | 1 | PA610427 | PM645158 |
| 14060000089632 | L14/dossiers | 14 | 14060000089631 | 14060000089631 | 1 | PA328 | PM653228 |
| 14060000089643 | L14/dossiers | 14 | 14060000089642 | 14060000089642 | 1 | PA267622 | PM702957 |