dossiers.dossier_parlementaire_acteur
Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
25 238 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 |
|---|---|---|---|---|---|---|---|
| 16060000102898 | L16/dossiers | 16 | 16060000102897 | 16060000102897 | 1 | PA793632 | PM796443 |
| 16060000102927 | L16/dossiers | 16 | 16060000102926 | 16060000102926 | 1 | PA703521 | PM775707 |
| 16060000102934 | L16/dossiers | 16 | 16060000102933 | 16060000102933 | 1 | PA775206 | PM775506 |
| 16060000102935 | L16/dossiers | 16 | 16060000102933 | 16060000102933 | 2 | PA736219 | PM736387 |
| 16060000102936 | L16/dossiers | 16 | 16060000102933 | 16060000102933 | 3 | PA736234 | PM736424 |
| 16060000102937 | L16/dossiers | 16 | 16060000102933 | 16060000102933 | 4 | PA605888 | PM775604 |
| 16060000102947 | L16/dossiers | 16 | 16060000102946 | 16060000102946 | 1 | PA267042 | PM796932 |
| 16060000102954 | L16/dossiers | 16 | 16060000102953 | 16060000102953 | 1 | PA736201 | PM797523 |
| 16060000102961 | L16/dossiers | 16 | 16060000102960 | 16060000102960 | 1 | PA717161 | PM791583 |
| 16060000102969 | L16/dossiers | 16 | 16060000102968 | 16060000102968 | 1 | PA719318 | PM796470 |
| 16060000102976 | L16/dossiers | 16 | 16060000102975 | 16060000102975 | 1 | PA794914 | PM797190 |
| 16060000102983 | L16/dossiers | 16 | 16060000102982 | 16060000102982 | 1 | PA793964 | PM796626 |
| 16060000102990 | L16/dossiers | 16 | 16060000102989 | 16060000102989 | 1 | PA793964 | PM796626 |
| 16060000102997 | L16/dossiers | 16 | 16060000102996 | 16060000102996 | 1 | PA266808 | PM797313 |
| 16060000103004 | L16/dossiers | 16 | 16060000103003 | 16060000103003 | 1 | PA720838 | PM797865 |
| 16060000103011 | L16/dossiers | 16 | 16060000103010 | 16060000103010 | 1 | PA719318 | PM796470 |
| 16060000103018 | L16/dossiers | 16 | 16060000103017 | 16060000103017 | 1 | PA718838 | PM796197 |
| 16060000103025 | L16/dossiers | 16 | 16060000103024 | 16060000103024 | 1 | PA794118 | PM796725 |
| 16060000103032 | L16/dossiers | 16 | 16060000103031 | 16060000103031 | 1 | PA794118 | PM796725 |
| 16060000103039 | L16/dossiers | 16 | 16060000103038 | 16060000103038 | 1 | PA722390 | PM797214 |
| 16060000103046 | L16/dossiers | 16 | 16060000103045 | 16060000103045 | 1 | PA642868 | PM796968 |
| 16060000103047 | L16/dossiers | 16 | 16060000103045 | 16060000103045 | 2 | PA793394 | PM796299 |
| 16060000103054 | L16/dossiers | 16 | 16060000103053 | 16060000103053 | 1 | PA795156 | PM797334 |
| 16060000103071 | L16/dossiers | 16 | 16060000103070 | 16060000103070 | 1 | PA267306 | PM797073 |
| 16060000103072 | L16/dossiers | 16 | 16060000103070 | 16060000103070 | 2 | PA720692 | PM796986 |
| 16060000103076 | L16/dossiers | 16 | 16060000103075 | 16060000103075 | 1 | PA736244 | PM736333 |
| 16060000103083 | L16/dossiers | 16 | 16060000103082 | 16060000103082 | 1 | PA774958 | PM797355 |
| 16060000103108 | L16/dossiers | 16 | 16060000103107 | 16060000103107 | 1 | PA774960 | PM797490 |
| 16060000103185 | L16/dossiers | 16 | 16060000103184 | 16060000103184 | 1 | PA736201 | PM797523 |
| 16060000103192 | L16/dossiers | 16 | 16060000103191 | 16060000103191 | 1 | PA722046 | PM797625 |
| 16060000103263 | L16/dossiers | 16 | 16060000103262 | 16060000103262 | 1 | PA793736 | PM796503 |
| 16060000103270 | L16/dossiers | 16 | 16060000103269 | 16060000103269 | 1 | PA718884 | PM796218 |
| 16060000103277 | L16/dossiers | 16 | 16060000103276 | 16060000103276 | 1 | PA642868 | PM796968 |
| 16060000103284 | L16/dossiers | 16 | 16060000103283 | 16060000103283 | 1 | PA330008 | PM796158 |
| 16060000103291 | L16/dossiers | 16 | 16060000103290 | 16060000103290 | 1 | PA335054 | PM797298 |
| 16060000103298 | L16/dossiers | 16 | 16060000103297 | 16060000103297 | 1 | PA721328 | PM797250 |
| 16060000103305 | L16/dossiers | 16 | 16060000103304 | 16060000103304 | 1 | PA330909 | PM796314 |
| 16060000103312 | L16/dossiers | 16 | 16060000103311 | 16060000103311 | 1 | PA346782 | PM797691 |
| 16060000103319 | L16/dossiers | 16 | 16060000103318 | 16060000103318 | 1 | PA642847 | PM796872 |
| 16060000103326 | L16/dossiers | 16 | 16060000103325 | 16060000103325 | 1 | PA721270 | PM797829 |
| 16060000103333 | L16/dossiers | 16 | 16060000103332 | 16060000103332 | 1 | PA795672 | PM797616 |
| 16060000103340 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 1 | PA775184 | PM775486 |
| 16060000103341 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 2 | PA227089 | PM736372 |
| 16060000103342 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 3 | PA429842 | PM736373 |
| 16060000103343 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 4 | PA341381 | PM775747 |
| 16060000103344 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 5 | PA775274 | PM775560 |
| 16060000103345 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 6 | PA267340 | PM775731 |
| 16060000103346 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 7 | PA266795 | PM775711 |
| 16060000103347 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 8 | PA775168 | PM775470 |
| 16060000103348 | L16/dossiers | 16 | 16060000103339 | 16060000103339 | 9 | PA429858 | PM736268 |