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
17060000130635L17/dossiers17170600001306231706000013062312PA827978PM828730
17060000130636L17/dossiers17170600001306231706000013062313PA775272PM775562
17060000130637L17/dossiers17170600001306231706000013062314PA775282PM775584
17060000130638L17/dossiers17170600001306231706000013062315PA828000PM828850
17060000130639L17/dossiers17170600001306231706000013062316PA828004PM828838
17060000130646L17/dossiers1717060000130645170600001306451PA775300PM775600
17060000130681L17/dossiers1717060000130680170600001306801PA719778PM842744
17060000130685L17/dossiers1717060000130684170600001306841PA841633PM843182
17060000130701L17/dossiers1717060000130700170600001307001PA793736PM842693
17060000130708L17/dossiers1717060000130707170600001307071PA643028PM829316
17060000130730L17/dossiers1717060000130729170600001307291PA335054PM843332
17060000130740L17/dossiers1717060000130739170600001307391PA703541PM775725
17060000130747L17/dossiers1717060000130746170600001307461PA778908PM829661
17060000130748L17/dossiers1717060000130746170600001307462PA736207PM829847
17060000130749L17/dossiers1717060000130746170600001307463PA775202PM775502
17060000130750L17/dossiers1717060000130746170600001307464PA827954PM828704
17060000130751L17/dossiers1717060000130746170600001307465PA775284PM775590
17060000130752L17/dossiers1717060000130746170600001307466PA703520PM775705
17060000130753L17/dossiers1717060000130746170600001307467PA415454PM785875
17060000130754L17/dossiers1717060000130746170600001307468PA267328PM775729
17060000130755L17/dossiers1717060000130746170600001307469PA775276PM775566
17060000130756L17/dossiers17170600001307461706000013074610PA736227PM829901
17060000130757L17/dossiers17170600001307461706000013074611PA775258PM775544
17060000130758L17/dossiers17170600001307461706000013074612PA736216PM829875
17060000130759L17/dossiers17170600001307461706000013074613PA415451PM775787
17060000130760L17/dossiers17170600001307461706000013074614PA827964PM828652
17060000130761L17/dossiers17170600001307461706000013074615PA703500PM775643
17060000130762L17/dossiers17170600001307461706000013074616PA828012PM828812
17060000130763L17/dossiers17170600001307461706000013074617PA775220PM775526
17060000130764L17/dossiers17170600001307461706000013074618PA415462PM775797
17060000130765L17/dossiers17170600001307461706000013074619PA721130PM775608
17060000130766L17/dossiers17170600001307461706000013074620PA827988PM828788
17060000130767L17/dossiers17170600001307461706000013074621PA775212PM775500
17060000130768L17/dossiers17170600001307461706000013074622PA736238PM829895
17060000130769L17/dossiers17170600001307461706000013074623PA1001PM829905
17060000130770L17/dossiers17170600001307461706000013074624PA736239PM829893
17060000130771L17/dossiers17170600001307461706000013074625PA775174PM775472
17060000130772L17/dossiers17170600001307461706000013074626PA736185PM829813
17060000130773L17/dossiers17170600001307461706000013074627PA775192PM775478
17060000130774L17/dossiers17170600001307461706000013074628PA775288PM775578
17060000130775L17/dossiers17170600001307461706000013074629PA827952PM828698
17060000130776L17/dossiers17170600001307461706000013074630PA859244PM859246
17060000130777L17/dossiers17170600001307461706000013074631PA775216PM775522
17060000130778L17/dossiers17170600001307461706000013074632PA267081PM775733
17060000130779L17/dossiers17170600001307461706000013074633PA703513PM775671
17060000130780L17/dossiers17170600001307461706000013074634PA426327PM775735
17060000130781L17/dossiers17170600001307461706000013074635PA773891PM829713
17060000130782L17/dossiers17170600001307461706000013074636PA715322PM775713
17060000130783L17/dossiers17170600001307461706000013074637PA775280PM775586
17060000130784L17/dossiers17170600001307461706000013074638PA763158PM775683