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
17060000023722L17/dossiers17170600000236731706000002367348PA3423842025-02-24False
17060000023723L17/dossiers17170600000236731706000002367349PA7954222025-02-24False
17060000023724L17/dossiers17170600000236731706000002367350PA7946862025-02-24False
17060000023725L17/dossiers17170600000236731706000002367351PA8412152025-02-24False
17060000023726L17/dossiers17170600000236731706000002367352PA7954822025-02-24False
17060000023727L17/dossiers17170600000236731706000002367353PA6106542025-02-24False
17060000023728L17/dossiers17170600000236731706000002367354PA8411912025-02-24False
17060000023729L17/dossiers17170600000236731706000002367355PA7219602025-02-24False
17060000023730L17/dossiers17170600000236731706000002367356PA7938722025-02-24False
17060000023731L17/dossiers17170600000236731706000002367357PA8172112025-02-24False
17060000023732L17/dossiers17170600000236731706000002367358PA7937562025-02-24False
17060000023733L17/dossiers17170600000236731706000002367359PA7960622025-02-24False
17060000023734L17/dossiers17170600000236731706000002367360PA7195782025-02-24False
17060000023735L17/dossiers17170600000236731706000002367361PA7210622025-02-24False
17060000023736L17/dossiers17170600000236731706000002367362PA8418452025-02-24False
17060000023737L17/dossiers17170600000236731706000002367363PA7959822025-02-24False
17060000023738L17/dossiers17170600000236731706000002367364PA7954662025-02-24False
17060000023739L17/dossiers17170600000236731706000002367365PA7937442025-02-24False
17060000023740L17/dossiers17170600000236731706000002367366PA7209522025-02-24False
17060000023741L17/dossiers17170600000236731706000002367367PA7941062025-02-24False
17060000023742L17/dossiers17170600000236731706000002367368PA7941662025-02-24False
17060000023743L17/dossiers17170600000236731706000002367369PA7951642025-02-24False
17060000023744L17/dossiers17170600000236731706000002367370PA7955962025-02-24False
17060000023745L17/dossiers17170600000236731706000002367371PA8414192025-02-24False
17060000023746L17/dossiers17170600000236731706000002367372PA8401712025-02-24False
17060000023747L17/dossiers17170600000236731706000002367373PA7960182025-02-24False
17060000023748L17/dossiers17170600000236731706000002367374PA8417132025-02-24False
17060000023749L17/dossiers17170600000236731706000002367375PA8418932025-02-24False
17060000023750L17/dossiers17170600000236731706000002367376PA6109682025-02-24False
17060000023757L17/dossiers1717060000023755170600000237551PA7208922025-01-21False
17060000023758L17/dossiers1717060000023755170600000237552PA7952282025-01-21False
17060000023759L17/dossiers1717060000023755170600000237553PA7932622025-01-21False
17060000023760L17/dossiers1717060000023755170600000237554PA7949062025-01-21False
17060000023761L17/dossiers1717060000023755170600000237555PA7941382025-01-21False
17060000023762L17/dossiers1717060000023755170600000237556PA7955882025-01-21False
17060000023763L17/dossiers1717060000023755170600000237557PA7950842025-01-21False
17060000023764L17/dossiers1717060000023755170600000237558PA8421052025-01-21False
17060000023765L17/dossiers1717060000023755170600000237559PA8416572025-01-21False
17060000023766L17/dossiers17170600000237551706000002375510PA7204302025-01-21False
17060000023767L17/dossiers17170600000237551706000002375511PA7937722025-01-21False
17060000023768L17/dossiers17170600000237551706000002375512PA7956162025-01-21False
17060000023769L17/dossiers17170600000237551706000002375513PA7934442025-01-21False
17060000023770L17/dossiers17170600000237551706000002375514PA7949382025-01-21False
17060000023771L17/dossiers17170600000237551706000002375515PA7953182025-01-21False
17060000023772L17/dossiers17170600000237551706000002375516PA8410232025-01-21False
17060000023773L17/dossiers17170600000237551706000002375517PA7960902025-01-21False
17060000023774L17/dossiers17170600000237551706000002375518PA7939122025-01-21False
17060000023775L17/dossiers17170600000237551706000002375519PA8421872025-01-21False
17060000023776L17/dossiers17170600000237551706000002375520PA8420372025-01-21False
17060000023777L17/dossiers17170600000237551706000002375521PA7937362025-01-21False