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 |
|---|---|---|---|---|---|---|---|
| 15060000151820 | L15/dossiers | 15 | 15060000151819 | 15060000151819 | 1 | PA345619 | PM725692 |
| 15060000151827 | L15/dossiers | 15 | 15060000151826 | 15060000151826 | 1 | PA345619 | PM725692 |
| 15060000151828 | L15/dossiers | 15 | 15060000151826 | 15060000151826 | 2 | PA331481 | PM730094 |
| 15060000151829 | L15/dossiers | 15 | 15060000151826 | 15060000151826 | 3 | PA702191 | PM730058 |
| 15060000151847 | L15/dossiers | 15 | 15060000151846 | 15060000151846 | 1 | PA267318 | PM723260 |
| 15060000151854 | L15/dossiers | 15 | 15060000151853 | 15060000151853 | 1 | PA755549 | PM755552 |
| 15060000151861 | L15/dossiers | 15 | 15060000151860 | 15060000151860 | 1 | PA720614 | PM723016 |
| 15060000151868 | L15/dossiers | 15 | 15060000151867 | 15060000151867 | 1 | PA643089 | PM758076 |
| 15060000151875 | L15/dossiers | 15 | 15060000151874 | 15060000151874 | 1 | PA266788 | PM722914 |
| 15060000151882 | L15/dossiers | 15 | 15060000151881 | 15060000151881 | 1 | PA719668 | PM722726 |
| 15060000151889 | L15/dossiers | 15 | 15060000151888 | 15060000151888 | 1 | PA719608 | PM722710 |
| 15060000151896 | L15/dossiers | 15 | 15060000151895 | 15060000151895 | 1 | PA609245 | PM723318 |
| 15060000151903 | L15/dossiers | 15 | 15060000151902 | 15060000151902 | 1 | PA266788 | PM722914 |
| 15060000151935 | L15/dossiers | 15 | 15060000151934 | 15060000151934 | 1 | PA719946 | PM722808 |
| 15060000151942 | L15/dossiers | 15 | 15060000151941 | 15060000151941 | 1 | PA609590 | PM723326 |
| 15060000151946 | L15/dossiers | 15 | 15060000151945 | 15060000151945 | 1 | PA345619 | PM725692 |
| 15060000151953 | L15/dossiers | 15 | 15060000151952 | 15060000151952 | 1 | PA345619 | PM725692 |
| 15060000152049 | L15/dossiers | 15 | 15060000152048 | 15060000152048 | 1 | PA719608 | PM722710 |
| 15060000152056 | L15/dossiers | 15 | 15060000152055 | 15060000152055 | 1 | PA719608 | PM722710 |
| 15060000152063 | L15/dossiers | 15 | 15060000152062 | 15060000152062 | 1 | PA719608 | PM722710 |
| 15060000152070 | L15/dossiers | 15 | 15060000152069 | 15060000152069 | 1 | PA335612 | PM723506 |
| 15060000152077 | L15/dossiers | 15 | 15060000152076 | 15060000152076 | 1 | PA719578 | PM722702 |
| 15060000152084 | L15/dossiers | 15 | 15060000152083 | 15060000152083 | 1 | PA721932 | PM734586 |
| 15060000152088 | L15/dossiers | 15 | 15060000152087 | 15060000152087 | 1 | PA642868 | PM722992 |
| 15060000152096 | L15/dossiers | 15 | 15060000152095 | 15060000152095 | 1 | PA713448 | PM722452 |
| 15060000152103 | L15/dossiers | 15 | 15060000152102 | 15060000152102 | 1 | PA610667 | PM723146 |
| 15060000152124 | L15/dossiers | 15 | 15060000152123 | 15060000152123 | 1 | PA345619 | PM725692 |
| 15060000152125 | L15/dossiers | 15 | 15060000152123 | 15060000152123 | 2 | PA717161 | PM766508 |
| 15060000152132 | L15/dossiers | 15 | 15060000152131 | 15060000152131 | 1 | PA345619 | PM725692 |
| 15060000152133 | L15/dossiers | 15 | 15060000152131 | 15060000152131 | 2 | PA227076 | PM759782 |
| 15060000152134 | L15/dossiers | 15 | 15060000152131 | 15060000152131 | 3 | PA729332 | PM759804 |
| 15060000152145 | L15/dossiers | 15 | 15060000152144 | 15060000152144 | 1 | PA2150 | PM722506 |
| 15060000152152 | L15/dossiers | 15 | 15060000152151 | 15060000152151 | 1 | PA345619 | PM725692 |
| 15060000152189 | L15/dossiers | 15 | 15060000152188 | 15060000152188 | 1 | PA345619 | PM725692 |
| 15060000152280 | L15/dossiers | 15 | 15060000152279 | 15060000152279 | 1 | PA720846 | PM723094 |
| 15060000152287 | L15/dossiers | 15 | 15060000152286 | 15060000152286 | 1 | PA721270 | PM723220 |
| 15060000152294 | L15/dossiers | 15 | 15060000152293 | 15060000152293 | 1 | PA719044 | PM722542 |
| 15060000152302 | L15/dossiers | 15 | 15060000152301 | 15060000152301 | 1 | PA720798 | PM723080 |
| 15060000152312 | L15/dossiers | 15 | 15060000152311 | 15060000152311 | 1 | PA605694 | PM722558 |
| 15060000152331 | L15/dossiers | 15 | 15060000152330 | 15060000152330 | 1 | PA345619 | PM725692 |
| 15060000152332 | L15/dossiers | 15 | 15060000152330 | 15060000152330 | 2 | PA717153 | PM730062 |
| 15060000152561 | L15/dossiers | 15 | 15060000152560 | 15060000152560 | 1 | PA340853 | PM722534 |
| 15060000152568 | L15/dossiers | 15 | 15060000152567 | 15060000152567 | 1 | PA718784 | PM722456 |
| 15060000152575 | L15/dossiers | 15 | 15060000152574 | 15060000152574 | 1 | PA610654 | PM723142 |
| 15060000152597 | L15/dossiers | 15 | 15060000152596 | 15060000152596 | 1 | PA266797 | PM722884 |
| 15060000152604 | L15/dossiers | 15 | 15060000152603 | 15060000152603 | 1 | PA345619 | PM725692 |
| 15060000152611 | L15/dossiers | 15 | 15060000152610 | 15060000152610 | 1 | PA267260 | PM722476 |
| 15060000152618 | L15/dossiers | 15 | 15060000152617 | 15060000152617 | 1 | PA719118 | PM722568 |
| 15060000152625 | L15/dossiers | 15 | 15060000152624 | 15060000152624 | 1 | PA605694 | PM722558 |
| 15060000152632 | L15/dossiers | 15 | 15060000152631 | 15060000152631 | 1 | PA718784 | PM722456 |