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 |
|---|---|---|---|---|---|---|---|
| 15060000175215 | L15/dossiers | 15 | 15060000175214 | 15060000175214 | 1 | PA2538 | PM775801 |
| 15060000175216 | L15/dossiers | 15 | 15060000175214 | 15060000175214 | 2 | PA703497 | PM775637 |
| 15060000175223 | L15/dossiers | 15 | 15060000175222 | 15060000175222 | 1 | PA721984 | PM723440 |
| 15060000175230 | L15/dossiers | 15 | 15060000175229 | 15060000175229 | 1 | PA227029 | PM736306 |
| 15060000175237 | L15/dossiers | 15 | 15060000175236 | 15060000175236 | 1 | PA227029 | PM736306 |
| 15060000175244 | L15/dossiers | 15 | 15060000175243 | 15060000175243 | 1 | PA1874 | PM722598 |
| 15060000175251 | L15/dossiers | 15 | 15060000175250 | 15060000175250 | 1 | PA719778 | PM722760 |
| 15060000175258 | L15/dossiers | 15 | 15060000175257 | 15060000175257 | 1 | PA719608 | PM722710 |
| 15060000175265 | L15/dossiers | 15 | 15060000175264 | 15060000175264 | 1 | PA607553 | PM722956 |
| 15060000175272 | L15/dossiers | 15 | 15060000175271 | 15060000175271 | 1 | PA719608 | PM722710 |
| 15060000175279 | L15/dossiers | 15 | 15060000175278 | 15060000175278 | 1 | PA720684 | PM723040 |
| 15060000175286 | L15/dossiers | 15 | 15060000175285 | 15060000175285 | 1 | PA607553 | PM722956 |
| 15060000175293 | L15/dossiers | 15 | 15060000175292 | 15060000175292 | 1 | PA719146 | PM722576 |
| 15060000175316 | L15/dossiers | 15 | 15060000175315 | 15060000175315 | 1 | PA736228 | PM736380 |
| 15060000175326 | L15/dossiers | 15 | 15060000175325 | 15060000175325 | 1 | PA2116 | PM736339 |
| 15060000175334 | L15/dossiers | 15 | 15060000175333 | 15060000175333 | 1 | PA721486 | PM723290 |
| 15060000175344 | L15/dossiers | 15 | 15060000175343 | 15060000175343 | 1 | PA773441 | PM773491 |
| 15060000175345 | L15/dossiers | 15 | 15060000175343 | 15060000175343 | 2 | PA335758 | PM773463 |
| 15060000175346 | L15/dossiers | 15 | 15060000175343 | 15060000175343 | 3 | PA1872 | PM773455 |
| 15060000175377 | L15/dossiers | 15 | 15060000175376 | 15060000175376 | 1 | PA775260 | PM775550 |
| 15060000175387 | L15/dossiers | 15 | 15060000175386 | 15060000175386 | 1 | PA227029 | PM736306 |
| 15060000175394 | L15/dossiers | 15 | 15060000175393 | 15060000175393 | 1 | PA773441 | PM773491 |
| 15060000175395 | L15/dossiers | 15 | 15060000175393 | 15060000175393 | 2 | PA205600 | PM773445 |
| 15060000175396 | L15/dossiers | 15 | 15060000175393 | 15060000175393 | 3 | PA607846 | PM773469 |
| 15060000175397 | L15/dossiers | 15 | 15060000175393 | 15060000175393 | 4 | PA721670 | PM773499 |
| 15060000175404 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 1 | PA2774 | PM736307 |
| 15060000175405 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 2 | PA702993 | PM736362 |
| 15060000175406 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 3 | PA736167 | PM736327 |
| 15060000175407 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 4 | PA703538 | PM775715 |
| 15060000175408 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 5 | PA775196 | PM775482 |
| 15060000175409 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 6 | PA642756 | PM775779 |
| 15060000175410 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 7 | PA736229 | PM736389 |
| 15060000175411 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 8 | PA429860 | PM736398 |
| 15060000175412 | L15/dossiers | 15 | 15060000175403 | 15060000175403 | 9 | PA2074 | PM775677 |
| 15060000175419 | L15/dossiers | 15 | 15060000175418 | 15060000175418 | 1 | PA267907 | PM775751 |
| 15060000175426 | L15/dossiers | 15 | 15060000175425 | 15060000175425 | 1 | PA721932 | PM734586 |
| 15060000175433 | L15/dossiers | 15 | 15060000175432 | 15060000175432 | 1 | PA267762 | PM736366 |
| 15060000175440 | L15/dossiers | 15 | 15060000175439 | 15060000175439 | 1 | PA343775 | PM736367 |
| 15060000175441 | L15/dossiers | 15 | 15060000175439 | 15060000175439 | 2 | PA736198 | PM736406 |
| 15060000175448 | L15/dossiers | 15 | 15060000175447 | 15060000175447 | 1 | PA703530 | PM775689 |
| 15060000175467 | L15/dossiers | 15 | 15060000175466 | 15060000175466 | 1 | PA773441 | PM773491 |
| 15060000175468 | L15/dossiers | 15 | 15060000175466 | 15060000175466 | 2 | PA717161 | PM773483 |
| 15060000175475 | L15/dossiers | 15 | 15060000175474 | 15060000175474 | 1 | PA718784 | PM722456 |
| 15060000175482 | L15/dossiers | 15 | 15060000175481 | 15060000175481 | 1 | PA1206 | PM723354 |
| 15060000175489 | L15/dossiers | 15 | 15060000175488 | 15060000175488 | 1 | PA773441 | PM773491 |
| 15060000175496 | L15/dossiers | 15 | 15060000175495 | 15060000175495 | 1 | PA415446 | PM775783 |
| 15060000175503 | L15/dossiers | 15 | 15060000175502 | 15060000175502 | 1 | PA736237 | PM736417 |
| 15060000175510 | L15/dossiers | 15 | 15060000175509 | 15060000175509 | 1 | PA719946 | PM722808 |
| 15060000175517 | L15/dossiers | 15 | 15060000175516 | 15060000175516 | 1 | PA330240 | PM722492 |
| 15060000175524 | L15/dossiers | 15 | 15060000175523 | 15060000175523 | 1 | PA720046 | PM722842 |