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 |
|---|---|---|---|---|---|---|---|
| 17060000134215 | L17/dossiers | 17 | 17060000134214 | 17060000134214 | 1 | PA429875 | PM829755 |
| 17060000134234 | L17/dossiers | 17 | 17060000134233 | 17060000134233 | 1 | PA842271 | PM843776 |
| 17060000134247 | L17/dossiers | 17 | 17060000134246 | 17060000134246 | 1 | PA796106 | PM843383 |
| 17060000134254 | L17/dossiers | 17 | 17060000134253 | 17060000134253 | 1 | PA605745 | PM842504 |
| 17060000134269 | L17/dossiers | 17 | 17060000134268 | 17060000134268 | 1 | PA796106 | PM843383 |
| 17060000134291 | L17/dossiers | 17 | 17060000134290 | 17060000134290 | 1 | PA721270 | PM840438 |
| 17060000134298 | L17/dossiers | 17 | 17060000134297 | 17060000134297 | 1 | PA795998 | PM843737 |
| 17060000134320 | L17/dossiers | 17 | 17060000134319 | 17060000134319 | 1 | PA793174 | PM842384 |
| 17060000134335 | L17/dossiers | 17 | 17060000134334 | 17060000134334 | 1 | PA828022 | PM828870 |
| 17060000134336 | L17/dossiers | 17 | 17060000134334 | 17060000134334 | 2 | PA785855 | PM785869 |
| 17060000134337 | L17/dossiers | 17 | 17060000134334 | 17060000134334 | 3 | PA703512 | PM775665 |
| 17060000134338 | L17/dossiers | 17 | 17060000134334 | 17060000134334 | 4 | PA643028 | PM829316 |
| 17060000134357 | L17/dossiers | 17 | 17060000134356 | 17060000134356 | 1 | PA410 | PM855580 |
| 17060000134422 | L17/dossiers | 17 | 17060000134421 | 17060000134421 | 1 | PA410 | PM855580 |
| 17060000134506 | L17/dossiers | 17 | 17060000134505 | 17060000134505 | 1 | PA410 | PM855580 |
| 17060000134535 | L17/dossiers | 17 | 17060000134534 | 17060000134534 | 1 | PA703532 | PM775699 |
| 17060000134536 | L17/dossiers | 17 | 17060000134534 | 17060000134534 | 2 | PA429832 | PM829723 |
| 17060000134570 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 1 | PA736175 | PM829795 |
| 17060000134571 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 2 | PA827962 | PM828676 |
| 17060000134572 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 3 | PA757676 | PM829801 |
| 17060000134573 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 4 | PA775172 | PM775474 |
| 17060000134574 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 5 | PA827898 | PM828454 |
| 17060000134575 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 6 | PA850008 | PM850016 |
| 17060000134576 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 7 | PA827912 | PM828488 |
| 17060000134577 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 8 | PA756685 | PM775777 |
| 17060000134578 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 9 | PA827930 | PM828544 |
| 17060000134579 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 10 | PA268007 | PM829695 |
| 17060000134580 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 11 | PA429886 | PM829757 |
| 17060000134581 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 12 | PA736195 | PM829855 |
| 17060000134582 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 13 | PA736173 | PM829799 |
| 17060000134583 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 14 | PA775246 | PM775532 |
| 17060000134584 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 15 | PA736243 | PM829929 |
| 17060000134585 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 16 | PA828002 | PM828856 |
| 17060000134586 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 17 | PA775296 | PM775596 |
| 17060000134587 | L17/dossiers | 17 | 17060000134569 | 17060000134569 | 18 | PA828020 | PM828864 |
| 17060000134594 | L17/dossiers | 17 | 17060000134593 | 17060000134593 | 1 | PA795164 | PM840444 |
| 17060000134601 | L17/dossiers | 17 | 17060000134600 | 17060000134600 | 1 | PA408578 | PM843662 |
| 17060000134605 | L17/dossiers | 17 | 17060000134604 | 17060000134604 | 1 | PA721296 | PM843698 |
| 17060000134612 | L17/dossiers | 17 | 17060000134611 | 17060000134611 | 1 | PA840721 | PM842378 |
| 17060000134619 | L17/dossiers | 17 | 17060000134618 | 17060000134618 | 1 | PA721270 | PM840438 |
| 17060000134627 | L17/dossiers | 17 | 17060000134626 | 17060000134626 | 1 | PA410 | PM855580 |
| 17060000134658 | L17/dossiers | 17 | 17060000134657 | 17060000134657 | 1 | PA736229 | PM829923 |
| 17060000134668 | L17/dossiers | 17 | 17060000134667 | 17060000134667 | 1 | PA410 | PM855580 |
| 17060000134702 | L17/dossiers | 17 | 17060000134701 | 17060000134701 | 1 | PA2952 | PM842414 |
| 17060000134709 | L17/dossiers | 17 | 17060000134708 | 17060000134708 | 1 | PA2952 | PM842414 |
| 17060000134716 | L17/dossiers | 17 | 17060000134715 | 17060000134715 | 1 | PA721062 | PM843740 |
| 17060000134723 | L17/dossiers | 17 | 17060000134722 | 17060000134722 | 1 | PA330240 | PM842357 |
| 17060000134727 | L17/dossiers | 17 | 17060000134726 | 17060000134726 | 1 | PA642982 | PM829146 |
| 17060000134728 | L17/dossiers | 17 | 17060000134726 | 17060000134726 | 2 | PA703512 | PM775665 |
| 17060000134729 | L17/dossiers | 17 | 17060000134726 | 17060000134726 | 3 | PA712422 | PM828926 |