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
17060000031637L17/dossiers17170600000315841706000003158452PA8418932025-06-12False
17060000031638L17/dossiers17170600000315841706000003158453PA7220002025-06-12False
17060000031639L17/dossiers17170600000315841706000003158454PA2672002025-06-12False
17060000031643L17/dossiers1717060000031641170600000316411PA7217642025-04-24False
17060000031644L17/dossiers1717060000031641170600000316412PA7221502025-04-24False
17060000031645L17/dossiers1717060000031641170600000316413PA6109682025-04-24False
17060000031646L17/dossiers1717060000031641170600000316414PA7933942025-04-24False
17060000031647L17/dossiers1717060000031641170600000316415PA2677802025-04-24False
17060000031648L17/dossiers1717060000031641170600000316416PA7192822025-04-24False
17060000031649L17/dossiers1717060000031641170600000316417PA8421252025-04-24False
17060000031650L17/dossiers1717060000031641170600000316418PA7202302025-04-24False
17060000031651L17/dossiers1717060000031641170600000316419PA7218442025-04-24False
17060000031652L17/dossiers17170600000316411706000003164110PA7214582025-04-24False
17060000031653L17/dossiers17170600000316411706000003164111PA6071932025-04-24False
17060000031654L17/dossiers17170600000316411706000003164112PA7203622025-04-24False
17060000031655L17/dossiers17170600000316411706000003164113PA8226172025-04-24False
17060000031656L17/dossiers17170600000316411706000003164114PA8417012025-04-24False
17060000031657L17/dossiers17170600000316411706000003164115PA7953622025-04-24False
17060000031658L17/dossiers17170600000316411706000003164116PA7954542025-04-24False
17060000031659L17/dossiers17170600000316411706000003164117PA8409972025-04-24False
17060000031660L17/dossiers17170600000316411706000003164118PA8418852025-04-24False
17060000031661L17/dossiers17170600000316411706000003164119PA8415072025-04-24False
17060000031662L17/dossiers17170600000316411706000003164120PA7940082025-04-24False
17060000031663L17/dossiers17170600000316411706000003164121PA7939802025-04-24False
17060000031664L17/dossiers17170600000316411706000003164122PA7950102025-04-24False
17060000031665L17/dossiers17170600000316411706000003164123PA8420132025-04-24False
17060000031666L17/dossiers17170600000316411706000003164124PA7941462025-04-24False
17060000031667L17/dossiers17170600000316411706000003164125PA8412232025-04-24False
17060000031668L17/dossiers17170600000316411706000003164126PA7956362025-04-24False
17060000031669L17/dossiers17170600000316411706000003164127PA8420452025-04-24False
17060000031670L17/dossiers17170600000316411706000003164128PA7937082025-04-24False
17060000031671L17/dossiers17170600000316411706000003164129PA7936642025-04-24False
17060000031672L17/dossiers17170600000316411706000003164130PA7941542025-04-172025-04-24False
17060000031673L17/dossiers17170600000316411706000003164131PA7947782025-04-24False
17060000031674L17/dossiers17170600000316411706000003164132PA7950762025-04-24False
17060000031675L17/dossiers17170600000316411706000003164133PA6100022025-04-24False
17060000031676L17/dossiers17170600000316411706000003164134PA7958082025-04-24False
17060000031677L17/dossiers17170600000316411706000003164135PA7960182025-04-24False
17060000031678L17/dossiers17170600000316411706000003164136PA7362012025-04-24False
17060000031679L17/dossiers17170600000316411706000003164137PA8417132025-04-24False
17060000031680L17/dossiers17170600000316411706000003164138PA7939482025-04-24False
17060000031681L17/dossiers17170600000316411706000003164139PA7944862025-04-24False
17060000031682L17/dossiers17170600000316411706000003164140PA3457222025-04-24False
17060000031683L17/dossiers17170600000316411706000003164141PA7199222025-04-24False
17060000031684L17/dossiers17170600000316411706000003164142PA8402352025-04-24False
17060000031685L17/dossiers17170600000316411706000003164143PA7197982025-04-24False
17060000031686L17/dossiers17170600000316411706000003164144PA7120142025-04-24False
17060000031687L17/dossiers17170600000316411706000003164145PA7201542025-04-24False
17060000031688L17/dossiers17170600000316411706000003164146PA7959202025-04-24False
17060000031689L17/dossiers17170600000316411706000003164147PA7223662025-04-24False