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
17060000150437L17/dossiers1717060000150429170600001504298PA827930PM828544
17060000150438L17/dossiers1717060000150429170600001504299PA429886PM829757
17060000150439L17/dossiers17170600001504291706000015042910PA736195PM829855
17060000150440L17/dossiers17170600001504291706000015042911PA736173PM829799
17060000150441L17/dossiers17170600001504291706000015042912PA775246PM775532
17060000150442L17/dossiers17170600001504291706000015042913PA827962PM828676
17060000150443L17/dossiers17170600001504291706000015042914PA736243PM829929
17060000150444L17/dossiers17170600001504291706000015042915PA736175PM829795
17060000150445L17/dossiers17170600001504291706000015042916PA828002PM828856
17060000150446L17/dossiers17170600001504291706000015042917PA775296PM775596
17060000150447L17/dossiers17170600001504291706000015042918PA828020PM828864
17060000150454L17/dossiers1717060000150453170600001504531PA827922PM856930
17060000150455L17/dossiers1717060000150453170600001504532PA827922PM856930
17060000150462L17/dossiers1717060000150461170600001504611PA827922PM856930
17060000150463L17/dossiers1717060000150461170600001504612PA827922PM856930
17060000150470L17/dossiers1717060000150469170600001504691PA703513PM775671
17060000150477L17/dossiers1717060000150476170600001504761PA268048PM829731
17060000150478L17/dossiers1717060000150476170600001504762PA827924PM828550
17060000150479L17/dossiers1717060000150476170600001504763PA702993PM829493
17060000150480L17/dossiers1717060000150476170600001504764PA736219PM829867
17060000150481L17/dossiers1717060000150476170600001504765PA827900PM828434
17060000150482L17/dossiers1717060000150476170600001504766PA775186PM775484
17060000150483L17/dossiers1717060000150476170600001504767PA415488PM775641
17060000150484L17/dossiers1717060000150476170600001504768PA775194PM775476
17060000150485L17/dossiers1717060000150476170600001504769PA775196PM775482
17060000150486L17/dossiers17170600001504761706000015047610PA775200PM775504
17060000150487L17/dossiers17170600001504761706000015047611PA642982PM829146
17060000150488L17/dossiers17170600001504761706000015047612PA827920PM828574
17060000150489L17/dossiers17170600001504761706000015047613PA775206PM775506
17060000150490L17/dossiers17170600001504761706000015047614PA590034PM775606
17060000150491L17/dossiers17170600001504761706000015047615PA785855PM785869
17060000150492L17/dossiers17170600001504761706000015047616PA736234PM829887
17060000150493L17/dossiers17170600001504761706000015047617PA429835PM829719
17060000150494L17/dossiers17170600001504761706000015047618PA429835PM829719
17060000150495L17/dossiers17170600001504761706000015047619PA775210PM775492
17060000150496L17/dossiers17170600001504761706000015047620PA712422PM828926
17060000150497L17/dossiers17170600001504761706000015047621PA827932PM828526
17060000150498L17/dossiers17170600001504761706000015047622PA736167PM829803
17060000150499L17/dossiers17170600001504761706000015047623PA732419PM775647
17060000150500L17/dossiers17170600001504761706000015047624PA732419PM775647
17060000150501L17/dossiers17170600001504761706000015047625PA429867PM829751
17060000150502L17/dossiers17170600001504761706000015047626PA429833PM829725
17060000150503L17/dossiers17170600001504761706000015047627PA827940PM828622
17060000150504L17/dossiers17170600001504761706000015047628PA736191PM829819
17060000150505L17/dossiers17170600001504761706000015047629PA708633PM775669
17060000150506L17/dossiers17170600001504761706000015047630PA415477PM775809
17060000150507L17/dossiers17170600001504761706000015047631PA415477PM775809
17060000150508L17/dossiers17170600001504761706000015047632PA766947PM775799
17060000150509L17/dossiers17170600001504761706000015047633PA642756PM775779
17060000150510L17/dossiers17170600001504761706000015047634PA736241PM829931