AN · données ouvertes
Explorateur / dossiers

dossiers.dossier_parlementaire_acteur

Chemin dossierParlementaire.initiateur.acteurs.acteur · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %

25 238 lignes (estimation)

Colonnes

#ColonneTypeCommentaire
1_idBIGINTidentifiant : code de la source × 10¹⁰ + rang
2_sourceVARCHARsource du catalogue (catalogue.py)
3_legislatureBIGINTcolonne constante de la source
4_racine_idBIGINT_id de la ligne racine
5_parent_idBIGINT_id de la ligne parente
6_ordreBIGINTrang dans le tableau d'origine (1…)
7acteur_refVARCHARdossierParlementaire.initiateur.acteurs.acteur.acteurRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %
8mandat_refVARCHARdossierParlementaire.initiateur.acteurs.acteur.mandatRef · présence : L17 91 %, L16 84 %, L15 86 %, L14 82 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_refmandat_ref
17060000152039L17/dossiers1717060000152038170600001520381PA703523PM775703
17060000152040L17/dossiers1717060000152038170600001520382PA703492PM775657
17060000152041L17/dossiers1717060000152038170600001520383PA736224PM829913
17060000152042L17/dossiers1717060000152038170600001520384PA775260PM775550
17060000152043L17/dossiers1717060000152038170600001520385PA703513PM775671
17060000152050L17/dossiers1717060000152049170600001520491PA785855PM785869
17060000152057L17/dossiers1717060000152056170600001520561PA736235PM874830
17060000152064L17/dossiers1717060000152063170600001520631PA736241PM829931
17060000152071L17/dossiers1717060000152070170600001520701PA842085PM843617
17060000152078L17/dossiers1717060000152077170600001520771PA793298PM842360
17060000152095L17/dossiers1717060000152094170600001520941PA795778PM843509
17060000152102L17/dossiers1717060000152101170600001521011PA827996PM828764
17060000152109L17/dossiers1717060000152108170600001521081PA415446PM775783
17060000152110L17/dossiers1717060000152108170600001521082PA775270PM775572
17060000152117L17/dossiers1717060000152116170600001521161PA793780PM842714
17060000152121L17/dossiers1717060000152120170600001521201PA721984PM843536
17060000152128L17/dossiers1717060000152127170600001521271PA841769PM843323
17060000152132L17/dossiers1717060000152131170600001521311PA827994PM828782
17060000152139L17/dossiers1717060000152138170600001521381PA775272PM775562
17060000152146L17/dossiers1717060000152145170600001521451PA719408PM775520
17060000152147L17/dossiers1717060000152145170600001521452PA703514PM775661
17060000152148L17/dossiers1717060000152145170600001521453PA775170PM775468
17060000152149L17/dossiers1717060000152145170600001521454PA827906PM828520
17060000152156L17/dossiers1717060000152155170600001521551PA703529PM836349
17060000152157L17/dossiers1717060000152155170600001521552PA703529PM836349
17060000152164L17/dossiers1717060000152163170600001521631PA793322PM840246
17060000152171L17/dossiers1717060000152170170600001521701PA794590PM840303
17060000152179L17/dossiers1717060000152178170600001521781PA827946PM828614
17060000152180L17/dossiers1717060000152178170600001521782PA775180PM775466
17060000152181L17/dossiers1717060000152178170600001521783PA827904PM828514
17060000152182L17/dossiers1717060000152178170600001521784PA429845PM829729
17060000152183L17/dossiers1717060000152178170600001521785PA775214PM775498
17060000152184L17/dossiers1717060000152178170600001521786PA775224PM775512
17060000152185L17/dossiers1717060000152178170600001521787PA736177PM829835
17060000152186L17/dossiers1717060000152178170600001521788PA827950PM828598
17060000152187L17/dossiers1717060000152178170600001521789PA775252PM775558
17060000152188L17/dossiers17170600001521781706000015217810PA827968PM828750
17060000152189L17/dossiers17170600001521781706000015217811PA827978PM828730
17060000152190L17/dossiers17170600001521781706000015217812PA775272PM775562
17060000152191L17/dossiers17170600001521781706000015217813PA775282PM775584
17060000152192L17/dossiers17170600001521781706000015217814PA828000PM828850
17060000152193L17/dossiers17170600001521781706000015217815PA828004PM828838
17060000152194L17/dossiers17170600001521781706000015217816PA785857PM785867
17060000152201L17/dossiers1717060000152200170600001522001PA303995PM775745
17060000152202L17/dossiers1717060000152200170600001522002PA703523PM775703
17060000152203L17/dossiers1717060000152200170600001522003PA760322PM775649
17060000152204L17/dossiers1717060000152200170600001522004PA827972PM828738
17060000152211L17/dossiers1717060000152210170600001522101PA842279PM843779
17060000152219L17/dossiers1717060000152218170600001522181PA795778PM843509
17060000152224L17/dossiers1717060000152223170600001522231PA793382PM842480