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
17060000114596L17/dossiers1717060000114587170600001145879PA736181PM736416
17060000114597L17/dossiers17170600001145871706000011458710PA703533PM703593
17060000114598L17/dossiers17170600001145871706000011458711PA268048PM736422
17060000114599L17/dossiers17170600001145871706000011458712PA703511PM703635
17060000114600L17/dossiers17170600001145871706000011458713PA736201PM736347
17060000114601L17/dossiers17170600001145871706000011458714PA736214PM736290
17060000114630L17/dossiers1717060000114629170600001146291PA736169PM736293
17060000114659L17/dossiers1717060000114658170600001146581PA415446PM703678
17060000114660L17/dossiers1717060000114658170600001146582PA736158PM736414
17060000114688L17/dossiers1717060000114687170600001146871PA736174PM736283
17060000114716L17/dossiers1717060000114715170600001147151PA429832PM736408
17060000114744L17/dossiers1717060000114743170600001147431PA2538PM703570
17060000114773L17/dossiers1717060000114772170600001147721PA2538PM703570
17060000114774L17/dossiers1717060000114772170600001147722PA703539PM703693
17060000114775L17/dossiers1717060000114772170600001147723PA415454PM703689
17060000114776L17/dossiers1717060000114772170600001147724PA736186PM736396
17060000114777L17/dossiers1717060000114772170600001147725PA304108PM736399
17060000114778L17/dossiers1717060000114772170600001147726PA758431PM758701
17060000114779L17/dossiers1717060000114772170600001147727PA415451PM703594
17060000114780L17/dossiers1717060000114772170600001147728PA267907PM703591
17060000114781L17/dossiers1717060000114772170600001147729PA736211PM736410
17060000114782L17/dossiers17170600001147721706000011477210PA736202PM736392
17060000114783L17/dossiers17170600001147721706000011477211PA708632PM708643
17060000114784L17/dossiers17170600001147721706000011477212PA716PM736261
17060000114785L17/dossiers17170600001147721706000011477213PA703483PM703613
17060000114786L17/dossiers17170600001147721706000011477214PA415456PM736433
17060000114787L17/dossiers17170600001147721706000011477215PA415456PM736433
17060000114788L17/dossiers17170600001147721706000011477216PA1344PM736383
17060000114789L17/dossiers17170600001147721706000011477217PA415495PM703579
17060000114790L17/dossiers17170600001147721706000011477218PA703488PM703632
17060000114791L17/dossiers17170600001147721706000011477219PA415447PM703616
17060000114792L17/dossiers17170600001147721706000011477220PA429851PM736305
17060000114793L17/dossiers17170600001147721706000011477221PA343775PM736367
17060000114794L17/dossiers17170600001147721706000011477222PA267081PM703617
17060000114795L17/dossiers17170600001147721706000011477223PA429854PM736335
17060000114796L17/dossiers17170600001147721706000011477224PA711156PM736319
17060000114797L17/dossiers17170600001147721706000011477225PA715745PM736297
17060000114798L17/dossiers17170600001147721706000011477226PA736185PM736264
17060000114799L17/dossiers17170600001147721706000011477227PA703510PM703672
17060000114800L17/dossiers17170600001147721706000011477228PA703500PM703574
17060000114801L17/dossiers17170600001147721706000011477229PA304000PM703599
17060000114802L17/dossiers17170600001147721706000011477230PA425322PM736282
17060000114803L17/dossiers17170600001147721706000011477231PA415473PM703666
17060000114804L17/dossiers17170600001147721706000011477232PA703518PM703704
17060000114832L17/dossiers1717060000114831170600001148311PA313924PM703546
17060000114861L17/dossiers1717060000114860170600001148601PA732420PM763170
17060000114862L17/dossiers1717060000114860170600001148602PA732420PM763170
17060000114863L17/dossiers1717060000114860170600001148603PA429895PM736262
17060000114864L17/dossiers1717060000114860170600001148604PA703486PM703718
17060000114865L17/dossiers1717060000114860170600001148605PA267840PM736423