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
17060000033749L17/dossiers1717060000033743170600000337435PA7952442025-05-12False
17060000033750L17/dossiers1717060000033743170600000337436PA7209762025-05-12False
17060000033751L17/dossiers1717060000033743170600000337437PA7214862025-05-12False
17060000033752L17/dossiers1717060000033743170600000337438PA8413592025-05-12False
17060000033753L17/dossiers1717060000033743170600000337439PA7211102025-05-12False
17060000033754L17/dossiers17170600000337431706000003374310PA7209602025-05-12False
17060000033758L17/dossiers1717060000033756170600000337561PA7945542025-04-08False
17060000033759L17/dossiers1717060000033756170600000337562PA7952442025-04-08False
17060000033760L17/dossiers1717060000033756170600000337563PA8419312025-04-08False
17060000033761L17/dossiers1717060000033756170600000337564PA2677632025-04-08False
17060000033762L17/dossiers1717060000033756170600000337565PA7192862025-04-08False
17060000033763L17/dossiers1717060000033756170600000337566PA8408172025-04-08False
17060000033764L17/dossiers1717060000033756170600000337567PA7214862025-04-08False
17060000033765L17/dossiers1717060000033756170600000337568PA7209762025-04-08False
17060000033766L17/dossiers1717060000033756170600000337569PA8226172025-04-08False
17060000033767L17/dossiers17170600000337561706000003375610PA7932102025-04-08False
17060000033768L17/dossiers17170600000337561706000003375611PA8413592025-04-08False
17060000033769L17/dossiers17170600000337561706000003375612PA7937962025-04-08False
17060000033770L17/dossiers17170600000337561706000003375613PA29522025-04-08False
17060000033792L17/dossiers1717060000033790170600000337901PA7208382025-04-16False
17060000033793L17/dossiers1717060000033790170600000337902PA7749622025-04-16False
17060000033794L17/dossiers1717060000033790170600000337903PA7960102025-04-16False
17060000033795L17/dossiers1717060000033790170600000337904PA6057452025-04-16False
17060000033802L17/dossiers1717060000033800170600000338001PA7214422025-04-28False
17060000033803L17/dossiers1717060000033800170600000338002PA13272025-04-28False
17060000033804L17/dossiers1717060000033800170600000338003PA8410472025-04-28False
17060000033805L17/dossiers1717060000033800170600000338004PA7188382025-04-28False
17060000033806L17/dossiers1717060000033800170600000338005PA7223902025-04-28False
17060000033807L17/dossiers1717060000033800170600000338006PA16302025-04-28False
17060000033808L17/dossiers1717060000033800170600000338007PA7933422025-04-28False
17060000033809L17/dossiers1717060000033800170600000338008PA7206442025-04-28False
17060000033810L17/dossiers1717060000033800170600000338009PA7188842025-04-28False
17060000033811L17/dossiers17170600000338001706000003380010PA7218162025-04-28False
17060000033812L17/dossiers17170600000338001706000003380011PA7930942025-04-28False
17060000033813L17/dossiers17170600000338001706000003380012PA7940422025-04-28False
17060000033814L17/dossiers17170600000338001706000003380013PA6428472025-04-28False
17060000033815L17/dossiers17170600000338001706000003380014PA7187842025-04-28False
17060000033816L17/dossiers17170600000338001706000003380015PA7949942025-04-28False
17060000033817L17/dossiers17170600000338001706000003380016PA6088262025-04-28False
17060000033818L17/dossiers17170600000338001706000003380017PA6427252025-04-28False
17060000033819L17/dossiers17170600000338001706000003380018PA3309092025-04-28False
17060000033826L17/dossiers1717060000033824170600000338241PA7203862025-04-17False
17060000033830L17/dossiers1717060000033828170600000338281PA7952282026-03-30False
17060000033831L17/dossiers1717060000033828170600000338282PA7932622026-03-30False
17060000033832L17/dossiers1717060000033828170600000338283PA7949062026-03-30False
17060000033833L17/dossiers1717060000033828170600000338284PA7941382026-03-30False
17060000033834L17/dossiers1717060000033828170600000338285PA7955882026-03-30False
17060000033835L17/dossiers1717060000033828170600000338286PA7950842026-03-30False
17060000033836L17/dossiers1717060000033828170600000338287PA8421052026-03-30False
17060000033837L17/dossiers1717060000033828170600000338288PA8416572026-03-30False