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
17060000053900L17/dossiers17170600000538581706000005385841PA8414632026-05-13False
17060000053901L17/dossiers17170600000538581706000005385842PA8420452026-05-13False
17060000053902L17/dossiers17170600000538581706000005385843PA8407932026-05-13False
17060000053903L17/dossiers17170600000538581706000005385844PA7212702026-05-13False
17060000053904L17/dossiers17170600000538581706000005385845PA7937082026-05-13False
17060000053905L17/dossiers17170600000538581706000005385846PA7942702026-05-13False
17060000053906L17/dossiers17170600000538581706000005385847PA6081722026-05-13False
17060000053907L17/dossiers17170600000538581706000005385848PA7936642026-05-13False
17060000053908L17/dossiers17170600000538581706000005385849PA8409552026-05-13False
17060000053909L17/dossiers17170600000538581706000005385850PA7941542026-05-13False
17060000053910L17/dossiers17170600000538581706000005385851PA7947782026-05-13False
17060000053911L17/dossiers17170600000538581706000005385852PA7952402026-05-13False
17060000053912L17/dossiers17170600000538581706000005385853PA3421962026-05-13False
17060000053913L17/dossiers17170600000538581706000005385854PA6065452026-05-13False
17060000053914L17/dossiers17170600000538581706000005385855PA6100022026-05-13False
17060000053915L17/dossiers17170600000538581706000005385856PA7958082026-05-13False
17060000053916L17/dossiers17170600000538581706000005385857PA7960182026-05-13False
17060000053917L17/dossiers17170600000538581706000005385858PA8416812026-05-13False
17060000053918L17/dossiers17170600000538581706000005385859PA7362012026-05-13False
17060000053919L17/dossiers17170600000538581706000005385860PA8417132026-05-13False
17060000053920L17/dossiers17170600000538581706000005385861PA7938162026-05-13False
17060000053921L17/dossiers17170600000538581706000005385862PA7199302026-05-13False
17060000053922L17/dossiers17170600000538581706000005385863PA29402026-05-13False
17060000053929L17/dossiers1717060000053927170600000539271PA8410672026-01-02False
17060000053930L17/dossiers1717060000053927170600000539272PA3096432026-01-02False
17060000053931L17/dossiers1717060000053927170600000539273PA8419732026-01-02False
17060000053932L17/dossiers1717060000053927170600000539274PA8407012026-01-02False
17060000053933L17/dossiers1717060000053927170600000539275PA7933222026-01-02False
17060000053934L17/dossiers1717060000053927170600000539276PA8407732026-01-02False
17060000053935L17/dossiers1717060000053927170600000539277PA8409832026-01-02False
17060000053936L17/dossiers1717060000053927170600000539278PA8413952026-01-02False
17060000053937L17/dossiers1717060000053927170600000539279PA8417692026-01-02False
17060000053938L17/dossiers17170600000539271706000005392710PA8406572026-01-02False
17060000053939L17/dossiers17170600000539271706000005392711PA8406852026-01-02False
17060000053940L17/dossiers17170600000539271706000005392712PA7945622026-01-02False
17060000053941L17/dossiers17170600000539271706000005392713PA7932382026-01-02False
17060000053942L17/dossiers17170600000539271706000005392714PA7944342026-01-02False
17060000053943L17/dossiers17170600000539271706000005392715PA8420012026-01-02False
17060000053944L17/dossiers17170600000539271706000005392716PA7960422026-01-02False
17060000053945L17/dossiers17170600000539271706000005392717PA7938442026-01-02False
17060000053946L17/dossiers17170600000539271706000005392718PA7931822026-01-02False
17060000053947L17/dossiers17170600000539271706000005392719PA7931342026-01-02False
17060000053948L17/dossiers17170600000539271706000005392720PA8400752026-01-02False
17060000053949L17/dossiers17170600000539271706000005392721PA8401192026-01-02False
17060000053950L17/dossiers17170600000539271706000005392722PA7932462026-01-02False
17060000053951L17/dossiers17170600000539271706000005392723PA7938922026-01-02False
17060000053952L17/dossiers17170600000539271706000005392724PA7935922026-01-02False
17060000053953L17/dossiers17170600000539271706000005392725PA8408692026-01-02False
17060000053954L17/dossiers17170600000539271706000005392726PA8408572026-01-02False
17060000053955L17/dossiers17170600000539271706000005392727PA7959742026-01-02False