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
17060000045880L17/dossiers17170600000458011706000004580178PA7945902025-09-17False
17060000045881L17/dossiers17170600000458011706000004580179PA8415872025-09-17False
17060000045882L17/dossiers17170600000458011706000004580180PA8415632025-09-17False
17060000045883L17/dossiers17170600000458011706000004580181PA7945302025-09-17False
17060000045884L17/dossiers17170600000458011706000004580182PA8408372025-09-17False
17060000045885L17/dossiers17170600000458011706000004580183PA8418252025-09-17False
17060000045886L17/dossiers17170600000458011706000004580184PA7947702025-09-17False
17060000045887L17/dossiers17170600000458011706000004580185PA7933142025-09-17False
17060000045888L17/dossiers17170600000458011706000004580186PA7933302025-09-17False
17060000045889L17/dossiers17170600000458011706000004580187PA7936162025-09-17False
17060000045890L17/dossiers17170600000458011706000004580188PA7194362025-09-17False
17060000045891L17/dossiers17170600000458011706000004580189PA7933542025-09-17False
17060000045892L17/dossiers17170600000458011706000004580190PA7957862025-09-17False
17060000045893L17/dossiers17170600000458011706000004580191PA7943222025-09-17False
17060000045894L17/dossiers17170600000458011706000004580192PA7938522025-09-17False
17060000045895L17/dossiers17170600000458011706000004580193PA8409152025-09-17False
17060000045896L17/dossiers17170600000458011706000004580194PA7936962025-09-17False
17060000045897L17/dossiers17170600000458011706000004580195PA7955522025-09-17False
17060000045898L17/dossiers17170600000458011706000004580196PA7946702025-09-17False
17060000045899L17/dossiers17170600000458011706000004580197PA8411992025-09-17False
17060000045900L17/dossiers17170600000458011706000004580198PA7945822025-09-17False
17060000045901L17/dossiers17170600000458011706000004580199PA7936562025-09-17False
17060000045902L17/dossiers171706000004580117060000045801100PA7959662025-09-17False
17060000045903L17/dossiers171706000004580117060000045801101PA7932302025-09-17False
17060000045904L17/dossiers171706000004580117060000045801102PA7932542025-09-17False
17060000045905L17/dossiers171706000004580117060000045801103PA8419552025-09-17False
17060000045906L17/dossiers171706000004580117060000045801104PA8419812025-09-17False
17060000045907L17/dossiers171706000004580117060000045801105PA8422272025-09-17False
17060000045908L17/dossiers171706000004580117060000045801106PA7944422025-09-17False
17060000045909L17/dossiers171706000004580117060000045801107PA7954102025-09-17False
17060000045910L17/dossiers171706000004580117060000045801108PA8420972025-09-17False
17060000045911L17/dossiers171706000004580117060000045801109PA7948942025-09-17False
17060000045912L17/dossiers171706000004580117060000045801110PA7945702025-09-17False
17060000045913L17/dossiers171706000004580117060000045801111PA7949542025-09-17False
17060000045914L17/dossiers171706000004580117060000045801112PA7960502025-09-17False
17060000045915L17/dossiers171706000004580117060000045801113PA8422552025-09-17False
17060000045916L17/dossiers171706000004580117060000045801114PA7933822025-09-17False
17060000045917L17/dossiers171706000004580117060000045801115PA7957782025-09-17False
17060000045918L17/dossiers171706000004580117060000045801116PA7945022025-09-17False
17060000045919L17/dossiers171706000004580117060000045801117PA8415532025-09-17False
17060000045920L17/dossiers171706000004580117060000045801118PA7932982025-09-17False
17060000045921L17/dossiers171706000004580117060000045801119PA8407812025-09-17False
17060000045922L17/dossiers171706000004580117060000045801120PA7949462025-09-17False
17060000045923L17/dossiers171706000004580117060000045801121PA8415752025-09-17False
17060000045924L17/dossiers171706000004580117060000045801122PA8414792025-09-17False
17060000045928L17/dossiers1717060000045926170600000459261PA7959982025-11-17False
17060000045929L17/dossiers1717060000045926170600000459262PA7952402025-11-17False
17060000045930L17/dossiers1717060000045926170600000459263PA7210622025-11-17False
17060000045931L17/dossiers1717060000045926170600000459264PA6431572025-11-17False
17060000045932L17/dossiers1717060000045926170600000459265PA7952002025-11-17False