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
17060000146366L17/dossiers1717060000146365170600001463651PA841729PM843287
17060000146373L17/dossiers1717060000146372170600001463721PA342196PM842807
17060000146380L17/dossiers1717060000146379170600001463791PA569PM843512
17060000146387L17/dossiers1717060000146386170600001463861PA330240PM842357
17060000146394L17/dossiers1717060000146393170600001463931PA793322PM840246
17060000146401L17/dossiers1717060000146400170600001464001PA840979PM842588
17060000146408L17/dossiers1717060000146407170600001464071PA842125PM843641
17060000146431L17/dossiers1717060000146430170600001464301PA687214PM843686
17060000146446L17/dossiers1717060000146445170600001464451PA841431PM843017
17060000146461L17/dossiers1717060000146460170600001464601PA642868PM858305
17060000146472L17/dossiers1717060000146471170600001464711PA793398PM842489
17060000146483L17/dossiers1717060000146482170600001464821PA722070PM843548
17060000146504L17/dossiers1717060000146503170600001465031PA841151PM874938
17060000146511L17/dossiers1717060000146510170600001465101PA817211PM842600
17060000146518L17/dossiers1717060000146517170600001465171PA795422PM843599
17060000146525L17/dossiers1717060000146524170600001465241PA841885PM843446
17060000146532L17/dossiers1717060000146531170600001465311PA795820PM843713
17060000146539L17/dossiers1717060000146538170600001465381PA643089PM858443
17060000146546L17/dossiers1717060000146545170600001465451PA722134PM843497
17060000146554L17/dossiers1717060000146553170600001465531PA793736PM842693
17060000146561L17/dossiers1717060000146560170600001465601PA607553PM843059
17060000146568L17/dossiers1717060000146567170600001465671PA643210PM873637
17060000146602L17/dossiers1717060000146601170600001466011PA415447PM775785
17060000146609L17/dossiers1717060000146608170600001466081PA429832PM829723
17060000146634L17/dossiers1717060000146633170600001466331PA840903PM842543
17060000146649L17/dossiers1717060000146648170600001466481PA775210PM775492
17060000146650L17/dossiers1717060000146648170600001466482PA736214PM829883
17060000146651L17/dossiers1717060000146648170600001466483PA702993PM829493
17060000146652L17/dossiers1717060000146648170600001466484PA736219PM829867
17060000146653L17/dossiers1717060000146648170600001466485PA827900PM828434
17060000146654L17/dossiers1717060000146648170600001466486PA775186PM775484
17060000146655L17/dossiers1717060000146648170600001466487PA415488PM775641
17060000146656L17/dossiers1717060000146648170600001466488PA775194PM775476
17060000146657L17/dossiers1717060000146648170600001466489PA775196PM775482
17060000146658L17/dossiers17170600001466481706000014664810PA775200PM775504
17060000146659L17/dossiers17170600001466481706000014664811PA642982PM829146
17060000146660L17/dossiers17170600001466481706000014664812PA827920PM828574
17060000146661L17/dossiers17170600001466481706000014664813PA775206PM775506
17060000146662L17/dossiers17170600001466481706000014664814PA590034PM775606
17060000146663L17/dossiers17170600001466481706000014664815PA827924PM828550
17060000146664L17/dossiers17170600001466481706000014664816PA785855PM785869
17060000146665L17/dossiers17170600001466481706000014664817PA736234PM829887
17060000146666L17/dossiers17170600001466481706000014664818PA429835PM829719
17060000146667L17/dossiers17170600001466481706000014664819PA712422PM828926
17060000146668L17/dossiers17170600001466481706000014664820PA827932PM828526
17060000146669L17/dossiers17170600001466481706000014664821PA736167PM829803
17060000146670L17/dossiers17170600001466481706000014664822PA732419PM775647
17060000146671L17/dossiers17170600001466481706000014664823PA429867PM829751
17060000146672L17/dossiers17170600001466481706000014664824PA429833PM829725
17060000146673L17/dossiers17170600001466481706000014664825PA827940PM828622