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
17060000128556L17/dossiers1717060000128555170600001285551PA794206PM842879
17060000128563L17/dossiers1717060000128562170600001285621PA805166PM849145
17060000128576L17/dossiers1717060000128575170600001285751PA794114PM842888
17060000128583L17/dossiers1717060000128582170600001285821PA267318PM843341
17060000128628L17/dossiers1717060000128627170600001286271PA793122PM842369
17060000128635L17/dossiers1717060000128634170600001286341PA719024PM842390
17060000128642L17/dossiers1717060000128641170600001286411PA795010PM840354
17060000128643L17/dossiers1717060000128641170600001286412PA721426PM843356
17060000128705L17/dossiers1717060000128704170600001287041PA429889PM829767
17060000128706L17/dossiers1717060000128704170600001287042PA429889PM829767
17060000128707L17/dossiers1717060000128704170600001287043PA775196PM775482
17060000128708L17/dossiers1717060000128704170600001287044PA702993PM829493
17060000128709L17/dossiers1717060000128704170600001287045PA736219PM829867
17060000128710L17/dossiers1717060000128704170600001287046PA827900PM828434
17060000128711L17/dossiers1717060000128704170600001287047PA775186PM775484
17060000128712L17/dossiers1717060000128704170600001287048PA415488PM775641
17060000128713L17/dossiers1717060000128704170600001287049PA775194PM775476
17060000128714L17/dossiers17170600001287041706000012870410PA775200PM775504
17060000128715L17/dossiers17170600001287041706000012870411PA642982PM829146
17060000128716L17/dossiers17170600001287041706000012870412PA827920PM828574
17060000128717L17/dossiers17170600001287041706000012870413PA775206PM775506
17060000128718L17/dossiers17170600001287041706000012870414PA590034PM775606
17060000128719L17/dossiers17170600001287041706000012870415PA827924PM828550
17060000128720L17/dossiers17170600001287041706000012870416PA785855PM785869
17060000128721L17/dossiers17170600001287041706000012870417PA736234PM829887
17060000128722L17/dossiers17170600001287041706000012870418PA429835PM829719
17060000128723L17/dossiers17170600001287041706000012870419PA429835PM829719
17060000128724L17/dossiers17170600001287041706000012870420PA775210PM775492
17060000128725L17/dossiers17170600001287041706000012870421PA712422PM828926
17060000128726L17/dossiers17170600001287041706000012870422PA827932PM828526
17060000128727L17/dossiers17170600001287041706000012870423PA732419PM775647
17060000128728L17/dossiers17170600001287041706000012870424PA732419PM775647
17060000128729L17/dossiers17170600001287041706000012870425PA703538PM775715
17060000128730L17/dossiers17170600001287041706000012870426PA429867PM829751
17060000128731L17/dossiers17170600001287041706000012870427PA429833PM829725
17060000128732L17/dossiers17170600001287041706000012870428PA827940PM828622
17060000128733L17/dossiers17170600001287041706000012870429PA736191PM829819
17060000128734L17/dossiers17170600001287041706000012870430PA708633PM775669
17060000128735L17/dossiers17170600001287041706000012870431PA415477PM775809
17060000128736L17/dossiers17170600001287041706000012870432PA415477PM775809
17060000128737L17/dossiers17170600001287041706000012870433PA766947PM775799
17060000128738L17/dossiers17170600001287041706000012870434PA642756PM775779
17060000128739L17/dossiers17170600001287041706000012870435PA736241PM829931
17060000128740L17/dossiers17170600001287041706000012870436PA703509PM775687
17060000128741L17/dossiers17170600001287041706000012870437PA736181PM829839
17060000128742L17/dossiers17170600001287041706000012870438PA736225PM829907
17060000128743L17/dossiers17170600001287041706000012870439PA703536PM775719
17060000128744L17/dossiers17170600001287041706000012870440PA736229PM829923
17060000128745L17/dossiers17170600001287041706000012870441PA736167PM829803
17060000128746L17/dossiers17170600001287041706000012870442PA605888PM775604