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 |
|---|---|---|---|---|---|---|---|
| 17060000140578 | L17/dossiers | 17 | 17060000140577 | 17060000140577 | 1 | PA345722 | PM843650 |
| 17060000140585 | L17/dossiers | 17 | 17060000140584 | 17060000140584 | 1 | PA721474 | PM843608 |
| 17060000140592 | L17/dossiers | 17 | 17060000140591 | 17060000140591 | 1 | PA840979 | PM842588 |
| 17060000140599 | L17/dossiers | 17 | 17060000140598 | 17060000140598 | 1 | PA840979 | PM842588 |
| 17060000140606 | L17/dossiers | 17 | 17060000140605 | 17060000140605 | 1 | PA774960 | PM840417 |
| 17060000140613 | L17/dossiers | 17 | 17060000140612 | 17060000140612 | 1 | PA795820 | PM843713 |
| 17060000140620 | L17/dossiers | 17 | 17060000140619 | 17060000140619 | 1 | PA720846 | PM840441 |
| 17060000140627 | L17/dossiers | 17 | 17060000140626 | 17060000140626 | 1 | PA794598 | PM843026 |
| 17060000140634 | L17/dossiers | 17 | 17060000140633 | 17060000140633 | 1 | PA793122 | PM842369 |
| 17060000140641 | L17/dossiers | 17 | 17060000140640 | 17060000140640 | 1 | PA345722 | PM843650 |
| 17060000140648 | L17/dossiers | 17 | 17060000140647 | 17060000140647 | 1 | PA791812 | PM840384 |
| 17060000140655 | L17/dossiers | 17 | 17060000140654 | 17060000140654 | 1 | PA720838 | PM843671 |
| 17060000140662 | L17/dossiers | 17 | 17060000140661 | 17060000140661 | 1 | PA870010 | PM870011 |
| 17060000140669 | L17/dossiers | 17 | 17060000140668 | 17060000140668 | 1 | PA840665 | PM842336 |
| 17060000140676 | L17/dossiers | 17 | 17060000140675 | 17060000140675 | 1 | PA793174 | PM842384 |
| 17060000140683 | L17/dossiers | 17 | 17060000140682 | 17060000140682 | 1 | PA795466 | PM843443 |
| 17060000140690 | L17/dossiers | 17 | 17060000140689 | 17060000140689 | 1 | PA794702 | PM843248 |
| 17060000140697 | L17/dossiers | 17 | 17060000140696 | 17060000140696 | 1 | PA345722 | PM843650 |
| 17060000140704 | L17/dossiers | 17 | 17060000140703 | 17060000140703 | 1 | PA841351 | PM842936 |
| 17060000140711 | L17/dossiers | 17 | 17060000140710 | 17060000140710 | 1 | PA785857 | PM785867 |
| 17060000140712 | L17/dossiers | 17 | 17060000140710 | 17060000140710 | 2 | PA827978 | PM828730 |
| 17060000140741 | L17/dossiers | 17 | 17060000140740 | 17060000140740 | 1 | PA720552 | PM843029 |
| 17060000140757 | L17/dossiers | 17 | 17060000140756 | 17060000140756 | 1 | PA267081 | PM775733 |
| 17060000140764 | L17/dossiers | 17 | 17060000140763 | 17060000140763 | 1 | PA795136 | PM843353 |
| 17060000140768 | L17/dossiers | 17 | 17060000140767 | 17060000140767 | 1 | PA794938 | PM843308 |
| 17060000140775 | L17/dossiers | 17 | 17060000140774 | 17060000140774 | 1 | PA722390 | PM843317 |
| 17060000140782 | L17/dossiers | 17 | 17060000140781 | 17060000140781 | 1 | PA775254 | PM775556 |
| 17060000140789 | L17/dossiers | 17 | 17060000140788 | 17060000140788 | 1 | PA736179 | PM829833 |
| 17060000140796 | L17/dossiers | 17 | 17060000140795 | 17060000140795 | 1 | PA415488 | PM775641 |
| 17060000140803 | L17/dossiers | 17 | 17060000140802 | 17060000140802 | 1 | PA775252 | PM775558 |
| 17060000140810 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 1 | PA758716 | PM775771 |
| 17060000140811 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 2 | PA758716 | PM775771 |
| 17060000140812 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 3 | PA330684 | PM775859 |
| 17060000140813 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 4 | PA715745 | PM829911 |
| 17060000140814 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 5 | PA775258 | PM775544 |
| 17060000140815 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 6 | PA736213 | PM775791 |
| 17060000140816 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 7 | PA827938 | PM828646 |
| 17060000140817 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 8 | PA778908 | PM829661 |
| 17060000140818 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 9 | PA415454 | PM785875 |
| 17060000140819 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 10 | PA736202 | PM775775 |
| 17060000140820 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 11 | PA827894 | PM828460 |
| 17060000140821 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 12 | PA775220 | PM775526 |
| 17060000140822 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 13 | PA736227 | PM829901 |
| 17060000140823 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 14 | PA267081 | PM775733 |
| 17060000140824 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 15 | PA827974 | PM828744 |
| 17060000140825 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 16 | PA827952 | PM828698 |
| 17060000140826 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 17 | PA736231 | PM829915 |
| 17060000140827 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 18 | PA785193 | PM829743 |
| 17060000140828 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 19 | PA849534 | PM849592 |
| 17060000140829 | L17/dossiers | 17 | 17060000140809 | 17060000140809 | 20 | PA827988 | PM828788 |