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
17060000137343L17/dossiers17170600001373041706000013730439PA775220PM775526
17060000137344L17/dossiers17170600001373041706000013730440PA736218PM829869
17060000137345L17/dossiers17170600001373041706000013730441PA703520PM775705
17060000137346L17/dossiers17170600001373041706000013730442PA736169PM829791
17060000137347L17/dossiers17170600001373041706000013730443PA827938PM828646
17060000137348L17/dossiers17170600001373041706000013730444PA415454PM785875
17060000137349L17/dossiers17170600001373041706000013730445PA776985PM859248
17060000137350L17/dossiers17170600001373041706000013730446PA778908PM829661
17060000137351L17/dossiers17170600001373041706000013730447PA415486PM775813
17060000137352L17/dossiers17170600001373041706000013730448PA703530PM775689
17060000137353L17/dossiers17170600001373041706000013730449PA331381PM775739
17060000137354L17/dossiers17170600001373041706000013730450PA267081PM775733
17060000137355L17/dossiers17170600001373041706000013730451PA415495PM775635
17060000137356L17/dossiers17170600001373041706000013730452PA736238PM829895
17060000137357L17/dossiers17170600001373041706000013730453PA849522PM849644
17060000137358L17/dossiers17170600001373041706000013730454PA703515PM775663
17060000137359L17/dossiers17170600001373041706000013730455PA721130PM775608
17060000137360L17/dossiers17170600001373041706000013730456PA827952PM828698
17060000137361L17/dossiers17170600001373041706000013730457PA775240PM775530
17060000137362L17/dossiers17170600001373041706000013730458PA205280PM829891
17060000137363L17/dossiers17170600001373041706000013730459PA827954PM828704
17060000137364L17/dossiers17170600001373041706000013730460PA775242PM775528
17060000137365L17/dossiers17170600001373041706000013730461PA736246PM775819
17060000137366L17/dossiers17170600001373041706000013730462PA415451PM775787
17060000137367L17/dossiers17170600001373041706000013730463PA736211PM829879
17060000137368L17/dossiers17170600001373041706000013730464PA736186PM829807
17060000137369L17/dossiers17170600001373041706000013730465PA775248PM775554
17060000137370L17/dossiers17170600001373041706000013730466PA415447PM775785
17060000137371L17/dossiers17170600001373041706000013730467PA736213PM775791
17060000137372L17/dossiers17170600001373041706000013730468PA703537PM775721
17060000137373L17/dossiers17170600001373041706000013730469PA736185PM829813
17060000137374L17/dossiers17170600001373041706000013730470PA866550PM866552
17060000137375L17/dossiers17170600001373041706000013730471PA827964PM828652
17060000137376L17/dossiers17170600001373041706000013730472PA785193PM829743
17060000137377L17/dossiers17170600001373041706000013730473PA708632PM775667
17060000137378L17/dossiers17170600001373041706000013730474PA827970PM828758
17060000137379L17/dossiers17170600001373041706000013730475PA703517PM775675
17060000137380L17/dossiers17170600001373041706000013730476PA2197PM775755
17060000137381L17/dossiers17170600001373041706000013730477PA775258PM775544
17060000137382L17/dossiers17170600001373041706000013730478PA827974PM828744
17060000137383L17/dossiers17170600001373041706000013730479PA827976PM828724
17060000137384L17/dossiers17170600001373041706000013730480PA343988PM829809
17060000137385L17/dossiers17170600001373041706000013730481PA703521PM775707
17060000137386L17/dossiers17170600001373041706000013730482PA415479PM775805
17060000137387L17/dossiers17170600001373041706000013730483PA342523PM828470
17060000137388L17/dossiers17170600001373041706000013730484PA775270PM775572
17060000137389L17/dossiers17170600001373041706000013730485PA313924PM775727
17060000137390L17/dossiers17170600001373041706000013730486PA711156PM829933
17060000137391L17/dossiers17170600001373041706000013730487PA827988PM828788
17060000137392L17/dossiers17170600001373041706000013730488PA763158PM775683