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
17060000044593L17/dossiers17170600000445681706000004456824PA7223902025-09-16False
17060000044594L17/dossiers17170600000445681706000004456825PA7949822025-09-16False
17060000044595L17/dossiers17170600000445681706000004456826PA7201542025-09-16False
17060000044596L17/dossiers17170600000445681706000004456827PA7946582025-09-16False
17060000044603L17/dossiers1717060000044601170600000446011PA7201622025-09-16False
17060000044604L17/dossiers1717060000044601170600000446012PA7939802025-09-16False
17060000044605L17/dossiers1717060000044601170600000446013PA7937962025-09-16False
17060000044606L17/dossiers1717060000044601170600000446014PA8406652025-09-16False
17060000044607L17/dossiers1717060000044601170600000446015PA6427642025-09-16False
17060000044608L17/dossiers1717060000044601170600000446016PA6431432025-09-16False
17060000044609L17/dossiers1717060000044601170600000446017PA8408292025-09-16False
17060000044610L17/dossiers1717060000044601170600000446018PA3424152025-09-16False
17060000044611L17/dossiers1717060000044601170600000446019PA6067932025-09-16False
17060000044612L17/dossiers17170600000446011706000004460110PA8422112025-09-16False
17060000044613L17/dossiers17170600000446011706000004460111PA8413152025-09-16False
17060000044614L17/dossiers17170600000446011706000004460112PA8409972025-09-16False
17060000044615L17/dossiers17170600000446011706000004460113PA8415072025-09-16False
17060000044616L17/dossiers17170600000446011706000004460114PA8418852025-09-16False
17060000044617L17/dossiers17170600000446011706000004460115PA7940942025-09-16False
17060000044618L17/dossiers17170600000446011706000004460116PA7936242025-09-16False
17060000044619L17/dossiers17170600000446011706000004460117PA7957622025-09-16False
17060000044620L17/dossiers17170600000446011706000004460118PA6082642025-09-16False
17060000044621L17/dossiers17170600000446011706000004460119PA6428682025-09-16False
17060000044622L17/dossiers17170600000446011706000004460120PA7212102025-09-16False
17060000044623L17/dossiers17170600000446011706000004460121PA8412952025-09-16False
17060000044624L17/dossiers17170600000446011706000004460122PA10082025-09-16False
17060000044625L17/dossiers17170600000446011706000004460123PA7933942025-09-16False
17060000044626L17/dossiers17170600000446011706000004460124PA8419192025-09-16False
17060000044627L17/dossiers17170600000446011706000004460125PA6065732025-09-16False
17060000044628L17/dossiers17170600000446011706000004460126PA8416332025-09-16False
17060000044629L17/dossiers17170600000446011706000004460127PA8413512025-09-16False
17060000044630L17/dossiers17170600000446011706000004460128PA7948542025-09-16False
17060000044631L17/dossiers17170600000446011706000004460129PA8421952025-09-16False
17060000044632L17/dossiers17170600000446011706000004460130PA6056942025-09-16False
17060000044633L17/dossiers17170600000446011706000004460131PA6093322025-09-16False
17060000044634L17/dossiers17170600000446011706000004460132PA8416652025-09-16False
17060000044635L17/dossiers17170600000446011706000004460133PA3332852025-09-16False
17060000044636L17/dossiers17170600000446011706000004460134PA8414192025-09-16False
17060000044637L17/dossiers17170600000446011706000004460135PA8409392025-09-16False
17060000044638L17/dossiers17170600000446011706000004460136PA8415392025-09-16False
17060000044639L17/dossiers17170600000446011706000004460137PA3319732025-09-16False
17060000044640L17/dossiers17170600000446011706000004460138PA8401712025-09-16False
17060000044641L17/dossiers17170600000446011706000004460139PA15672025-09-16False
17060000044642L17/dossiers17170600000446011706000004460140PA8420132025-09-16False
17060000044643L17/dossiers17170600000446011706000004460141PA8414712025-09-16False
17060000044644L17/dossiers17170600000446011706000004460142PA8422632025-09-16False
17060000044645L17/dossiers17170600000446011706000004460143PA8418132025-09-16False
17060000044646L17/dossiers17170600000446011706000004460144PA8418532025-09-16False
17060000044647L17/dossiers17170600000446011706000004460145PA8409472025-09-16False
17060000044648L17/dossiers17170600000446011706000004460146PA16542025-09-16False