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
17060000020376L17/dossiers17170600000203211706000002032154PA8419312024-12-16False
17060000020377L17/dossiers17170600000203211706000002032155PA7193382024-12-16False
17060000020378L17/dossiers17170600000203211706000002032156PA7203702024-12-16False
17060000020379L17/dossiers17170600000203211706000002032157PA7196402024-12-16False
17060000020380L17/dossiers17170600000203211706000002032158PA7951762024-12-16False
17060000020381L17/dossiers17170600000203211706000002032159PA7192722024-12-16False
17060000020382L17/dossiers17170600000203211706000002032160PA7956642024-12-16False
17060000020383L17/dossiers17170600000203211706000002032161PA8172032024-12-16False
17060000020384L17/dossiers17170600000203211706000002032162PA7959622024-12-16False
17060000020385L17/dossiers17170600000203211706000002032163PA8421472024-12-16False
17060000020386L17/dossiers17170600000203211706000002032164PA7948102024-12-16False
17060000020387L17/dossiers17170600000203211706000002032165PA7944662024-12-16False
17060000020388L17/dossiers17170600000203211706000002032166PA7196322024-12-16False
17060000020389L17/dossiers17170600000203211706000002032167PA7218442024-12-16False
17060000020390L17/dossiers17170600000203211706000002032168PA7207202024-12-16False
17060000020391L17/dossiers17170600000203211706000002032169PA7219162024-12-16False
17060000020392L17/dossiers17170600000203211706000002032170PA8423232024-12-16False
17060000020393L17/dossiers17170600000203211706000002032171PA7200662024-12-16False
17060000020394L17/dossiers17170600000203211706000002032172PA7955282024-12-16False
17060000020395L17/dossiers17170600000203211706000002032173PA7214582024-12-16False
17060000020396L17/dossiers17170600000203211706000002032174PA7958882024-12-16False
17060000020397L17/dossiers17170600000203211706000002032175PA7932702024-12-16False
17060000020398L17/dossiers17170600000203211706000002032176PA7201382024-12-16False
17060000020399L17/dossiers17170600000203211706000002032177PA7572252024-12-16False
17060000020400L17/dossiers17170600000203211706000002032178PA7201902024-12-16False
17060000020401L17/dossiers17170600000203211706000002032179PA7944862024-12-16False
17060000020402L17/dossiers17170600000203211706000002032180PA7941782024-12-16False
17060000020403L17/dossiers17170600000203211706000002032181PA7195502024-12-16False
17060000020404L17/dossiers17170600000203211706000002032182PA6073952024-12-16False
17060000020405L17/dossiers17170600000203211706000002032183PA7221022024-12-16False
17060000020406L17/dossiers17170600000203211706000002032184PA7195122024-12-16False
17060000020407L17/dossiers17170600000203211706000002032185PA7950262024-12-16False
17060000020408L17/dossiers17170600000203211706000002032186PA7211702024-12-16False
17060000020409L17/dossiers17170600000203211706000002032187PA7950462024-12-16False
17060000020410L17/dossiers17170600000203211706000002032188PA7199222024-12-16False
17060000020411L17/dossiers17170600000203211706000002032189PA7213362024-12-16False
17060000020412L17/dossiers17170600000203211706000002032190PA7192182024-12-16False
17060000020413L17/dossiers17170600000203211706000002032191PA7949822024-12-16False
17060000020414L17/dossiers17170600000203211706000002032192PA7933982024-12-16False
17060000020415L17/dossiers17170600000203211706000002032193PA7959202024-12-16False
17060000020416L17/dossiers17170600000203211706000002032194PA7951002024-12-16False
17060000020417L17/dossiers17170600000203211706000002032195PA8410132024-12-16False
17060000020418L17/dossiers17170600000203211706000002032196PA7190802024-12-16False
17060000020419L17/dossiers17170600000203211706000002032197PA7952402024-12-16False
17060000020420L17/dossiers17170600000203211706000002032198PA6872142024-12-16False
17060000020421L17/dossiers17170600000203211706000002032199PA7945542024-12-16False
17060000020422L17/dossiers171706000002032117060000020321100PA7952782024-12-16False
17060000020423L17/dossiers171706000002032117060000020321101PA7190322024-12-16False
17060000020424L17/dossiers171706000002032117060000020321102PA7223362024-12-16False
17060000020425L17/dossiers171706000002032117060000020321103PA6080162024-12-16False