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
17060000026671L17/dossiers17170600000266351706000002663535PA8417132025-02-13False
17060000026672L17/dossiers17170600000266351706000002663536PA7939482025-02-13False
17060000026673L17/dossiers17170600000266351706000002663537PA29402025-02-13False
17060000026677L17/dossiers1717060000026675170600000266751PA7952442025-02-13False
17060000026678L17/dossiers1717060000026675170600000266752PA7932102025-02-13False
17060000026679L17/dossiers1717060000026675170600000266753PA7937962025-02-13False
17060000026687L17/dossiers1717060000026685170600000266851PA3315822025-03-31False
17060000026688L17/dossiers1717060000026685170600000266852PA3359992025-03-31False
17060000026689L17/dossiers1717060000026685170600000266853PA7942062025-03-31False
17060000026690L17/dossiers1717060000026685170600000266854PA2670422025-03-31False
17060000026691L17/dossiers1717060000026685170600000266855PA7940822025-03-31False
17060000026692L17/dossiers1717060000026685170600000266856PA3300082025-03-31False
17060000026693L17/dossiers1717060000026685170600000266857PA6057452025-03-31False
17060000026694L17/dossiers1717060000026685170600000266858PA7190522025-03-31False
17060000026695L17/dossiers1717060000026685170600000266859PA7206442025-03-31False
17060000026696L17/dossiers17170600000266851706000002668510PA7951002025-03-31False
17060000026697L17/dossiers17170600000266851706000002668511PA7937362025-03-31False
17060000026698L17/dossiers17170600000266851706000002668512PA7937962025-03-31False
17060000026699L17/dossiers17170600000266851706000002668513PA7941542025-03-31False
17060000026700L17/dossiers17170600000266851706000002668514PA7203422025-03-31False
17060000026701L17/dossiers17170600000266851706000002668515PA7931742025-03-31False
17060000026702L17/dossiers17170600000266851706000002668516PA7933982025-03-31False
17060000026703L17/dossiers17170600000266851706000002668517PA6431922025-03-31False
17060000026704L17/dossiers17170600000266851706000002668518PA2673062025-03-31False
17060000026705L17/dossiers17170600000266851706000002668519PA7952442025-03-31False
17060000026706L17/dossiers17170600000266851706000002668520PA29402025-03-31False
17060000026707L17/dossiers17170600000266851706000002668521PA6431752025-03-31False
17060000026708L17/dossiers17170600000266851706000002668522PA7946582025-03-31False
17060000026709L17/dossiers17170600000266851706000002668523PA7220702025-03-31False
17060000026710L17/dossiers17170600000266851706000002668524PA13272025-03-31False
17060000026711L17/dossiers17170600000266851706000002668525PA7954222025-03-31False
17060000026712L17/dossiers17170600000266851706000002668526PA8226172025-03-31False
17060000026713L17/dossiers17170600000266851706000002668527PA7953742025-03-31False
17060000026714L17/dossiers17170600000266851706000002668528PA6427642025-03-31False
17060000026715L17/dossiers17170600000266851706000002668529PA6426952025-03-242025-03-26False
17060000026716L17/dossiers17170600000266851706000002668530PA7201002025-03-31False
17060000026717L17/dossiers17170600000266851706000002668531PA7936642025-03-31False
17060000026718L17/dossiers17170600000266851706000002668532PA7218962025-03-31False
17060000026719L17/dossiers17170600000266851706000002668533PA3322282025-03-31False
17060000026720L17/dossiers17170600000266851706000002668534PA7935322025-03-31False
17060000026721L17/dossiers17170600000266851706000002668535PA6076192025-03-31False
17060000026722L17/dossiers17170600000266851706000002668536PA7199682025-03-032025-03-18False
17060000026723L17/dossiers17170600000266851706000002668537PA7954302025-03-31False
17060000026724L17/dossiers17170600000266851706000002668538PA7203622025-03-31False
17060000026725L17/dossiers17170600000266851706000002668539PA8413512025-03-31False
17060000026726L17/dossiers17170600000266851706000002668540PA7208382025-03-31False
17060000026727L17/dossiers17170600000266851706000002668541PA7218442025-03-31False
17060000026728L17/dossiers17170600000266851706000002668542PA7951082025-03-31False
17060000026729L17/dossiers17170600000266851706000002668543PA7214862025-03-31False
17060000026730L17/dossiers17170600000266851706000002668544PA7195582025-03-31False