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 |
|---|---|---|---|---|---|---|---|
| 17060000135573 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 11 | PA827978 | PM828730 |
| 17060000135574 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 12 | PA775272 | PM775562 |
| 17060000135575 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 13 | PA775282 | PM775584 |
| 17060000135576 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 14 | PA828000 | PM828850 |
| 17060000135577 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 15 | PA828004 | PM828838 |
| 17060000135578 | L17/dossiers | 17 | 17060000135562 | 17060000135562 | 16 | PA785857 | PM785867 |
| 17060000135585 | L17/dossiers | 17 | 17060000135584 | 17060000135584 | 1 | PA791812 | PM840384 |
| 17060000135595 | L17/dossiers | 17 | 17060000135594 | 17060000135594 | 1 | PA794938 | PM843308 |
| 17060000135603 | L17/dossiers | 17 | 17060000135602 | 17060000135602 | 1 | PA785855 | PM785869 |
| 17060000135622 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 1 | PA850008 | PM850016 |
| 17060000135623 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 2 | PA757676 | PM829801 |
| 17060000135624 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 3 | PA775172 | PM775474 |
| 17060000135625 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 4 | PA827898 | PM828454 |
| 17060000135626 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 5 | PA827912 | PM828488 |
| 17060000135627 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 6 | PA756685 | PM775777 |
| 17060000135628 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 7 | PA827930 | PM828544 |
| 17060000135629 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 8 | PA268007 | PM829695 |
| 17060000135630 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 9 | PA429886 | PM829757 |
| 17060000135631 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 10 | PA736195 | PM829855 |
| 17060000135632 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 11 | PA736173 | PM829799 |
| 17060000135633 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 12 | PA775246 | PM775532 |
| 17060000135634 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 13 | PA827962 | PM828676 |
| 17060000135635 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 14 | PA736243 | PM829929 |
| 17060000135636 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 15 | PA736175 | PM829795 |
| 17060000135637 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 16 | PA828002 | PM828856 |
| 17060000135638 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 17 | PA775296 | PM775596 |
| 17060000135639 | L17/dossiers | 17 | 17060000135621 | 17060000135621 | 18 | PA828020 | PM828864 |
| 17060000135646 | L17/dossiers | 17 | 17060000135645 | 17060000135645 | 1 | PA720892 | PM840420 |
| 17060000135671 | L17/dossiers | 17 | 17060000135670 | 17060000135670 | 1 | PA795046 | PM843818 |
| 17060000135675 | L17/dossiers | 17 | 17060000135674 | 17060000135674 | 1 | PA794082 | PM842810 |
| 17060000135685 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 1 | PA429886 | PM829757 |
| 17060000135686 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 2 | PA736177 | PM829835 |
| 17060000135687 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 3 | PA702993 | PM829493 |
| 17060000135688 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 4 | PA736195 | PM829855 |
| 17060000135689 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 5 | PA775246 | PM775532 |
| 17060000135690 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 6 | PA827962 | PM828676 |
| 17060000135691 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 7 | PA757676 | PM829801 |
| 17060000135692 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 8 | PA775172 | PM775474 |
| 17060000135693 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 9 | PA827898 | PM828454 |
| 17060000135694 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 10 | PA850008 | PM850016 |
| 17060000135695 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 11 | PA827912 | PM828488 |
| 17060000135696 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 12 | PA756685 | PM775777 |
| 17060000135697 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 13 | PA827930 | PM828544 |
| 17060000135698 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 14 | PA268007 | PM829695 |
| 17060000135699 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 15 | PA736173 | PM829799 |
| 17060000135700 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 16 | PA736243 | PM829929 |
| 17060000135701 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 17 | PA736175 | PM829795 |
| 17060000135702 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 18 | PA828002 | PM828856 |
| 17060000135703 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 19 | PA775296 | PM775596 |
| 17060000135704 | L17/dossiers | 17 | 17060000135684 | 17060000135684 | 20 | PA828020 | PM828864 |