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
17060000034869L17/dossiers17170600000348571706000003485711PA7958202026-05-27False
17060000034870L17/dossiers17170600000348571706000003485712PA7212702026-05-27False
17060000034871L17/dossiers17170600000348571706000003485713PA7952402026-05-27False
17060000034872L17/dossiers17170600000348571706000003485714PA7958762026-05-27False
17060000034873L17/dossiers17170600000348571706000003485715PA6057452026-05-27False
17060000034874L17/dossiers17170600000348571706000003485716PA8422992026-05-27False
17060000034875L17/dossiers17170600000348571706000003485717PA7932622026-05-27False
17060000034876L17/dossiers17170600000348571706000003485718PA8406652026-05-27False
17060000034877L17/dossiers17170600000348571706000003485719PA6427642026-05-27False
17060000034878L17/dossiers17170600000348571706000003485720PA8408292026-05-27False
17060000034879L17/dossiers17170600000348571706000003485721PA2677632026-05-27False
17060000034880L17/dossiers17170600000348571706000003485722PA3359992026-05-27False
17060000034881L17/dossiers17170600000348571706000003485723PA8416572026-05-27False
17060000034882L17/dossiers17170600000348571706000003485724PA7937722026-05-27False
17060000034883L17/dossiers17170600000348571706000003485725PA8409972026-05-27False
17060000034884L17/dossiers17170600000348571706000003485726PA7201622026-05-27False
17060000034885L17/dossiers17170600000348571706000003485727PA7934442026-05-27False
17060000034886L17/dossiers17170600000348571706000003485728PA7199682026-05-27False
17060000034887L17/dossiers17170600000348571706000003485729PA2667932026-05-27False
17060000034888L17/dossiers17170600000348571706000003485730PA7940942026-05-27False
17060000034889L17/dossiers17170600000348571706000003485731PA8410232026-05-27False
17060000034890L17/dossiers17170600000348571706000003485732PA7940082026-05-27False
17060000034891L17/dossiers17170600000348571706000003485733PA8409032026-05-27False
17060000034892L17/dossiers17170600000348571706000003485734PA7188502026-05-27False
17060000034893L17/dossiers17170600000348571706000003485735PA7951362026-05-27False
17060000034894L17/dossiers17170600000348571706000003485736PA3309092026-05-27False
17060000034895L17/dossiers17170600000348571706000003485737PA7948542026-05-27False
17060000034896L17/dossiers17170600000348571706000003485738PA8412512026-05-27False
17060000034897L17/dossiers17170600000348571706000003485739PA8226172026-05-27False
17060000034898L17/dossiers17170600000348571706000003485740PA7223662026-05-27False
17060000034899L17/dossiers17170600000348571706000003485741PA8414192026-05-27False
17060000034900L17/dossiers17170600000348571706000003485742PA3319732026-05-27False
17060000034901L17/dossiers17170600000348571706000003485743PA7953102026-05-27False
17060000034902L17/dossiers17170600000348571706000003485744PA7940822026-05-27False
17060000034903L17/dossiers17170600000348571706000003485745PA7955162026-05-27False
17060000034904L17/dossiers17170600000348571706000003485746PA8409792026-05-27False
17060000034905L17/dossiers17170600000348571706000003485747PA7953742026-05-27False
17060000034906L17/dossiers17170600000348571706000003485748PA7918242026-05-27False
17060000034907L17/dossiers17170600000348571706000003485749PA8407652026-05-27False
17060000034908L17/dossiers17170600000348571706000003485750PA7947022026-05-27False
17060000034909L17/dossiers17170600000348571706000003485751PA7954222026-05-27False
17060000034910L17/dossiers17170600000348571706000003485752PA7946862026-05-27False
17060000034911L17/dossiers17170600000348571706000003485753PA7192722026-05-27False
17060000034912L17/dossiers17170600000348571706000003485754PA6076192026-05-27False
17060000034913L17/dossiers17170600000348571706000003485755PA8411912026-05-27False
17060000034914L17/dossiers17170600000348571706000003485756PA7948302026-05-27False
17060000034915L17/dossiers17170600000348571706000003485757PA7932102026-05-27False
17060000034916L17/dossiers17170600000348571706000003485758PA8413812026-05-27False
17060000034917L17/dossiers17170600000348571706000003485759PA6081722026-05-27False
17060000034918L17/dossiers17170600000348571706000003485760PA7936642026-05-27False