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 |
|---|---|---|---|---|---|---|---|
| 17060000132815 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 31 | PA766947 | PM775799 |
| 17060000132816 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 32 | PA642756 | PM775779 |
| 17060000132817 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 33 | PA736241 | PM829931 |
| 17060000132818 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 34 | PA703509 | PM775687 |
| 17060000132819 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 35 | PA736181 | PM829839 |
| 17060000132820 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 36 | PA736225 | PM829907 |
| 17060000132821 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 37 | PA703536 | PM775719 |
| 17060000132822 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 38 | PA605888 | PM775604 |
| 17060000132823 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 39 | PA607761 | PM828556 |
| 17060000132824 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 40 | PA415449 | PM775793 |
| 17060000132825 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 41 | PA342564 | PM829509 |
| 17060000132826 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 42 | PA268048 | PM829731 |
| 17060000132827 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 43 | PA2074 | PM775677 |
| 17060000132828 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 44 | PA775254 | PM775556 |
| 17060000132829 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 45 | PA775256 | PM775546 |
| 17060000132830 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 46 | PA703512 | PM775665 |
| 17060000132831 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 47 | PA643211 | PM775749 |
| 17060000132832 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 48 | PA610850 | PM828634 |
| 17060000132833 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 49 | PA827980 | PM828710 |
| 17060000132834 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 50 | PA827982 | PM828718 |
| 17060000132835 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 51 | PA606375 | PM775602 |
| 17060000132836 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 52 | PA703505 | PM775679 |
| 17060000132837 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 53 | PA775274 | PM775560 |
| 17060000132838 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 54 | PA703511 | PM775685 |
| 17060000132839 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 55 | PA827994 | PM828782 |
| 17060000132840 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 56 | PA643028 | PM829316 |
| 17060000132841 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 57 | PA429889 | PM829767 |
| 17060000132842 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 58 | PA775290 | PM775576 |
| 17060000132843 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 59 | PA736214 | PM829883 |
| 17060000132844 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 60 | PA736217 | PM829873 |
| 17060000132845 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 61 | PA828010 | PM828832 |
| 17060000132846 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 62 | PA775294 | PM775580 |
| 17060000132847 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 63 | PA828014 | PM828818 |
| 17060000132848 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 64 | PA828018 | PM828882 |
| 17060000132849 | L17/dossiers | 17 | 17060000132784 | 17060000132784 | 65 | PA828022 | PM828870 |
| 17060000132856 | L17/dossiers | 17 | 17060000132855 | 17060000132855 | 1 | PA703518 | PM775673 |
| 17060000132876 | L17/dossiers | 17 | 17060000132875 | 17060000132875 | 1 | PA313924 | PM775727 |
| 17060000132877 | L17/dossiers | 17 | 17060000132875 | 17060000132875 | 2 | PA770871 | PM829763 |
| 17060000132878 | L17/dossiers | 17 | 17060000132875 | 17060000132875 | 3 | PA709298 | PM775773 |
| 17060000132897 | L17/dossiers | 17 | 17060000132896 | 17060000132896 | 1 | PA793772 | PM842708 |
| 17060000132904 | L17/dossiers | 17 | 17060000132903 | 17060000132903 | 1 | PA841981 | PM843533 |
| 17060000132911 | L17/dossiers | 17 | 17060000132910 | 17060000132910 | 1 | PA721584 | PM843518 |
| 17060000132918 | L17/dossiers | 17 | 17060000132917 | 17060000132917 | 1 | PA335054 | PM843332 |
| 17060000132925 | L17/dossiers | 17 | 17060000132924 | 17060000132924 | 1 | PA795746 | PM843584 |
| 17060000132932 | L17/dossiers | 17 | 17060000132931 | 17060000132931 | 1 | PA794094 | PM840291 |
| 17060000132939 | L17/dossiers | 17 | 17060000132938 | 17060000132938 | 1 | PA642847 | PM843056 |
| 17060000132946 | L17/dossiers | 17 | 17060000132945 | 17060000132945 | 1 | PA719024 | PM842390 |
| 17060000132953 | L17/dossiers | 17 | 17060000132952 | 17060000132952 | 1 | PA841507 | PM843086 |
| 17060000132960 | L17/dossiers | 17 | 17060000132959 | 17060000132959 | 1 | PA796062 | PM843668 |
| 17060000132967 | L17/dossiers | 17 | 17060000132966 | 17060000132966 | 1 | PA794198 | PM842876 |