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
17060000137127L17/dossiers17170600001370881706000013708839PA736241PM829931
17060000137128L17/dossiers17170600001370881706000013708840PA703509PM775687
17060000137129L17/dossiers17170600001370881706000013708841PA736181PM829839
17060000137130L17/dossiers17170600001370881706000013708842PA736225PM829907
17060000137131L17/dossiers17170600001370881706000013708843PA703536PM775719
17060000137132L17/dossiers17170600001370881706000013708844PA736229PM829923
17060000137133L17/dossiers17170600001370881706000013708845PA605888PM775604
17060000137134L17/dossiers17170600001370881706000013708846PA607761PM828556
17060000137135L17/dossiers17170600001370881706000013708847PA415449PM775793
17060000137136L17/dossiers17170600001370881706000013708848PA342564PM829509
17060000137137L17/dossiers17170600001370881706000013708849PA268048PM829731
17060000137138L17/dossiers17170600001370881706000013708850PA2074PM775677
17060000137139L17/dossiers17170600001370881706000013708851PA703512PM775665
17060000137140L17/dossiers17170600001370881706000013708852PA610850PM828634
17060000137141L17/dossiers17170600001370881706000013708853PA827980PM828710
17060000137142L17/dossiers17170600001370881706000013708854PA827982PM828718
17060000137143L17/dossiers17170600001370881706000013708855PA606375PM775602
17060000137144L17/dossiers17170600001370881706000013708856PA703505PM775679
17060000137145L17/dossiers17170600001370881706000013708857PA703511PM775685
17060000137146L17/dossiers17170600001370881706000013708858PA827994PM828782
17060000137147L17/dossiers17170600001370881706000013708859PA643028PM829316
17060000137148L17/dossiers17170600001370881706000013708860PA429889PM829767
17060000137149L17/dossiers17170600001370881706000013708861PA736214PM829883
17060000137150L17/dossiers17170600001370881706000013708862PA775294PM775580
17060000137151L17/dossiers17170600001370881706000013708863PA828014PM828818
17060000137152L17/dossiers17170600001370881706000013708864PA828018PM828882
17060000137153L17/dossiers17170600001370881706000013708865PA828022PM828870
17060000137160L17/dossiers1717060000137159170600001371591PA736224PM829913
17060000137161L17/dossiers1717060000137159170600001371592PA736206PM829849
17060000137162L17/dossiers1717060000137159170600001371593PA343988PM829809
17060000137163L17/dossiers1717060000137159170600001371594PA775176PM775462
17060000137164L17/dossiers1717060000137159170600001371595PA773891PM829713
17060000137165L17/dossiers1717060000137159170600001371596PA703532PM775699
17060000137166L17/dossiers1717060000137159170600001371597PA775196PM775482
17060000137167L17/dossiers1717060000137159170600001371598PA827914PM828494
17060000137168L17/dossiers1717060000137159170600001371599PA760322PM775649
17060000137169L17/dossiers17170600001371591706000013715910PA775202PM775502
17060000137170L17/dossiers17170600001371591706000013715911PA827918PM828482
17060000137171L17/dossiers17170600001371591706000013715912PA703510PM859251
17060000137172L17/dossiers17170600001371591706000013715913PA703534PM775695
17060000137173L17/dossiers17170600001371591706000013715914PA775208PM775494
17060000137174L17/dossiers17170600001371591706000013715915PA736192PM829859
17060000137175L17/dossiers17170600001371591706000013715916PA784534PM784544
17060000137176L17/dossiers17170600001371591706000013715917PA703498PM829449
17060000137177L17/dossiers17170600001371591706000013715918PA775216PM775522
17060000137178L17/dossiers17170600001371591706000013715919PA775220PM775526
17060000137179L17/dossiers17170600001371591706000013715920PA776985PM859248
17060000137180L17/dossiers17170600001371591706000013715921PA267081PM775733
17060000137181L17/dossiers17170600001371591706000013715922PA736223PM829877
17060000137182L17/dossiers17170600001371591706000013715923PA848377PM848383