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
17060000051882L17/dossiers17170600000518411706000005184140PA7214262026-01-19False
17060000051883L17/dossiers17170600000518411706000005184141PA7214742026-01-19False
17060000051884L17/dossiers17170600000518411706000005184142PA7951242026-01-19False
17060000051885L17/dossiers17170600000518411706000005184143PA6774832026-01-19False
17060000051886L17/dossiers17170600000518411706000005184144PA7940382026-01-19False
17060000051887L17/dossiers17170600000518411706000005184145PA7223902026-01-19False
17060000051888L17/dossiers17170600000518411706000005184146PA8700092026-01-19False
17060000051889L17/dossiers17170600000518411706000005184147PA7218442026-01-19False
17060000051890L17/dossiers17170600000518411706000005184148PA7952782026-01-19False
17060000051891L17/dossiers17170600000518411706000005184149PA7937162026-01-19False
17060000051892L17/dossiers17170600000518411706000005184150PA8410472026-01-19False
17060000051893L17/dossiers17170600000518411706000005184151PA7192862026-01-19False
17060000051894L17/dossiers17170600000518411706000005184152PA7190522026-01-19False
17060000051895L17/dossiers17170600000518411706000005184153PA7220702026-01-19False
17060000051896L17/dossiers17170600000518411706000005184154PA7223362026-01-19False
17060000051897L17/dossiers17170600000518411706000005184155PA7942342026-01-19False
17060000051898L17/dossiers17170600000518411706000005184156PA7953502026-01-19False
17060000051899L17/dossiers17170600000518411706000005184157PA7197782026-01-19False
17060000051900L17/dossiers17170600000518411706000005184158PA2677802026-01-19False
17060000051901L17/dossiers17170600000518411706000005184159PA7188502026-01-19False
17060000051902L17/dossiers17170600000518411706000005184160PA7959542026-01-19False
17060000051903L17/dossiers17170600000518411706000005184161PA2672002026-01-19False
17060000051904L17/dossiers17170600000518411706000005184162PA8419312026-01-19False
17060000051905L17/dossiers17170600000518411706000005184163PA9422026-01-19False
17060000051906L17/dossiers17170600000518411706000005184164PA6056942026-01-19False
17060000051910L17/dossiers1717060000051908170600000519081PA7208922025-12-02False
17060000051911L17/dossiers1717060000051908170600000519082PA7952282025-12-02False
17060000051912L17/dossiers1717060000051908170600000519083PA7932622025-12-02False
17060000051913L17/dossiers1717060000051908170600000519084PA7949062025-12-02False
17060000051914L17/dossiers1717060000051908170600000519085PA7941382025-12-02False
17060000051915L17/dossiers1717060000051908170600000519086PA7955882025-12-02False
17060000051916L17/dossiers1717060000051908170600000519087PA7950842025-12-02False
17060000051917L17/dossiers1717060000051908170600000519088PA8421052025-12-02False
17060000051918L17/dossiers1717060000051908170600000519089PA8416572025-12-02False
17060000051919L17/dossiers17170600000519081706000005190810PA7204302025-12-02False
17060000051920L17/dossiers17170600000519081706000005190811PA7937722025-12-02False
17060000051921L17/dossiers17170600000519081706000005190812PA7934442025-12-02False
17060000051922L17/dossiers17170600000519081706000005190813PA7949382025-12-02False
17060000051923L17/dossiers17170600000519081706000005190814PA7953182025-12-02False
17060000051924L17/dossiers17170600000519081706000005190815PA8410232025-12-02False
17060000051925L17/dossiers17170600000519081706000005190816PA7960902025-12-02False
17060000051926L17/dossiers17170600000519081706000005190817PA7939122025-12-02False
17060000051927L17/dossiers17170600000519081706000005190818PA8421872025-12-02False
17060000051928L17/dossiers17170600000519081706000005190819PA8420372025-12-02False
17060000051929L17/dossiers17170600000519081706000005190820PA7918122025-12-02False
17060000051930L17/dossiers17170600000519081706000005190821PA7937362025-12-02False
17060000051931L17/dossiers17170600000519081706000005190822PA7212022025-12-02False
17060000051932L17/dossiers17170600000519081706000005190823PA7951362025-12-02False
17060000051933L17/dossiers17170600000519081706000005190824PA7934642025-12-02False
17060000051934L17/dossiers17170600000519081706000005190825PA8421552025-12-02False