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
17060000048155L17/dossiers1717060000048150170600000481504PA2667972025-12-30False
17060000048156L17/dossiers1717060000048150170600000481505PA7941782025-12-30False
17060000048157L17/dossiers1717060000048150170600000481506PA7940382025-12-30False
17060000048158L17/dossiers1717060000048150170600000481507PA6080162025-12-30False
17060000048159L17/dossiers1717060000048150170600000481508PA3309092025-12-30False
17060000048160L17/dossiers1717060000048150170600000481509PA7120152025-12-30False
17060000048161L17/dossiers17170600000481501706000004815010PA7941182025-12-30False
17060000048162L17/dossiers17170600000481501706000004815011PA6070902025-12-30False
17060000048163L17/dossiers17170600000481501706000004815012PA7950262025-12-30False
17060000048164L17/dossiers17170600000481501706000004815013PA7946582025-12-30False
17060000048165L17/dossiers17170600000481501706000004815014PA7214742025-12-30False
17060000048166L17/dossiers17170600000481501706000004815015PA8172032025-12-30False
17060000048167L17/dossiers17170600000481501706000004815016PA7944862025-12-30False
17060000048168L17/dossiers17170600000481501706000004815017PA8419272025-12-30False
17060000048169L17/dossiers17170600000481501706000004815018PA7948102025-12-30False
17060000048176L17/dossiers1717060000048174170600000481741PA8415152025-10-14False
17060000048177L17/dossiers1717060000048174170600000481742PA7208922025-10-14False
17060000048178L17/dossiers1717060000048174170600000481743PA7952282025-10-14False
17060000048179L17/dossiers1717060000048174170600000481744PA7932622025-10-14False
17060000048180L17/dossiers1717060000048174170600000481745PA7949062025-10-14False
17060000048181L17/dossiers1717060000048174170600000481746PA7941382025-10-14False
17060000048182L17/dossiers1717060000048174170600000481747PA7955882025-10-14False
17060000048183L17/dossiers1717060000048174170600000481748PA7950842025-10-14False
17060000048184L17/dossiers1717060000048174170600000481749PA8421052025-10-14False
17060000048185L17/dossiers17170600000481741706000004817410PA8416572025-10-14False
17060000048186L17/dossiers17170600000481741706000004817411PA7204302025-10-14False
17060000048187L17/dossiers17170600000481741706000004817412PA7937722025-10-14False
17060000048188L17/dossiers17170600000481741706000004817413PA7956162025-10-14False
17060000048189L17/dossiers17170600000481741706000004817414PA7934442025-10-14False
17060000048190L17/dossiers17170600000481741706000004817415PA7949382025-10-14False
17060000048191L17/dossiers17170600000481741706000004817416PA7953182025-10-14False
17060000048192L17/dossiers17170600000481741706000004817417PA8410232025-10-14False
17060000048193L17/dossiers17170600000481741706000004817418PA7960902025-10-14False
17060000048194L17/dossiers17170600000481741706000004817419PA7939122025-10-14False
17060000048195L17/dossiers17170600000481741706000004817420PA8421872025-10-14False
17060000048196L17/dossiers17170600000481741706000004817421PA8420372025-10-14False
17060000048197L17/dossiers17170600000481741706000004817422PA7918122025-10-14False
17060000048198L17/dossiers17170600000481741706000004817423PA7937362025-10-14False
17060000048199L17/dossiers17170600000481741706000004817424PA7212022025-10-14False
17060000048200L17/dossiers17170600000481741706000004817425PA7951362025-10-14False
17060000048201L17/dossiers17170600000481741706000004817426PA7934642025-10-14False
17060000048202L17/dossiers17170600000481741706000004817427PA8421552025-10-14False
17060000048203L17/dossiers17170600000481741706000004817428PA7952002025-10-14False
17060000048204L17/dossiers17170600000481741706000004817429PA7958442025-10-14False
17060000048205L17/dossiers17170600000481741706000004817430PA8412512025-10-14False
17060000048206L17/dossiers17170600000481741706000004817431PA7947862025-10-14False
17060000048207L17/dossiers17170600000481741706000004817432PA7948702025-10-14False
17060000048208L17/dossiers17170600000481741706000004817433PA7960702025-10-14False
17060000048209L17/dossiers17170600000481741706000004817434PA7953102025-10-14False
17060000048210L17/dossiers17170600000481741706000004817435PA7944782025-10-14False