About this Dataset

EU-wide Transparency Exercise Results 2022

The EU-wide Transparency exercise is part of the EBA's ongoing efforts to foster transparency and market discipline in the EU financial market, and complements banks' own Pillar 3 disclosures, as laid down in the EU Capital Requirements Directive (CRD). With the 2022 EU-wide transparency exercise the EBA discloses detailed bank-by-bank data for the reference dates of 30 September 2021, 31 December 2021, 31 March 2022 and 30 June 2022. Information is published at the highest level of consolidation for 122 banks across 26 countries of the European Union (EU) and the European Economic Area (EEA). The exercise results are based on the supervisory data submitted to the EBA via the European Centralised Infrastructure of Data (EUCLID) platform, which the EBA has developed to gather and analyse regulatory data from a wide range of financial institutions. EUCLID, which acts as a data hub, covers supervisory, resolution, remuneration and payments data, thus allowing the EBA and its stakeholders to carry out in-depth analyses of the EU-wide banking/financial sector.
Publisher name: European Banking Authority
Publisher URL: https://eba.europa.eu
Last updated: 2024-02-08T18:37:59Z

Tables

Credit Risk

@eba.eu_wide_transparency_exercise_results_2022.credit_risk

2.95 MB
683340 rows
14 columns


CREATE TABLE credit_risk (
  "lei_code" VARCHAR,
  "nsa" VARCHAR,
  "period" BIGINT,
  "item" BIGINT,
  "label" VARCHAR,
  "portfolio" BIGINT,
  "country" BIGINT,
  "country_rank" BIGINT,
  "exposure" BIGINT,
  "status" BIGINT,
  "perf_status" BIGINT,
  "nace_codes" BIGINT,
  "amount" DOUBLE,
  "footnote" VARCHAR
);

Market Risk

@eba.eu_wide_transparency_exercise_results_2022.market_risk

76.38 KB
23358 rows
10 columns


CREATE TABLE market_risk (
  "lei_code" VARCHAR,
  "nsa" VARCHAR,
  "period" BIGINT,
  "item" BIGINT,
  "label" VARCHAR,
  "portfolio" BIGINT,
  "mkt_modprod" BIGINT,
  "mkt_risk" BIGINT,
  "amount" DOUBLE,
  "footnote" VARCHAR
);

Other Templates

@eba.eu_wide_transparency_exercise_results_2022.other_templates

582.31 KB
95914 rows
13 columns


CREATE TABLE other_templates (
  "lei_code" VARCHAR,
  "nsa" VARCHAR,
  "period" BIGINT,
  "item" BIGINT,
  "label" VARCHAR,
  "assets_fv" BIGINT,
  "assets_stages" BIGINT,
  "exposure" BIGINT,
  "financial_instruments" BIGINT,
  "amount" DOUBLE,
  "fin_end_year" BIGINT,
  "n_quarters" BIGINT,
  "footnote" VARCHAR
);

Sovereign Debt Exposures

@eba.eu_wide_transparency_exercise_results_2022.sovereign_debt_exposures

720.95 KB
404005 rows
10 columns


CREATE TABLE sovereign_debt_exposures (
  "lei_code" VARCHAR,
  "nsa" VARCHAR,
  "period" BIGINT,
  "item" BIGINT,
  "label" VARCHAR,
  "country" BIGINT,
  "accounting_portfolio" BIGINT,
  "maturity" BIGINT,
  "amount" DOUBLE,
  "footnote" VARCHAR
);