EU-wide Transparency Exercise Results Autumn 2020

European Banking Authority

@eba.eu_wide_transparency_exercise_results_autumn_2020

Table List

4 tables(2.5 MB)

Credit Risk

Market Risk

Other Templates

Sovereign Debt Exposures

Credit Risk

@eba.eu_wide_transparency_exercise_results_autumn_2020.credit_risk

1.72 MB
396232 rows
14 columns

lei_code LEI Code	nsa NSA	period Period	item Item	label Label	portfolio Portfolio	country Country	country_rank Country Rank	exposure Exposure	amount Amount
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2			103	437.67050391
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2			203	27316.20167471
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2			303	34857.95284806
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2			404
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2			606	435.32577959
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2	10	1	103
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2	10	1	203	11330.33897595
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2	10	1	303	9326.69988956
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2	10	1	404
0W2PZJM8XOY22M4GG883	DE	202003	2020502	Original Exposure - by exposure class (SA_and_IRB)	2	10	1	606	76.36982786


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
);