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
17060000052989L17/dossiers17170600000529751706000005297513PA7944862026-06-24False
17060000052990L17/dossiers17170600000529751706000005297514PA7195582026-06-24False
17060000052991L17/dossiers17170600000529751706000005297515PA7930942026-06-24False
17060000052992L17/dossiers17170600000529751706000005297516PA7362012026-06-24False
17060000052993L17/dossiers17170600000529751706000005297517PA8413592026-06-24False
17060000052994L17/dossiers17170600000529751706000005297518PA3332852026-06-24False
17060000052995L17/dossiers17170600000529751706000005297519PA8420132026-06-24False
17060000052999L17/dossiers1717060000052997170600000529971PA7952402025-12-02False
17060000053006L17/dossiers1717060000053004170600000530041PA8422112026-02-20False
17060000053007L17/dossiers1717060000053004170600000530042PA7952582026-02-20False
17060000053008L17/dossiers1717060000053004170600000530043PA7212342026-02-20False
17060000053009L17/dossiers1717060000053004170600000530044PA8172032026-02-20False
17060000053010L17/dossiers1717060000053004170600000530045PA7572252026-02-20False
17060000053011L17/dossiers1717060000053004170600000530046PA7951362026-02-20False
17060000053012L17/dossiers1717060000053004170600000530047PA6106542026-02-20False
17060000053013L17/dossiers1717060000053004170600000530048PA7209762026-02-20False
17060000053014L17/dossiers1717060000053004170600000530049PA7937962026-02-20False
17060000053015L17/dossiers17170600000530041706000005300410PA7192862026-02-20False
17060000053016L17/dossiers17170600000530041706000005300411PA6076192026-02-20False
17060000053017L17/dossiers17170600000530041706000005300412PA7960782026-02-20False
17060000053018L17/dossiers17170600000530041706000005300413PA8413592026-02-20False
17060000053019L17/dossiers17170600000530041706000005300414PA7191382026-02-20False
17060000053020L17/dossiers17170600000530041706000005300415PA9422026-02-20False
17060000053021L17/dossiers17170600000530041706000005300416PA8419312026-02-20False
17060000053022L17/dossiers17170600000530041706000005300417PA7196402026-02-20False
17060000053023L17/dossiers17170600000530041706000005300418PA7947022026-02-20False
17060000053024L17/dossiers17170600000530041706000005300419PA6056942026-02-20False
17060000053025L17/dossiers17170600000530041706000005300420PA7951002026-02-20False
17060000053026L17/dossiers17170600000530041706000005300421PA7951242026-02-20False
17060000053027L17/dossiers17170600000530041706000005300422PA2673182026-02-20False
17060000053028L17/dossiers17170600000530041706000005300423PA7931222026-02-20False
17060000053029L17/dossiers17170600000530041706000005300424PA7222842026-02-20False
17060000053030L17/dossiers17170600000530041706000005300425PA7199142026-02-20False
17060000053031L17/dossiers17170600000530041706000005300426PA7953742026-02-20False
17060000053032L17/dossiers17170600000530041706000005300427PA7221622026-02-20False
17060000053033L17/dossiers17170600000530041706000005300428PA7201622026-02-20False
17060000053034L17/dossiers17170600000530041706000005300429PA7195582026-02-20False
17060000053035L17/dossiers17170600000530041706000005300430PA7207202026-02-20False
17060000053036L17/dossiers17170600000530041706000005300431PA7202562026-02-20False
17060000053037L17/dossiers17170600000530041706000005300432PA7937162026-02-20False
17060000053038L17/dossiers17170600000530041706000005300433PA7200382026-02-20False
17060000053039L17/dossiers17170600000530041706000005300434PA7223742026-02-20False
17060000053040L17/dossiers17170600000530041706000005300435PA7948542026-02-20False
17060000053041L17/dossiers17170600000530041706000005300436PA7749602026-02-20False
17060000053042L17/dossiers17170600000530041706000005300437PA7940942026-02-20False
17060000053043L17/dossiers17170600000530041706000005300438PA6431572026-02-20False
17060000053044L17/dossiers17170600000530041706000005300439PA6427642026-02-20False
17060000053045L17/dossiers17170600000530041706000005300440PA8416812026-02-20False
17060000053046L17/dossiers17170600000530041706000005300441PA8413152026-02-20False
17060000053047L17/dossiers17170600000530041706000005300442PA8421952026-02-20False