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
17060000147424L17/dossiers1717060000147422170600001474222PA736182PM829837
17060000147425L17/dossiers1717060000147422170600001474223PA775172PM775474
17060000147426L17/dossiers1717060000147422170600001474224PA827930PM828544
17060000147427L17/dossiers1717060000147422170600001474225PA775192PM775478
17060000147428L17/dossiers1717060000147422170600001474226PA736192PM829859
17060000147429L17/dossiers1717060000147422170600001474227PA775226PM775510
17060000147430L17/dossiers1717060000147422170600001474228PA775252PM775558
17060000147431L17/dossiers1717060000147422170600001474229PA827978PM828730
17060000147432L17/dossiers17170600001474221706000014742210PA736166PM775765
17060000147433L17/dossiers17170600001474221706000014742211PA736167PM829803
17060000147434L17/dossiers17170600001474221706000014742212PA643028PM829316
17060000147435L17/dossiers17170600001474221706000014742213PA785855PM785869
17060000147436L17/dossiers17170600001474221706000014742214PA736200PM829845
17060000147443L17/dossiers1717060000147442170600001474421PA605745PM842504
17060000147450L17/dossiers1717060000147449170600001474491PA794702PM843248
17060000147454L17/dossiers1717060000147453170600001474531PA268048PM829731
17060000147461L17/dossiers1717060000147460170600001474601PA841381PM842966
17060000147468L17/dossiers1717060000147467170600001474671PA331381PM775739
17060000147475L17/dossiers1717060000147474170600001474741PA643210PM873637
17060000147482L17/dossiers1717060000147481170600001474811PA2538PM875132
17060000147483L17/dossiers1717060000147481170600001474812PA2538PM875132
17060000147502L17/dossiers1717060000147501170600001475011PA775180PM775466
17060000147509L17/dossiers1717060000147508170600001475081PA736195PM829855
17060000147510L17/dossiers1717060000147508170600001475082PA775246PM775532
17060000147511L17/dossiers1717060000147508170600001475083PA827962PM828676
17060000147512L17/dossiers1717060000147508170600001475084PA757676PM829801
17060000147513L17/dossiers1717060000147508170600001475085PA775172PM775474
17060000147514L17/dossiers1717060000147508170600001475086PA827898PM828454
17060000147515L17/dossiers1717060000147508170600001475087PA850008PM850016
17060000147516L17/dossiers1717060000147508170600001475088PA827912PM828488
17060000147517L17/dossiers1717060000147508170600001475089PA756685PM775777
17060000147518L17/dossiers17170600001475081706000014750810PA827930PM828544
17060000147519L17/dossiers17170600001475081706000014750811PA268007PM829695
17060000147520L17/dossiers17170600001475081706000014750812PA429886PM829757
17060000147521L17/dossiers17170600001475081706000014750813PA736173PM829799
17060000147522L17/dossiers17170600001475081706000014750814PA736243PM829929
17060000147523L17/dossiers17170600001475081706000014750815PA736175PM829795
17060000147524L17/dossiers17170600001475081706000014750816PA828002PM828856
17060000147525L17/dossiers17170600001475081706000014750817PA775296PM775596
17060000147526L17/dossiers17170600001475081706000014750818PA828020PM828864
17060000147533L17/dossiers1717060000147532170600001475321PA721474PM843608
17060000147537L17/dossiers1717060000147536170600001475361PA643210PM873637
17060000147603L17/dossiers1717060000147602170600001476021PA736186PM829807
17060000147604L17/dossiers1717060000147602170600001476022PA415454PM785875
17060000147605L17/dossiers1717060000147602170600001476023PA775168PM775470
17060000147606L17/dossiers1717060000147602170600001476024PA775176PM775462
17060000147607L17/dossiers1717060000147602170600001476025PA775178PM775460
17060000147608L17/dossiers1717060000147602170600001476026PA773891PM829713
17060000147609L17/dossiers1717060000147602170600001476027PA736202PM775775
17060000147610L17/dossiers1717060000147602170600001476028PA775192PM775478