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
17060000033693L17/dossiers1717060000033684170600000336848PA15922025-05-07False
17060000033694L17/dossiers1717060000033684170600000336849PA8410172025-05-07False
17060000033695L17/dossiers17170600000336841706000003368410PA7952442025-05-07False
17060000033696L17/dossiers17170600000336841706000003368411PA7209762025-05-07False
17060000033697L17/dossiers17170600000336841706000003368412PA8419312025-05-07False
17060000033698L17/dossiers17170600000336841706000003368413PA6076192025-05-07False
17060000033699L17/dossiers17170600000336841706000003368414PA7214862025-05-07False
17060000033700L17/dossiers17170600000336841706000003368415PA8413592025-05-07False
17060000033701L17/dossiers17170600000336841706000003368416PA7211102025-05-07False
17060000033702L17/dossiers17170600000336841706000003368417PA7209602025-05-07False
17060000033703L17/dossiers17170600000336841706000003368418PA7937962025-05-07False
17060000033704L17/dossiers17170600000336841706000003368419PA7960782025-05-07False
17060000033705L17/dossiers17170600000336841706000003368420PA7214742025-05-07False
17060000033706L17/dossiers17170600000336841706000003368421PA8418532025-05-07False
17060000033707L17/dossiers17170600000336841706000003368422PA8422712025-05-07False
17060000033708L17/dossiers17170600000336841706000003368423PA7954222025-05-07False
17060000033709L17/dossiers17170600000336841706000003368424PA7199222025-05-07False
17060000033710L17/dossiers17170600000336841706000003368425PA7947022025-05-07False
17060000033711L17/dossiers17170600000336841706000003368426PA7960102025-05-07False
17060000033712L17/dossiers17170600000336841706000003368427PA7199682025-05-07False
17060000033713L17/dossiers17170600000336841706000003368428PA7944942025-05-07False
17060000033714L17/dossiers17170600000336841706000003368429PA7223902025-05-07False
17060000033715L17/dossiers17170600000336841706000003368430PA6427642025-05-07False
17060000033716L17/dossiers17170600000336841706000003368431PA8410472025-05-07False
17060000033717L17/dossiers17170600000336841706000003368432PA6081722025-05-07False
17060000033718L17/dossiers17170600000336841706000003368433PA3300082025-05-07False
17060000033719L17/dossiers17170600000336841706000003368434PA7218162025-05-07False
17060000033720L17/dossiers17170600000336841706000003368435PA8421872025-05-07False
17060000033721L17/dossiers17170600000336841706000003368436PA7930942025-05-07False
17060000033722L17/dossiers17170600000336841706000003368437PA7947862025-05-07False
17060000033723L17/dossiers17170600000336841706000003368438PA7951082025-05-07False
17060000033724L17/dossiers17170600000336841706000003368439PA7196322025-05-07False
17060000033725L17/dossiers17170600000336841706000003368440PA8416572025-05-07False
17060000033726L17/dossiers17170600000336841706000003368441PA7749582025-05-07False
17060000033727L17/dossiers17170600000336841706000003368442PA7950262025-05-07False
17060000033728L17/dossiers17170600000336841706000003368443PA2673182025-05-07False
17060000033729L17/dossiers17170600000336841706000003368444PA7192822025-05-07False
17060000033730L17/dossiers17170600000336841706000003368445PA7941062025-05-07False
17060000033731L17/dossiers17170600000336841706000003368446PA8410232025-05-07False
17060000033732L17/dossiers17170600000336841706000003368447PA7955162025-05-07False
17060000033733L17/dossiers17170600000336841706000003368448PA7918122025-05-07False
17060000033734L17/dossiers17170600000336841706000003368449PA8416812025-05-07False
17060000033735L17/dossiers17170600000336841706000003368450PA7937722025-05-07False
17060000033736L17/dossiers17170600000336841706000003368451PA8411912025-05-07False
17060000033737L17/dossiers17170600000336841706000003368452PA7948542025-05-07False
17060000033738L17/dossiers17170600000336841706000003368453PA7935322025-05-07False
17060000033745L17/dossiers1717060000033743170600000337431PA2677632025-05-12False
17060000033746L17/dossiers1717060000033743170600000337432PA7945542025-05-12False
17060000033747L17/dossiers1717060000033743170600000337433PA7192862025-05-12False
17060000033748L17/dossiers1717060000033743170600000337434PA9422025-05-12False