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
17060000036244L17/dossiers1717060000036235170600000362358PA8422712025-04-28False
17060000036245L17/dossiers1717060000036235170600000362359PA7931742025-04-28False
17060000036246L17/dossiers17170600000362351706000003623510PA7958202025-04-28False
17060000036247L17/dossiers17170600000362351706000003623511PA7212702025-04-28False
17060000036248L17/dossiers17170600000362351706000003623512PA7952402025-04-28False
17060000036249L17/dossiers17170600000362351706000003623513PA7958762025-04-28False
17060000036250L17/dossiers17170600000362351706000003623514PA8422992025-04-28False
17060000036254L17/dossiers1717060000036252170600000362521PA7947102025-05-16False
17060000036255L17/dossiers1717060000036252170600000362522PA7961062025-05-16False
17060000036256L17/dossiers1717060000036252170600000362523PA7208382025-05-16False
17060000036257L17/dossiers1717060000036252170600000362524PA7958682025-05-16False
17060000036258L17/dossiers1717060000036252170600000362525PA7218962025-05-16False
17060000036259L17/dossiers1717060000036252170600000362526PA7959982025-05-16False
17060000036260L17/dossiers1717060000036252170600000362527PA7749622025-05-16False
17060000036261L17/dossiers1717060000036252170600000362528PA3356122025-05-16False
17060000036262L17/dossiers1717060000036252170600000362529PA7960102025-05-16False
17060000036263L17/dossiers17170600000362521706000003625210PA8422712025-05-16False
17060000036264L17/dossiers17170600000362521706000003625211PA7958202025-05-16False
17060000036265L17/dossiers17170600000362521706000003625212PA7212702025-05-16False
17060000036266L17/dossiers17170600000362521706000003625213PA7952402025-05-16False
17060000036267L17/dossiers17170600000362521706000003625214PA6057452025-05-16False
17060000036268L17/dossiers17170600000362521706000003625215PA7958762025-05-16False
17060000036269L17/dossiers17170600000362521706000003625216PA8422992025-05-16False
17060000036273L17/dossiers1717060000036271170600000362711PA6088262026-02-17False
17060000036274L17/dossiers1717060000036271170600000362712PA8266352026-02-17False
17060000036275L17/dossiers1717060000036271170600000362713PA7209082026-02-17False
17060000036276L17/dossiers1717060000036271170600000362714PA7222842026-02-17False
17060000036277L17/dossiers1717060000036271170600000362715PA7958082026-02-17False
17060000036278L17/dossiers1717060000036271170600000362716PA7192182026-02-17False
17060000036279L17/dossiers1717060000036271170600000362717PA7749622026-02-17False
17060000036280L17/dossiers1717060000036271170600000362718PA7221502026-02-17False
17060000036281L17/dossiers1717060000036271170600000362719PA2677802026-02-17False
17060000036282L17/dossiers17170600000362711706000003627110PA7211582026-02-17False
17060000036283L17/dossiers17170600000362711706000003627111PA8417012026-02-17False
17060000036284L17/dossiers17170600000362711706000003627112PA7195582026-02-17False
17060000036285L17/dossiers17170600000362711706000003627113PA7954542026-02-17False
17060000036286L17/dossiers17170600000362711706000003627114PA7203622026-02-17False
17060000036287L17/dossiers17170600000362711706000003627115PA3424152026-02-17False
17060000036288L17/dossiers17170600000362711706000003627116PA6065072026-02-17False
17060000036289L17/dossiers17170600000362711706000003627117PA6426952026-02-17False
17060000036290L17/dossiers17170600000362711706000003627118PA7220002026-02-17False
17060000036291L17/dossiers17170600000362711706000003627119PA7190322026-02-17False
17060000036292L17/dossiers17170600000362711706000003627120PA7217502026-02-17False
17060000036293L17/dossiers17170600000362711706000003627121PA7953302026-02-17False
17060000036294L17/dossiers17170600000362711706000003627122PA6082642026-02-17False
17060000036295L17/dossiers17170600000362711706000003627123PA8423112026-02-17False
17060000036296L17/dossiers17170600000362711706000003627124PA7199222026-02-17False
17060000036297L17/dossiers17170600000362711706000003627125PA7933942026-02-17False
17060000036298L17/dossiers17170600000362711706000003627126PA7949822026-02-17False
17060000036299L17/dossiers17170600000362711706000003627127PA6431752026-02-17False