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 |
|---|---|---|---|---|---|---|---|
| 15060000132772 | L15/dossiers | 15 | 15060000132771 | 15060000132771 | 1 | PA335612 | PM723506 |
| 15060000132779 | L15/dossiers | 15 | 15060000132778 | 15060000132778 | 1 | PA721984 | PM723440 |
| 15060000132794 | L15/dossiers | 15 | 15060000132793 | 15060000132793 | 1 | PA720746 | PM723064 |
| 15060000132801 | L15/dossiers | 15 | 15060000132800 | 15060000132800 | 1 | PA721734 | PM723368 |
| 15060000132808 | L15/dossiers | 15 | 15060000132807 | 15060000132807 | 1 | PA720614 | PM723016 |
| 15060000132815 | L15/dossiers | 15 | 15060000132814 | 15060000132814 | 1 | PA719938 | PM722806 |
| 15060000132868 | L15/dossiers | 15 | 15060000132867 | 15060000132867 | 1 | PA720210 | PM722892 |
| 15060000132875 | L15/dossiers | 15 | 15060000132874 | 15060000132874 | 1 | PA267200 | PM722974 |
| 15060000132882 | L15/dossiers | 15 | 15060000132881 | 15060000132881 | 1 | PA720644 | PM723026 |
| 15060000132889 | L15/dossiers | 15 | 15060000132888 | 15060000132888 | 1 | PA605991 | PM722660 |
| 15060000132896 | L15/dossiers | 15 | 15060000132895 | 15060000132895 | 1 | PA605991 | PM722660 |
| 15060000132903 | L15/dossiers | 15 | 15060000132902 | 15060000132902 | 1 | PA1012 | PM722418 |
| 15060000132910 | L15/dossiers | 15 | 15060000132909 | 15060000132909 | 1 | PA1012 | PM722418 |
| 15060000132917 | L15/dossiers | 15 | 15060000132916 | 15060000132916 | 1 | PA606212 | PM722662 |
| 15060000132924 | L15/dossiers | 15 | 15060000132923 | 15060000132923 | 1 | PA345619 | PM725692 |
| 15060000132925 | L15/dossiers | 15 | 15060000132923 | 15060000132923 | 2 | PA717155 | PM730092 |
| 15060000132932 | L15/dossiers | 15 | 15060000132931 | 15060000132931 | 1 | PA345619 | PM725692 |
| 15060000132933 | L15/dossiers | 15 | 15060000132931 | 15060000132931 | 2 | PA717155 | PM730092 |
| 15060000132940 | L15/dossiers | 15 | 15060000132939 | 15060000132939 | 1 | PA345619 | PM725692 |
| 15060000132941 | L15/dossiers | 15 | 15060000132939 | 15060000132939 | 2 | PA331481 | PM730094 |
| 15060000132968 | L15/dossiers | 15 | 15060000132967 | 15060000132967 | 1 | PA606212 | PM722662 |
| 15060000132975 | L15/dossiers | 15 | 15060000132974 | 15060000132974 | 1 | PA720178 | PM722882 |
| 15060000132982 | L15/dossiers | 15 | 15060000132981 | 15060000132981 | 1 | PA642847 | PM722954 |
| 15060000132989 | L15/dossiers | 15 | 15060000132988 | 15060000132988 | 1 | PA721486 | PM723290 |
| 15060000133005 | L15/dossiers | 15 | 15060000133004 | 15060000133004 | 1 | PA721398 | PM723262 |
| 15060000133015 | L15/dossiers | 15 | 15060000133014 | 15060000133014 | 1 | PA267204 | PM722794 |
| 15060000133022 | L15/dossiers | 15 | 15060000133021 | 15060000133021 | 1 | PA345619 | PM725692 |
| 15060000133053 | L15/dossiers | 15 | 15060000133052 | 15060000133052 | 1 | PA266788 | PM722914 |
| 15060000133060 | L15/dossiers | 15 | 15060000133059 | 15060000133059 | 1 | PA2952 | PM722480 |
| 15060000133110 | L15/dossiers | 15 | 15060000133109 | 15060000133109 | 1 | PA718850 | PM722478 |
| 15060000133117 | L15/dossiers | 15 | 15060000133116 | 15060000133116 | 1 | PA703492 | PM703645 |
| 15060000133126 | L15/dossiers | 15 | 15060000133125 | 15060000133125 | 1 | PA334149 | PM723034 |
| 15060000133134 | L15/dossiers | 15 | 15060000133133 | 15060000133133 | 1 | PA267585 | PM722978 |
| 15060000133141 | L15/dossiers | 15 | 15060000133140 | 15060000133140 | 1 | PA345619 | PM725692 |
| 15060000133142 | L15/dossiers | 15 | 15060000133140 | 15060000133140 | 2 | PA1872 | PM730104 |
| 15060000133154 | L15/dossiers | 15 | 15060000133153 | 15060000133153 | 1 | PA345619 | PM725692 |
| 15060000133155 | L15/dossiers | 15 | 15060000133153 | 15060000133153 | 2 | PA1872 | PM730104 |
| 15060000133165 | L15/dossiers | 15 | 15060000133164 | 15060000133164 | 1 | PA345619 | PM725692 |
| 15060000133166 | L15/dossiers | 15 | 15060000133164 | 15060000133164 | 2 | PA1872 | PM730104 |
| 15060000133198 | L15/dossiers | 15 | 15060000133197 | 15060000133197 | 1 | PA345619 | PM725692 |
| 15060000133199 | L15/dossiers | 15 | 15060000133197 | 15060000133197 | 2 | PA1872 | PM730104 |
| 15060000133231 | L15/dossiers | 15 | 15060000133230 | 15060000133230 | 1 | PA345619 | PM725692 |
| 15060000133232 | L15/dossiers | 15 | 15060000133230 | 15060000133230 | 2 | PA1872 | PM730104 |
| 15060000133264 | L15/dossiers | 15 | 15060000133263 | 15060000133263 | 1 | PA721314 | PM723236 |
| 15060000133271 | L15/dossiers | 15 | 15060000133270 | 15060000133270 | 1 | PA718838 | PM722474 |
| 15060000133279 | L15/dossiers | 15 | 15060000133278 | 15060000133278 | 1 | PA223837 | PM722458 |
| 15060000133286 | L15/dossiers | 15 | 15060000133285 | 15060000133285 | 1 | PA345619 | PM725692 |
| 15060000133287 | L15/dossiers | 15 | 15060000133285 | 15060000133285 | 2 | PA717169 | PM730074 |
| 15060000133295 | L15/dossiers | 15 | 15060000133294 | 15060000133294 | 1 | PA267324 | PM723292 |
| 15060000133306 | L15/dossiers | 15 | 15060000133305 | 15060000133305 | 1 | PA720892 | PM723106 |