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
17060000028457L17/dossiers17170600000284411706000002844115PA8407572025-03-11False
17060000028458L17/dossiers17170600000284411706000002844116PA7945982025-03-11False
17060000028459L17/dossiers17170600000284411706000002844117PA8408692025-03-11False
17060000028460L17/dossiers17170600000284411706000002844118PA8409832025-03-11False
17060000028461L17/dossiers17170600000284411706000002844119PA7959742025-03-11False
17060000028462L17/dossiers17170600000284411706000002844120PA7933142025-03-11False
17060000028463L17/dossiers17170600000284411706000002844121PA7194362025-03-11False
17060000028464L17/dossiers17170600000284411706000002844122PA7957862025-03-11False
17060000028465L17/dossiers17170600000284411706000002844123PA8417692025-03-11False
17060000028466L17/dossiers17170600000284411706000002844124PA8409152025-03-11False
17060000028467L17/dossiers17170600000284411706000002844125PA7936962025-03-11False
17060000028468L17/dossiers17170600000284411706000002844126PA7945822025-03-11False
17060000028469L17/dossiers17170600000284411706000002844127PA8406572025-03-11False
17060000028470L17/dossiers17170600000284411706000002844128PA7944422025-03-11False
17060000028471L17/dossiers17170600000284411706000002844129PA7949542025-03-11False
17060000028472L17/dossiers17170600000284411706000002844130PA7932982025-03-11False
17060000028476L17/dossiers1717060000028474170600000284741PA7952282025-05-05False
17060000028477L17/dossiers1717060000028474170600000284742PA7932622025-05-05False
17060000028478L17/dossiers1717060000028474170600000284743PA7949062025-05-05False
17060000028479L17/dossiers1717060000028474170600000284744PA7941382025-05-05False
17060000028480L17/dossiers1717060000028474170600000284745PA7955882025-05-05False
17060000028481L17/dossiers1717060000028474170600000284746PA7950842025-05-05False
17060000028482L17/dossiers1717060000028474170600000284747PA8421052025-05-05False
17060000028483L17/dossiers1717060000028474170600000284748PA8416572025-05-05False
17060000028484L17/dossiers1717060000028474170600000284749PA7204302025-05-05False
17060000028485L17/dossiers17170600000284741706000002847410PA7937722025-05-05False
17060000028486L17/dossiers17170600000284741706000002847411PA7956162025-05-05False
17060000028487L17/dossiers17170600000284741706000002847412PA7934442025-05-05False
17060000028488L17/dossiers17170600000284741706000002847413PA7949382025-05-05False
17060000028489L17/dossiers17170600000284741706000002847414PA7953182025-05-05False
17060000028490L17/dossiers17170600000284741706000002847415PA8410232025-05-05False
17060000028491L17/dossiers17170600000284741706000002847416PA7960902025-05-05False
17060000028492L17/dossiers17170600000284741706000002847417PA7939122025-05-05False
17060000028493L17/dossiers17170600000284741706000002847418PA8421872025-05-05False
17060000028494L17/dossiers17170600000284741706000002847419PA8420372025-05-05False
17060000028495L17/dossiers17170600000284741706000002847420PA7918122025-05-05False
17060000028496L17/dossiers17170600000284741706000002847421PA7937362025-05-05False
17060000028497L17/dossiers17170600000284741706000002847422PA7212022025-05-05False
17060000028498L17/dossiers17170600000284741706000002847423PA7951362025-05-05False
17060000028499L17/dossiers17170600000284741706000002847424PA7934642025-05-05False
17060000028500L17/dossiers17170600000284741706000002847425PA8421552025-05-05False
17060000028501L17/dossiers17170600000284741706000002847426PA7952002025-05-05False
17060000028502L17/dossiers17170600000284741706000002847427PA7958442025-05-05False
17060000028503L17/dossiers17170600000284741706000002847428PA8412512025-05-05False
17060000028504L17/dossiers17170600000284741706000002847429PA7947862025-05-05False
17060000028505L17/dossiers17170600000284741706000002847430PA7948702025-05-05False
17060000028506L17/dossiers17170600000284741706000002847431PA7960702025-05-05False
17060000028507L17/dossiers17170600000284741706000002847432PA7953102025-05-05False
17060000028508L17/dossiers17170600000284741706000002847433PA7944782025-05-05False
17060000028509L17/dossiers17170600000284741706000002847434PA8419472025-05-05False