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
17060000125299L17/dossiers1717060000125297170600001252972PA775180PM775466
17060000125300L17/dossiers1717060000125297170600001252973PA827904PM828514
17060000125301L17/dossiers1717060000125297170600001252974PA429845PM829729
17060000125302L17/dossiers1717060000125297170600001252975PA775214PM775498
17060000125303L17/dossiers1717060000125297170600001252976PA775224PM775512
17060000125304L17/dossiers1717060000125297170600001252977PA736177PM829835
17060000125305L17/dossiers1717060000125297170600001252978PA827946PM828614
17060000125306L17/dossiers1717060000125297170600001252979PA827950PM828598
17060000125307L17/dossiers17170600001252971706000012529710PA775252PM775558
17060000125308L17/dossiers17170600001252971706000012529711PA827968PM828750
17060000125309L17/dossiers17170600001252971706000012529712PA775272PM775562
17060000125310L17/dossiers17170600001252971706000012529713PA775282PM775584
17060000125311L17/dossiers17170600001252971706000012529714PA828000PM828850
17060000125312L17/dossiers17170600001252971706000012529715PA828004PM828838
17060000125313L17/dossiers17170600001252971706000012529716PA785857PM785867
17060000125320L17/dossiers1717060000125319170600001253191PA775224PM775512
17060000125327L17/dossiers1717060000125326170600001253261PA795310PM840453
17060000125334L17/dossiers1717060000125333170600001253331PA795730PM843491
17060000125350L17/dossiers1717060000125349170600001253491PA719822PM842762
17060000125366L17/dossiers1717060000125365170600001253651PA429889PM829767
17060000125367L17/dossiers1717060000125365170600001253652PA429889PM829767
17060000125368L17/dossiers1717060000125365170600001253653PA702993PM829493
17060000125369L17/dossiers1717060000125365170600001253654PA606375PM775602
17060000125370L17/dossiers1717060000125365170600001253655PA785855PM785869
17060000125371L17/dossiers1717060000125365170600001253656PA775196PM775482
17060000125372L17/dossiers1717060000125365170600001253657PA775294PM775580
17060000125373L17/dossiers1717060000125365170600001253658PA736217PM829873
17060000125374L17/dossiers1717060000125365170600001253659PA827920PM828574
17060000125375L17/dossiers17170600001253651706000012536510PA642982PM829146
17060000125376L17/dossiers17170600001253651706000012536511PA610850PM828634
17060000125377L17/dossiers17170600001253651706000012536512PA703512PM775665
17060000125378L17/dossiers17170600001253651706000012536513PA643028PM829316
17060000125379L17/dossiers17170600001253651706000012536514PA429835PM829719
17060000125380L17/dossiers17170600001253651706000012536515PA732419PM775647
17060000125381L17/dossiers17170600001253651706000012536516PA736234PM829887
17060000125382L17/dossiers17170600001253651706000012536517PA607761PM828556
17060000125383L17/dossiers17170600001253651706000012536518PA642756PM775779
17060000125384L17/dossiers17170600001253651706000012536519PA736229PM829923
17060000125385L17/dossiers17170600001253651706000012536520PA828018PM828882
17060000125386L17/dossiers17170600001253651706000012536521PA736219PM829867
17060000125387L17/dossiers17170600001253651706000012536522PA827900PM828434
17060000125388L17/dossiers17170600001253651706000012536523PA775186PM775484
17060000125389L17/dossiers17170600001253651706000012536524PA415488PM775641
17060000125390L17/dossiers17170600001253651706000012536525PA775194PM775476
17060000125391L17/dossiers17170600001253651706000012536526PA775200PM775504
17060000125392L17/dossiers17170600001253651706000012536527PA775206PM775506
17060000125393L17/dossiers17170600001253651706000012536528PA590034PM775606
17060000125394L17/dossiers17170600001253651706000012536529PA827924PM828550
17060000125395L17/dossiers17170600001253651706000012536530PA775210PM775492
17060000125396L17/dossiers17170600001253651706000012536531PA712422PM828926