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
17060000129023L17/dossiers17170600001290131706000012901310PA775272PM775562
17060000129024L17/dossiers17170600001290131706000012901311PA775282PM775584
17060000129025L17/dossiers17170600001290131706000012901312PA828000PM828850
17060000129026L17/dossiers17170600001290131706000012901313PA785857PM785867
17060000129033L17/dossiers1717060000129032170600001290321PA736175PM829795
17060000129034L17/dossiers1717060000129032170600001290322PA827898PM828454
17060000129035L17/dossiers1717060000129032170600001290323PA429886PM829757
17060000129036L17/dossiers1717060000129032170600001290324PA757676PM829801
17060000129037L17/dossiers1717060000129032170600001290325PA775172PM775474
17060000129038L17/dossiers1717060000129032170600001290326PA850008PM850016
17060000129039L17/dossiers1717060000129032170600001290327PA827912PM828488
17060000129040L17/dossiers1717060000129032170600001290328PA756685PM775777
17060000129041L17/dossiers1717060000129032170600001290329PA827930PM828544
17060000129042L17/dossiers17170600001290321706000012903210PA268007PM829695
17060000129043L17/dossiers17170600001290321706000012903211PA736195PM829855
17060000129044L17/dossiers17170600001290321706000012903212PA736173PM829799
17060000129045L17/dossiers17170600001290321706000012903213PA775246PM775532
17060000129046L17/dossiers17170600001290321706000012903214PA827962PM828676
17060000129047L17/dossiers17170600001290321706000012903215PA736243PM829929
17060000129048L17/dossiers17170600001290321706000012903216PA828002PM828856
17060000129049L17/dossiers17170600001290321706000012903217PA775296PM775596
17060000129050L17/dossiers17170600001290321706000012903218PA828020PM828864
17060000129060L17/dossiers1717060000129059170600001290591PA410PM855580
17060000129067L17/dossiers1717060000129066170600001290661PA719778PM842744
17060000129074L17/dossiers1717060000129073170600001290731PA719778PM842744
17060000129078L17/dossiers1717060000129077170600001290771PA841681PM843245
17060000129103L17/dossiers1717060000129102170600001291021PA721486PM843614
17060000129113L17/dossiers1717060000129112170600001291121PA410PM855580
17060000129121L17/dossiers1717060000129120170600001291201PA791812PM840384
17060000129125L17/dossiers1717060000129124170600001291241PA410PM855580
17060000129133L17/dossiers1717060000129132170600001291321PA335612PM843398
17060000129137L17/dossiers1717060000129136170600001291361PA736169PM829791
17060000129183L17/dossiers1717060000129182170600001291821PA793992PM842756
17060000129190L17/dossiers1717060000129189170600001291891PA795176PM843788
17060000129205L17/dossiers1717060000129204170600001292041PA795552PM840408
17060000129212L17/dossiers1717060000129211170600001292111PA608826PM843365
17060000129219L17/dossiers1717060000129218170600001292181PA719798PM842753
17060000129249L17/dossiers1717060000129248170600001292481PA840915PM842552
17060000129256L17/dossiers1717060000129255170600001292551PA795552PM840408
17060000129263L17/dossiers1717060000129262170600001292621PA719388PM842642
17060000129270L17/dossiers1717060000129269170600001292691PA774954PM842843
17060000129277L17/dossiers1717060000129276170600001292761PA794178PM842897
17060000129284L17/dossiers1717060000129283170600001292831PA1327PM842747
17060000129291L17/dossiers1717060000129290170600001292901PA795430PM843602
17060000129292L17/dossiers1717060000129290170600001292902PA643175PM842840
17060000129299L17/dossiers1717060000129298170600001292981PA330909PM842399
17060000129306L17/dossiers1717060000129305170600001293051PA793322PM840246
17060000129313L17/dossiers1717060000129312170600001293121PA720370PM843014
17060000129320L17/dossiers1717060000129319170600001293191PA721486PM843614
17060000129327L17/dossiers1717060000129326170600001293261PA605745PM842504