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
17060000053761L17/dossiers17170600000536991706000005369961PA7210622025-12-09False
17060000053762L17/dossiers17170600000536991706000005369962PA8418452025-12-09False
17060000053763L17/dossiers17170600000536991706000005369963PA7959822025-12-09False
17060000053764L17/dossiers17170600000536991706000005369964PA7954662025-12-09False
17060000053765L17/dossiers17170600000536991706000005369965PA7937442025-12-09False
17060000053766L17/dossiers17170600000536991706000005369966PA7209522025-12-09False
17060000053767L17/dossiers17170600000536991706000005369967PA7941062025-12-09False
17060000053768L17/dossiers17170600000536991706000005369968PA7941662025-12-09False
17060000053769L17/dossiers17170600000536991706000005369969PA7951642025-12-09False
17060000053770L17/dossiers17170600000536991706000005369970PA7955962025-12-09False
17060000053783L17/dossiers1717060000053781170600000537811PA7749542026-01-13False
17060000053790L17/dossiers1717060000053788170600000537881PA7931342025-12-18False
17060000053791L17/dossiers1717060000053788170600000537882PA8407012025-12-18False
17060000053792L17/dossiers1717060000053788170600000537883PA7204682025-12-18False
17060000053793L17/dossiers1717060000053788170600000537884PA7940302025-12-18False
17060000053794L17/dossiers1717060000053788170600000537885PA8408572025-12-18False
17060000053795L17/dossiers1717060000053788170600000537886PA8409832025-12-18False
17060000053796L17/dossiers1717060000053788170600000537887PA7945902025-12-18False
17060000053797L17/dossiers1717060000053788170600000537888PA7931822025-12-18False
17060000053798L17/dossiers1717060000053788170600000537889PA8407212025-12-18False
17060000053799L17/dossiers17170600000537881706000005378810PA8417372025-12-18False
17060000053800L17/dossiers17170600000537881706000005378811PA7933822025-12-18False
17060000053801L17/dossiers17170600000537881706000005378812PA7219322025-12-18False
17060000053802L17/dossiers17170600000537881706000005378813PA7938522025-12-18False
17060000053818L17/dossiers1717060000053816170600000538161PA6109682025-12-18False
17060000053819L17/dossiers1717060000053816170600000538162PA7937802025-12-18False
17060000053820L17/dossiers1717060000053816170600000538163PA5888842025-12-18False
17060000053821L17/dossiers1717060000053816170600000538164PA8417012025-12-18False
17060000053822L17/dossiers1717060000053816170600000538165PA7953622025-12-18False
17060000053823L17/dossiers1717060000053816170600000538166PA7954542025-12-18False
17060000053824L17/dossiers1717060000053816170600000538167PA8409972025-12-18False
17060000053825L17/dossiers1717060000053816170600000538168PA8418852025-12-18False
17060000053826L17/dossiers1717060000053816170600000538169PA8415072025-12-18False
17060000053827L17/dossiers17170600000538161706000005381610PA7940082025-12-18False
17060000053828L17/dossiers17170600000538161706000005381611PA7212102025-12-18False
17060000053829L17/dossiers17170600000538161706000005381612PA7934522025-12-18False
17060000053830L17/dossiers17170600000538161706000005381613PA8413512025-12-18False
17060000053831L17/dossiers17170600000538161706000005381614PA7939802025-12-18False
17060000053832L17/dossiers17170600000538161706000005381615PA7950102025-12-18False
17060000053833L17/dossiers17170600000538161706000005381616PA8414192025-12-18False
17060000053834L17/dossiers17170600000538161706000005381617PA8420132025-12-18False
17060000053835L17/dossiers17170600000538161706000005381618PA8409472025-12-18False
17060000053836L17/dossiers17170600000538161706000005381619PA7940222025-12-18False
17060000053837L17/dossiers17170600000538161706000005381620PA7941462025-12-18False
17060000053838L17/dossiers17170600000538161706000005381621PA8412232025-12-18False
17060000053839L17/dossiers17170600000538161706000005381622PA7956362025-12-18False
17060000053840L17/dossiers17170600000538161706000005381623PA8420452025-12-18False
17060000053841L17/dossiers17170600000538161706000005381624PA7937082025-12-18False
17060000053842L17/dossiers17170600000538161706000005381625PA7941542025-12-18False
17060000053843L17/dossiers17170600000538161706000005381626PA7947782025-12-18False