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
17060000053546L17/dossiers17170600000534911706000005349154PA8411912025-12-09False
17060000053547L17/dossiers17170600000534911706000005349155PA7219602025-12-09False
17060000053548L17/dossiers17170600000534911706000005349156PA7938722025-12-09False
17060000053549L17/dossiers17170600000534911706000005349157PA8172112025-12-09False
17060000053550L17/dossiers17170600000534911706000005349158PA7937562025-12-09False
17060000053551L17/dossiers17170600000534911706000005349159PA7960622025-12-09False
17060000053552L17/dossiers17170600000534911706000005349160PA7195782025-12-09False
17060000053553L17/dossiers17170600000534911706000005349161PA7210622025-12-09False
17060000053554L17/dossiers17170600000534911706000005349162PA8418452025-12-09False
17060000053555L17/dossiers17170600000534911706000005349163PA7959822025-12-09False
17060000053556L17/dossiers17170600000534911706000005349164PA7954662025-12-09False
17060000053557L17/dossiers17170600000534911706000005349165PA7937442025-12-09False
17060000053558L17/dossiers17170600000534911706000005349166PA7209522025-12-09False
17060000053559L17/dossiers17170600000534911706000005349167PA7941062025-12-09False
17060000053560L17/dossiers17170600000534911706000005349168PA7941662025-12-09False
17060000053561L17/dossiers17170600000534911706000005349169PA7951642025-12-09False
17060000053562L17/dossiers17170600000534911706000005349170PA7955962025-12-09False
17060000053566L17/dossiers1717060000053564170600000535641PA7937802026-02-03False
17060000053567L17/dossiers1717060000053564170600000535642PA7953622026-02-03False
17060000053568L17/dossiers1717060000053564170600000535643PA8415072026-02-03False
17060000053569L17/dossiers1717060000053564170600000535644PA7212102026-02-03False
17060000053570L17/dossiers1717060000053564170600000535645PA7939802026-02-03False
17060000053571L17/dossiers1717060000053564170600000535646PA8420132026-02-03False
17060000053572L17/dossiers1717060000053564170600000535647PA8420452026-02-03False
17060000053573L17/dossiers1717060000053564170600000535648PA7937082026-02-03False
17060000053574L17/dossiers1717060000053564170600000535649PA7936642026-02-03False
17060000053575L17/dossiers17170600000535641706000005356410PA7941542026-02-03False
17060000053576L17/dossiers17170600000535641706000005356411PA7947782026-02-03False
17060000053577L17/dossiers17170600000535641706000005356412PA6065452026-02-03False
17060000053578L17/dossiers17170600000535641706000005356413PA6100022026-02-03False
17060000053579L17/dossiers17170600000535641706000005356414PA8417132026-02-03False
17060000053580L17/dossiers17170600000535641706000005356415PA8412952026-02-03False
17060000053581L17/dossiers17170600000535641706000005356416PA7950102026-02-03False
17060000053582L17/dossiers17170600000535641706000005356417PA5888842026-02-03False
17060000053583L17/dossiers17170600000535641706000005356418PA7952402026-02-03False
17060000053584L17/dossiers17170600000535641706000005356419PA7749622026-02-03False
17060000053585L17/dossiers17170600000535641706000005356420PA8416812026-02-03False
17060000053586L17/dossiers17170600000535641706000005356421PA6081722026-02-03False
17060000053587L17/dossiers17170600000535641706000005356422PA7940942026-02-03False
17060000053588L17/dossiers17170600000535641706000005356423PA7960182026-02-03False
17060000053589L17/dossiers17170600000535641706000005356424PA8408292026-02-03False
17060000053590L17/dossiers17170600000535641706000005356425PA8409472026-02-03False
17060000053591L17/dossiers17170600000535641706000005356426PA6431922026-02-03False
17060000053592L17/dossiers17170600000535641706000005356427PA8409392026-02-03False
17060000053593L17/dossiers17170600000535641706000005356428PA8416332026-02-03False
17060000053597L17/dossiers1717060000053595170600000535951PA7190322026-02-23False
17060000053598L17/dossiers1717060000053595170600000535952PA8418532026-02-162026-02-19False
17060000053599L17/dossiers1717060000053595170600000535953PA6056942026-02-23False
17060000053600L17/dossiers1717060000053595170600000535954PA2673182026-02-23False
17060000053601L17/dossiers1717060000053595170600000535955PA7947022026-02-23False