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 |
|---|---|---|---|---|---|---|---|
| 15060000136699 | L15/dossiers | 15 | 15060000136698 | 15060000136698 | 1 | PA721364 | PM723250 |
| 15060000136767 | L15/dossiers | 15 | 15060000136766 | 15060000136766 | 1 | PA609726 | PM723426 |
| 15060000136771 | L15/dossiers | 15 | 15060000136770 | 15060000136770 | 1 | PA720606 | PM723014 |
| 15060000136778 | L15/dossiers | 15 | 15060000136777 | 15060000136777 | 1 | PA643211 | PM703707 |
| 15060000136797 | L15/dossiers | 15 | 15060000136796 | 15060000136796 | 1 | PA267200 | PM722974 |
| 15060000136804 | L15/dossiers | 15 | 15060000136803 | 15060000136803 | 1 | PA721046 | PM723154 |
| 15060000136811 | L15/dossiers | 15 | 15060000136810 | 15060000136810 | 1 | PA330788 | PM722570 |
| 15060000136818 | L15/dossiers | 15 | 15060000136817 | 15060000136817 | 1 | PA718784 | PM722456 |
| 15060000136825 | L15/dossiers | 15 | 15060000136824 | 15060000136824 | 1 | PA712015 | PM722448 |
| 15060000136842 | L15/dossiers | 15 | 15060000136841 | 15060000136841 | 1 | PA605036 | PM722444 |
| 15060000136849 | L15/dossiers | 15 | 15060000136848 | 15060000136848 | 1 | PA330684 | PM722528 |
| 15060000136856 | L15/dossiers | 15 | 15060000136855 | 15060000136855 | 1 | PA609726 | PM723426 |
| 15060000136863 | L15/dossiers | 15 | 15060000136862 | 15060000136862 | 1 | PA719946 | PM722808 |
| 15060000136883 | L15/dossiers | 15 | 15060000136882 | 15060000136882 | 1 | PA718780 | PM722454 |
| 15060000136890 | L15/dossiers | 15 | 15060000136889 | 15060000136889 | 1 | PA223837 | PM722458 |
| 15060000136897 | L15/dossiers | 15 | 15060000136896 | 15060000136896 | 1 | PA2792 | PM722870 |
| 15060000136904 | L15/dossiers | 15 | 15060000136903 | 15060000136903 | 1 | PA606212 | PM722662 |
| 15060000136905 | L15/dossiers | 15 | 15060000136903 | 15060000136903 | 2 | PA720614 | PM723016 |
| 15060000136912 | L15/dossiers | 15 | 15060000136911 | 15060000136911 | 1 | PA1874 | PM722598 |
| 15060000136917 | L15/dossiers | 15 | 15060000136916 | 15060000136916 | 1 | PA333818 | PM722990 |
| 15060000136925 | L15/dossiers | 15 | 15060000136924 | 15060000136924 | 1 | PA721314 | PM723236 |
| 15060000136932 | L15/dossiers | 15 | 15060000136931 | 15060000136931 | 1 | PA1206 | PM723354 |
| 15060000136939 | L15/dossiers | 15 | 15060000136938 | 15060000136938 | 1 | PA721678 | PM723352 |
| 15060000136946 | L15/dossiers | 15 | 15060000136945 | 15060000136945 | 1 | PA345619 | PM725692 |
| 15060000136947 | L15/dossiers | 15 | 15060000136945 | 15060000136945 | 2 | PA906 | PM730043 |
| 15060000137078 | L15/dossiers | 15 | 15060000137077 | 15060000137077 | 1 | PA2150 | PM722506 |
| 15060000137095 | L15/dossiers | 15 | 15060000137094 | 15060000137094 | 1 | PA721158 | PM723190 |
| 15060000137096 | L15/dossiers | 15 | 15060000137094 | 15060000137094 | 2 | PA608011 | PM723022 |
| 15060000137109 | L15/dossiers | 15 | 15060000137108 | 15060000137108 | 1 | PA267785 | PM723310 |
| 15060000137116 | L15/dossiers | 15 | 15060000137115 | 15060000137115 | 1 | PA345619 | PM725692 |
| 15060000137123 | L15/dossiers | 15 | 15060000137122 | 15060000137122 | 1 | PA721314 | PM723236 |
| 15060000137142 | L15/dossiers | 15 | 15060000137141 | 15060000137141 | 1 | PA268019 | PM723092 |
| 15060000137149 | L15/dossiers | 15 | 15060000137148 | 15060000137148 | 1 | PA330909 | PM722548 |
| 15060000137156 | L15/dossiers | 15 | 15060000137155 | 15060000137155 | 1 | PA267318 | PM723260 |
| 15060000137163 | L15/dossiers | 15 | 15060000137162 | 15060000137162 | 1 | PA345619 | PM725692 |
| 15060000137164 | L15/dossiers | 15 | 15060000137162 | 15060000137162 | 2 | PA331481 | PM730094 |
| 15060000137172 | L15/dossiers | 15 | 15060000137171 | 15060000137171 | 1 | PA720696 | PM723044 |
| 15060000137179 | L15/dossiers | 15 | 15060000137178 | 15060000137178 | 1 | PA713448 | PM722452 |
| 15060000137189 | L15/dossiers | 15 | 15060000137188 | 15060000137188 | 1 | PA345619 | PM725692 |
| 15060000137240 | L15/dossiers | 15 | 15060000137239 | 15060000137239 | 1 | PA643211 | PM703707 |
| 15060000137250 | L15/dossiers | 15 | 15060000137249 | 15060000137249 | 1 | PA605991 | PM722660 |
| 15060000137257 | L15/dossiers | 15 | 15060000137256 | 15060000137256 | 1 | PA720846 | PM723094 |
| 15060000137264 | L15/dossiers | 15 | 15060000137263 | 15060000137263 | 1 | PA330008 | PM722416 |
| 15060000137271 | L15/dossiers | 15 | 15060000137270 | 15060000137270 | 1 | PA719728 | PM722744 |
| 15060000137278 | L15/dossiers | 15 | 15060000137277 | 15060000137277 | 1 | PA720630 | PM723020 |
| 15060000137285 | L15/dossiers | 15 | 15060000137284 | 15060000137284 | 1 | PA2377 | PM723550 |
| 15060000137292 | L15/dossiers | 15 | 15060000137291 | 15060000137291 | 1 | PA720586 | PM723008 |
| 15060000137299 | L15/dossiers | 15 | 15060000137298 | 15060000137298 | 1 | PA719272 | PM722612 |
| 15060000137306 | L15/dossiers | 15 | 15060000137305 | 15060000137305 | 1 | PA267324 | PM723292 |
| 15060000137313 | L15/dossiers | 15 | 15060000137312 | 15060000137312 | 1 | PA721234 | PM723210 |