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
17060000115718L17/dossiers17170600001156811706000011568137PA736217PM736384
17060000115719L17/dossiers17170600001156811706000011568138PA227096PM736342
17060000115720L17/dossiers17170600001156811706000011568139PA227096PM736342
17060000115721L17/dossiers17170600001156811706000011568140PA775294PM775580
17060000115722L17/dossiers17170600001156811706000011568141PA2870PM736316
17060000115723L17/dossiers17170600001156811706000011568142PA2870PM736316
17060000115724L17/dossiers17170600001156811706000011568143PA736162PM736320
17060000115725L17/dossiers17170600001156811706000011568144PA429852PM736275
17060000115753L17/dossiers1717060000115752170600001157521PA304017PM775757
17060000115754L17/dossiers1717060000115752170600001157522PA736216PM736273
17060000115755L17/dossiers1717060000115752170600001157523PA736243PM736413
17060000115756L17/dossiers1717060000115752170600001157524PA736182PM736346
17060000115757L17/dossiers1717060000115752170600001157525PA775250PM775552
17060000115758L17/dossiers1717060000115752170600001157526PA736230PM736377
17060000115759L17/dossiers1717060000115752170600001157527PA775226PM775510
17060000115760L17/dossiers1717060000115752170600001157528PA775198PM775480
17060000115761L17/dossiers1717060000115752170600001157529PA331381PM775739
17060000115762L17/dossiers17170600001157521706000011575210PA758431PM758701
17060000115763L17/dossiers17170600001157521706000011575211PA267762PM736366
17060000115764L17/dossiers17170600001157521706000011575212PA736192PM736353
17060000115765L17/dossiers17170600001157521706000011575213PA703501PM775645
17060000115766L17/dossiers17170600001157521706000011575214PA703532PM775699
17060000115767L17/dossiers17170600001157521706000011575215PA736200PM736285
17060000115768L17/dossiers17170600001157521706000011575216PA775286PM775588
17060000115769L17/dossiers17170600001157521706000011575217PA736166PM775765
17060000115770L17/dossiers17170600001157521706000011575218PA736167PM736327
17060000115771L17/dossiers17170600001157521706000011575219PA775302PM775598
17060000115772L17/dossiers17170600001157521706000011575220PA775216PM775522
17060000115773L17/dossiers17170600001157521706000011575221PA429874PM736314
17060000115774L17/dossiers17170600001157521706000011575222PA703512PM775665
17060000115775L17/dossiers17170600001157521706000011575223PA703511PM775685
17060000115776L17/dossiers17170600001157521706000011575224PA429855PM736425
17060000115804L17/dossiers1717060000115803170600001158031PA719874PM722786
17060000115860L17/dossiers1717060000115859170600001158591PA720846PM723094
17060000115899L17/dossiers1717060000115898170600001158981PA736223PM736368
17060000115927L17/dossiers1717060000115926170600001159261PA425322PM736282
17060000115928L17/dossiers1717060000115926170600001159262PA736160PM736359
17060000115957L17/dossiers1717060000115956170600001159561PA703498PM736260
17060000115980L17/dossiers1717060000115979170600001159791PA267081PM775733
17060000116011L17/dossiers1717060000116010170600001160101PA2538PM775801
17060000116012L17/dossiers1717060000116010170600001160102PA425322PM736282
17060000116013L17/dossiers1717060000116010170600001160103PA775284PM775590
17060000116014L17/dossiers1717060000116010170600001160104PA703540PM775723
17060000116015L17/dossiers1717060000116010170600001160105PA775168PM775470
17060000116016L17/dossiers1717060000116010170600001160106PA736247PM736281
17060000116017L17/dossiers1717060000116010170600001160107PA775174PM775472
17060000116018L17/dossiers1717060000116010170600001160108PA736180PM785871
17060000116019L17/dossiers1717060000116010170600001160109PA736180PM785871
17060000116020L17/dossiers17170600001160101706000011601010PA429858PM736268
17060000116021L17/dossiers17170600001160101706000011601011PA744079PM744082