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
17060000026515L17/dossiers17170600000264611706000002646153PA6106542025-02-19False
17060000026516L17/dossiers17170600000264611706000002646154PA8411912025-02-19False
17060000026517L17/dossiers17170600000264611706000002646155PA7219602025-02-19False
17060000026518L17/dossiers17170600000264611706000002646156PA7938722025-02-19False
17060000026519L17/dossiers17170600000264611706000002646157PA8172112025-02-19False
17060000026520L17/dossiers17170600000264611706000002646158PA7937562025-02-19False
17060000026521L17/dossiers17170600000264611706000002646159PA7960622025-02-19False
17060000026522L17/dossiers17170600000264611706000002646160PA7195782025-02-19False
17060000026523L17/dossiers17170600000264611706000002646161PA7210622025-02-19False
17060000026524L17/dossiers17170600000264611706000002646162PA8418452025-02-19False
17060000026525L17/dossiers17170600000264611706000002646163PA7959822025-02-19False
17060000026526L17/dossiers17170600000264611706000002646164PA7954662025-02-19False
17060000026527L17/dossiers17170600000264611706000002646165PA7937442025-02-19False
17060000026528L17/dossiers17170600000264611706000002646166PA7209522025-02-19False
17060000026529L17/dossiers17170600000264611706000002646167PA7941062025-02-19False
17060000026530L17/dossiers17170600000264611706000002646168PA7941662025-02-19False
17060000026531L17/dossiers17170600000264611706000002646169PA7951642025-02-19False
17060000026532L17/dossiers17170600000264611706000002646170PA7955962025-02-19False
17060000026536L17/dossiers1717060000026534170600000265341PA8406652025-04-02False
17060000026537L17/dossiers1717060000026534170600000265342PA6427642025-04-02False
17060000026538L17/dossiers1717060000026534170600000265343PA8408292025-04-02False
17060000026539L17/dossiers1717060000026534170600000265344PA6067932025-02-172025-02-27False
17060000026540L17/dossiers1717060000026534170600000265345PA6428472025-03-052025-03-11False
17060000026541L17/dossiers1717060000026534170600000265346PA7190242025-04-02False
17060000026542L17/dossiers1717060000026534170600000265347PA8413152025-03-172025-03-24False
17060000026543L17/dossiers1717060000026534170600000265348PA7201622025-04-02False
17060000026544L17/dossiers1717060000026534170600000265349PA7199682025-04-02False
17060000026545L17/dossiers17170600000265341706000002653410PA2667932025-04-02False
17060000026546L17/dossiers17170600000265341706000002653411PA3422402025-04-02False
17060000026547L17/dossiers17170600000265341706000002653412PA7936242025-04-02False
17060000026548L17/dossiers17170600000265341706000002653413PA6082642025-04-02False
17060000026549L17/dossiers17170600000265341706000002653414PA2673062025-04-02False
17060000026550L17/dossiers17170600000265341706000002653415PA7940942025-02-172025-02-27False
17060000026551L17/dossiers17170600000265341706000002653416PA7188502025-04-02False
17060000026552L17/dossiers17170600000265341706000002653417PA7194722025-03-112025-03-11False
17060000026553L17/dossiers17170600000265341706000002653418PA7935202025-04-02False
17060000026554L17/dossiers17170600000265341706000002653419PA7931222025-04-02False
17060000026555L17/dossiers17170600000265341706000002653420PA7949822025-04-02False
17060000026556L17/dossiers17170600000265341706000002653421PA7954302025-03-172025-03-24False
17060000026557L17/dossiers17170600000265341706000002653422PA8419192025-04-02False
17060000026558L17/dossiers17170600000265341706000002653423PA8416332025-04-02False
17060000026559L17/dossiers17170600000265341706000002653424PA6431752025-04-02False
17060000026560L17/dossiers17170600000265341706000002653425PA3325232025-02-142025-02-17False
17060000026561L17/dossiers17170600000265341706000002653426PA7948542025-04-02False
17060000026562L17/dossiers17170600000265341706000002653427PA8421952025-04-02False
17060000026563L17/dossiers17170600000265341706000002653428PA6056942025-04-02False
17060000026564L17/dossiers17170600000265341706000002653429PA7120152025-03-052025-03-11False
17060000026565L17/dossiers17170600000265341706000002653430PA8416652025-04-02False
17060000026566L17/dossiers17170600000265341706000002653431PA8226172025-04-02False
17060000026567L17/dossiers17170600000265341706000002653432PA7223662025-04-02False