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
17060000018665L17/dossiers17170600000186511706000001865113PA6427252025-02-17False
17060000018666L17/dossiers17170600000186511706000001865114PA7188842025-02-17False
17060000018667L17/dossiers17170600000186511706000001865115PA3309092025-02-17False
17060000018668L17/dossiers17170600000186511706000001865116PA8421172025-02-17False
17060000018669L17/dossiers17170600000186511706000001865117PA3422402025-02-17False
17060000018673L17/dossiers1717060000018671170600000186711PA8406652025-06-04False
17060000018674L17/dossiers1717060000018671170600000186712PA7950842025-06-04False
17060000018675L17/dossiers1717060000018671170600000186713PA6427642025-06-04False
17060000018676L17/dossiers1717060000018671170600000186714PA8417012025-06-04False
17060000018677L17/dossiers1717060000018671170600000186715PA8408292025-06-04False
17060000018678L17/dossiers1717060000018671170600000186716PA3424152025-06-04False
17060000018679L17/dossiers1717060000018671170600000186717PA8413152025-06-04False
17060000018680L17/dossiers1717060000018671170600000186718PA6872142025-06-04False
17060000018681L17/dossiers1717060000018671170600000186719PA7192182025-06-04False
17060000018682L17/dossiers17170600000186711706000001867110PA8415072025-06-04False
17060000018683L17/dossiers17170600000186711706000001867111PA7208382025-06-04False
17060000018684L17/dossiers17170600000186711706000001867112PA6082642025-06-04False
17060000018685L17/dossiers17170600000186711706000001867113PA7192862025-06-04False
17060000018686L17/dossiers17170600000186711706000001867114PA10082025-06-04False
17060000018687L17/dossiers17170600000186711706000001867115PA7933942025-06-04False
17060000018688L17/dossiers17170600000186711706000001867116PA8416332025-06-04False
17060000018689L17/dossiers17170600000186711706000001867117PA6093322025-06-04False
17060000018690L17/dossiers17170600000186711706000001867118PA8416652025-06-04False
17060000018691L17/dossiers17170600000186711706000001867119PA7950102025-06-04False
17060000018692L17/dossiers17170600000186711706000001867120PA3319732025-06-04False
17060000018693L17/dossiers17170600000186711706000001867121PA8401712025-06-04False
17060000018694L17/dossiers17170600000186711706000001867122PA8419472025-06-04False
17060000018695L17/dossiers17170600000186711706000001867123PA8418132025-06-04False
17060000018696L17/dossiers17170600000186711706000001867124PA8418532025-06-04False
17060000018697L17/dossiers17170600000186711706000001867125PA7940822025-06-04False
17060000018698L17/dossiers17170600000186711706000001867126PA6431922025-06-04False
17060000018699L17/dossiers17170600000186711706000001867127PA3350542025-06-04False
17060000018700L17/dossiers17170600000186711706000001867128PA7951562025-06-04False
17060000018701L17/dossiers17170600000186711706000001867129PA7749622025-06-04False
17060000018702L17/dossiers17170600000186711706000001867130PA7749582025-06-04False
17060000018703L17/dossiers17170600000186711706000001867131PA7933422025-06-04False
17060000018704L17/dossiers17170600000186711706000001867132PA7946862025-06-04False
17060000018705L17/dossiers17170600000186711706000001867133PA6076192025-06-04False
17060000018706L17/dossiers17170600000186711706000001867134PA7948102025-06-04False
17060000018707L17/dossiers17170600000186711706000001867135PA6431572025-06-04False
17060000018708L17/dossiers17170600000186711706000001867136PA8407932025-06-04False
17060000018709L17/dossiers17170600000186711706000001867137PA7212342025-06-04False
17060000018710L17/dossiers17170600000186711706000001867138PA7212702025-06-04False
17060000018711L17/dossiers17170600000186711706000001867139PA7937082025-06-04False
17060000018712L17/dossiers17170600000186711706000001867140PA6081722025-06-04False
17060000018713L17/dossiers17170600000186711706000001867141PA7936642025-06-04False
17060000018714L17/dossiers17170600000186711706000001867142PA8409552025-06-04False
17060000018715L17/dossiers17170600000186711706000001867143PA8413672025-06-04False
17060000018716L17/dossiers17170600000186711706000001867144PA8413272025-06-04False
17060000018717L17/dossiers17170600000186711706000001867145PA8412432025-06-04False