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 |
|---|---|---|---|---|---|---|---|
| 15060000175774 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 19 | PA736181 | PM736416 |
| 15060000175775 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 20 | PA429855 | PM736425 |
| 15060000175776 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 21 | PA643211 | PM775749 |
| 15060000175777 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 22 | PA766947 | PM775799 |
| 15060000175778 | L15/dossiers | 15 | 15060000175755 | 15060000175755 | 23 | PA415453 | PM703691 |
| 15060000175785 | L15/dossiers | 15 | 15060000175784 | 15060000175784 | 1 | PA605036 | PM722444 |
| 15060000175789 | L15/dossiers | 15 | 15060000175788 | 15060000175788 | 1 | PA721012 | PM755861 |
| 15060000175793 | L15/dossiers | 15 | 15060000175792 | 15060000175792 | 1 | PA720892 | PM723106 |
| 15060000175800 | L15/dossiers | 15 | 15060000175799 | 15060000175799 | 1 | PA773441 | PM773491 |
| 15060000175801 | L15/dossiers | 15 | 15060000175799 | 15060000175799 | 2 | PA607846 | PM773469 |
| 15060000175808 | L15/dossiers | 15 | 15060000175807 | 15060000175807 | 1 | PA773441 | PM773491 |
| 15060000175815 | L15/dossiers | 15 | 15060000175814 | 15060000175814 | 1 | PA722252 | PM723518 |
| 15060000175869 | L15/dossiers | 15 | 15060000175868 | 15060000175868 | 1 | PA643134 | PM722824 |
| 15060000175876 | L15/dossiers | 15 | 15060000175875 | 15060000175875 | 1 | PA330008 | PM722416 |
| 15060000175880 | L15/dossiers | 15 | 15060000175879 | 15060000175879 | 1 | PA2150 | PM722506 |
| 15060000175895 | L15/dossiers | 15 | 15060000175894 | 15060000175894 | 1 | PA722142 | PM723484 |
| 15060000175911 | L15/dossiers | 15 | 15060000175910 | 15060000175910 | 1 | PA718860 | PM722482 |
| 15060000175922 | L15/dossiers | 15 | 15060000175921 | 15060000175921 | 1 | PA719624 | PM722714 |
| 15060000175929 | L15/dossiers | 15 | 15060000175928 | 15060000175928 | 1 | PA267780 | PM723504 |
| 15060000175933 | L15/dossiers | 15 | 15060000175932 | 15060000175932 | 1 | PA719558 | PM722696 |
| 15060000175940 | L15/dossiers | 15 | 15060000175939 | 15060000175939 | 1 | PA718884 | PM722488 |
| 15060000175947 | L15/dossiers | 15 | 15060000175946 | 15060000175946 | 1 | PA722390 | PM723560 |
| 15060000175954 | L15/dossiers | 15 | 15060000175953 | 15060000175953 | 1 | PA718868 | PM722484 |
| 15060000175965 | L15/dossiers | 15 | 15060000175964 | 15060000175964 | 1 | PA721062 | PM723158 |
| 15060000175980 | L15/dossiers | 15 | 15060000175979 | 15060000175979 | 1 | PA736192 | PM736353 |
| 15060000175987 | L15/dossiers | 15 | 15060000175986 | 15060000175986 | 1 | PA721226 | PM723208 |
| 15060000176004 | L15/dossiers | 15 | 15060000176003 | 15060000176003 | 1 | PA720846 | PM723094 |
| 15060000176016 | L15/dossiers | 15 | 15060000176015 | 15060000176015 | 1 | PA720630 | PM723020 |
| 15060000176023 | L15/dossiers | 15 | 15060000176022 | 15060000176022 | 1 | PA718838 | PM722474 |
| 15060000176030 | L15/dossiers | 15 | 15060000176029 | 15060000176029 | 1 | PA720862 | PM723098 |
| 15060000176037 | L15/dossiers | 15 | 15060000176036 | 15060000176036 | 1 | PA720878 | PM723102 |
| 15060000176038 | L15/dossiers | 15 | 15060000176036 | 15060000176036 | 2 | PA2960 | PM723006 |
| 15060000176091 | L15/dossiers | 15 | 15060000176090 | 15060000176090 | 1 | PA718728 | PM722438 |
| 15060000176145 | L15/dossiers | 15 | 15060000176144 | 15060000176144 | 1 | PA720892 | PM723106 |
| 15060000176162 | L15/dossiers | 15 | 15060000176161 | 15060000176161 | 1 | PA721674 | PM764881 |
| 15060000176169 | L15/dossiers | 15 | 15060000176168 | 15060000176168 | 1 | PA2116 | PM736339 |
| 15060000176176 | L15/dossiers | 15 | 15060000176175 | 15060000176175 | 1 | PA330788 | PM722570 |
| 15060000176183 | L15/dossiers | 15 | 15060000176182 | 15060000176182 | 1 | PA335999 | PM723480 |
| 15060000176190 | L15/dossiers | 15 | 15060000176189 | 15060000176189 | 1 | PA720614 | PM723016 |
| 15060000176197 | L15/dossiers | 15 | 15060000176196 | 15060000176196 | 1 | PA382672 | PM736263 |
| 15060000176204 | L15/dossiers | 15 | 15060000176203 | 15060000176203 | 1 | PA721932 | PM734586 |
| 15060000176208 | L15/dossiers | 15 | 15060000176207 | 15060000176207 | 1 | PA303997 | PM775743 |
| 15060000176227 | L15/dossiers | 15 | 15060000176226 | 15060000176226 | 1 | PA773441 | PM773491 |
| 15060000176228 | L15/dossiers | 15 | 15060000176226 | 15060000176226 | 2 | PA721670 | PM773499 |
| 15060000176238 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 1 | PA703538 | PM775715 |
| 15060000176239 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 2 | PA429860 | PM736398 |
| 15060000176240 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 3 | PA702993 | PM736362 |
| 15060000176241 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 4 | PA736167 | PM736327 |
| 15060000176242 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 5 | PA775196 | PM775482 |
| 15060000176243 | L15/dossiers | 15 | 15060000176237 | 15060000176237 | 6 | PA736229 | PM736389 |