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
17060000137393L17/dossiers17170600001373041706000013730489PA775276PM775566
17060000137394L17/dossiers17170600001373041706000013730490PA775280PM775586
17060000137395L17/dossiers17170600001373041706000013730491PA736227PM829901
17060000137396L17/dossiers17170600001373041706000013730492PA775284PM775590
17060000137397L17/dossiers17170600001373041706000013730493PA429874PM829753
17060000137398L17/dossiers17170600001373041706000013730494PA775286PM775588
17060000137399L17/dossiers17170600001373041706000013730495PA227094PM829735
17060000137400L17/dossiers17170600001373041706000013730496PA736207PM829847
17060000137401L17/dossiers17170600001373041706000013730497PA775288PM775578
17060000137402L17/dossiers17170600001373041706000013730498PA828008PM828826
17060000137403L17/dossiers17170600001373041706000013730499PA828012PM828812
17060000137404L17/dossiers171706000013730417060000137304100PA775298PM775594
17060000137405L17/dossiers171706000013730417060000137304101PA849534PM849592
17060000137412L17/dossiers1717060000137411170600001374111PA775264PM775570
17060000137419L17/dossiers1717060000137418170600001374181PA841729PM843287
17060000137456L17/dossiers1717060000137455170600001374551PA643210PM873637
17060000137457L17/dossiers1717060000137455170600001374552PA721134PM873687
17060000137458L17/dossiers1717060000137455170600001374553PA721670PM873693
17060000138178L17/dossiers1717060000138177170600001381771PA410PM855580
17060000138179L17/dossiers1717060000138177170600001381772PA721836PM855144
17060000138212L17/dossiers1717060000138211170600001382111PA588884PM840450
17060000138225L17/dossiers1717060000138224170600001382241PA410PM855580
17060000138232L17/dossiers1717060000138231170600001382311PA736196PM829865
17060000138233L17/dossiers1717060000138231170600001382312PA827958PM828690
17060000138240L17/dossiers1717060000138239170600001382391PA836345PM836353
17060000138247L17/dossiers1717060000138246170600001382461PA703514PM775661
17060000138254L17/dossiers1717060000138253170600001382531PA795108PM843338
17060000138261L17/dossiers1717060000138260170600001382601PA720430PM843092
17060000138268L17/dossiers1717060000138267170600001382671PA793736PM842693
17060000138275L17/dossiers1717060000138274170600001382741PA794906PM843284
17060000138283L17/dossiers1717060000138282170600001382821PA793852PM842684
17060000138287L17/dossiers1717060000138286170600001382861PA642756PM775779
17060000138288L17/dossiers1717060000138286170600001382862PA766947PM775799
17060000138295L17/dossiers1717060000138294170600001382941PA304017PM775757
17060000138315L17/dossiers1717060000138314170600001383141PA415486PM775813
17060000138365L17/dossiers1717060000138364170600001383641PA795844PM843515
17060000138372L17/dossiers1717060000138371170600001383711PA841893PM843449
17060000138379L17/dossiers1717060000138378170600001383781PA721474PM843608
17060000138386L17/dossiers1717060000138385170600001383851PA841931PM843485
17060000138399L17/dossiers1717060000138398170600001383981PA793330PM840249
17060000138406L17/dossiers1717060000138405170600001384051PA840903PM842543
17060000138413L17/dossiers1717060000138412170600001384121PA687214PM843686
17060000138420L17/dossiers1717060000138419170600001384191PA794166PM842924
17060000138427L17/dossiers1717060000138426170600001384261PA841563PM843134
17060000138434L17/dossiers1717060000138433170600001384331PA840889PM842534
17060000138441L17/dossiers1717060000138440170600001384401PA795136PM843353
17060000138448L17/dossiers1717060000138447170600001384471PA794198PM842876
17060000138455L17/dossiers1717060000138454170600001384541PA794198PM842876
17060000138462L17/dossiers1717060000138461170600001384611PA841575PM843143
17060000138469L17/dossiers1717060000138468170600001384681PA794486PM843110