About this Dataset

EU-wide Transparency Exercise Results Spring 2020

With the Spring 2020 EU-wide transparency exercise the EBA discloses detailed bank-by-bank data for the reference dates of 30 September 2019 and December 2019. Information is published at the highest level of consolidation for 127 banks across 27 countries of the European Union (EU) and the European Economic Area (EEA). The data available on this webpage provides disclosure on banks' assets and liabilities, capital positions, risk exposure amounts, leverage exposures and asset quality. Sovereign exposures are available only for the reference date of December 2019.
Publisher name: European Banking Authority
Publisher URL: https://eba.europa.eu
Last updated: 2024-06-11T16:17:31Z

Tables

Credit Risk

@eba.eu_wide_transparency_exercise_results_spring_2020.credit_risk

1.57 MB
342,927 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_spring_2020.market_risk

49.72 kB
12,852 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_spring_2020.other_templates

331.53 kB
50,648 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_spring_2020.sovereign_debt_exposures

420.51 kB
546,304 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
);