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
17060000023180L17/dossiers17170600000231431706000002314336PA7939482024-12-19False
17060000023181L17/dossiers17170600000231431706000002314337PA29402024-12-19False
17060000023185L17/dossiers1717060000023183170600000231831PA8408892025-01-02False
17060000023186L17/dossiers1717060000023183170600000231832PA8407012025-01-02False
17060000023187L17/dossiers1717060000023183170600000231833PA8407212025-01-02False
17060000023188L17/dossiers1717060000023183170600000231834PA8409832025-01-02False
17060000023189L17/dossiers1717060000023183170600000231835PA8411832025-01-02False
17060000023193L17/dossiers1717060000023191170600000231911PA5888842025-01-07False
17060000023194L17/dossiers1717060000023191170600000231912PA6109682025-01-07False
17060000023195L17/dossiers1717060000023191170600000231913PA7937802025-01-07False
17060000023196L17/dossiers1717060000023191170600000231914PA8417012025-01-07False
17060000023197L17/dossiers1717060000023191170600000231915PA3359992025-01-07False
17060000023198L17/dossiers1717060000023191170600000231916PA7953622025-01-07False
17060000023199L17/dossiers1717060000023191170600000231917PA7954542025-01-07False
17060000023200L17/dossiers1717060000023191170600000231918PA8409972025-01-07False
17060000023201L17/dossiers1717060000023191170600000231919PA8418852025-01-07False
17060000023202L17/dossiers17170600000231911706000002319110PA8415072025-01-07False
17060000023203L17/dossiers17170600000231911706000002319111PA7940082025-01-07False
17060000023204L17/dossiers17170600000231911706000002319112PA7212102025-01-07False
17060000023205L17/dossiers17170600000231911706000002319113PA7934522025-01-07False
17060000023206L17/dossiers17170600000231911706000002319114PA8413512025-01-07False
17060000023207L17/dossiers17170600000231911706000002319115PA7939802025-01-07False
17060000023208L17/dossiers17170600000231911706000002319116PA7950102025-01-07False
17060000023209L17/dossiers17170600000231911706000002319117PA8414192025-01-07False
17060000023210L17/dossiers17170600000231911706000002319118PA8420132025-01-07False
17060000023211L17/dossiers17170600000231911706000002319119PA8409472025-01-07False
17060000023212L17/dossiers17170600000231911706000002319120PA7940222025-01-07False
17060000023213L17/dossiers17170600000231911706000002319121PA7941462025-01-07False
17060000023214L17/dossiers17170600000231911706000002319122PA8412232025-01-07False
17060000023215L17/dossiers17170600000231911706000002319123PA7956362025-01-07False
17060000023216L17/dossiers17170600000231911706000002319124PA8420452025-01-07False
17060000023217L17/dossiers17170600000231911706000002319125PA7937082025-01-07False
17060000023218L17/dossiers17170600000231911706000002319126PA7936642025-01-07False
17060000023219L17/dossiers17170600000231911706000002319127PA7941542025-01-07False
17060000023220L17/dossiers17170600000231911706000002319128PA7947782025-01-07False
17060000023221L17/dossiers17170600000231911706000002319129PA6065452025-01-07False
17060000023222L17/dossiers17170600000231911706000002319130PA7950762025-01-07False
17060000023223L17/dossiers17170600000231911706000002319131PA7221422025-01-07False
17060000023224L17/dossiers17170600000231911706000002319132PA7958082025-01-07False
17060000023225L17/dossiers17170600000231911706000002319133PA7960182025-01-07False
17060000023226L17/dossiers17170600000231911706000002319134PA7362012025-01-07False
17060000023227L17/dossiers17170600000231911706000002319135PA8417132025-01-07False
17060000023228L17/dossiers17170600000231911706000002319136PA7939482025-01-07False
17060000023229L17/dossiers17170600000231911706000002319137PA29402025-01-07False
17060000023233L17/dossiers1717060000023231170600000232311PA7949062025-02-11False
17060000023234L17/dossiers1717060000023231170600000232312PA7941382025-02-11False
17060000023235L17/dossiers1717060000023231170600000232313PA6109682025-02-11False
17060000023236L17/dossiers1717060000023231170600000232314PA7955882025-02-11False
17060000023237L17/dossiers1717060000023231170600000232315PA7950842025-02-11False
17060000023238L17/dossiers1717060000023231170600000232316PA7937802025-02-11False