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
17060000036182L17/dossiers1717060000036175170600000361756PA7749622025-04-22False
17060000036183L17/dossiers1717060000036175170600000361757PA3356122025-04-22False
17060000036184L17/dossiers1717060000036175170600000361758PA7960102025-04-22False
17060000036185L17/dossiers1717060000036175170600000361759PA8422712025-04-22False
17060000036186L17/dossiers17170600000361751706000003617510PA7931742025-04-22False
17060000036187L17/dossiers17170600000361751706000003617511PA7958202025-04-22False
17060000036188L17/dossiers17170600000361751706000003617512PA7212702025-04-22False
17060000036189L17/dossiers17170600000361751706000003617513PA7952402025-04-22False
17060000036190L17/dossiers17170600000361751706000003617514PA7958762025-04-22False
17060000036191L17/dossiers17170600000361751706000003617515PA6057452025-04-22False
17060000036192L17/dossiers17170600000361751706000003617516PA8422992025-04-22False
17060000036196L17/dossiers1717060000036194170600000361941PA7961062025-04-22False
17060000036197L17/dossiers1717060000036194170600000361942PA7208382025-04-22False
17060000036198L17/dossiers1717060000036194170600000361943PA7947102025-04-22False
17060000036199L17/dossiers1717060000036194170600000361944PA7958682025-04-22False
17060000036200L17/dossiers1717060000036194170600000361945PA7218962025-04-22False
17060000036201L17/dossiers1717060000036194170600000361946PA7959982025-04-22False
17060000036202L17/dossiers1717060000036194170600000361947PA7749622025-04-22False
17060000036203L17/dossiers1717060000036194170600000361948PA3356122025-04-22False
17060000036204L17/dossiers1717060000036194170600000361949PA7960102025-04-22False
17060000036205L17/dossiers17170600000361941706000003619410PA8422712025-04-22False
17060000036206L17/dossiers17170600000361941706000003619411PA7931742025-04-22False
17060000036207L17/dossiers17170600000361941706000003619412PA7958202025-04-22False
17060000036208L17/dossiers17170600000361941706000003619413PA7212702025-04-22False
17060000036209L17/dossiers17170600000361941706000003619414PA7952402025-04-22False
17060000036210L17/dossiers17170600000361941706000003619415PA7958762025-04-22False
17060000036211L17/dossiers17170600000361941706000003619416PA8422992025-04-22False
17060000036215L17/dossiers1717060000036213170600000362131PA7208382025-04-22False
17060000036216L17/dossiers1717060000036213170600000362132PA7947102025-04-22False
17060000036217L17/dossiers1717060000036213170600000362133PA7958682025-04-22False
17060000036218L17/dossiers1717060000036213170600000362134PA7218962025-04-22False
17060000036219L17/dossiers1717060000036213170600000362135PA7959982025-04-22False
17060000036220L17/dossiers1717060000036213170600000362136PA7749622025-04-22False
17060000036221L17/dossiers1717060000036213170600000362137PA3356122025-04-22False
17060000036222L17/dossiers1717060000036213170600000362138PA7960102025-04-22False
17060000036223L17/dossiers1717060000036213170600000362139PA8422712025-04-22False
17060000036224L17/dossiers17170600000362131706000003621310PA7931742025-04-22False
17060000036225L17/dossiers17170600000362131706000003621311PA7958202025-04-22False
17060000036226L17/dossiers17170600000362131706000003621312PA7212702025-04-22False
17060000036227L17/dossiers17170600000362131706000003621313PA7952402025-04-22False
17060000036228L17/dossiers17170600000362131706000003621314PA7958762025-04-22False
17060000036229L17/dossiers17170600000362131706000003621315PA6057452025-04-22False
17060000036230L17/dossiers17170600000362131706000003621316PA8422992025-04-22False
17060000036237L17/dossiers1717060000036235170600000362351PA7961062025-04-28False
17060000036238L17/dossiers1717060000036235170600000362352PA7208382025-04-28False
17060000036239L17/dossiers1717060000036235170600000362353PA7947102025-04-28False
17060000036240L17/dossiers1717060000036235170600000362354PA7958682025-04-28False
17060000036241L17/dossiers1717060000036235170600000362355PA7749622025-04-28False
17060000036242L17/dossiers1717060000036235170600000362356PA3356122025-04-28False
17060000036243L17/dossiers1717060000036235170600000362357PA7960102025-04-28False