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
17060000138890L17/dossiers1717060000138889170600001388891PA828016PM828876
17060000138897L17/dossiers1717060000138896170600001388961PA642756PM775779
17060000138898L17/dossiers1717060000138896170600001388962PA736167PM829803
17060000138905L17/dossiers1717060000138904170600001389041PA827978PM828730
17060000138906L17/dossiers1717060000138904170600001389042PA785857PM785867
17060000138913L17/dossiers1717060000138912170600001389121PA827978PM828730
17060000138914L17/dossiers1717060000138912170600001389122PA785857PM785867
17060000138921L17/dossiers1717060000138920170600001389201PA736190PM829825
17060000138922L17/dossiers1717060000138920170600001389202PA827956PM828682
17060000138923L17/dossiers1717060000138920170600001389203PA775226PM775510
17060000138930L17/dossiers1717060000138929170600001389291PA827978PM828730
17060000138931L17/dossiers1717060000138929170600001389292PA785857PM785867
17060000138938L17/dossiers1717060000138937170600001389371PA795808PM843644
17060000138945L17/dossiers1717060000138944170600001389441PA775226PM775510
17060000138963L17/dossiers1717060000138962170600001389621PA828004PM828838
17060000138964L17/dossiers1717060000138962170600001389622PA736177PM829835
17060000138965L17/dossiers1717060000138962170600001389623PA775180PM775466
17060000138966L17/dossiers1717060000138962170600001389624PA827904PM828514
17060000138967L17/dossiers1717060000138962170600001389625PA429845PM829729
17060000138968L17/dossiers1717060000138962170600001389626PA775214PM775498
17060000138969L17/dossiers1717060000138962170600001389627PA775224PM775512
17060000138970L17/dossiers1717060000138962170600001389628PA827946PM828614
17060000138971L17/dossiers1717060000138962170600001389629PA827950PM828598
17060000138972L17/dossiers17170600001389621706000013896210PA775252PM775558
17060000138973L17/dossiers17170600001389621706000013896211PA827968PM828750
17060000138974L17/dossiers17170600001389621706000013896212PA827978PM828730
17060000138975L17/dossiers17170600001389621706000013896213PA775272PM775562
17060000138976L17/dossiers17170600001389621706000013896214PA775282PM775584
17060000138977L17/dossiers17170600001389621706000013896215PA828000PM828850
17060000138978L17/dossiers17170600001389621706000013896216PA785857PM785867
17060000138985L17/dossiers1717060000138984170600001389841PA775302PM775598
17060000138986L17/dossiers1717060000138984170600001389842PA703538PM775715
17060000138987L17/dossiers1717060000138984170600001389843PA709298PM775773
17060000138994L17/dossiers1717060000138993170600001389931PA410PM855580
17060000138995L17/dossiers1717060000138993170600001389932PA717161PM855117
17060000138996L17/dossiers1717060000138993170600001389933PA855049PM855055
17060000139007L17/dossiers1717060000139006170600001390061PA842271PM843776
17060000139032L17/dossiers1717060000139031170600001390311PA410PM855580
17060000139039L17/dossiers1717060000139038170600001390381PA410PM855580
17060000139059L17/dossiers1717060000139058170600001390581PA703515PM775663
17060000139078L17/dossiers1717060000139077170600001390771PA793736PM842693
17060000139082L17/dossiers1717060000139081170600001390811PA410PM855580
17060000139141L17/dossiers1717060000139140170600001391401PA703512PM775665
17060000139142L17/dossiers1717060000139140170600001391402PA642982PM829146
17060000139143L17/dossiers1717060000139140170600001391403PA785855PM785869
17060000139144L17/dossiers1717060000139140170600001391404PA712422PM828926
17060000139145L17/dossiers1717060000139140170600001391405PA708633PM775669
17060000139146L17/dossiers1717060000139140170600001391406PA605888PM775604
17060000139147L17/dossiers1717060000139140170600001391407PA415449PM775793
17060000139148L17/dossiers1717060000139140170600001391408PA703511PM775685