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
17060000119743L17/dossiers17170600001197201706000011972023PA736217PM829873
17060000119744L17/dossiers17170600001197201706000011972024PA828014PM828818
17060000119745L17/dossiers17170600001197201706000011972025PA828018PM828882
17060000119755L17/dossiers1717060000119754170600001197541PA722190PM833697
17060000119787L17/dossiers1717060000119786170600001197861PA827904PM828514
17060000119797L17/dossiers1717060000119796170600001197961PA793362PM842465
17060000119801L17/dossiers1717060000119800170600001198001PA721908PM843467
17060000119805L17/dossiers1717060000119804170600001198041PA775192PM775478
17060000119812L17/dossiers1717060000119811170600001198111PA268048PM829731
17060000119819L17/dossiers1717060000119818170600001198181PA267081PM775733
17060000119820L17/dossiers1717060000119818170600001198182PA2538PM775801
17060000119821L17/dossiers1717060000119818170600001198183PA703513PM775671
17060000119822L17/dossiers1717060000119818170600001198184PA736239PM829893
17060000119823L17/dossiers1717060000119818170600001198185PA775288PM775578
17060000119824L17/dossiers1717060000119818170600001198186PA267112PM775737
17060000119825L17/dossiers1717060000119818170600001198187PA736200PM829845
17060000119826L17/dossiers1717060000119818170600001198188PA736202PM775775
17060000119827L17/dossiers1717060000119818170600001198189PA415447PM775785
17060000119828L17/dossiers17170600001198181706000011981810PA775184PM775486
17060000119829L17/dossiers17170600001198181706000011981811PA703494PM775651
17060000119830L17/dossiers17170600001198181706000011981812PA703520PM775705
17060000119831L17/dossiers17170600001198181706000011981813PA828012PM828812
17060000119832L17/dossiers17170600001198181706000011981814PA415451PM775787
17060000119833L17/dossiers17170600001198181706000011981815PA775212PM775500
17060000119834L17/dossiers17170600001198181706000011981816PA775202PM775502
17060000119835L17/dossiers17170600001198181706000011981817PA736207PM829847
17060000119836L17/dossiers17170600001198181706000011981818PA775302PM775598
17060000119837L17/dossiers17170600001198181706000011981819PA775176PM775462
17060000119838L17/dossiers17170600001198181706000011981820PA775292PM775582
17060000119839L17/dossiers17170600001198181706000011981821PA827984PM828800
17060000119840L17/dossiers17170600001198181706000011981822PA736216PM829875
17060000119841L17/dossiers17170600001198181706000011981823PA775298PM775594
17060000119842L17/dossiers17170600001198181706000011981824PA267340PM775731
17060000119843L17/dossiers17170600001198181706000011981825PA736246PM775819
17060000119844L17/dossiers17170600001198181706000011981826PA703540PM775723
17060000119845L17/dossiers17170600001198181706000011981827PA827988PM828788
17060000119846L17/dossiers17170600001198181706000011981828PA342523PM828470
17060000119847L17/dossiers17170600001198181706000011981829PA736185PM829813
17060000119848L17/dossiers17170600001198181706000011981830PA785193PM829743
17060000119849L17/dossiers17170600001198181706000011981831PA827974PM828744
17060000119850L17/dossiers17170600001198181706000011981832PA703500PM775643
17060000119851L17/dossiers17170600001198181706000011981833PA775220PM775526
17060000119852L17/dossiers17170600001198181706000011981834PA773891PM829713
17060000119859L17/dossiers1717060000119858170600001198581PA828008PM828826
17060000119866L17/dossiers1717060000119865170600001198651PA785857PM785867
17060000119867L17/dossiers1717060000119865170600001198652PA775180PM775466
17060000119868L17/dossiers1717060000119865170600001198653PA827904PM828514
17060000119869L17/dossiers1717060000119865170600001198654PA429845PM829729
17060000119870L17/dossiers1717060000119865170600001198655PA775214PM775498
17060000119871L17/dossiers1717060000119865170600001198656PA775224PM775512