About this Dataset

Balance Sheets and Income Statements of Commercial Banks: 1959 to 2025

This data set contains a set of time-consistent balance sheet and income statement variables over the period from 1959 to 2025, constructed from more than 2.5 million quarterly financial statements for 24,000 unique banks.

The original source of the data is the “Consolidated Reports of Condition and Income for a Bank with Domestic and Foreign Offices” filed by commercial banks in the U.S. and collected by the Federal Financial Institutions Examination Council (FFIEC). These “Call Reports” contain both bank balance sheets and income statements and are reported at least at an annual frequency or higher.

Using the original filings, this data set contains time-consistent balance sheet and income statement variables ranging from 1959 to 2025. In addition, a subset of selected, more granular line items as well as bank identifiers, bank location, and links to bank holding companies (where applicable) are provided. The data provided here have been used in a Staff Report by Correia, Luck, and Verner (2024; forthcoming in the Quarterly Journal of Economics).

Tables

Data

@pjsousa.call_reports_from_1959_to_2025.data

400.94 MB
2,544,226 rows
102 columns

CREATE TABLE data (
  "id_rssd" INTEGER,
  "date" TIMESTAMP,
  "id_rssd_hd_off" DOUBLE,
  "id_cusip" VARCHAR,
  "id_thrift" DOUBLE,
  "id_aba_prim" DOUBLE,
  "id_fdic_cert" DOUBLE,
  "id_occ" DOUBLE,
  "state_cd" DOUBLE,
  "ent_type_cd" DOUBLE,
  "assets" DOUBLE,
  "cash" DOUBLE,
  "securities" DOUBLE,
  "ln_tot_gross" DOUBLE,
  "ln_tot" DOUBLE,
  "llres" DOUBLE,
  "trad_ass" DOUBLE,
  "ffrepo_ass" DOUBLE,
  "ffsold" DOUBLE,
  "repo_purch" DOUBLE,
  "fixed_ass" DOUBLE,
  "oreo" DOUBLE,
  "oth_assets" DOUBLE,
  "oth_assets_alt" DOUBLE,
  "earn_ass" DOUBLE,
  "earn_ass_1959" DOUBLE,
  "demand_deposits" DOUBLE,
  "time_deposits" DOUBLE,
  "deposits" DOUBLE,
  "ffrepo_liab" DOUBLE,
  "ffpurch" DOUBLE,
  "repo_sold" DOUBLE,
  "trad_liab" DOUBLE,
  "othbor_liab" DOUBLE,
  "subdebt" DOUBLE,
  "liab_oth" DOUBLE,
  "liab_tot" DOUBLE,
  "liab_tot_unadj" DOUBLE,
  "minorint" DOUBLE,
  "pref_stock" DOUBLE,
  "comm_stock" DOUBLE,
  "surplus" DOUBLE,
  "retain_earn" DOUBLE,
  "equity" DOUBLE,
  "ln_re" DOUBLE,
  "ln_fi" DOUBLE,
  "ln_dep_inst" DOUBLE,
  "ln_dep_inst_dom" DOUBLE,
  "ln_oth" DOUBLE,
  "ln_cc" DOUBLE,
  "ln_ci" DOUBLE,
  "ln_cons" DOUBLE,
  "npl_tot" DOUBLE,
  "brokered_dep" DOUBLE,
  "insured_deposits" DOUBLE,
  "insured_deposits_alt" DOUBLE,
  "ytdint_inc_sec" DOUBLE,
  "ytdint_inc_ln" DOUBLE,
  "ytdint_inc_ffrepo" DOUBLE,
  "ytdint_inc_lease" DOUBLE,
  "ytdint_inc_ibb" DOUBLE,
  "ytdfiduc_inc" DOUBLE,
  "ytdnonint_inc_srv_chrg_dep" DOUBLE,
  "ytdoth_srv_chrg" DOUBLE,
  "ytdoth_operating_inc" DOUBLE,
  "ytdoth_operating_inc_adj" DOUBLE,
  "ytdoperating_inc_tot" DOUBLE,
  "ytdop_inc_tot_1960" DOUBLE,
  "num_employees" DOUBLE,
  "ytdnonint_exp_comp" DOUBLE,
  "ytdint_exp_dep" DOUBLE,
  "ytdint_exp_ffrepo" DOUBLE,
  "ytdint_exp_othbor" DOUBLE,
  "ytdint_exp_trad_othbor" DOUBLE,
  "ytdint_exp_subdebt" DOUBLE,
  "ytdnonint_exp_fass" DOUBLE,
  "ytdllprov" DOUBLE,
  "ytdoth_operating_exp" DOUBLE,
  "ytdoperating_exp_tot" DOUBLE,
  "ytdoperating_exp_tot_adj" DOUBLE,
  "ytdop_exp_tot_1960" DOUBLE,
  "ytdnet_op_earn_1960" DOUBLE,
  "ytdnet_operating_earn" DOUBLE,
  "ytdrecov_tot" DOUBLE,
  "ytdxoff_tot" DOUBLE,
  "ytdinc_taxes_net" DOUBLE,
  "ytdinc_taxes_netsec" DOUBLE,
  "ytdinc_taxes_sec" DOUBLE,
  "ytdinc_taxes" DOUBLE,
  "ytdinc_before_sec_gain" DOUBLE,
  "ytdsecur_inc" DOUBLE,
  "ytdsec_net" DOUBLE,
  "ytdinc_before_disc_op" DOUBLE,
  "ytdextra_inc_gross" DOUBLE,
  "ytdextra_inc" DOUBLE,
  "ytddisc_op" DOUBLE,
  "ytdminor_int" DOUBLE,
  "ytdnetinc" DOUBLE,
  "ytdint_inc" DOUBLE,
  "ytdnonint_inc" DOUBLE
);