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 |
|---|---|---|---|---|---|---|---|
| 17060000143799 | L17/dossiers | 17 | 17060000143798 | 17060000143798 | 1 | PA720960 | PM843758 |
| 17060000143806 | L17/dossiers | 17 | 17060000143805 | 17060000143805 | 1 | PA642847 | PM843056 |
| 17060000143813 | L17/dossiers | 17 | 17060000143812 | 17060000143812 | 1 | PA718784 | PM842342 |
| 17060000143820 | L17/dossiers | 17 | 17060000143819 | 17060000143819 | 1 | PA703520 | PM775705 |
| 17060000143821 | L17/dossiers | 17 | 17060000143819 | 17060000143819 | 2 | PA267340 | PM775731 |
| 17060000143841 | L17/dossiers | 17 | 17060000143840 | 17060000143840 | 1 | PA330008 | PM842366 |
| 17060000143846 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 1 | PA736243 | PM829929 |
| 17060000143847 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 2 | PA775172 | PM775474 |
| 17060000143848 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 3 | PA827930 | PM828544 |
| 17060000143849 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 4 | PA757676 | PM829801 |
| 17060000143850 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 5 | PA827898 | PM828454 |
| 17060000143851 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 6 | PA850008 | PM850016 |
| 17060000143852 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 7 | PA827912 | PM828488 |
| 17060000143853 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 8 | PA756685 | PM775777 |
| 17060000143854 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 9 | PA268007 | PM829695 |
| 17060000143855 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 10 | PA429886 | PM829757 |
| 17060000143856 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 11 | PA736195 | PM829855 |
| 17060000143857 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 12 | PA736173 | PM829799 |
| 17060000143858 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 13 | PA775246 | PM775532 |
| 17060000143859 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 14 | PA827962 | PM828676 |
| 17060000143860 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 15 | PA736175 | PM829795 |
| 17060000143861 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 16 | PA828002 | PM828856 |
| 17060000143862 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 17 | PA775296 | PM775596 |
| 17060000143863 | L17/dossiers | 17 | 17060000143845 | 17060000143845 | 18 | PA828020 | PM828864 |
| 17060000143873 | L17/dossiers | 17 | 17060000143872 | 17060000143872 | 1 | PA330008 | PM842366 |
| 17060000143877 | L17/dossiers | 17 | 17060000143876 | 17060000143876 | 1 | PA793322 | PM840246 |
| 17060000143881 | L17/dossiers | 17 | 17060000143880 | 17060000143880 | 1 | PA382672 | PM829681 |
| 17060000143888 | L17/dossiers | 17 | 17060000143887 | 17060000143887 | 1 | PA643210 | PM873637 |
| 17060000143895 | L17/dossiers | 17 | 17060000143894 | 17060000143894 | 1 | PA774954 | PM842843 |
| 17060000143903 | L17/dossiers | 17 | 17060000143902 | 17060000143902 | 1 | PA736241 | PM829931 |
| 17060000143910 | L17/dossiers | 17 | 17060000143909 | 17060000143909 | 1 | PA736241 | PM829931 |
| 17060000143917 | L17/dossiers | 17 | 17060000143916 | 17060000143916 | 1 | PA736241 | PM829931 |
| 17060000143924 | L17/dossiers | 17 | 17060000143923 | 17060000143923 | 1 | PA415499 | PM775655 |
| 17060000143957 | L17/dossiers | 17 | 17060000143956 | 17060000143956 | 1 | PA2337 | PM775691 |
| 17060000143987 | L17/dossiers | 17 | 17060000143986 | 17060000143986 | 1 | PA643211 | PM775749 |
| 17060000143994 | L17/dossiers | 17 | 17060000143993 | 17060000143993 | 1 | PA736241 | PM829931 |
| 17060000144001 | L17/dossiers | 17 | 17060000144000 | 17060000144000 | 1 | PA736241 | PM829931 |
| 17060000144008 | L17/dossiers | 17 | 17060000144007 | 17060000144007 | 1 | PA736241 | PM829931 |
| 17060000144015 | L17/dossiers | 17 | 17060000144014 | 17060000144014 | 1 | PA840657 | PM842333 |
| 17060000144022 | L17/dossiers | 17 | 17060000144021 | 17060000144021 | 1 | PA643104 | PM872431 |
| 17060000144029 | L17/dossiers | 17 | 17060000144028 | 17060000144028 | 1 | PA793322 | PM840246 |
| 17060000144036 | L17/dossiers | 17 | 17060000144035 | 17060000144035 | 1 | PA2952 | PM842414 |
| 17060000144043 | L17/dossiers | 17 | 17060000144042 | 17060000144042 | 1 | PA677483 | PM842435 |
| 17060000144050 | L17/dossiers | 17 | 17060000144049 | 17060000144049 | 1 | PA408578 | PM843662 |
| 17060000144057 | L17/dossiers | 17 | 17060000144056 | 17060000144056 | 1 | PA796018 | PM843425 |
| 17060000144064 | L17/dossiers | 17 | 17060000144063 | 17060000144063 | 1 | PA842187 | PM843704 |
| 17060000144071 | L17/dossiers | 17 | 17060000144070 | 17060000144070 | 1 | PA793194 | PM853806 |
| 17060000144078 | L17/dossiers | 17 | 17060000144077 | 17060000144077 | 1 | PA736201 | PM840423 |
| 17060000144095 | L17/dossiers | 17 | 17060000144094 | 17060000144094 | 1 | PA719968 | PM842891 |
| 17060000144107 | L17/dossiers | 17 | 17060000144106 | 17060000144106 | 1 | PA610654 | PM843719 |