# US bank financials by quarter since 1984

**Compare every FDIC-insured US bank quarter by quarter, and see which ones later failed.** Call-report financials since 1984 are joined to each bank's location, regulator and holding company, and to the FDIC failed-bank list. Use the table to screen banks on capital, uninsured deposits or commercial real estate exposure, or to train and test a bank-failure model. Dollar amounts are converted fro…

US bank financials by quarter since 1984 is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `us-bank-financials-by-quarter-since-1984`
- Canonical page: https://mostlyright.md/datasets/us-bank-financials-by-quarter-since-1984
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-11-13T14:14:37.658Z
- Tables: 4
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/us-bank-financials-by-quarter-since-1984`
- Topics: banks, fdic, call reports, bank failures, deposits, commercial real estate, bank capital

## Table directory

Tables follow the publisher's curated order. Display labels do not change table identifiers.

Start here: bank_branch_deposits — table id: 3e073f5b-c93b-49ad-b20c-d39859a57d77

- bank_quarter_financials — table id: ac52599b-db04-4018-ba1e-43f3d3cc9706; published name: bank_quarter_financials; https://mostlyright.md/datasets/us-bank-financials-by-quarter-since-1984/tables?table=bank-quarter-financials
- bank_branch_deposits — table id: 3e073f5b-c93b-49ad-b20c-d39859a57d77; published name: bank_branch_deposits; https://mostlyright.md/datasets/us-bank-financials-by-quarter-since-1984/tables?table=bank-branch-deposits
- bank_enforcement_actions — table id: 5a4f5bde-ce2f-4efb-8171-b48264c30bd5; published name: bank_enforcement_actions; https://mostlyright.md/datasets/us-bank-financials-by-quarter-since-1984/tables?table=bank-enforcement-actions
- source_enforcement_actions — table id: dcc13894-455b-46b2-b298-c57c09d9027a; published name: source_enforcement_actions; https://mostlyright.md/datasets/us-bank-financials-by-quarter-since-1984/tables?table=source-enforcement-actions

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and ranked row search on public tables (search_table). An empty search query pages through a table in stored order. There is no filter, sort or download without an account.
3. Log in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: bank_quarter_financials

- Table id: `ac52599b-db04-4018-ba1e-43f3d3cc9706`
- Slug: `bank-quarter-financials`
- Immutable version: `aaef9079-40a9-56e3-b47b-7efe4af79727`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/ac52599b-db04-4018-ba1e-43f3d3cc9706/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/ac52599b-db04-4018-ba1e-43f3d3cc9706/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/ac52599b-db04-4018-ba1e-43f3d3cc9706/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/ac52599b-db04-4018-ba1e-43f3d3cc9706/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (77)

| Column | Type | Description |
| --- | --- | --- |
| `cert` | integer | FDIC certificate number, the stable identifier of one insured bank. |
| `report_date` | date | Quarter-end date the call report covers. |
| `bank_name` | string | Bank name as reported that quarter. |
| `city` | string | Headquarters city as reported that quarter. |
| `state` | string | Two-letter headquarters state as reported that quarter. |
| `state_name` | string | Headquarters state name from the bank's current FDIC profile. |
| `county` | string | Headquarters county from the bank's current FDIC profile. |
| `zip_code` | string | Headquarters ZIP code from the bank's current FDIC profile. |
| `metro_area` | string | Core-based statistical area of the headquarters, from the current FDIC profile. |
| `latitude` | decimal | Headquarters latitude in degrees, from the current FDIC profile. |
| `longitude` | decimal | Headquarters longitude in degrees, from the current FDIC profile. |
| `primary_regulator` | string | Primary federal regulator: OCC, FDIC or FED, from the current FDIC profile. |
| `charter_class` | string | FDIC charter class code as reported that quarter. |
| `charter_class_name` | string | Charter class in words, derived from the code. |
| `specialization` | string | FDIC asset-concentration group that quarter, such as agricultural, credit card or commercial lending. |
| `size_tier` | string | Asset size band that quarter, derived from total assets. |
| `holding_company_name` | string | Regulatory top holding company name, when the bank has one. |
| `holding_company_rssd_id` | string | Federal Reserve RSSD identifier of the top holding company. |
| `rssd_id` | string | Federal Reserve RSSD identifier of the bank. |
| `website` | string | Bank website from the current FDIC profile. |
| `established_on` | date | Date the bank was established. |
| `closed_on` | date | Date the bank stopped operating under this certificate, by failure, merger or closure. Null while active. |
| `is_active_today` | boolean | Whether the bank is active in the current FDIC profile, not as of the report date. |
| `employees` | integer | Full-time equivalent employees. |
| `domestic_offices` | integer | Number of domestic offices. |
| `total_assets_usd` | integer | Total assets. US dollars. |
| `total_deposits_usd` | integer | Total deposits, domestic and foreign offices. US dollars. |
| `domestic_deposits_usd` | integer | Deposits held in domestic offices. US dollars. |
| `insured_deposits_usd` | integer | Estimated FDIC-insured deposits. US dollars. |
| `uninsured_deposits_usd` | integer | Estimated uninsured deposits in domestic offices. US dollars. |
| `brokered_deposits_usd` | integer | Brokered deposits. US dollars. |
| `core_deposits_usd` | integer | Core deposits, the stable retail funding base. US dollars. |
| `total_equity_usd` | integer | Total equity capital. US dollars. |
| `net_loans_usd` | integer | Loans and leases net of allowance and unearned income. US dollars. |
| `gross_loans_usd` | integer | Loans and leases before the loss allowance. US dollars. |
| `real_estate_loans_usd` | integer | All loans secured by real estate. US dollars. |
| `construction_loans_usd` | integer | Construction and land development loans. US dollars. |
| `commercial_real_estate_loans_usd` | integer | Loans secured by nonfarm nonresidential property. US dollars. |
| `multifamily_loans_usd` | integer | Loans secured by multifamily residential property. US dollars. |
| `residential_mortgage_loans_usd` | integer | Loans secured by one to four family homes. US dollars. |
| `farmland_loans_usd` | integer | Loans secured by farmland. US dollars. |
| `commercial_industrial_loans_usd` | integer | Commercial and industrial loans. US dollars. |
| `consumer_loans_usd` | integer | Loans to individuals, including credit cards. US dollars. |
| `credit_card_loans_usd` | integer | Credit card loans. US dollars. |
| `farm_loans_usd` | integer | Loans to finance agricultural production. US dollars. |
| `securities_usd` | integer | Total securities. US dollars. |
| `held_to_maturity_securities_usd` | integer | Securities held to maturity, at amortized cost. US dollars. |
| `available_for_sale_securities_usd` | integer | Securities available for sale, at fair value. US dollars. |
| `cash_and_bank_balances_usd` | integer | Cash and balances due from depository institutions. US dollars. |
| `foreclosed_real_estate_usd` | integer | Other real estate owned, mostly foreclosed property. US dollars. |
| `noncurrent_loans_usd` | integer | Loans 90 or more days past due or on nonaccrual. US dollars. |
| `past_due_30_89_days_usd` | integer | Assets 30 to 89 days past due. US dollars. |
| `interest_income_ytd_usd` | integer | Total interest income, year to date. US dollars. |
| `interest_expense_ytd_usd` | integer | Total interest expense, year to date. US dollars. |
| `net_interest_income_ytd_usd` | integer | Net interest income, year to date. US dollars. |
| `noninterest_income_ytd_usd` | integer | Noninterest income, year to date. US dollars. |
| `noninterest_expense_ytd_usd` | integer | Noninterest expense, year to date. US dollars. |
| `loan_loss_provision_ytd_usd` | integer | Provision for credit losses, year to date. US dollars. |
| `net_charge_offs_ytd_usd` | integer | Loan charge-offs net of recoveries, year to date. US dollars. |
| `net_income_ytd_usd` | integer | Net income, year to date. US dollars. |
| `return_on_assets_pct` | decimal | Annualized net income as a percent of average assets. |
| `return_on_equity_pct` | decimal | Annualized net income as a percent of average equity. |
| `net_interest_margin_pct` | decimal | Annualized net interest income as a percent of average earning assets. |
| `efficiency_ratio_pct` | decimal | Noninterest expense as a percent of revenue. Lower is more efficient. |
| `noncurrent_loans_pct` | decimal | Noncurrent loans as a percent of gross loans. |
| `net_charge_off_rate_pct` | decimal | Annualized net charge-offs as a percent of average loans. |
| `loan_loss_reserve_pct` | decimal | Loss allowance as a percent of gross loans. |
| `tier1_leverage_ratio_pct` | decimal | Tier 1 capital as a percent of average assets. |
| `cet1_ratio_pct` | decimal | Common equity tier 1 capital as a percent of risk-weighted assets. |
| `total_capital_ratio_pct` | decimal | Total risk-based capital as a percent of risk-weighted assets. |
| `loans_to_deposits_pct` | decimal | Net loans as a percent of total deposits. |
| `uninsured_deposit_share_pct` | decimal | Estimated uninsured deposits as a percent of domestic deposits, derived. |
| `brokered_deposit_share_pct` | decimal | Brokered deposits as a percent of total deposits, derived. |
| `commercial_real_estate_to_equity_pct` | decimal | Construction, nonfarm nonresidential and multifamily loans as a percent of total equity, derived. A proxy for the regulators' 300 percent concentration guidanc… |
| `failed_on` | date | Date the bank failed, from the FDIC failures list, excluding open-bank assistance. Null for banks that never failed. |
| `days_until_failure` | integer | Days from the report date to the failure date, null once the failure is in the past. Future information: use it as a label, never as a feature. |
| `failure_cost_usd` | integer | FDIC's estimated cost of resolving the failure, in US dollars. Future information on rows before the failure. |

## Table: bank_branch_deposits

- Table id: `3e073f5b-c93b-49ad-b20c-d39859a57d77`
- Slug: `bank-branch-deposits`
- Immutable version: `2faad17d-3f99-53dd-a8e7-fa263c304c86`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/3e073f5b-c93b-49ad-b20c-d39859a57d77/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/3e073f5b-c93b-49ad-b20c-d39859a57d77/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/3e073f5b-c93b-49ad-b20c-d39859a57d77/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/3e073f5b-c93b-49ad-b20c-d39859a57d77/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (25)

| Column | Type | Description |
| --- | --- | --- |
| `survey_date` | date | The 30 June the deposits were measured on. |
| `survey_year` | integer | Year of the survey. |
| `cert` | integer | FDIC certificate number of the bank, joining to bank_quarter_financials. |
| `branch_number` | integer | The bank's own number for the branch. Zero is the main office. |
| `branch_id` | string | FDIC's unique number for the branch, stable across years and owners. |
| `bank_name` | string | Bank name that year. |
| `branch_name` | string | Branch name. |
| `address` | string | Street address of the branch. |
| `city` | string | City of the branch. |
| `state` | string | Two-letter state of the branch. |
| `zip_code` | string | ZIP code of the branch. |
| `county` | string | County of the branch. |
| `county_fips` | string | Five-digit state and county FIPS code of the branch. |
| `metro_area` | string | Metropolitan statistical area of the branch. |
| `latitude` | decimal | Branch latitude in degrees. |
| `longitude` | decimal | Branch longitude in degrees. |
| `branch_deposits_usd` | integer | Deposits booked at the branch on the survey date, in US dollars. |
| `service_type_code` | integer | FDIC branch service type code. |
| `service_type` | string | Branch service type in words, derived from the code. |
| `is_main_office` | boolean | Whether the row is the bank's main office. |
| `established_on` | date | Date the branch was established. |
| `bank_branch_count` | integer | Number of offices the bank reported that year, derived. |
| `branch_share_of_county_pct` | decimal | The branch's deposits as a percent of all deposits in its county that year, derived. |
| `bank_share_of_county_pct` | decimal | The bank's deposits across all its branches in the county as a percent of the county total that year, derived. |
| `county_deposits_usd` | integer | Total deposits of all banks' branches in the county that year, in US dollars, derived. |

## Table: bank_enforcement_actions

- Table id: `5a4f5bde-ce2f-4efb-8171-b48264c30bd5`
- Slug: `bank-enforcement-actions`
- Immutable version: `3c67e355-af24-5f91-a531-07842b83a824`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/5a4f5bde-ce2f-4efb-8171-b48264c30bd5/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/5a4f5bde-ce2f-4efb-8171-b48264c30bd5/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/5a4f5bde-ce2f-4efb-8171-b48264c30bd5/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/5a4f5bde-ce2f-4efb-8171-b48264c30bd5/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (19)

| Column | Type | Description |
| --- | --- | --- |
| `action_id` | string | Stable identifier of the action, a hash of the regulator, institution, action type, date and docket. |
| `regulator` | string | The agency that took the action: OCC or Federal Reserve. |
| `institution_name` | string | The bank or holding company named in the action. |
| `city` | string | City of the institution as the regulator wrote it. |
| `state` | string | Two-letter state of the institution. |
| `cert` | integer | FDIC certificate number of the bank, joining to bank_quarter_financials. Null for holding companies and unmatched names. |
| `cert_match_method` | string | How the certificate was found: OCC charter number, savings association docket number, or exact name, city and state. |
| `action_type_code` | string | OCC's short code for the action type. |
| `action_type` | string | Type of action, such as cease and desist order, written agreement, formal agreement or civil money penalty. |
| `penalty_usd` | integer | Civil money penalty in US dollars, zero or null when the action carried none. |
| `started_on` | date | Date the action took effect. |
| `terminated_on` | date | Date the regulator terminated the action. Null while it is open. |
| `is_open` | boolean | Whether the action has no termination date. |
| `docket_number` | string | OCC docket number of the action. |
| `stated_subjects` | string | Subject matters the OCC itself lists for the action, separated by semicolons. |
| `cause` | string | Main reason for the action in one of six groups, or other or unclear when the model found none fits. Taken from the regulator's subject list where it has one,… |
| `cause_source` | string | Where the cause came from: regulator subject list, or model. |
| `cause_probability` | decimal | The model's probability for its label, between 0 and 1. Null when the cause came from the regulator's list. |
| `document_url` | string | Address of the order or press release. |

## Table: source_enforcement_actions

- Table id: `dcc13894-455b-46b2-b298-c57c09d9027a`
- Slug: `source-enforcement-actions`
- Immutable version: `4d10ecee-e93e-554b-9efb-28eff7f430a1`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/dcc13894-455b-46b2-b298-c57c09d9027a/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/dcc13894-455b-46b2-b298-c57c09d9027a/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/dcc13894-455b-46b2-b298-c57c09d9027a/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/dcc13894-455b-46b2-b298-c57c09d9027a/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (18)

| Column | Type | Description |
| --- | --- | --- |
| `action_id` | string | Stable identifier of the action, a hash of the regulator, institution, action type, date and docket. |
| `regulator` | string | The agency that took the action: OCC or Federal Reserve. |
| `institution_name` | string | The bank or holding company named in the action. |
| `city` | string | City of the institution as the regulator wrote it. |
| `state` | string | Two-letter state of the institution. |
| `cert` | integer | FDIC certificate number of the bank, joining to bank_quarter_financials. Null for holding companies and unmatched names. |
| `cert_match_method` | string | How the certificate was found: OCC charter number, savings association docket number, or exact name, city and state. |
| `action_type_code` | string | OCC's short code for the action type. |
| `action_type` | string | Type of action, such as cease and desist order, written agreement, formal agreement or civil money penalty. |
| `penalty_usd` | integer | Civil money penalty in US dollars, zero or null when the action carried none. |
| `started_on` | date | Date the action took effect. |
| `terminated_on` | date | Date the regulator terminated the action. Null while it is open. |
| `is_open` | boolean | Whether the action has no termination date. |
| `docket_number` | string | OCC docket number of the action. |
| `stated_subjects` | string | Subject matters the OCC itself lists for the action, separated by semicolons. |
| `rule_cause` | string | Main reason for the action, derived by rule from the OCC's own subject list. Null where the regulator lists none. |
| `document_id` | string | The regulator's identifier of the order or press release, used to fetch its text. |
| `document_url` | string | Address of the order or press release. |

## Citing this dataset

Cite the dataset by name and canonical URL (https://mostlyright.md/datasets/us-bank-financials-by-quarter-since-1984), the table, and the immutable `version_id` the rows came from. A query response carries `table.version_id` and `table.content_digest`; a download carries a strong ETag and a `Content-Digest` header.
