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
17060000052718L17/dossiers171706000005259517060000052595122PA8410912026-01-28False
17060000052719L17/dossiers171706000005259517060000052595123PA7960182026-01-28False
17060000052720L17/dossiers171706000005259517060000052595124PA8416812026-01-28False
17060000052721L17/dossiers171706000005259517060000052595125PA7944862026-01-28False
17060000052722L17/dossiers171706000005259517060000052595126PA7362012026-01-28False
17060000052723L17/dossiers171706000005259517060000052595127PA7941782026-01-28False
17060000052724L17/dossiers171706000005259517060000052595128PA8417132026-01-28False
17060000052725L17/dossiers171706000005259517060000052595129PA7959202026-01-28False
17060000052726L17/dossiers171706000005259517060000052595130PA7953502026-01-28False
17060000052727L17/dossiers171706000005259517060000052595131PA7944942026-01-28False
17060000052728L17/dossiers171706000005259517060000052595132PA7195122026-01-28False
17060000052729L17/dossiers171706000005259517060000052595133PA7950262026-01-28False
17060000052730L17/dossiers171706000005259517060000052595134PA7214742026-01-28False
17060000052731L17/dossiers171706000005259517060000052595135PA29402026-01-28False
17060000052732L17/dossiers171706000005259517060000052595136PA8172032026-01-28False
17060000052733L17/dossiers171706000005259517060000052595137PA7938162026-01-28False
17060000052734L17/dossiers171706000005259517060000052595138PA8416332026-01-28False
17060000052738L17/dossiers1717060000052736170600000527361PA7951442026-01-07False
17060000052739L17/dossiers1717060000052736170600000527362PA5692026-01-07False
17060000052740L17/dossiers1717060000052736170600000527363PA8408172026-01-07False
17060000052741L17/dossiers1717060000052736170600000527364PA7191382026-01-07False
17060000052742L17/dossiers1717060000052736170600000527365PA7946582026-01-07False
17060000052743L17/dossiers1717060000052736170600000527366PA6056942026-01-07False
17060000052744L17/dossiers1717060000052736170600000527367PA7212962026-01-07False
17060000052745L17/dossiers1717060000052736170600000527368PA7203542026-01-07False
17060000052746L17/dossiers1717060000052736170600000527369PA7200382026-01-07False
17060000052747L17/dossiers17170600000527361706000005273610PA7948302026-01-07False
17060000052748L17/dossiers17170600000527361706000005273611PA7935722026-01-07False
17060000052749L17/dossiers17170600000527361706000005273612PA7949942026-01-07False
17060000052750L17/dossiers17170600000527361706000005273613PA7952402026-01-07False
17060000052751L17/dossiers17170600000527361706000005273614PA7950262026-01-07False
17060000052752L17/dossiers17170600000527361706000005273615PA3315822026-01-07False
17060000052753L17/dossiers17170600000527361706000005273616PA7194722026-01-07False
17060000052763L17/dossiers1717060000052761170600000527611PA7944862025-12-10False
17060000052764L17/dossiers1717060000052761170600000527612PA7201462025-12-10False
17060000052765L17/dossiers1717060000052761170600000527613PA7201542025-12-10False
17060000052766L17/dossiers1717060000052761170600000527614PA7120142025-12-10False
17060000052767L17/dossiers1717060000052761170600000527615PA7221022025-12-10False
17060000052771L17/dossiers1717060000052769170600000527691PA3682025-12-05False
17060000052772L17/dossiers1717060000052769170600000527692PA7211582025-12-05False
17060000052773L17/dossiers1717060000052769170600000527693PA7951442025-12-05False
17060000052774L17/dossiers1717060000052769170600000527694PA7221902025-12-05False
17060000052775L17/dossiers1717060000052769170600000527695PA6428472025-12-05False
17060000052776L17/dossiers1717060000052769170600000527696PA7188842025-12-05False
17060000052777L17/dossiers1717060000052769170600000527697PA6429352025-12-05False
17060000052778L17/dossiers1717060000052769170600000527698PA3322282025-12-05False
17060000052779L17/dossiers1717060000052769170600000527699PA8051662025-12-05False
17060000052780L17/dossiers17170600000527691706000005276910PA4085782025-12-05False
17060000052781L17/dossiers17170600000527691706000005276911PA6872142025-12-05False
17060000052782L17/dossiers17170600000527691706000005276912PA7192182025-12-05False