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
17060000018176L17/dossiers17170600000181121706000001811263PA7212702025-01-22False
17060000018177L17/dossiers17170600000181121706000001811264PA7952402025-01-22False
17060000018178L17/dossiers17170600000181121706000001811265PA7957222025-01-22False
17060000018179L17/dossiers17170600000181121706000001811266PA7202302025-01-22False
17060000018180L17/dossiers17170600000181121706000001811267PA7223742025-01-22False
17060000018181L17/dossiers17170600000181121706000001811268PA7212342025-01-22False
17060000018182L17/dossiers17170600000181121706000001811269PA7200922025-01-22False
17060000018183L17/dossiers17170600000181121706000001811270PA6076192025-01-22False
17060000018184L17/dossiers17170600000181121706000001811271PA8408292025-01-22False
17060000018185L17/dossiers17170600000181121706000001811272PA7940942025-01-22False
17060000018186L17/dossiers17170600000181121706000001811273PA7936242025-01-22False
17060000018187L17/dossiers17170600000181121706000001811274PA8412952025-01-22False
17060000018188L17/dossiers17170600000181121706000001811275PA7954302025-01-22False
17060000018189L17/dossiers17170600000181121706000001811276PA7948542025-01-22False
17060000018190L17/dossiers17170600000181121706000001811277PA8421952025-01-22False
17060000018191L17/dossiers17170600000181121706000001811278PA8414712025-01-22False
17060000018192L17/dossiers17170600000181121706000001811279PA8422632025-01-22False
17060000018193L17/dossiers17170600000181121706000001811280PA7951562025-01-22False
17060000018194L17/dossiers17170600000181121706000001811281PA7749582025-01-22False
17060000018195L17/dossiers17170600000181121706000001811282PA8407652025-01-22False
17060000018196L17/dossiers17170600000181121706000001811283PA6081722025-01-22False
17060000018197L17/dossiers17170600000181121706000001811284PA7749602025-01-22False
17060000018198L17/dossiers17170600000181121706000001811285PA3403432025-01-22False
17060000018199L17/dossiers17170600000181121706000001811286PA8401712025-01-22False
17060000018200L17/dossiers17170600000181121706000001811287PA7937562025-01-22False
17060000018201L17/dossiers17170600000181121706000001811288PA7210622025-01-22False
17060000018202L17/dossiers17170600000181121706000001811289PA6106542025-01-22False
17060000018203L17/dossiers17170600000181121706000001811290PA7214862025-01-22False
17060000018204L17/dossiers17170600000181121706000001811291PA8415072025-01-22False
17060000018205L17/dossiers17170600000181121706000001811292PA7935202025-01-22False
17060000018206L17/dossiers17170600000181121706000001811293PA7937082025-01-22False
17060000018207L17/dossiers17170600000181121706000001811294PA7218162025-01-22False
17060000018208L17/dossiers17170600000181121706000001811295PA7223662025-01-22False
17060000018209L17/dossiers17170600000181121706000001811296PA7209602025-01-22False
17060000018210L17/dossiers17170600000181121706000001811297PA7948302025-01-22False
17060000018211L17/dossiers17170600000181121706000001811298PA7960182025-01-22False
17060000018212L17/dossiers17170600000181121706000001811299PA9422025-01-22False
17060000018213L17/dossiers171706000001811217060000018112100PA7937162025-01-22False
17060000018214L17/dossiers171706000001811217060000018112101PA8416332025-01-22False
17060000018218L17/dossiers1717060000018216170600000182161PA7200382025-01-28False
17060000018219L17/dossiers1717060000018216170600000182162PA7935202025-01-28False
17060000018220L17/dossiers1717060000018216170600000182163PA7572252025-01-28False
17060000018221L17/dossiers1717060000018216170600000182164PA7749602025-01-28False
17060000018222L17/dossiers1717060000018216170600000182165PA8419312025-01-28False
17060000018223L17/dossiers1717060000018216170600000182166PA8417092025-01-28False
17060000018224L17/dossiers1717060000018216170600000182167PA8416012025-01-28False
17060000018225L17/dossiers1717060000018216170600000182168PA7950102025-01-28False
17060000018226L17/dossiers1717060000018216170600000182169PA8418532025-01-28False
17060000018227L17/dossiers17170600000182161706000001821610PA7221342025-01-28False
17060000018228L17/dossiers17170600000182161706000001821611PA8401712025-01-28False