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
17060000026831L17/dossiers171706000002668517060000026685145PA7936242025-03-31False
17060000026832L17/dossiers171706000002668517060000026685146PA8409472025-03-31False
17060000026833L17/dossiers171706000002668517060000026685147PA7120152025-03-31False
17060000026834L17/dossiers171706000002668517060000026685148PA7956162025-03-31False
17060000026835L17/dossiers171706000002668517060000026685149PA8406652025-03-31False
17060000026836L17/dossiers171706000002668517060000026685150PA7940222025-03-31False
17060000026837L17/dossiers171706000002668517060000026685151PA7934442025-03-31False
17060000026838L17/dossiers171706000002668517060000026685152PA6431432025-03-31False
17060000026839L17/dossiers171706000002668517060000026685153PA7941462025-03-31False
17060000026840L17/dossiers171706000002668517060000026685154PA7949382025-03-31False
17060000026841L17/dossiers171706000002668517060000026685155PA8408292025-03-31False
17060000026842L17/dossiers171706000002668517060000026685156PA8412232025-03-31False
17060000026843L17/dossiers171706000002668517060000026685157PA7953182025-03-31False
17060000026844L17/dossiers171706000002668517060000026685158PA3424152025-03-31False
17060000026845L17/dossiers171706000002668517060000026685159PA7956362025-03-31False
17060000026846L17/dossiers171706000002668517060000026685160PA8410232025-03-31False
17060000026847L17/dossiers171706000002668517060000026685161PA6067932025-03-31False
17060000026848L17/dossiers171706000002668517060000026685162PA8420452025-03-31False
17060000026849L17/dossiers171706000002668517060000026685163PA7939122025-03-31False
17060000026850L17/dossiers171706000002668517060000026685164PA8422112025-03-31False
17060000026851L17/dossiers171706000002668517060000026685165PA7937082025-03-31False
17060000026852L17/dossiers171706000002668517060000026685166PA8421872025-03-31False
17060000026853L17/dossiers171706000002668517060000026685167PA8413152025-03-31False
17060000026854L17/dossiers171706000002668517060000026685168PA7947782025-03-31False
17060000026855L17/dossiers171706000002668517060000026685169PA8420372025-03-31False
17060000026856L17/dossiers171706000002668517060000026685170PA7940942025-03-31False
17060000026857L17/dossiers171706000002668517060000026685171PA6065452025-03-31False
17060000026858L17/dossiers171706000002668517060000026685172PA7918122025-03-31False
17060000026859L17/dossiers171706000002668517060000026685173PA7957622025-03-31False
17060000026860L17/dossiers171706000002668517060000026685174PA7950762025-03-31False
17060000026861L17/dossiers171706000002668517060000026685175PA7212022025-03-31False
17060000026862L17/dossiers171706000002668517060000026685176PA6082642025-03-31False
17060000026863L17/dossiers171706000002668517060000026685177PA7221422025-03-31False
17060000026864L17/dossiers171706000002668517060000026685178PA7951362025-03-31False
17060000026865L17/dossiers171706000002668517060000026685179PA8409032025-03-31False
17060000026866L17/dossiers171706000002668517060000026685180PA6100022025-03-31False
17060000026867L17/dossiers171706000002668517060000026685181PA7934642025-03-31False
17060000026868L17/dossiers171706000002668517060000026685182PA10082025-03-31False
17060000026869L17/dossiers171706000002668517060000026685183PA7958082025-03-31False
17060000026870L17/dossiers171706000002668517060000026685184PA8421552025-03-31False
17060000026871L17/dossiers171706000002668517060000026685185PA7933942025-03-31False
17060000026872L17/dossiers171706000002668517060000026685186PA7960182025-03-31False
17060000026873L17/dossiers171706000002668517060000026685187PA7958442025-03-31False
17060000026874L17/dossiers171706000002668517060000026685188PA8419192025-03-31False
17060000026875L17/dossiers171706000002668517060000026685189PA7362012025-03-31False
17060000026876L17/dossiers171706000002668517060000026685190PA8412512025-03-31False
17060000026877L17/dossiers171706000002668517060000026685191PA6065732025-03-31False
17060000026878L17/dossiers171706000002668517060000026685192PA8417132025-03-31False
17060000026879L17/dossiers171706000002668517060000026685193PA7960702025-03-31False
17060000026880L17/dossiers171706000002668517060000026685194PA8416332025-03-31False