EU-wide Transparency Exercise Results Spring 2020

European Banking Authority

@eba.eu_wide_transparency_exercise_results_spring_2020

Table List

4 tables(2.27 MB)

Sovereign Debt Exposures

Market Risk

Credit Risk

Other Templates

Sovereign Debt Exposures

@eba.eu_wide_transparency_exercise_results_spring_2020.sovereign_debt_exposures

410.66 KB
546304 rows
10 columns

lei_code LEI Code	nsa NSA	period Period	item Item	label Label	country Country	maturity Maturity	amount Amount
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	1
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	2	3.12384758
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	3
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	4	3.33021309
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	5	3.25491249
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	6
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	7
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	1	8	9.70897316
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	2	1
0W2PZJM8XOY22M4GG883	DE	201912	2020810	Direct exposures - On balance sheet - Total gross carrying amount of non-derivative financial assets	2	2


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