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
17060000024208L17/dossiers17170600000241461706000002414661PA7195502025-02-11False
17060000024209L17/dossiers17170600000241461706000002414662PA8418932025-02-11False
17060000024210L17/dossiers17170600000241461706000002414663PA7938162025-02-11False
17060000024211L17/dossiers17170600000241461706000002414664PA7221022025-02-11False
17060000024212L17/dossiers17170600000241461706000002414665PA7195122025-02-11False
17060000024213L17/dossiers17170600000241461706000002414666PA7950262025-02-11False
17060000024214L17/dossiers17170600000241461706000002414667PA7950462025-02-11False
17060000024215L17/dossiers17170600000241461706000002414668PA7960782025-02-11False
17060000024219L17/dossiers1717060000024217170600000242171PA2672002025-05-20False
17060000024220L17/dossiers1717060000024217170600000242172PA7197562025-05-20False
17060000024221L17/dossiers1717060000024217170600000242173PA7947022025-05-20False
17060000024222L17/dossiers1717060000024217170600000242174PA7951762025-05-20False
17060000024223L17/dossiers1717060000024217170600000242175PA8172032025-05-20False
17060000024224L17/dossiers1717060000024217170600000242176PA7955282025-05-20False
17060000024225L17/dossiers1717060000024217170600000242177PA8419272025-05-20False
17060000024226L17/dossiers1717060000024217170600000242178PA7950462025-05-20False
17060000024230L17/dossiers1717060000024228170600000242281PA8410672025-03-07False
17060000024231L17/dossiers1717060000024228170600000242282PA8412072025-03-07False
17060000024232L17/dossiers1717060000024228170600000242283PA7931582025-03-07False
17060000024233L17/dossiers1717060000024228170600000242284PA8407012025-03-07False
17060000024234L17/dossiers1717060000024228170600000242285PA7204682025-03-07False
17060000024235L17/dossiers1717060000024228170600000242286PA7938322025-03-07False
17060000024236L17/dossiers1717060000024228170600000242287PA7931022025-03-07False
17060000024237L17/dossiers1717060000024228170600000242288PA7959002025-03-07False
17060000024238L17/dossiers1717060000024228170600000242289PA6429882025-03-07False
17060000024239L17/dossiers17170600000242281706000002422810PA7936962025-03-07False
17060000024240L17/dossiers17170600000242281706000002422811PA7932542025-03-07False
17060000024241L17/dossiers17170600000242281706000002422812PA7949462025-03-07False
17060000024242L17/dossiers17170600000242281706000002422813PA7938922025-03-07False
17060000024243L17/dossiers17170600000242281706000002422814PA7943542025-03-07False
17060000024244L17/dossiers17170600000242281706000002422815PA8414512025-03-07False
17060000024245L17/dossiers17170600000242281706000002422816PA7957862025-03-07False
17060000024246L17/dossiers17170600000242281706000002422817PA8419812025-03-07False
17060000024247L17/dossiers17170600000242281706000002422818PA7960262025-03-07False
17060000024248L17/dossiers17170600000242281706000002422819PA8407212025-03-07False
17060000024249L17/dossiers17170600000242281706000002422820PA7933822025-03-07False
17060000024250L17/dossiers17170600000242281706000002422821PA7932302025-03-07False
17060000024251L17/dossiers17170600000242281706000002422822PA7932462025-03-07False
17060000024252L17/dossiers17170600000242281706000002422823PA8408012025-03-07False
17060000024253L17/dossiers17170600000242281706000002422824PA8409832025-03-07False
17060000024254L17/dossiers17170600000242281706000002422825PA7959742025-03-07False
17060000024255L17/dossiers17170600000242281706000002422826PA7945822025-03-07False
17060000024256L17/dossiers17170600000242281706000002422827PA7219322025-03-07False
17060000024257L17/dossiers17170600000242281706000002422828PA8417772025-01-212025-03-07False
17060000024258L17/dossiers17170600000242281706000002422829PA8406572025-03-07False
17060000024259L17/dossiers17170600000242281706000002422830PA7933302025-03-07False
17060000024260L17/dossiers17170600000242281706000002422831PA8401592025-03-07False
17060000024261L17/dossiers17170600000242281706000002422832PA7949542025-03-07False
17060000024262L17/dossiers17170600000242281706000002422833PA7941982025-03-07False
17060000024263L17/dossiers17170600000242281706000002422834PA7933142025-03-07False