AN · données ouvertes
Explorateur / dossiers

dossiers.document_co_signataire

Chemin document.coSignataires.coSignataire · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %

305 264 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_acteur_refVARCHARdocument.coSignataires.coSignataire.acteur.acteurRef · présence : L17 25 %, L16 26 %, L15 28 %, L14 29 %
8date_cosignatureDATEdocument.coSignataires.coSignataire.dateCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
9date_retrait_cosignatureDATEdocument.coSignataires.coSignataire.dateRetraitCosignature · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
10editeBOOLEANdocument.coSignataires.coSignataire.edite · présence : L17 26 %, L16 26 %, L15 28 %, L14 29 %
11organe_organe_refVARCHARdocument.coSignataires.coSignataire.organe.organeRef · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %
12organe_et_apparentesBOOLEANdocument.coSignataires.coSignataire.organe.etApparentes · présence : L17 0 %, L16 1 %, L15 1 %, L14 2 %

Aperçu

_id_source_legislature_racine_id_parent_id_ordreacteur_acteur_refdate_cosignaturedate_retrait_cosignatureediteorgane_organe_reforgane_et_apparentes
17060000051829L17/dossiers17170600000517561706000005175672PA7200922025-12-09False
17060000051830L17/dossiers17170600000517561706000005175673PA7210622025-12-09False
17060000051831L17/dossiers17170600000517561706000005175674PA8418452025-12-09False
17060000051832L17/dossiers17170600000517561706000005175675PA7959822025-12-09False
17060000051833L17/dossiers17170600000517561706000005175676PA7954662025-12-09False
17060000051834L17/dossiers17170600000517561706000005175677PA7937442025-12-09False
17060000051835L17/dossiers17170600000517561706000005175678PA7209522025-12-09False
17060000051836L17/dossiers17170600000517561706000005175679PA7941062025-12-09False
17060000051837L17/dossiers17170600000517561706000005175680PA7941662025-12-09False
17060000051838L17/dossiers17170600000517561706000005175681PA7951642025-12-09False
17060000051839L17/dossiers17170600000517561706000005175682PA7955962025-12-09False
17060000051843L17/dossiers1717060000051841170600000518411PA7203702026-01-19False
17060000051844L17/dossiers1717060000051841170600000518412PA8414312026-01-19False
17060000051845L17/dossiers1717060000051841170600000518413PA7935722026-01-19False
17060000051846L17/dossiers1717060000051841170600000518414PA7942062026-01-19False
17060000051847L17/dossiers1717060000051841170600000518415PA6057822026-01-19False
17060000051848L17/dossiers1717060000051841170600000518416PA5692026-01-19False
17060000051849L17/dossiers1717060000051841170600000518417PA8172032026-01-19False
17060000051850L17/dossiers1717060000051841170600000518418PA7205522026-01-19False
17060000051851L17/dossiers1717060000051841170600000518419PA6431842026-01-19False
17060000051852L17/dossiers17170600000518411706000005184110PA7947982026-01-19False
17060000051853L17/dossiers17170600000518411706000005184111PA6428682026-01-19False
17060000051854L17/dossiers17170600000518411706000005184112PA7947022026-01-19False
17060000051855L17/dossiers17170600000518411706000005184113PA7194122026-01-19False
17060000051856L17/dossiers17170600000518411706000005184114PA7195122026-01-19False
17060000051857L17/dossiers17170600000518411706000005184115PA7952702026-01-19False
17060000051858L17/dossiers17170600000518411706000005184116PA7944662026-01-19False
17060000051859L17/dossiers17170600000518411706000005184117PA7195282026-01-19False
17060000051860L17/dossiers17170600000518411706000005184118PA7190322026-01-19False
17060000051861L17/dossiers17170600000518411706000005184119PA7930942026-01-19False
17060000051862L17/dossiers17170600000518411706000005184120PA6428472026-01-19False
17060000051863L17/dossiers17170600000518411706000005184121PA2670422026-01-19False
17060000051864L17/dossiers17170600000518411706000005184122PA7944702026-01-19False
17060000051865L17/dossiers17170600000518411706000005184123PA3322282026-01-19False
17060000051866L17/dossiers17170600000518411706000005184124PA7933982026-01-19False
17060000051867L17/dossiers17170600000518411706000005184125PA6082642026-01-19False
17060000051868L17/dossiers17170600000518411706000005184126PA2270892026-01-19False
17060000051869L17/dossiers17170600000518411706000005184127PA8413592026-01-19False
17060000051870L17/dossiers17170600000518411706000005184128PA7214582026-01-19False
17060000051871L17/dossiers17170600000518411706000005184129PA6872142026-01-19False
17060000051872L17/dossiers17170600000518411706000005184130PA7203542026-01-19False
17060000051873L17/dossiers17170600000518411706000005184131PA7944302026-01-19False
17060000051874L17/dossiers17170600000518411706000005184132PA8419272026-01-19False
17060000051875L17/dossiers17170600000518411706000005184133PA8421252026-01-19False
17060000051876L17/dossiers17170600000518411706000005184134PA7950262026-01-19False
17060000051877L17/dossiers17170600000518411706000005184135PA3315822026-01-19False
17060000051878L17/dossiers17170600000518411706000005184136PA7931942026-01-19False
17060000051879L17/dossiers17170600000518411706000005184137PA7202302026-01-19False
17060000051880L17/dossiers17170600000518411706000005184138PA6088262026-01-19False
17060000051881L17/dossiers17170600000518411706000005184139PA29522026-01-19False