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 151 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
17060000011492L17/dossiers17170600000114511706000001145140PA7956722025-03-12False
17060000011493L17/dossiers17170600000114511706000001145141PA7957462025-03-12False
17060000011494L17/dossiers17170600000114511706000001145142PA7951082025-03-12False
17060000011495L17/dossiers17170600000114511706000001145143PA8415152025-03-12False
17060000011496L17/dossiers17170600000114511706000001145144PA7952982025-03-12False
17060000011497L17/dossiers17170600000114511706000001145145PA8420292025-03-12False
17060000011498L17/dossiers17170600000114511706000001145146PA7935322025-03-12False
17060000011499L17/dossiers17170600000114511706000001145147PA3423842024-10-312024-11-05False
17060000011500L17/dossiers17170600000114511706000001145148PA7954222025-03-12False
17060000011501L17/dossiers17170600000114511706000001145149PA7946862025-03-12False
17060000011502L17/dossiers17170600000114511706000001145150PA8412152025-03-12False
17060000011503L17/dossiers17170600000114511706000001145151PA7954822025-03-12False
17060000011504L17/dossiers17170600000114511706000001145152PA6106542025-03-12False
17060000011505L17/dossiers17170600000114511706000001145153PA8411912025-03-12False
17060000011506L17/dossiers17170600000114511706000001145154PA7219602025-03-12False
17060000011507L17/dossiers17170600000114511706000001145155PA7938722025-03-12False
17060000011508L17/dossiers17170600000114511706000001145156PA8172112025-03-12False
17060000011509L17/dossiers17170600000114511706000001145157PA7937562025-03-12False
17060000011510L17/dossiers17170600000114511706000001145158PA7960622025-03-12False
17060000011511L17/dossiers17170600000114511706000001145159PA7195782025-03-12False
17060000011512L17/dossiers17170600000114511706000001145160PA7210622025-03-12False
17060000011513L17/dossiers17170600000114511706000001145161PA8411672024-10-152024-10-31False
17060000011514L17/dossiers17170600000114511706000001145162PA8418452025-03-12False
17060000011515L17/dossiers17170600000114511706000001145163PA7954662025-03-12False
17060000011516L17/dossiers17170600000114511706000001145164PA7937442025-03-12False
17060000011517L17/dossiers17170600000114511706000001145165PA7209522025-03-12False
17060000011518L17/dossiers17170600000114511706000001145166PA7941662025-03-12False
17060000011519L17/dossiers17170600000114511706000001145167PA7951642025-03-12False
17060000011520L17/dossiers17170600000114511706000001145168PA7955962025-03-12False
17060000011521L17/dossiers17170600000114511706000001145169PA7936642025-03-122025-03-12False
17060000011522L17/dossiers17170600000114511706000001145170PA7937082025-03-122025-03-12False
17060000011526L17/dossiers1717060000011524170600000115241PA3325232024-10-152025-02-17False
17060000011527L17/dossiers1717060000011524170600000115242PA7218162025-04-30False
17060000011528L17/dossiers1717060000011524170600000115243PA7949942025-04-30False
17060000011529L17/dossiers1717060000011524170600000115244PA6080162025-04-30False
17060000011530L17/dossiers1717060000011524170600000115245PA7223902025-04-30False
17060000011531L17/dossiers1717060000011524170600000115246PA6088262025-04-30False
17060000011532L17/dossiers1717060000011524170600000115247PA3422402025-04-30False
17060000011533L17/dossiers1717060000011524170600000115248PA7930942025-04-30False
17060000011534L17/dossiers1717060000011524170600000115249PA7941782025-04-30False
17060000011535L17/dossiers17170600000115241706000001152410PA7203862025-04-30False
17060000011536L17/dossiers17170600000115241706000001152411PA2667972025-04-30False
17060000011537L17/dossiers17170600000115241706000001152412PA6059912025-04-30False
17060000011538L17/dossiers17170600000115241706000001152413PA6070902025-04-30False
17060000011539L17/dossiers17170600000115241706000001152414PA7940382025-04-30False
17060000011540L17/dossiers17170600000115241706000001152415PA13272025-04-30False
17060000011541L17/dossiers17170600000115241706000001152416PA16302025-04-30False
17060000011542L17/dossiers17170600000115241706000001152417PA8413812025-04-30False
17060000011543L17/dossiers17170600000115241706000001152418PA2677632025-04-30False
17060000011544L17/dossiers17170600000115241706000001152419PA8419312025-04-30False