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
17060000035440L17/dossiers17170600000353701706000003537069PA8414192025-05-30False
17060000035441L17/dossiers17170600000353701706000003537070PA8409392025-05-30False
17060000035442L17/dossiers17170600000353701706000003537071PA8401712025-05-30False
17060000035443L17/dossiers17170600000353701706000003537072PA15672025-05-30False
17060000035444L17/dossiers17170600000353701706000003537073PA7953102025-05-30False
17060000035445L17/dossiers17170600000353701706000003537074PA8422632025-05-30False
17060000035446L17/dossiers17170600000353701706000003537075PA8418132025-05-30False
17060000035447L17/dossiers17170600000353701706000003537076PA8409472025-05-30False
17060000035448L17/dossiers17170600000353701706000003537077PA8418532025-05-30False
17060000035449L17/dossiers17170600000353701706000003537078PA6084162025-05-30False
17060000035450L17/dossiers17170600000353701706000003537079PA7940822025-05-30False
17060000035451L17/dossiers17170600000353701706000003537080PA16542025-05-30False
17060000035452L17/dossiers17170600000353701706000003537081PA7940222025-05-30False
17060000035453L17/dossiers17170600000353701706000003537082PA7203542025-05-30False
17060000035454L17/dossiers17170600000353701706000003537083PA7200382025-05-30False
17060000035455L17/dossiers17170600000353701706000003537084PA6431922025-05-30False
17060000035456L17/dossiers17170600000353701706000003537085PA3350542025-05-30False
17060000035457L17/dossiers17170600000353701706000003537086PA7951562025-05-30False
17060000035458L17/dossiers17170600000353701706000003537087PA7192822025-05-30False
17060000035459L17/dossiers17170600000353701706000003537088PA7941462025-05-30False
17060000035460L17/dossiers17170600000353701706000003537089PA8412232025-05-30False
17060000035461L17/dossiers17170600000353701706000003537090PA7749622025-05-30False
17060000035462L17/dossiers17170600000353701706000003537091PA8409792025-05-30False
17060000035463L17/dossiers17170600000353701706000003537092PA7918242025-05-30False
17060000035464L17/dossiers17170600000353701706000003537093PA7952442025-05-30False
17060000035465L17/dossiers17170600000353701706000003537094PA7749582025-05-30False
17060000035466L17/dossiers17170600000353701706000003537095PA8407652025-05-30False
17060000035467L17/dossiers17170600000353701706000003537096PA6427252025-05-30False
17060000035468L17/dossiers17170600000353701706000003537097PA7947022025-05-30False
17060000035469L17/dossiers17170600000353701706000003537098PA7956362025-05-30False
17060000035470L17/dossiers17170600000353701706000003537099PA7942062025-05-30False
17060000035471L17/dossiers171706000003537017060000035370100PA3423842025-05-30False
17060000035472L17/dossiers171706000003537017060000035370101PA7209762025-05-30False
17060000035473L17/dossiers171706000003537017060000035370102PA7954222025-05-30False
17060000035474L17/dossiers171706000003537017060000035370103PA8422712025-05-30False
17060000035475L17/dossiers171706000003537017060000035370104PA8419312025-05-30False
17060000035476L17/dossiers171706000003537017060000035370105PA8414632025-05-30False
17060000035477L17/dossiers171706000003537017060000035370106PA8412152025-05-30False
17060000035478L17/dossiers171706000003537017060000035370107PA6076192025-05-30False
17060000035479L17/dossiers171706000003537017060000035370108PA6431572025-05-30False
17060000035480L17/dossiers171706000003537017060000035370109PA6106542025-05-30False
17060000035481L17/dossiers171706000003537017060000035370110PA8411072025-05-30False
17060000035482L17/dossiers171706000003537017060000035370111PA8420452025-05-30False
17060000035483L17/dossiers171706000003537017060000035370112PA7932102025-05-30False
17060000035484L17/dossiers171706000003537017060000035370113PA8413592025-05-30False
17060000035485L17/dossiers171706000003537017060000035370114PA8407932025-05-30False
17060000035486L17/dossiers171706000003537017060000035370115PA8172112025-05-30False
17060000035487L17/dossiers171706000003537017060000035370116PA6081722025-05-30False
17060000035488L17/dossiers171706000003537017060000035370117PA7936642025-05-30False
17060000035489L17/dossiers171706000003537017060000035370118PA6075532025-05-30False