dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 249 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 |
|---|---|---|---|---|---|---|---|
| 15060000162862 | L15/dossiers | 15 | 15060000162861 | 15060000162861 | 1 | PA642764 | PM753836 |
| 15060000162869 | L15/dossiers | 15 | 15060000162868 | 15060000162868 | 1 | PA267766 | PM722970 |
| 15060000162876 | L15/dossiers | 15 | 15060000162875 | 15060000162875 | 1 | PA267330 | PM723392 |
| 15060000162883 | L15/dossiers | 15 | 15060000162882 | 15060000162882 | 1 | PA719436 | PM770316 |
| 15060000162887 | L15/dossiers | 15 | 15060000162886 | 15060000162886 | 1 | PA340853 | PM722534 |
| 15060000162894 | L15/dossiers | 15 | 15060000162893 | 15060000162893 | 1 | PA713448 | PM722452 |
| 15060000162901 | L15/dossiers | 15 | 15060000162900 | 15060000162900 | 1 | PA266788 | PM722914 |
| 15060000162908 | L15/dossiers | 15 | 15060000162907 | 15060000162907 | 1 | PA643089 | PM758076 |
| 15060000162915 | L15/dossiers | 15 | 15060000162914 | 15060000162914 | 1 | PA709315 | PM722526 |
| 15060000162922 | L15/dossiers | 15 | 15060000162921 | 15060000162921 | 1 | PA719946 | PM722808 |
| 15060000162929 | L15/dossiers | 15 | 15060000162928 | 15060000162928 | 1 | PA998 | PM723046 |
| 15060000162936 | L15/dossiers | 15 | 15060000162935 | 15060000162935 | 1 | PA1874 | PM722598 |
| 15060000162943 | L15/dossiers | 15 | 15060000162942 | 15060000162942 | 1 | PA718926 | PM722502 |
| 15060000162950 | L15/dossiers | 15 | 15060000162949 | 15060000162949 | 1 | PA1874 | PM722598 |
| 15060000162957 | L15/dossiers | 15 | 15060000162956 | 15060000162956 | 1 | PA1874 | PM722598 |
| 15060000162964 | L15/dossiers | 15 | 15060000162963 | 15060000162963 | 1 | PA722110 | PM723474 |
| 15060000162971 | L15/dossiers | 15 | 15060000162970 | 15060000162970 | 1 | PA2116 | PM736339 |
| 15060000162972 | L15/dossiers | 15 | 15060000162970 | 15060000162970 | 2 | PA736236 | PM736341 |
| 15060000162973 | L15/dossiers | 15 | 15060000162970 | 15060000162970 | 3 | PA736203 | PM736432 |
| 15060000162980 | L15/dossiers | 15 | 15060000162979 | 15060000162979 | 1 | PA718784 | PM722456 |
| 15060000162984 | L15/dossiers | 15 | 15060000162983 | 15060000162983 | 1 | PA718838 | PM722474 |
| 15060000162991 | L15/dossiers | 15 | 15060000162990 | 15060000162990 | 1 | PA608016 | PM723024 |
| 15060000162998 | L15/dossiers | 15 | 15060000162997 | 15060000162997 | 1 | PA609726 | PM723426 |
| 15060000163005 | L15/dossiers | 15 | 15060000163004 | 15060000163004 | 1 | PA721142 | PM723186 |
| 15060000163009 | L15/dossiers | 15 | 15060000163008 | 15060000163008 | 1 | PA334149 | PM723034 |
| 15060000163016 | L15/dossiers | 15 | 15060000163015 | 15060000163015 | 1 | PA334149 | PM723034 |
| 15060000163023 | L15/dossiers | 15 | 15060000163022 | 15060000163022 | 1 | PA718838 | PM722474 |
| 15060000163030 | L15/dossiers | 15 | 15060000163029 | 15060000163029 | 1 | PA719608 | PM722710 |
| 15060000163037 | L15/dossiers | 15 | 15060000163036 | 15060000163036 | 1 | PA607090 | PM722796 |
| 15060000163044 | L15/dossiers | 15 | 15060000163043 | 15060000163043 | 1 | PA720798 | PM723080 |
| 15060000163051 | L15/dossiers | 15 | 15060000163050 | 15060000163050 | 1 | PA721194 | PM723200 |
| 15060000163058 | L15/dossiers | 15 | 15060000163057 | 15060000163057 | 1 | PA345619 | PM725692 |
| 15060000163059 | L15/dossiers | 15 | 15060000163057 | 15060000163057 | 2 | PA605131 | PM759784 |
| 15060000163067 | L15/dossiers | 15 | 15060000163066 | 15060000163066 | 1 | PA332523 | PM722792 |
| 15060000163071 | L15/dossiers | 15 | 15060000163070 | 15060000163070 | 1 | PA744079 | PM744082 |
| 15060000163078 | L15/dossiers | 15 | 15060000163077 | 15060000163077 | 1 | PA721506 | PM723296 |
| 15060000163085 | L15/dossiers | 15 | 15060000163084 | 15060000163084 | 1 | PA720568 | PM723002 |
| 15060000163092 | L15/dossiers | 15 | 15060000163091 | 15060000163091 | 1 | PA718926 | PM722502 |
| 15060000163096 | L15/dossiers | 15 | 15060000163095 | 15060000163095 | 1 | PA718926 | PM722502 |
| 15060000163103 | L15/dossiers | 15 | 15060000163102 | 15060000163102 | 1 | PA720546 | PM722996 |
| 15060000163107 | L15/dossiers | 15 | 15060000163106 | 15060000163106 | 1 | PA718784 | PM722456 |
| 15060000163111 | L15/dossiers | 15 | 15060000163110 | 15060000163110 | 1 | PA267324 | PM723292 |
| 15060000163118 | L15/dossiers | 15 | 15060000163117 | 15060000163117 | 1 | PA719578 | PM722702 |
| 15060000163135 | L15/dossiers | 15 | 15060000163134 | 15060000163134 | 1 | PA695100 | PM723198 |
| 15060000163139 | L15/dossiers | 15 | 15060000163138 | 15060000163138 | 1 | PA415446 | PM703678 |
| 15060000163146 | L15/dossiers | 15 | 15060000163145 | 15060000163145 | 1 | PA703513 | PM703621 |
| 15060000163153 | L15/dossiers | 15 | 15060000163152 | 15060000163152 | 1 | PA718860 | PM722482 |
| 15060000163160 | L15/dossiers | 15 | 15060000163159 | 15060000163159 | 1 | PA721932 | PM734586 |
| 15060000163167 | L15/dossiers | 15 | 15060000163166 | 15060000163166 | 1 | PA609590 | PM723326 |
| 15060000163171 | L15/dossiers | 15 | 15060000163170 | 15060000163170 | 1 | PA722142 | PM723484 |