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
17060000031690L17/dossiers17170600000316411706000003164148PA7220002025-04-24False
17060000031691L17/dossiers17170600000316411706000003164149PA8419272025-04-24False
17060000031692L17/dossiers17170600000316411706000003164150PA8417092025-04-24False
17060000031693L17/dossiers17170600000316411706000003164151PA29602025-04-24False
17060000031694L17/dossiers17170600000316411706000003164152PA7195122025-04-24False
17060000031695L17/dossiers17170600000316411706000003164153PA7221022025-04-24False
17060000031696L17/dossiers17170600000316411706000003164154PA7196322025-04-24False
17060000031697L17/dossiers17170600000316411706000003164155PA7197562025-04-24False
17060000031698L17/dossiers17170600000316411706000003164156PA7946582025-04-24False
17060000031699L17/dossiers17170600000316411706000003164157PA7950462025-04-24False
17060000031700L17/dossiers17170600000316411706000003164158PA7222522025-04-24False
17060000031701L17/dossiers17170600000316411706000003164159PA7949822025-04-24False
17060000031702L17/dossiers17170600000316411706000003164160PA8412952025-04-24False
17060000031703L17/dossiers17170600000316411706000003164161PA8401712025-04-24False
17060000031704L17/dossiers17170600000316411706000003164162PA6431922025-04-24False
17060000031705L17/dossiers17170600000316411706000003164163PA8422632025-04-24False
17060000031706L17/dossiers17170600000316411706000003164164PA8407932025-04-24False
17060000031707L17/dossiers17170600000316411706000003164165PA8409392025-04-24False
17060000031708L17/dossiers17170600000316411706000003164166PA8408292025-04-24False
17060000031709L17/dossiers17170600000316411706000003164167PA8411072025-04-24False
17060000031710L17/dossiers17170600000316411706000003164168PA3319732025-04-24False
17060000031711L17/dossiers17170600000316411706000003164169PA16542025-04-24False
17060000031712L17/dossiers17170600000316411706000003164170PA8418932025-04-24False
17060000031713L17/dossiers17170600000316411706000003164171PA7942702025-04-24False
17060000031714L17/dossiers17170600000316411706000003164172PA8414632025-04-24False
17060000031715L17/dossiers17170600000316411706000003164173PA8414712025-04-24False
17060000031716L17/dossiers17170600000316411706000003164174PA8407652025-04-24False
17060000031717L17/dossiers17170600000316411706000003164175PA8414192025-04-24False
17060000031718L17/dossiers17170600000316411706000003164176PA7200922025-04-24False
17060000031719L17/dossiers17170600000316411706000003164177PA7221622025-04-24False
17060000031720L17/dossiers17170600000316411706000003164178PA2673182025-04-24False
17060000031721L17/dossiers17170600000316411706000003164179PA7212342025-04-24False
17060000031722L17/dossiers17170600000316411706000003164180PA7208382025-04-24False
17060000031723L17/dossiers17170600000316411706000003164181PA7950842025-04-24False
17060000031724L17/dossiers17170600000316411706000003164182PA8419312025-04-24False
17060000031725L17/dossiers17170600000316411706000003164183PA7190242025-04-24False
17060000031726L17/dossiers17170600000316411706000003164184PA6056942025-04-24False
17060000031727L17/dossiers17170600000316411706000003164185PA5888842025-04-24False
17060000031728L17/dossiers17170600000316411706000003164186PA8421412025-04-24False
17060000031729L17/dossiers17170600000316411706000003164187PA7957222025-04-24False
17060000031730L17/dossiers17170600000316411706000003164188PA8416012025-04-24False
17060000031731L17/dossiers17170600000316411706000003164189PA7210242025-04-24False
17060000031732L17/dossiers17170600000316411706000003164190PA7212962025-04-24False
17060000031733L17/dossiers17170600000316411706000003164191PA7958882025-04-24False
17060000031734L17/dossiers17170600000316411706000003164192PA8172032025-04-012025-04-03False
17060000031735L17/dossiers17170600000316411706000003164193PA7191182025-04-24False
17060000031736L17/dossiers17170600000316411706000003164194PA7217502025-04-24False
17060000031737L17/dossiers17170600000316411706000003164195PA7203422025-04-24False
17060000031738L17/dossiers17170600000316411706000003164196PA13272025-04-24False
17060000031739L17/dossiers17170600000316411706000003164197PA6088262025-04-24False