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 |
|---|---|---|---|---|---|---|---|
| 17060000121732 | L17/dossiers | 17 | 17060000121731 | 17060000121731 | 1 | PA793844 | PM842681 |
| 17060000121749 | L17/dossiers | 17 | 17060000121748 | 17060000121748 | 1 | PA721474 | PM843608 |
| 17060000121756 | L17/dossiers | 17 | 17060000121755 | 17060000121755 | 1 | PA840979 | PM842588 |
| 17060000121763 | L17/dossiers | 17 | 17060000121762 | 17060000121762 | 1 | PA841955 | PM843506 |
| 17060000121778 | L17/dossiers | 17 | 17060000121777 | 17060000121777 | 1 | PA335999 | PM843494 |
| 17060000121785 | L17/dossiers | 17 | 17060000121784 | 17060000121784 | 1 | PA794562 | PM840339 |
| 17060000121792 | L17/dossiers | 17 | 17060000121791 | 17060000121791 | 1 | PA822617 | PM840264 |
| 17060000121800 | L17/dossiers | 17 | 17060000121799 | 17060000121799 | 1 | PA608826 | PM843365 |
| 17060000121807 | L17/dossiers | 17 | 17060000121806 | 17060000121806 | 1 | PA330909 | PM842399 |
| 17060000121814 | L17/dossiers | 17 | 17060000121813 | 17060000121813 | 1 | PA721442 | PM843362 |
| 17060000121821 | L17/dossiers | 17 | 17060000121820 | 17060000121820 | 1 | PA266808 | PM843347 |
| 17060000121828 | L17/dossiers | 17 | 17060000121827 | 17060000121827 | 1 | PA719436 | PM840279 |
| 17060000121844 | L17/dossiers | 17 | 17060000121843 | 17060000121843 | 1 | PA794946 | PM843311 |
| 17060000121851 | L17/dossiers | 17 | 17060000121850 | 17060000121850 | 1 | PA793246 | PM842429 |
| 17060000121868 | L17/dossiers | 17 | 17060000121867 | 17060000121867 | 1 | PA795808 | PM843644 |
| 17060000121875 | L17/dossiers | 17 | 17060000121874 | 17060000121874 | 1 | PA793928 | PM840294 |
| 17060000121893 | L17/dossiers | 17 | 17060000121892 | 17060000121892 | 1 | PA721932 | PM843632 |
| 17060000121900 | L17/dossiers | 17 | 17060000121899 | 17060000121899 | 1 | PA794486 | PM843110 |
| 17060000121907 | L17/dossiers | 17 | 17060000121906 | 17060000121906 | 1 | PA346782 | PM840426 |
| 17060000121914 | L17/dossiers | 17 | 17060000121913 | 17060000121913 | 1 | PA721474 | PM843608 |
| 17060000121921 | L17/dossiers | 17 | 17060000121920 | 17060000121920 | 1 | PA330909 | PM842399 |
| 17060000121928 | L17/dossiers | 17 | 17060000121927 | 17060000121927 | 1 | PA794058 | PM842861 |
| 17060000121935 | L17/dossiers | 17 | 17060000121934 | 17060000121934 | 1 | PA796050 | PM840411 |
| 17060000121942 | L17/dossiers | 17 | 17060000121941 | 17060000121941 | 1 | PA722336 | PM843203 |
| 17060000121988 | L17/dossiers | 17 | 17060000121987 | 17060000121987 | 1 | PA794906 | PM843284 |
| 17060000121995 | L17/dossiers | 17 | 17060000121994 | 17060000121994 | 1 | PA793210 | PM842417 |
| 17060000122002 | L17/dossiers | 17 | 17060000122001 | 17060000122001 | 1 | PA718884 | PM842420 |
| 17060000122009 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 1 | PA382672 | PM829681 |
| 17060000122010 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 2 | PA827902 | PM828442 |
| 17060000122011 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 3 | PA709298 | PM775773 |
| 17060000122012 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 4 | PA267673 | PM775865 |
| 17060000122013 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 5 | PA415446 | PM775783 |
| 17060000122014 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 6 | PA827996 | PM828764 |
| 17060000122015 | L17/dossiers | 17 | 17060000122008 | 17060000122008 | 7 | PA736237 | PM829897 |
| 17060000122022 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 1 | PA429886 | PM829757 |
| 17060000122023 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 2 | PA827912 | PM828488 |
| 17060000122024 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 3 | PA757676 | PM829801 |
| 17060000122025 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 4 | PA775172 | PM775474 |
| 17060000122026 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 5 | PA827898 | PM828454 |
| 17060000122027 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 6 | PA429894 | PM829765 |
| 17060000122028 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 7 | PA756685 | PM775777 |
| 17060000122029 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 8 | PA827930 | PM828544 |
| 17060000122030 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 9 | PA268007 | PM829695 |
| 17060000122031 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 10 | PA736195 | PM829855 |
| 17060000122032 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 11 | PA736173 | PM829799 |
| 17060000122033 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 12 | PA775246 | PM775532 |
| 17060000122034 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 13 | PA827962 | PM828676 |
| 17060000122035 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 14 | PA736243 | PM829929 |
| 17060000122036 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 15 | PA736175 | PM829795 |
| 17060000122037 | L17/dossiers | 17 | 17060000122021 | 17060000122021 | 16 | PA828002 | PM828856 |