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
17060000049684L17/dossiers17170600000496481706000004964835PA6075532026-01-07False
17060000049685L17/dossiers17170600000496481706000004964836PA8409552026-01-07False
17060000049686L17/dossiers17170600000496481706000004964837PA8413672026-01-07False
17060000049687L17/dossiers17170600000496481706000004964838PA3419812026-01-07False
17060000049688L17/dossiers17170600000496481706000004964839PA8406732026-01-07False
17060000049689L17/dossiers17170600000496481706000004964840PA3421962026-01-07False
17060000049690L17/dossiers17170600000496481706000004964841PA8266352026-01-07False
17060000049691L17/dossiers17170600000496481706000004964842PA8413272026-01-07False
17060000049692L17/dossiers17170600000496481706000004964843PA8417172026-01-07False
17060000049693L17/dossiers17170600000496481706000004964844PA8412432026-01-07False
17060000049694L17/dossiers17170600000496481706000004964845PA7749602026-01-07False
17060000049695L17/dossiers17170600000496481706000004964846PA3403432026-01-07False
17060000049696L17/dossiers17170600000496481706000004964847PA8410912026-01-07False
17060000049697L17/dossiers17170600000496481706000004964848PA8416812026-01-07False
17060000049698L17/dossiers17170600000496481706000004964849PA8418932026-01-07False
17060000049699L17/dossiers17170600000496481706000004964850PA7938162026-01-07False
17060000049700L17/dossiers17170600000496481706000004964851PA7944942026-01-07False
17060000049701L17/dossiers17170600000496481706000004964852PA7209922026-01-07False
17060000049702L17/dossiers17170600000496481706000004964853PA6427642025-10-282026-01-07False
17060000049703L17/dossiers17170600000496481706000004964854PA7952402026-01-07False
17060000049704L17/dossiers17170600000496481706000004964855PA6431432025-10-282026-01-07False
17060000049705L17/dossiers17170600000496481706000004964856PA7946862026-01-07False
17060000049706L17/dossiers17170600000496481706000004964857PA7955882026-01-07False
17060000049707L17/dossiers17170600000496481706000004964858PA8408292025-10-282026-01-07False
17060000049708L17/dossiers17170600000496481706000004964859PA3424152025-10-282026-01-07False
17060000049709L17/dossiers17170600000496481706000004964860PA7939802026-01-07False
17060000049710L17/dossiers17170600000496481706000004964861PA6067932025-10-282026-01-07False
17060000049711L17/dossiers17170600000496481706000004964862PA7203622025-10-282026-01-07False
17060000049712L17/dossiers17170600000496481706000004964863PA8422112025-10-282026-01-07False
17060000049713L17/dossiers17170600000496481706000004964864PA8413152025-10-282026-01-07False
17060000049714L17/dossiers17170600000496481706000004964865PA7940942025-10-282026-01-07False
17060000049715L17/dossiers17170600000496481706000004964866PA7936242025-10-282026-01-07False
17060000049716L17/dossiers17170600000496481706000004964867PA7957622025-10-282026-01-07False
17060000049717L17/dossiers17170600000496481706000004964868PA6082642025-10-282026-01-07False
17060000049718L17/dossiers17170600000496481706000004964869PA8409032025-10-282026-01-07False
17060000049719L17/dossiers17170600000496481706000004964870PA8412952025-10-282026-01-07False
17060000049720L17/dossiers17170600000496481706000004964871PA10082025-10-282026-01-07False
17060000049721L17/dossiers17170600000496481706000004964872PA7933942025-10-282026-01-07False
17060000049728L17/dossiers1717060000049726170600000497261PA6109682026-01-29False
17060000049729L17/dossiers1717060000049726170600000497262PA7937802026-01-29False
17060000049730L17/dossiers1717060000049726170600000497263PA7953622026-01-29False
17060000049731L17/dossiers1717060000049726170600000497264PA8418852026-01-29False
17060000049732L17/dossiers1717060000049726170600000497265PA8415072026-01-29False
17060000049733L17/dossiers1717060000049726170600000497266PA6082642026-01-29False
17060000049734L17/dossiers1717060000049726170600000497267PA8409032026-01-29False
17060000049735L17/dossiers1717060000049726170600000497268PA7212102026-01-29False
17060000049736L17/dossiers1717060000049726170600000497269PA7934522026-01-29False
17060000049737L17/dossiers17170600000497261706000004972610PA7948542026-01-29False
17060000049738L17/dossiers17170600000497261706000004972611PA8421952026-01-29False
17060000049739L17/dossiers17170600000497261706000004972612PA8416652026-01-29False