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
17060000139397L17/dossiers17170600001393751706000013937522PA842187PM843704
17060000139398L17/dossiers17170600001393751706000013937523PA842037PM843578
17060000139399L17/dossiers17170600001393751706000013937524PA791812PM840384
17060000139400L17/dossiers17170600001393751706000013937525PA793736PM842693
17060000139401L17/dossiers17170600001393751706000013937526PA721202PM840435
17060000139402L17/dossiers17170600001393751706000013937527PA721210PM843677
17060000139403L17/dossiers17170600001393751706000013937528PA795136PM843353
17060000139404L17/dossiers17170600001393751706000013937529PA793452PM842453
17060000139405L17/dossiers17170600001393751706000013937530PA793464PM840273
17060000139406L17/dossiers17170600001393751706000013937531PA842155PM843674
17060000139407L17/dossiers17170600001393751706000013937532PA795200PM843386
17060000139408L17/dossiers17170600001393751706000013937533PA795844PM843515
17060000139409L17/dossiers17170600001393751706000013937534PA721896PM840405
17060000139410L17/dossiers17170600001393751706000013937535PA841251PM842837
17060000139411L17/dossiers17170600001393751706000013937536PA794786PM843242
17060000139412L17/dossiers17170600001393751706000013937537PA794870PM843185
17060000139413L17/dossiers17170600001393751706000013937538PA796070PM843746
17060000139414L17/dossiers17170600001393751706000013937539PA795310PM840453
17060000139415L17/dossiers17170600001393751706000013937540PA794478PM843107
17060000139416L17/dossiers17170600001393751706000013937541PA841947PM843503
17060000139417L17/dossiers17170600001393751706000013937542PA794082PM842810
17060000139418L17/dossiers17170600001393751706000013937543PA795998PM843737
17060000139419L17/dossiers17170600001393751706000013937544PA794130PM840297
17060000139420L17/dossiers17170600001393751706000013937545PA720846PM840441
17060000139421L17/dossiers17170600001393751706000013937546PA841729PM843287
17060000139422L17/dossiers17170600001393751706000013937547PA795516PM843452
17060000139423L17/dossiers17170600001393751706000013937548PA774962PM843731
17060000139424L17/dossiers17170600001393751706000013937549PA795672PM843752
17060000139425L17/dossiers17170600001393751706000013937550PA795746PM843584
17060000139426L17/dossiers17170600001393751706000013937551PA795108PM843338
17060000139427L17/dossiers17170600001393751706000013937552PA841515PM843089
17060000139428L17/dossiers17170600001393751706000013937553PA335612PM843398
17060000139429L17/dossiers17170600001393751706000013937554PA795298PM843683
17060000139430L17/dossiers17170600001393751706000013937555PA791824PM840375
17060000139431L17/dossiers17170600001393751706000013937556PA842029PM843575
17060000139432L17/dossiers17170600001393751706000013937557PA793532PM842591
17060000139433L17/dossiers17170600001393751706000013937558PA795636PM843476
17060000139434L17/dossiers17170600001393751706000013937559PA796010PM843743
17060000139435L17/dossiers17170600001393751706000013937560PA342384PM842771
17060000139436L17/dossiers17170600001393751706000013937561PA795422PM843599
17060000139437L17/dossiers17170600001393751706000013937562PA794686PM843080
17060000139438L17/dossiers17170600001393751706000013937563PA841215PM842801
17060000139439L17/dossiers17170600001393751706000013937564PA795482PM843605
17060000139440L17/dossiers17170600001393751706000013937565PA610654PM843719
17060000139441L17/dossiers17170600001393751706000013937566PA841191PM842789
17060000139442L17/dossiers17170600001393751706000013937567PA721960PM840378
17060000139443L17/dossiers17170600001393751706000013937568PA793872PM840285
17060000139444L17/dossiers17170600001393751706000013937569PA817211PM842600
17060000139445L17/dossiers17170600001393751706000013937570PA793756PM840282
17060000139446L17/dossiers17170600001393751706000013937571PA796062PM843668