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
17060000119020L17/dossiers17170600001189301706000011893090PA775298PM775594
17060000119021L17/dossiers17170600001189301706000011893091PA703527PM775709
17060000119040L17/dossiers1717060000119039170600001190391PA736169PM829791
17060000119064L17/dossiers1717060000119063170600001190631PA721166PM785865
17060000119065L17/dossiers1717060000119063170600001190632PA736188PM829827
17060000119075L17/dossiers1717060000119074170600001190741PA722190PM833697
17060000119076L17/dossiers1717060000119074170600001190742PA719938PM833702
17060000119167L17/dossiers1717060000119166170600001191661PA736233PM829889
17060000119191L17/dossiers1717060000119190170600001191901PA736190PM829825
17060000119209L17/dossiers1717060000119208170600001192081PA703500PM775643
17060000119210L17/dossiers1717060000119208170600001192082PA703518PM775673
17060000119243L17/dossiers1717060000119242170600001192421PA720692PM796986
17060000119291L17/dossiers1717060000119290170600001192901PA722190PM833697
17060000119330L17/dossiers1717060000119329170600001193291PA722190PM833697
17060000119362L17/dossiers1717060000119361170600001193611PA703532PM775699
17060000119363L17/dossiers1717060000119361170600001193612PA2538PM775801
17060000119364L17/dossiers1717060000119361170600001193613PA266795PM775711
17060000119397L17/dossiers1717060000119396170600001193961PA703530PM775689
17060000119398L17/dossiers1717060000119396170600001193962PA703520PM775705
17060000119465L17/dossiers1717060000119464170600001194641PA267673PM775865
17060000119500L17/dossiers1717060000119499170600001194991PA722190PM833697
17060000119584L17/dossiers1717060000119583170600001195831PA775170PM775468
17060000119627L17/dossiers1717060000119626170600001196261PA722190PM833697
17060000119628L17/dossiers1717060000119626170600001196262PA842137PM833737
17060000119660L17/dossiers1717060000119659170600001196591PA775182PM775464
17060000119670L17/dossiers1717060000119669170600001196691PA736211PM829879
17060000119688L17/dossiers1717060000119687170600001196871PA303997PM775743
17060000119689L17/dossiers1717060000119687170600001196872PA569PM775717
17060000119721L17/dossiers1717060000119720170600001197201PA415477PM775809
17060000119722L17/dossiers1717060000119720170600001197202PA415477PM775809
17060000119723L17/dossiers1717060000119720170600001197203PA827900PM828434
17060000119724L17/dossiers1717060000119720170600001197204PA415488PM775641
17060000119725L17/dossiers1717060000119720170600001197205PA775194PM775476
17060000119726L17/dossiers1717060000119720170600001197206PA775196PM775482
17060000119727L17/dossiers1717060000119720170600001197207PA827920PM828574
17060000119728L17/dossiers1717060000119720170600001197208PA590034PM775606
17060000119729L17/dossiers1717060000119720170600001197209PA827924PM828550
17060000119730L17/dossiers17170600001197201706000011972010PA785855PM785869
17060000119731L17/dossiers17170600001197201706000011972011PA429835PM829719
17060000119732L17/dossiers17170600001197201706000011972012PA732419PM775647
17060000119733L17/dossiers17170600001197201706000011972013PA827940PM828622
17060000119734L17/dossiers17170600001197201706000011972014PA642756PM775779
17060000119735L17/dossiers17170600001197201706000011972015PA736241PM829931
17060000119736L17/dossiers17170600001197201706000011972016PA736181PM829839
17060000119737L17/dossiers17170600001197201706000011972017PA703536PM775719
17060000119738L17/dossiers17170600001197201706000011972018PA775256PM775546
17060000119739L17/dossiers17170600001197201706000011972019PA610850PM828634
17060000119740L17/dossiers17170600001197201706000011972020PA775274PM775560
17060000119741L17/dossiers17170600001197201706000011972021PA643028PM829316
17060000119742L17/dossiers17170600001197201706000011972022PA736214PM829883