Consolidated Banking Data - CBD2

European Central Bank

@ecb.consolidated_banking_data_cbd2

Table List

1 table(18.49 MB)

Table 1

@ecb.consolidated_banking_data_cbd2.table_1

18.49 MB
1671896 rows
39 columns

key KEY	freq FREQ	ref_area REF AREA	count_area COUNT AREA	cb_rep_sector CB REP SECTOR	bs_count_sector BS COUNT SECTOR	bs_nfc_activity BS NFC ACTIVITY	cb_sector_size CB SECTOR SIZE	cb_rep_framewrk CB REP FRAMEWRK	cb_item CB ITEM	cb_portfolio CB PORTFOLIO	cb_exp_type CB EXP TYPE	cb_val_method CB VAL METHOD	maturity_res MATURITY RES	data_type DATA TYPE	currency_trans CURRENCY TRANS	unit_measure UNIT MEASURE	time_period TIME PERIOD	obs_value OBS VALUE	obs_status OBS STATUS	conf_status CONF STATUS	time_format TIME FORMAT	comment_ts COMMENT TS	data_comp DATA COMP	decimals DECIMALS	time_per_collect TIME PER COLLECT	title TITLE
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2007		M	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2008	1.5503408272771084	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2009	1.5852958728616462	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2010	1.705435597375058	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2011	1.675431249697728	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2012	1.5766886264030542	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2013	1.625049679926272	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2014	1.7619084122711168	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2015	1.6703028975388543	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]
CBD2.A.AT.W0.11._Z._Z.A.A.I2410._Z._Z._Z._Z._Z._Z.PC	A	AT	W0	11	_Z	_Z	A	A	I2410	_Z	_Z	_Z	_Z	_Z	_Z	PC	2016	1.594574414351749	E	F	P1Y	Austria,counterpart: World (all entities, including reference area, including IO),reporting sector: Domestic banking groups and stand-alone banks,All institutions,Full sample (All banking groups / stand-alone banks irrespective of their accounting / supervisory reporting framework),Net interest inco…	The underlying profitability data is not annualised.Net interest income / TOTAL ASSETS	4	A	Net interest income [% of total assets]


CREATE TABLE table_1 (
  "key" VARCHAR,
  "freq" VARCHAR,
  "ref_area" VARCHAR,
  "count_area" VARCHAR,
  "cb_rep_sector" BIGINT,
  "bs_count_sector" VARCHAR,
  "bs_nfc_activity" VARCHAR,
  "cb_sector_size" VARCHAR,
  "cb_rep_framewrk" VARCHAR,
  "cb_item" VARCHAR,
  "cb_portfolio" VARCHAR,
  "cb_exp_type" VARCHAR,
  "cb_val_method" VARCHAR,
  "maturity_res" VARCHAR,
  "data_type" VARCHAR,
  "currency_trans" VARCHAR,
  "unit_measure" VARCHAR,
  "time_period" VARCHAR,
  "obs_value" DOUBLE,
  "obs_status" VARCHAR,
  "conf_status" VARCHAR,
  "pre_break_value" VARCHAR,
  "comment_obs" VARCHAR,
  "time_format" VARCHAR,
  "breaks" VARCHAR,
  "comment_ts" VARCHAR,
  "compiling_org" VARCHAR,
  "coverage" VARCHAR,
  "currency" VARCHAR,
  "data_comp" VARCHAR,
  "decimals" BIGINT,
  "diss_org" VARCHAR,
  "publ_ecb" VARCHAR,
  "publ_mu" VARCHAR,
  "publ_public" VARCHAR,
  "time_per_collect" VARCHAR,
  "title" VARCHAR,
  "title_compl" VARCHAR,
  "unit_mult" BIGINT
);