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
17060000150922L17/dossiers1717060000150921170600001509211PA643210PM873637
17060000150939L17/dossiers1717060000150938170600001509381PA643210PM873637
17060000150946L17/dossiers1717060000150945170600001509451PA709298PM775773
17060000150947L17/dossiers1717060000150945170600001509452PA313924PM775727
17060000150954L17/dossiers1717060000150953170600001509531PA841769PM843323
17060000150961L17/dossiers1717060000150960170600001509601PA827958PM828690
17060000150962L17/dossiers1717060000150960170600001509602PA736196PM829865
17060000150969L17/dossiers1717060000150968170600001509681PA775286PM775588
17060000150976L17/dossiers1717060000150975170600001509751PA721908PM843467
17060000151007L17/dossiers1717060000151006170600001510061PA429886PM829757
17060000151008L17/dossiers1717060000151006170600001510062PA827930PM828544
17060000151009L17/dossiers1717060000151006170600001510063PA757676PM829801
17060000151010L17/dossiers1717060000151006170600001510064PA775172PM775474
17060000151011L17/dossiers1717060000151006170600001510065PA827898PM828454
17060000151012L17/dossiers1717060000151006170600001510066PA850008PM850016
17060000151013L17/dossiers1717060000151006170600001510067PA827912PM828488
17060000151014L17/dossiers1717060000151006170600001510068PA756685PM775777
17060000151015L17/dossiers1717060000151006170600001510069PA268007PM829695
17060000151016L17/dossiers17170600001510061706000015100610PA736195PM829855
17060000151017L17/dossiers17170600001510061706000015100611PA736173PM829799
17060000151018L17/dossiers17170600001510061706000015100612PA775246PM775532
17060000151019L17/dossiers17170600001510061706000015100613PA827962PM828676
17060000151020L17/dossiers17170600001510061706000015100614PA736243PM829929
17060000151021L17/dossiers17170600001510061706000015100615PA736175PM829795
17060000151022L17/dossiers17170600001510061706000015100616PA828002PM828856
17060000151023L17/dossiers17170600001510061706000015100617PA775296PM775596
17060000151024L17/dossiers17170600001510061706000015100618PA828020PM828864
17060000151031L17/dossiers1717060000151030170600001510301PA866550PM866552
17060000151032L17/dossiers1717060000151030170600001510302PA827928PM828538
17060000151033L17/dossiers1717060000151030170600001510303PA827902PM828442
17060000151041L17/dossiers1717060000151040170600001510401PA643210PM873637
17060000151096L17/dossiers1717060000151095170600001510951PA795552PM840408
17060000151100L17/dossiers1717060000151099170600001510991PA643210PM873637
17060000151108L17/dossiers1717060000151107170600001511071PA736206PM829849
17060000151115L17/dossiers1717060000151114170600001511141PA841451PM843035
17060000151119L17/dossiers1717060000151118170600001511181PA721474PM843608
17060000151123L17/dossiers1717060000151122170600001511221PA331381PM775739
17060000151130L17/dossiers1717060000151129170600001511291PA775290PM775576
17060000151137L17/dossiers1717060000151136170600001511361PA795636PM843476
17060000151141L17/dossiers1717060000151140170600001511401PA795422PM843599
17060000151145L17/dossiers1717060000151144170600001511441PA773891PM829713
17060000151146L17/dossiers1717060000151144170600001511442PA736229PM829923
17060000151147L17/dossiers1717060000151144170600001511443PA736208PM829881
17060000151148L17/dossiers1717060000151144170600001511444PA827904PM828514
17060000151149L17/dossiers1717060000151144170600001511445PA709298PM775773
17060000151156L17/dossiers1717060000151155170600001511551PA415446PM775783
17060000151157L17/dossiers1717060000151155170600001511552PA775270PM775572
17060000151164L17/dossiers1717060000151163170600001511631PA415488PM775641
17060000151165L17/dossiers1717060000151163170600001511632PA775200PM775504
17060000151166L17/dossiers1717060000151163170600001511633PA827940PM828622