About this Dataset

Consolidated Banking Data - CBD2

These data contain information on the aggregate consolidated

profitability
balance sheets
asset quality
liquidity
funding
capital adequacy
solvency of EU banks

and refer to all EU Member States.

The banks are divided into three size groups: small, medium-sized and large. Information on foreign-controlled institutions active in EU countries is also provided.
Publisher name: European Central Bank
Publisher URL: https://www.ecb.europa.eu
Last updated: 2025-06-26T05:15:01Z

Tables

Table 1

@ecb.consolidated_banking_data_cbd2.table_1

19.89 MB
1,732,734 rows
39 columns

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