About this Dataset

EU-wide Transparency Exercise Results Autumn 2020

With the 2020 EU-wide transparency exercise the EBA discloses detailed bank-by-bank data for the reference dates of 31 March 2020 and 30 June 2020. Information is published for 129 banks across 26 countries at the highest level of consolidation in the European Union (EU-27) and the European Economic Area (EEA) as well as for 6 banks from UK. The data available on this webpage provides disclosure on banks' assets and liabilities, capital positions, risk exposure amounts, leverage exposures and asset quality. Furthermore, information on sovereign exposures and on legislative and non-legislative moratoria is available for the reference date of June 2020.
Publisher name: European Banking Authority
Publisher URL: https://eba.europa.eu
Last updated: 2024-06-11T16:17:59Z

Tables

Credit Risk

@eba.eu_wide_transparency_exercise_results_autumn_2020.credit_risk

1.72 MB
396232 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_autumn_2020.market_risk

48.91 KB
13668 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_autumn_2020.other_templates

334.01 KB
53526 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_autumn_2020.sovereign_debt_exposures

412.08 KB
580448 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
);