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 |
|---|---|---|---|---|---|---|---|
| 17060000130226 | L17/dossiers | 17 | 17060000130225 | 17060000130225 | 1 | PA721486 | PM843614 |
| 17060000130233 | L17/dossiers | 17 | 17060000130232 | 17060000130232 | 1 | PA720908 | PM843701 |
| 17060000130240 | L17/dossiers | 17 | 17060000130239 | 17060000130239 | 1 | PA722070 | PM843548 |
| 17060000130247 | L17/dossiers | 17 | 17060000130246 | 17060000130246 | 1 | PA720908 | PM843701 |
| 17060000130262 | L17/dossiers | 17 | 17060000130261 | 17060000130261 | 1 | PA841701 | PM843269 |
| 17060000130263 | L17/dossiers | 17 | 17060000130261 | 17060000130261 | 2 | PA677483 | PM842435 |
| 17060000130287 | L17/dossiers | 17 | 17060000130286 | 17060000130286 | 1 | PA791812 | PM840384 |
| 17060000130294 | L17/dossiers | 17 | 17060000130293 | 17060000130293 | 1 | PA795374 | PM843593 |
| 17060000130307 | L17/dossiers | 17 | 17060000130306 | 17060000130306 | 1 | PA335999 | PM843494 |
| 17060000130314 | L17/dossiers | 17 | 17060000130313 | 17060000130313 | 1 | PA822617 | PM840264 |
| 17060000130321 | L17/dossiers | 17 | 17060000130320 | 17060000130320 | 1 | PA774958 | PM843389 |
| 17060000130322 | L17/dossiers | 17 | 17060000130320 | 17060000130320 | 2 | PA722134 | PM843497 |
| 17060000130329 | L17/dossiers | 17 | 17060000130328 | 17060000130328 | 1 | PA333285 | PM843038 |
| 17060000130357 | L17/dossiers | 17 | 17060000130356 | 17060000130356 | 1 | PA796010 | PM843743 |
| 17060000130364 | L17/dossiers | 17 | 17060000130363 | 17060000130363 | 1 | PA794838 | PM843212 |
| 17060000130388 | L17/dossiers | 17 | 17060000130387 | 17060000130387 | 1 | PA410 | PM855580 |
| 17060000130425 | L17/dossiers | 17 | 17060000130424 | 17060000130424 | 1 | PA795350 | PM843410 |
| 17060000130429 | L17/dossiers | 17 | 17060000130428 | 17060000130428 | 1 | PA736233 | PM829889 |
| 17060000130436 | L17/dossiers | 17 | 17060000130435 | 17060000130435 | 1 | PA841131 | PM842735 |
| 17060000130447 | L17/dossiers | 17 | 17060000130446 | 17060000130446 | 1 | PA795636 | PM843476 |
| 17060000130459 | L17/dossiers | 17 | 17060000130458 | 17060000130458 | 1 | PA795540 | PM843620 |
| 17060000130463 | L17/dossiers | 17 | 17060000130462 | 17060000130462 | 1 | PA794008 | PM842768 |
| 17060000130479 | L17/dossiers | 17 | 17060000130478 | 17060000130478 | 1 | PA842001 | PM843554 |
| 17060000130494 | L17/dossiers | 17 | 17060000130493 | 17060000130493 | 1 | PA794008 | PM842768 |
| 17060000130501 | L17/dossiers | 17 | 17060000130500 | 17060000130500 | 1 | PA793342 | PM842345 |
| 17060000130508 | L17/dossiers | 17 | 17060000130507 | 17060000130507 | 1 | PA793832 | PM842678 |
| 17060000130515 | L17/dossiers | 17 | 17060000130514 | 17060000130514 | 1 | PA721474 | PM843608 |
| 17060000130522 | L17/dossiers | 17 | 17060000130521 | 17060000130521 | 1 | PA841067 | PM842687 |
| 17060000130529 | L17/dossiers | 17 | 17060000130528 | 17060000130528 | 1 | PA721474 | PM843608 |
| 17060000130536 | L17/dossiers | 17 | 17060000130535 | 17060000130535 | 1 | PA719968 | PM842891 |
| 17060000130543 | L17/dossiers | 17 | 17060000130542 | 17060000130542 | 1 | PA794234 | PM842969 |
| 17060000130550 | L17/dossiers | 17 | 17060000130549 | 17060000130549 | 1 | PA840171 | PM840360 |
| 17060000130557 | L17/dossiers | 17 | 17060000130556 | 17060000130556 | 1 | PA346782 | PM840426 |
| 17060000130564 | L17/dossiers | 17 | 17060000130563 | 17060000130563 | 1 | PA794442 | PM840306 |
| 17060000130571 | L17/dossiers | 17 | 17060000130570 | 17060000130570 | 1 | PA842271 | PM843776 |
| 17060000130578 | L17/dossiers | 17 | 17060000130577 | 17060000130577 | 1 | PA841419 | PM843005 |
| 17060000130585 | L17/dossiers | 17 | 17060000130584 | 17060000130584 | 1 | PA608172 | PM843083 |
| 17060000130592 | L17/dossiers | 17 | 17060000130591 | 17060000130591 | 1 | PA736233 | PM829889 |
| 17060000130617 | L17/dossiers | 17 | 17060000130616 | 17060000130616 | 1 | PA796062 | PM843668 |
| 17060000130624 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 1 | PA785857 | PM785867 |
| 17060000130625 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 2 | PA775180 | PM775466 |
| 17060000130626 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 3 | PA827904 | PM828514 |
| 17060000130627 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 4 | PA429845 | PM829729 |
| 17060000130628 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 5 | PA775214 | PM775498 |
| 17060000130629 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 6 | PA775224 | PM775512 |
| 17060000130630 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 7 | PA736177 | PM829835 |
| 17060000130631 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 8 | PA827946 | PM828614 |
| 17060000130632 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 9 | PA827950 | PM828598 |
| 17060000130633 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 10 | PA775252 | PM775558 |
| 17060000130634 | L17/dossiers | 17 | 17060000130623 | 17060000130623 | 11 | PA827968 | PM828750 |