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
17060000030639L17/dossiers17170600000306231706000003062315PA7955162025-03-24False
17060000030640L17/dossiers17170600000306231706000003062316PA8411912025-03-24False
17060000030641L17/dossiers17170600000306231706000003062317PA7936642025-03-24False
17060000030642L17/dossiers17170600000306231706000003062318PA7195782025-03-24False
17060000030643L17/dossiers17170600000306231706000003062319PA7947782025-03-24False
17060000030644L17/dossiers17170600000306231706000003062320PA7952402025-03-24False
17060000030645L17/dossiers17170600000306231706000003062321PA7950762025-03-24False
17060000030646L17/dossiers17170600000306231706000003062322PA6100022025-03-24False
17060000030647L17/dossiers17170600000306231706000003062323PA7958082025-03-24False
17060000030648L17/dossiers17170600000306231706000003062324PA8418932025-03-24False
17060000030655L17/dossiers1717060000030653170600000306531PA7749542025-03-21False
17060000030656L17/dossiers1717060000030653170600000306532PA7199682025-03-21False
17060000030657L17/dossiers1717060000030653170600000306533PA7218162025-03-21False
17060000030658L17/dossiers1717060000030653170600000306534PA3422402025-03-21False
17060000030659L17/dossiers1717060000030653170600000306535PA3300082025-03-21False
17060000030660L17/dossiers1717060000030653170600000306536PA7935082025-03-21False
17060000030661L17/dossiers1717060000030653170600000306537PA7188502025-03-21False
17060000030662L17/dossiers1717060000030653170600000306538PA7223902025-03-21False
17060000030663L17/dossiers1717060000030653170600000306539PA3309092025-03-21False
17060000030664L17/dossiers17170600000306531706000003065310PA8421172025-03-21False
17060000030665L17/dossiers17170600000306531706000003065311PA7947502025-03-21False
17060000030666L17/dossiers17170600000306531706000003065312PA8421412025-03-21False
17060000030667L17/dossiers17170600000306531706000003065313PA7933422025-03-21False
17060000030668L17/dossiers17170600000306531706000003065314PA7949942025-03-21False
17060000030669L17/dossiers17170600000306531706000003065315PA7930942025-03-21False
17060000030670L17/dossiers17170600000306531706000003065316PA7941182025-03-21False
17060000030671L17/dossiers17170600000306531706000003065317PA7940422025-03-21False
17060000030672L17/dossiers17170600000306531706000003065318PA7940582025-03-21False
17060000030673L17/dossiers17170600000306531706000003065319PA6084162025-03-21False
17060000030674L17/dossiers17170600000306531706000003065320PA6088262025-03-21False
17060000030678L17/dossiers1717060000030676170600000306761PA6428682025-04-24False
17060000030679L17/dossiers1717060000030676170600000306762PA7209082025-04-24False
17060000030680L17/dossiers1717060000030676170600000306763PA6872142025-04-24False
17060000030681L17/dossiers1717060000030676170600000306764PA8421252025-04-24False
17060000030682L17/dossiers1717060000030676170600000306765PA7944702025-04-24False
17060000030683L17/dossiers1717060000030676170600000306766PA7935722025-04-24False
17060000030684L17/dossiers1717060000030676170600000306767PA7190322025-04-24False
17060000030685L17/dossiers1717060000030676170600000306768PA7952782025-04-24False
17060000030686L17/dossiers1717060000030676170600000306769PA7944262025-04-24False
17060000030687L17/dossiers17170600000306761706000003067610PA7223362025-04-24False
17060000030688L17/dossiers17170600000306761706000003067611PA7202302025-04-24False
17060000030689L17/dossiers17170600000306761706000003067612PA7944662025-04-24False
17060000030690L17/dossiers17170600000306761706000003067613PA7953502025-04-24False
17060000030691L17/dossiers17170600000306761706000003067614PA7933982025-04-24False
17060000030692L17/dossiers17170600000306761706000003067615PA3322282025-04-24False
17060000030693L17/dossiers17170600000306761706000003067616PA7948382025-04-24False
17060000030694L17/dossiers17170600000306761706000003067617PA7942782025-04-24False
17060000030695L17/dossiers17170600000306761706000003067618PA8414312025-04-24False
17060000030696L17/dossiers17170600000306761706000003067619PA2677802025-04-24False
17060000030697L17/dossiers17170600000306761706000003067620PA7942342025-04-24False