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
17060000026072L17/dossiers17170600000260481706000002604823PA7200382025-02-26False
17060000026073L17/dossiers17170600000260481706000002604824PA7947502025-02-26False
17060000026074L17/dossiers17170600000260481706000002604825PA7214742025-02-26False
17060000026075L17/dossiers17170600000260481706000002604826PA7214422025-02-26False
17060000026076L17/dossiers17170600000260481706000002604827PA6060982025-02-26False
17060000026080L17/dossiers1717060000026078170600000260781PA6428682025-02-13False
17060000026081L17/dossiers1717060000026078170600000260782PA7942782025-02-13False
17060000026082L17/dossiers1717060000026078170600000260783PA7939922025-02-13False
17060000026083L17/dossiers1717060000026078170600000260784PA7952782025-02-13False
17060000026084L17/dossiers1717060000026078170600000260785PA3322282025-02-13False
17060000026085L17/dossiers1717060000026078170600000260786PA6872142025-02-13False
17060000026086L17/dossiers1717060000026078170600000260787PA7190322025-02-13False
17060000026087L17/dossiers1717060000026078170600000260788PA8413392025-02-13False
17060000026088L17/dossiers1717060000026078170600000260789PA8414312025-02-13False
17060000026089L17/dossiers17170600000260781706000002607810PA2677802025-02-13False
17060000026090L17/dossiers17170600000260781706000002607811PA7944702025-02-13False
17060000026091L17/dossiers17170600000260781706000002607812PA7942342025-02-13False
17060000026092L17/dossiers17170600000260781706000002607813PA7220702025-02-13False
17060000026093L17/dossiers17170600000260781706000002607814PA7197782025-02-13False
17060000026094L17/dossiers17170600000260781706000002607815PA7190522025-02-13False
17060000026095L17/dossiers17170600000260781706000002607816PA7192822025-02-13False
17060000026096L17/dossiers17170600000260781706000002607817PA8421252025-02-13False
17060000026097L17/dossiers17170600000260781706000002607818PA7944262025-02-13False
17060000026098L17/dossiers17170600000260781706000002607819PA7202302025-02-13False
17060000026099L17/dossiers17170600000260781706000002607820PA7944662025-02-13False
17060000026100L17/dossiers17170600000260781706000002607821PA7209082025-02-13False
17060000026101L17/dossiers17170600000260781706000002607822PA7933982025-02-13False
17060000026102L17/dossiers17170600000260781706000002607823PA7218442025-02-13False
17060000026103L17/dossiers17170600000260781706000002607824PA7935722025-02-13False
17060000026104L17/dossiers17170600000260781706000002607825PA7195282025-02-13False
17060000026105L17/dossiers17170600000260781706000002607826PA7952702025-02-13False
17060000026106L17/dossiers17170600000260781706000002607827PA7205522025-02-13False
17060000026107L17/dossiers17170600000260781706000002607828PA7214582025-02-13False
17060000026108L17/dossiers17170600000260781706000002607829PA7201382025-02-13False
17060000026109L17/dossiers17170600000260781706000002607830PA7223362025-02-13False
17060000026110L17/dossiers17170600000260781706000002607831PA7953502025-02-13False
17060000026111L17/dossiers17170600000260781706000002607832PA7950262025-02-13False
17060000026115L17/dossiers1717060000026113170600000261131PA7944262025-05-16False
17060000026116L17/dossiers1717060000026113170600000261132PA7931742025-05-16False
17060000026117L17/dossiers1717060000026113170600000261133PA7930942025-05-16False
17060000026118L17/dossiers1717060000026113170600000261134PA8406652025-05-16False
17060000026119L17/dossiers1717060000026113170600000261135PA5888842025-05-16False
17060000026120L17/dossiers1717060000026113170600000261136PA6427642025-05-16False
17060000026121L17/dossiers1717060000026113170600000261137PA6431432025-05-16False
17060000026122L17/dossiers1717060000026113170600000261138PA8408292025-05-16False
17060000026123L17/dossiers1717060000026113170600000261139PA3424152025-05-16False
17060000026124L17/dossiers17170600000261131706000002611310PA6067932025-05-16False
17060000026125L17/dossiers17170600000261131706000002611311PA8422112025-05-16False
17060000026126L17/dossiers17170600000261131706000002611312PA8413152025-05-16False
17060000026127L17/dossiers17170600000261131706000002611313PA8418852025-05-16False