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
17060000123846L17/dossiers1717060000123845170600001238451PA720230PM842984
17060000123853L17/dossiers1717060000123852170600001238521PA794894PM840351
17060000123860L17/dossiers1717060000123859170600001238591PA840979PM842588
17060000123867L17/dossiers1717060000123866170600001238661PA719272PM842513
17060000123874L17/dossiers1717060000123873170600001238731PA840979PM842588
17060000123881L17/dossiers1717060000123880170600001238801PA795350PM843410
17060000123888L17/dossiers1717060000123887170600001238871PA712015PM842381
17060000123895L17/dossiers1717060000123894170600001238941PA722390PM843317
17060000123902L17/dossiers1717060000123901170600001239011PA718850PM842411
17060000123909L17/dossiers1717060000123908170600001239081PA722390PM843317
17060000123916L17/dossiers1717060000123915170600001239151PA721896PM840405
17060000123923L17/dossiers1717060000123922170600001239221PA720838PM843671
17060000123930L17/dossiers1717060000123929170600001239291PA842117PM843635
17060000123937L17/dossiers1717060000123936170600001239361PA793940PM842726
17060000123996L17/dossiers1717060000123995170600001239951PA722046PM843482
17060000124003L17/dossiers1717060000124002170600001240021PA793342PM842345
17060000124010L17/dossiers1717060000124009170600001240091PA793322PM840246
17060000124017L17/dossiers1717060000124016170600001240161PA793342PM842345
17060000124024L17/dossiers1717060000124023170600001240231PA718784PM842342
17060000124031L17/dossiers1717060000124030170600001240301PA721486PM843614
17060000124038L17/dossiers1717060000124037170600001240371PA382672PM829681
17060000124057L17/dossiers1717060000124056170600001240561PA736179PM829833
17060000124067L17/dossiers1717060000124066170600001240661PA775250PM775552
17060000124068L17/dossiers1717060000124066170600001240662PA775226PM775510
17060000124127L17/dossiers1717060000124126170600001241261PA774958PM843389
17060000124137L17/dossiers1717060000124136170600001241361PA346782PM840426
17060000124144L17/dossiers1717060000124143170600001241431PA736243PM829929
17060000124145L17/dossiers1717060000124143170600001241432PA757676PM829801
17060000124146L17/dossiers1717060000124143170600001241433PA775172PM775474
17060000124147L17/dossiers1717060000124143170600001241434PA827898PM828454
17060000124148L17/dossiers1717060000124143170600001241435PA429894PM829765
17060000124149L17/dossiers1717060000124143170600001241436PA827912PM828488
17060000124150L17/dossiers1717060000124143170600001241437PA756685PM775777
17060000124151L17/dossiers1717060000124143170600001241438PA827930PM828544
17060000124152L17/dossiers1717060000124143170600001241439PA268007PM829695
17060000124153L17/dossiers17170600001241431706000012414310PA429886PM829757
17060000124154L17/dossiers17170600001241431706000012414311PA736195PM829855
17060000124155L17/dossiers17170600001241431706000012414312PA736173PM829799
17060000124156L17/dossiers17170600001241431706000012414313PA775246PM775532
17060000124157L17/dossiers17170600001241431706000012414314PA827962PM828676
17060000124158L17/dossiers17170600001241431706000012414315PA736175PM829795
17060000124159L17/dossiers17170600001241431706000012414316PA828002PM828856
17060000124160L17/dossiers17170600001241431706000012414317PA775296PM775596
17060000124161L17/dossiers17170600001241431706000012414318PA828020PM828864
17060000124168L17/dossiers1717060000124167170600001241671PA610850PM828634
17060000124169L17/dossiers1717060000124167170600001241672PA703538PM775715
17060000124170L17/dossiers1717060000124167170600001241673PA736167PM829803
17060000124171L17/dossiers1717060000124167170600001241674PA736229PM829923
17060000124172L17/dossiers1717060000124167170600001241675PA642756PM775779
17060000124173L17/dossiers1717060000124167170600001241676PA607761PM828556