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
17060000147325L17/dossiers17170600001472841706000014728441PA605888PM775604
17060000147326L17/dossiers17170600001472841706000014728442PA607761PM828556
17060000147327L17/dossiers17170600001472841706000014728443PA342564PM829509
17060000147328L17/dossiers17170600001472841706000014728444PA268048PM829731
17060000147329L17/dossiers17170600001472841706000014728445PA2074PM775677
17060000147330L17/dossiers17170600001472841706000014728446PA873607PM873611
17060000147331L17/dossiers17170600001472841706000014728447PA775254PM775556
17060000147332L17/dossiers17170600001472841706000014728448PA775256PM775546
17060000147333L17/dossiers17170600001472841706000014728449PA643211PM775749
17060000147334L17/dossiers17170600001472841706000014728450PA610850PM828634
17060000147335L17/dossiers17170600001472841706000014728451PA827980PM828710
17060000147336L17/dossiers17170600001472841706000014728452PA827982PM828718
17060000147337L17/dossiers17170600001472841706000014728453PA775268PM775574
17060000147338L17/dossiers17170600001472841706000014728454PA606375PM775602
17060000147339L17/dossiers17170600001472841706000014728455PA703505PM775679
17060000147340L17/dossiers17170600001472841706000014728456PA775274PM775560
17060000147341L17/dossiers17170600001472841706000014728457PA827994PM828782
17060000147342L17/dossiers17170600001472841706000014728458PA429889PM829767
17060000147343L17/dossiers17170600001472841706000014728459PA775290PM775576
17060000147344L17/dossiers17170600001472841706000014728460PA736214PM829883
17060000147345L17/dossiers17170600001472841706000014728461PA736217PM829873
17060000147346L17/dossiers17170600001472841706000014728462PA828010PM828832
17060000147347L17/dossiers17170600001472841706000014728463PA775294PM775580
17060000147348L17/dossiers17170600001472841706000014728464PA828014PM828818
17060000147349L17/dossiers17170600001472841706000014728465PA828018PM828882
17060000147356L17/dossiers1717060000147355170600001473551PA267241PM778080
17060000147363L17/dossiers1717060000147362170600001473621PA827930PM828544
17060000147364L17/dossiers1717060000147362170600001473622PA775172PM775474
17060000147365L17/dossiers1717060000147362170600001473623PA736243PM829929
17060000147366L17/dossiers1717060000147362170600001473624PA757676PM829801
17060000147367L17/dossiers1717060000147362170600001473625PA827898PM828454
17060000147368L17/dossiers1717060000147362170600001473626PA850008PM850016
17060000147369L17/dossiers1717060000147362170600001473627PA827912PM828488
17060000147370L17/dossiers1717060000147362170600001473628PA756685PM775777
17060000147371L17/dossiers1717060000147362170600001473629PA268007PM829695
17060000147372L17/dossiers17170600001473621706000014736210PA429886PM829757
17060000147373L17/dossiers17170600001473621706000014736211PA736195PM829855
17060000147374L17/dossiers17170600001473621706000014736212PA736173PM829799
17060000147375L17/dossiers17170600001473621706000014736213PA775246PM775532
17060000147376L17/dossiers17170600001473621706000014736214PA827962PM828676
17060000147377L17/dossiers17170600001473621706000014736215PA736175PM829795
17060000147378L17/dossiers17170600001473621706000014736216PA828002PM828856
17060000147379L17/dossiers17170600001473621706000014736217PA775296PM775596
17060000147380L17/dossiers17170600001473621706000014736218PA828020PM828864
17060000147387L17/dossiers1717060000147386170600001473861PA703518PM775673
17060000147388L17/dossiers1717060000147386170600001473862PA342564PM829509
17060000147389L17/dossiers1717060000147386170600001473863PA702993PM829493
17060000147390L17/dossiers1717060000147386170600001473864PA736206PM829849
17060000147416L17/dossiers1717060000147415170600001474151PA268048PM829731
17060000147423L17/dossiers1717060000147422170600001474221PA736243PM829929