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
17060000044004L17/dossiers17170600000439551706000004395548PA7935322025-10-01False
17060000044005L17/dossiers17170600000439551706000004395549PA3423842025-10-01False
17060000044006L17/dossiers17170600000439551706000004395550PA7954222025-10-01False
17060000044007L17/dossiers17170600000439551706000004395551PA7946862025-10-01False
17060000044008L17/dossiers17170600000439551706000004395552PA8412152025-10-01False
17060000044009L17/dossiers17170600000439551706000004395553PA7954822025-10-01False
17060000044010L17/dossiers17170600000439551706000004395554PA6106542025-10-01False
17060000044011L17/dossiers17170600000439551706000004395555PA8411912025-10-01False
17060000044012L17/dossiers17170600000439551706000004395556PA7219602025-10-01False
17060000044013L17/dossiers17170600000439551706000004395557PA7938722025-10-01False
17060000044014L17/dossiers17170600000439551706000004395558PA7937562025-10-01False
17060000044015L17/dossiers17170600000439551706000004395559PA7960622025-10-01False
17060000044016L17/dossiers17170600000439551706000004395560PA7195782025-10-01False
17060000044017L17/dossiers17170600000439551706000004395561PA7210622025-10-01False
17060000044018L17/dossiers17170600000439551706000004395562PA8418452025-10-01False
17060000044019L17/dossiers17170600000439551706000004395563PA7959822025-10-01False
17060000044020L17/dossiers17170600000439551706000004395564PA7954662025-10-01False
17060000044021L17/dossiers17170600000439551706000004395565PA7937442025-10-01False
17060000044022L17/dossiers17170600000439551706000004395566PA7209522025-10-01False
17060000044023L17/dossiers17170600000439551706000004395567PA7941062025-10-01False
17060000044024L17/dossiers17170600000439551706000004395568PA7941662025-10-01False
17060000044025L17/dossiers17170600000439551706000004395569PA7951642025-10-01False
17060000044026L17/dossiers17170600000439551706000004395570PA7955962025-10-01False
17060000044030L17/dossiers1717060000044028170600000440281PA7941662025-09-24False
17060000044031L17/dossiers1717060000044028170600000440282PA7952282025-09-24False
17060000044032L17/dossiers1717060000044028170600000440283PA7932622025-09-24False
17060000044033L17/dossiers1717060000044028170600000440284PA7949062025-09-24False
17060000044034L17/dossiers1717060000044028170600000440285PA7941382025-09-24False
17060000044035L17/dossiers1717060000044028170600000440286PA7955882025-09-24False
17060000044036L17/dossiers1717060000044028170600000440287PA7950842025-09-24False
17060000044037L17/dossiers1717060000044028170600000440288PA8421052025-09-24False
17060000044038L17/dossiers1717060000044028170600000440289PA8416572025-09-24False
17060000044039L17/dossiers17170600000440281706000004402810PA7204302025-09-24False
17060000044040L17/dossiers17170600000440281706000004402811PA7937722025-09-24False
17060000044041L17/dossiers17170600000440281706000004402812PA7956162025-09-24False
17060000044042L17/dossiers17170600000440281706000004402813PA7934442025-09-24False
17060000044043L17/dossiers17170600000440281706000004402814PA7949382025-09-24False
17060000044044L17/dossiers17170600000440281706000004402815PA7953182025-09-24False
17060000044045L17/dossiers17170600000440281706000004402816PA8410232025-09-24False
17060000044046L17/dossiers17170600000440281706000004402817PA7960902025-09-24False
17060000044047L17/dossiers17170600000440281706000004402818PA7939122025-09-24False
17060000044048L17/dossiers17170600000440281706000004402819PA8421872025-09-24False
17060000044049L17/dossiers17170600000440281706000004402820PA8420372025-09-24False
17060000044050L17/dossiers17170600000440281706000004402821PA7918122025-09-24False
17060000044051L17/dossiers17170600000440281706000004402822PA7937362025-09-24False
17060000044052L17/dossiers17170600000440281706000004402823PA7212022025-09-24False
17060000044053L17/dossiers17170600000440281706000004402824PA7951362025-09-24False
17060000044054L17/dossiers17170600000440281706000004402825PA7934642025-09-24False
17060000044055L17/dossiers17170600000440281706000004402826PA8421552025-09-24False
17060000044056L17/dossiers17170600000440281706000004402827PA7952002025-09-24False