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
17060000147202L17/dossiers1717060000147201170600001472011PA793736PM842693
17060000147209L17/dossiers1717060000147208170600001472081PA841713PM843275
17060000147216L17/dossiers1717060000147215170600001472151PA610002PM840363
17060000147223L17/dossiers1717060000147222170600001472221PA795108PM843338
17060000147230L17/dossiers1717060000147229170600001472291PA793980PM842750
17060000147237L17/dossiers1717060000147236170600001472361PA606507PM842834
17060000147250L17/dossiers1717060000147249170600001472491PA606507PM842834
17060000147263L17/dossiers1717060000147262170600001472621PA382672PM829681
17060000147270L17/dossiers1717060000147269170600001472691PA605745PM842504
17060000147278L17/dossiers1717060000147277170600001472771PA643210PM873637
17060000147285L17/dossiers1717060000147284170600001472841PA785855PM785869
17060000147286L17/dossiers1717060000147284170600001472842PA703512PM775665
17060000147287L17/dossiers1717060000147284170600001472843PA702993PM829493
17060000147288L17/dossiers1717060000147284170600001472844PA642982PM829146
17060000147289L17/dossiers1717060000147284170600001472845PA712422PM828926
17060000147290L17/dossiers1717060000147284170600001472846PA415449PM775793
17060000147291L17/dossiers1717060000147284170600001472847PA703511PM775685
17060000147292L17/dossiers1717060000147284170600001472848PA643028PM829316
17060000147293L17/dossiers1717060000147284170600001472849PA828022PM828870
17060000147294L17/dossiers17170600001472841706000014728410PA736219PM829867
17060000147295L17/dossiers17170600001472841706000014728411PA827900PM828434
17060000147296L17/dossiers17170600001472841706000014728412PA775186PM775484
17060000147297L17/dossiers17170600001472841706000014728413PA415488PM775641
17060000147298L17/dossiers17170600001472841706000014728414PA775194PM775476
17060000147299L17/dossiers17170600001472841706000014728415PA775196PM775482
17060000147300L17/dossiers17170600001472841706000014728416PA775200PM775504
17060000147301L17/dossiers17170600001472841706000014728417PA827920PM828574
17060000147302L17/dossiers17170600001472841706000014728418PA775206PM775506
17060000147303L17/dossiers17170600001472841706000014728419PA590034PM775606
17060000147304L17/dossiers17170600001472841706000014728420PA827924PM828550
17060000147305L17/dossiers17170600001472841706000014728421PA736234PM829887
17060000147306L17/dossiers17170600001472841706000014728422PA429835PM829719
17060000147307L17/dossiers17170600001472841706000014728423PA775210PM775492
17060000147308L17/dossiers17170600001472841706000014728424PA827932PM828526
17060000147309L17/dossiers17170600001472841706000014728425PA736167PM829803
17060000147310L17/dossiers17170600001472841706000014728426PA732419PM775647
17060000147311L17/dossiers17170600001472841706000014728427PA429867PM829751
17060000147312L17/dossiers17170600001472841706000014728428PA429833PM829725
17060000147313L17/dossiers17170600001472841706000014728429PA827940PM828622
17060000147314L17/dossiers17170600001472841706000014728430PA736191PM829819
17060000147315L17/dossiers17170600001472841706000014728431PA708633PM775669
17060000147316L17/dossiers17170600001472841706000014728432PA415477PM775809
17060000147317L17/dossiers17170600001472841706000014728433PA766947PM775799
17060000147318L17/dossiers17170600001472841706000014728434PA642756PM775779
17060000147319L17/dossiers17170600001472841706000014728435PA736241PM829931
17060000147320L17/dossiers17170600001472841706000014728436PA703509PM775687
17060000147321L17/dossiers17170600001472841706000014728437PA736181PM829839
17060000147322L17/dossiers17170600001472841706000014728438PA736225PM829907
17060000147323L17/dossiers17170600001472841706000014728439PA703536PM775719
17060000147324L17/dossiers17170600001472841706000014728440PA736229PM829923