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 |
|---|---|---|---|---|---|---|---|
| 15060000160927 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 44 | PA415451 | PM703594 |
| 15060000160928 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 45 | PA703539 | PM703693 |
| 15060000160929 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 46 | PA736176 | PM736434 |
| 15060000160930 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 47 | PA980 | PM736356 |
| 15060000160931 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 48 | PA736163 | PM736253 |
| 15060000160932 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 49 | PA345785 | PM736294 |
| 15060000160933 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 50 | PA304737 | PM703551 |
| 15060000160934 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 51 | PA429854 | PM736335 |
| 15060000160935 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 52 | PA426327 | PM703630 |
| 15060000160936 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 53 | PA715322 | PM715327 |
| 15060000160937 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 54 | PA703517 | PM703625 |
| 15060000160938 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 55 | PA703500 | PM703574 |
| 15060000160939 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 56 | PA703483 | PM703613 |
| 15060000160940 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 57 | PA703540 | PM703573 |
| 15060000160941 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 58 | PA758431 | PM758701 |
| 15060000160942 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 59 | PA757678 | PM757684 |
| 15060000160943 | L15/dossiers | 15 | 15060000160883 | 15060000160883 | 60 | PA703488 | PM703632 |
| 15060000160960 | L15/dossiers | 15 | 15060000160959 | 15060000160959 | 1 | PA334149 | PM723034 |
| 15060000160967 | L15/dossiers | 15 | 15060000160966 | 15060000160966 | 1 | PA334149 | PM723034 |
| 15060000160974 | L15/dossiers | 15 | 15060000160973 | 15060000160973 | 1 | PA721718 | PM723364 |
| 15060000160978 | L15/dossiers | 15 | 15060000160977 | 15060000160977 | 1 | PA343775 | PM736367 |
| 15060000160985 | L15/dossiers | 15 | 15060000160984 | 15060000160984 | 1 | PA345619 | PM725692 |
| 15060000161055 | L15/dossiers | 15 | 15060000161054 | 15060000161054 | 1 | PA345619 | PM725692 |
| 15060000161072 | L15/dossiers | 15 | 15060000161071 | 15060000161071 | 1 | PA719946 | PM722808 |
| 15060000161079 | L15/dossiers | 15 | 15060000161078 | 15060000161078 | 1 | PA719946 | PM722808 |
| 15060000161087 | L15/dossiers | 15 | 15060000161086 | 15060000161086 | 1 | PA267794 | PM722468 |
| 15060000161094 | L15/dossiers | 15 | 15060000161093 | 15060000161093 | 1 | PA1206 | PM723354 |
| 15060000161101 | L15/dossiers | 15 | 15060000161100 | 15060000161100 | 1 | PA608826 | PM723276 |
| 15060000161131 | L15/dossiers | 15 | 15060000161130 | 15060000161130 | 1 | PA335999 | PM723480 |
| 15060000161138 | L15/dossiers | 15 | 15060000161137 | 15060000161137 | 1 | PA330240 | PM722492 |
| 15060000161145 | L15/dossiers | 15 | 15060000161144 | 15060000161144 | 1 | PA643089 | PM758076 |
| 15060000161152 | L15/dossiers | 15 | 15060000161151 | 15060000161151 | 1 | PA718884 | PM722488 |
| 15060000161164 | L15/dossiers | 15 | 15060000161163 | 15060000161163 | 1 | PA2792 | PM722870 |
| 15060000161171 | L15/dossiers | 15 | 15060000161170 | 15060000161170 | 1 | PA2792 | PM722870 |
| 15060000161178 | L15/dossiers | 15 | 15060000161177 | 15060000161177 | 1 | PA721816 | PM748964 |
| 15060000161182 | L15/dossiers | 15 | 15060000161181 | 15060000161181 | 1 | PA721718 | PM723364 |
| 15060000161186 | L15/dossiers | 15 | 15060000161185 | 15060000161185 | 1 | PA720606 | PM723014 |
| 15060000161193 | L15/dossiers | 15 | 15060000161192 | 15060000161192 | 1 | PA609590 | PM723326 |
| 15060000161208 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 1 | PA732420 | PM763170 |
| 15060000161209 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 2 | PA732420 | PM763170 |
| 15060000161210 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 3 | PA429895 | PM736262 |
| 15060000161211 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 4 | PA703486 | PM703718 |
| 15060000161212 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 5 | PA267840 | PM736423 |
| 15060000161213 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 6 | PA703528 | PM703588 |
| 15060000161214 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 7 | PA736190 | PM736255 |
| 15060000161215 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 8 | PA703531 | PM703701 |
| 15060000161216 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 9 | PA905 | PM703566 |
| 15060000161217 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 10 | PA268007 | PM736325 |
| 15060000161218 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 11 | PA429845 | PM736278 |
| 15060000161219 | L15/dossiers | 15 | 15060000161207 | 15060000161207 | 12 | PA736235 | PM736426 |