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
17060000146674L17/dossiers17170600001466481706000014664826PA736191PM829819
17060000146675L17/dossiers17170600001466481706000014664827PA708633PM775669
17060000146676L17/dossiers17170600001466481706000014664828PA415477PM775809
17060000146677L17/dossiers17170600001466481706000014664829PA766947PM775799
17060000146678L17/dossiers17170600001466481706000014664830PA642756PM775779
17060000146679L17/dossiers17170600001466481706000014664831PA736241PM829931
17060000146680L17/dossiers17170600001466481706000014664832PA703509PM775687
17060000146681L17/dossiers17170600001466481706000014664833PA736181PM829839
17060000146682L17/dossiers17170600001466481706000014664834PA736225PM829907
17060000146683L17/dossiers17170600001466481706000014664835PA703536PM775719
17060000146684L17/dossiers17170600001466481706000014664836PA736229PM829923
17060000146685L17/dossiers17170600001466481706000014664837PA605888PM775604
17060000146686L17/dossiers17170600001466481706000014664838PA607761PM828556
17060000146687L17/dossiers17170600001466481706000014664839PA415449PM775793
17060000146688L17/dossiers17170600001466481706000014664840PA342564PM829509
17060000146689L17/dossiers17170600001466481706000014664841PA268048PM829731
17060000146690L17/dossiers17170600001466481706000014664842PA2074PM775677
17060000146691L17/dossiers17170600001466481706000014664843PA873607PM873611
17060000146692L17/dossiers17170600001466481706000014664844PA775254PM775556
17060000146693L17/dossiers17170600001466481706000014664845PA775256PM775546
17060000146694L17/dossiers17170600001466481706000014664846PA703512PM775665
17060000146695L17/dossiers17170600001466481706000014664847PA643211PM775749
17060000146696L17/dossiers17170600001466481706000014664848PA610850PM828634
17060000146697L17/dossiers17170600001466481706000014664849PA827980PM828710
17060000146698L17/dossiers17170600001466481706000014664850PA827982PM828718
17060000146699L17/dossiers17170600001466481706000014664851PA775268PM775574
17060000146700L17/dossiers17170600001466481706000014664852PA606375PM775602
17060000146701L17/dossiers17170600001466481706000014664853PA703505PM775679
17060000146702L17/dossiers17170600001466481706000014664854PA775274PM775560
17060000146703L17/dossiers17170600001466481706000014664855PA703511PM775685
17060000146704L17/dossiers17170600001466481706000014664856PA827994PM828782
17060000146705L17/dossiers17170600001466481706000014664857PA643028PM829316
17060000146706L17/dossiers17170600001466481706000014664858PA429889PM829767
17060000146707L17/dossiers17170600001466481706000014664859PA775290PM775576
17060000146708L17/dossiers17170600001466481706000014664860PA736217PM829873
17060000146709L17/dossiers17170600001466481706000014664861PA828010PM828832
17060000146710L17/dossiers17170600001466481706000014664862PA775294PM775580
17060000146711L17/dossiers17170600001466481706000014664863PA828014PM828818
17060000146712L17/dossiers17170600001466481706000014664864PA828018PM828882
17060000146713L17/dossiers17170600001466481706000014664865PA828022PM828870
17060000146727L17/dossiers1717060000146726170600001467261PA795516PM843452
17060000146731L17/dossiers1717060000146730170600001467301PA775248PM775554
17060000146732L17/dossiers1717060000146730170600001467302PA775202PM775502
17060000146739L17/dossiers1717060000146738170600001467381PA828004PM828838
17060000146746L17/dossiers1717060000146745170600001467451PA703532PM775699
17060000146753L17/dossiers1717060000146752170600001467521PA794270PM842972
17060000146767L17/dossiers1717060000146766170600001467661PA736233PM829889
17060000146774L17/dossiers1717060000146773170600001467731PA415446PM775783
17060000146794L17/dossiers1717060000146793170600001467931PA268048PM829731
17060000146801L17/dossiers1717060000146800170600001468001PA793444PM840270