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
17060000023893L17/dossiers1717060000023887170600000238875PA2673062025-02-18False
17060000023894L17/dossiers1717060000023887170600000238876PA7953742025-02-18False
17060000023895L17/dossiers1717060000023887170600000238877PA7937962025-02-18False
17060000023896L17/dossiers1717060000023887170600000238878PA6073952025-02-18False
17060000023897L17/dossiers1717060000023887170600000238879PA7951642025-02-18False
17060000023898L17/dossiers17170600000238871706000002388710PA7948542025-02-18False
17060000023899L17/dossiers17170600000238871706000002388711PA6082642025-02-18False
17060000023900L17/dossiers17170600000238871706000002388712PA6075532025-02-18False
17060000023901L17/dossiers17170600000238871706000002388713PA8406652025-02-18False
17060000023902L17/dossiers17170600000238871706000002388714PA7949062025-02-18False
17060000023903L17/dossiers17170600000238871706000002388715PA7955882025-02-18False
17060000023904L17/dossiers17170600000238871706000002388716PA6427642025-02-18False
17060000023905L17/dossiers17170600000238871706000002388717PA8417012025-02-18False
17060000023906L17/dossiers17170600000238871706000002388718PA8408292025-02-18False
17060000023907L17/dossiers17170600000238871706000002388719PA2677632025-02-18False
17060000023908L17/dossiers17170600000238871706000002388720PA3424152025-02-18False
17060000023909L17/dossiers17170600000238871706000002388721PA7953622025-02-18False
17060000023910L17/dossiers17170600000238871706000002388722PA8416572025-02-18False
17060000023911L17/dossiers17170600000238871706000002388723PA8418852025-02-18False
17060000023912L17/dossiers17170600000238871706000002388724PA8415072025-02-18False
17060000023913L17/dossiers17170600000238871706000002388725PA7940942025-02-18False
17060000023914L17/dossiers17170600000238871706000002388726PA8410232025-02-18False
17060000023915L17/dossiers17170600000238871706000002388727PA7939122025-02-18False
17060000023916L17/dossiers17170600000238871706000002388728PA8420372025-02-18False
17060000023917L17/dossiers17170600000238871706000002388729PA7937362025-02-18False
17060000023918L17/dossiers17170600000238871706000002388730PA7192862025-02-18False
17060000023919L17/dossiers17170600000238871706000002388731PA7223902025-02-18False
17060000023920L17/dossiers17170600000238871706000002388732PA7951362025-02-18False
17060000023921L17/dossiers17170600000238871706000002388733PA8412952025-02-18False
17060000023922L17/dossiers17170600000238871706000002388734PA7934522025-02-18False
17060000023923L17/dossiers17170600000238871706000002388735PA10082025-02-18False
17060000023924L17/dossiers17170600000238871706000002388736PA7933942025-02-18False
17060000023925L17/dossiers17170600000238871706000002388737PA7954302025-02-18False
17060000023926L17/dossiers17170600000238871706000002388738PA6088262025-02-18False
17060000023927L17/dossiers17170600000238871706000002388739PA8421952025-02-18False
17060000023928L17/dossiers17170600000238871706000002388740PA8416652025-02-18False
17060000023929L17/dossiers17170600000238871706000002388741PA8226172025-02-18False
17060000023930L17/dossiers17170600000238871706000002388742PA7223662025-02-18False
17060000023931L17/dossiers17170600000238871706000002388743PA7960702025-02-18False
17060000023932L17/dossiers17170600000238871706000002388744PA8415392025-02-18False
17060000023933L17/dossiers17170600000238871706000002388745PA3319732025-02-18False
17060000023934L17/dossiers17170600000238871706000002388746PA8401712025-02-18False
17060000023935L17/dossiers17170600000238871706000002388747PA15922025-02-18False
17060000023936L17/dossiers17170600000238871706000002388748PA8414712025-02-18False
17060000023937L17/dossiers17170600000238871706000002388749PA8422632025-02-18False
17060000023938L17/dossiers17170600000238871706000002388750PA8409472025-02-18False
17060000023939L17/dossiers17170600000238871706000002388751PA7940822025-02-18False
17060000023940L17/dossiers17170600000238871706000002388752PA6431922025-02-18False
17060000023941L17/dossiers17170600000238871706000002388753PA3467822025-02-18False
17060000023942L17/dossiers17170600000238871706000002388754PA3350542025-02-18False