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 |
|---|---|---|---|---|---|---|---|
| 17060000116424 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 76 | PA736175 | PM736344 |
| 17060000116425 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 77 | PA775290 | PM775576 |
| 17060000116426 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 78 | PA736214 | PM736290 |
| 17060000116427 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 79 | PA736217 | PM736384 |
| 17060000116428 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 80 | PA775294 | PM775580 |
| 17060000116429 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 81 | PA775296 | PM775596 |
| 17060000116430 | L17/dossiers | 17 | 17060000116348 | 17060000116348 | 82 | PA785857 | PM785867 |
| 17060000116501 | L17/dossiers | 17 | 17060000116500 | 17060000116500 | 1 | PA711156 | PM736319 |
| 17060000116524 | L17/dossiers | 17 | 17060000116523 | 17060000116523 | 1 | PA703495 | PM775653 |
| 17060000116554 | L17/dossiers | 17 | 17060000116553 | 17060000116553 | 1 | PA736191 | PM736336 |
| 17060000116578 | L17/dossiers | 17 | 17060000116577 | 17060000116577 | 1 | PA721130 | PM775608 |
| 17060000116601 | L17/dossiers | 17 | 17060000116600 | 17060000116600 | 1 | PA703511 | PM775685 |
| 17060000116602 | L17/dossiers | 17 | 17060000116600 | 17060000116600 | 2 | PA415447 | PM775785 |
| 17060000116603 | L17/dossiers | 17 | 17060000116600 | 17060000116600 | 3 | PA429832 | PM736408 |
| 17060000116604 | L17/dossiers | 17 | 17060000116600 | 17060000116600 | 4 | PA736212 | PM736331 |
| 17060000116627 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 1 | PA736225 | PM736334 |
| 17060000116628 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 2 | PA736234 | PM736424 |
| 17060000116629 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 3 | PA708633 | PM775669 |
| 17060000116630 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 4 | PA415477 | PM775809 |
| 17060000116631 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 5 | PA415477 | PM775809 |
| 17060000116632 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 6 | PA736161 | PM736421 |
| 17060000116633 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 7 | PA605888 | PM775604 |
| 17060000116634 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 8 | PA342564 | PM736388 |
| 17060000116635 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 9 | PA429844 | PM736276 |
| 17060000116636 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 10 | PA606375 | PM775602 |
| 17060000116637 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 11 | PA429889 | PM736313 |
| 17060000116638 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 12 | PA429889 | PM736313 |
| 17060000116639 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 13 | PA429855 | PM736425 |
| 17060000116640 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 14 | PA304002 | PM736326 |
| 17060000116641 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 15 | PA736199 | PM736284 |
| 17060000116642 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 16 | PA415488 | PM775641 |
| 17060000116643 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 17 | PA775196 | PM775482 |
| 17060000116644 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 18 | PA775206 | PM775506 |
| 17060000116645 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 19 | PA590034 | PM775606 |
| 17060000116646 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 20 | PA785855 | PM785869 |
| 17060000116647 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 21 | PA732419 | PM775647 |
| 17060000116648 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 22 | PA732419 | PM775647 |
| 17060000116649 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 23 | PA736191 | PM736336 |
| 17060000116650 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 24 | PA736187 | PM736365 |
| 17060000116651 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 25 | PA642756 | PM775779 |
| 17060000116652 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 26 | PA736229 | PM736389 |
| 17060000116653 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 27 | PA736167 | PM736327 |
| 17060000116654 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 28 | PA703512 | PM775665 |
| 17060000116655 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 29 | PA643211 | PM775749 |
| 17060000116656 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 30 | PA736209 | PM736400 |
| 17060000116657 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 31 | PA775274 | PM775560 |
| 17060000116658 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 32 | PA429883 | PM736355 |
| 17060000116659 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 33 | PA775290 | PM775576 |
| 17060000116660 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 34 | PA2774 | PM736307 |
| 17060000116661 | L17/dossiers | 17 | 17060000116626 | 17060000116626 | 35 | PA736214 | PM736290 |