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
17060000046643L17/dossiers17170600000466011706000004660141PA7957462025-10-07False
17060000046644L17/dossiers17170600000466011706000004660142PA7951082025-10-07False
17060000046645L17/dossiers17170600000466011706000004660143PA8415152025-10-07False
17060000046646L17/dossiers17170600000466011706000004660144PA7952982025-10-07False
17060000046647L17/dossiers17170600000466011706000004660145PA7918242025-10-07False
17060000046648L17/dossiers17170600000466011706000004660146PA8420292025-10-07False
17060000046649L17/dossiers17170600000466011706000004660147PA7935322025-10-07False
17060000046650L17/dossiers17170600000466011706000004660148PA3423842025-10-07False
17060000046651L17/dossiers17170600000466011706000004660149PA7954222025-10-07False
17060000046652L17/dossiers17170600000466011706000004660150PA7946862025-10-07False
17060000046653L17/dossiers17170600000466011706000004660151PA8412152025-10-07False
17060000046654L17/dossiers17170600000466011706000004660152PA7954822025-10-07False
17060000046655L17/dossiers17170600000466011706000004660153PA6106542025-10-07False
17060000046656L17/dossiers17170600000466011706000004660154PA8411912025-10-07False
17060000046657L17/dossiers17170600000466011706000004660155PA7219602025-10-07False
17060000046658L17/dossiers17170600000466011706000004660156PA7938722025-10-07False
17060000046659L17/dossiers17170600000466011706000004660157PA8172112025-10-07False
17060000046660L17/dossiers17170600000466011706000004660158PA7937562025-10-07False
17060000046661L17/dossiers17170600000466011706000004660159PA7960622025-10-07False
17060000046662L17/dossiers17170600000466011706000004660160PA7195782025-10-07False
17060000046663L17/dossiers17170600000466011706000004660161PA7210622025-10-07False
17060000046664L17/dossiers17170600000466011706000004660162PA8418452025-10-07False
17060000046665L17/dossiers17170600000466011706000004660163PA7959822025-10-07False
17060000046666L17/dossiers17170600000466011706000004660164PA7954662025-10-07False
17060000046667L17/dossiers17170600000466011706000004660165PA7937442025-10-07False
17060000046668L17/dossiers17170600000466011706000004660166PA7209522025-10-07False
17060000046669L17/dossiers17170600000466011706000004660167PA7941062025-10-07False
17060000046670L17/dossiers17170600000466011706000004660168PA7941662025-10-07False
17060000046671L17/dossiers17170600000466011706000004660169PA7951642025-10-07False
17060000046672L17/dossiers17170600000466011706000004660170PA7955962025-10-07False
17060000046673L17/dossiers17170600000466011706000004660171PA8422992025-10-07False
17060000046677L17/dossiers1717060000046675170600000466751PA8410672025-10-01False
17060000046678L17/dossiers1717060000046675170600000466752PA7961182025-10-01False
17060000046679L17/dossiers1717060000046675170600000466753PA7945622025-10-01False
17060000046680L17/dossiers1717060000046675170600000466754PA7932382025-10-01False
17060000046681L17/dossiers1717060000046675170600000466755PA7933742025-10-01False
17060000046682L17/dossiers1717060000046675170600000466756PA7931582025-10-01False
17060000046683L17/dossiers1717060000046675170600000466757PA7944342025-10-01False
17060000046684L17/dossiers1717060000046675170600000466758PA8416452025-10-01False
17060000046685L17/dossiers1717060000046675170600000466759PA3096432025-10-01False
17060000046686L17/dossiers17170600000466751706000004667510PA7206682025-10-01False
17060000046687L17/dossiers17170600000466751706000004667511PA7948862025-10-01False
17060000046688L17/dossiers17170600000466751706000004667512PA7931822025-10-01False
17060000046689L17/dossiers17170600000466751706000004667513PA7931342025-10-01False
17060000046690L17/dossiers17170600000466751706000004667514PA8407012025-10-01False
17060000046691L17/dossiers17170600000466751706000004667515PA7204682025-10-01False
17060000046692L17/dossiers17170600000466751706000004667516PA7956442025-10-01False
17060000046693L17/dossiers17170600000466751706000004667517PA8401192025-10-01False
17060000046694L17/dossiers17170600000466751706000004667518PA7939282025-10-01False
17060000046695L17/dossiers17170600000466751706000004667519PA7947622025-10-01False