FDIC Deposit Market Share & HHI Rollup — SOD Branch Data

Turn the official FDIC Summary of Deposits (SOD) branch-level survey into an instant deposit market-share, concentration (HHI), and branch-network-change report for any US county, metro area (MSA), or state. One run answers: who holds the deposits in this market, how concentrated is it under DOJ thresholds, and who is opening or closing branches?

• Source: FDIC BankFind Suite API, SOD endpoint (api.fdic.gov/banks/sod) — official, keyless, no scraping.
• Coverage: every FDIC-insured branch in the US (~77,000 branches; annual survey, deposits as of June 30).
• The analytics layer (what raw SOD doesn't give you): per-bank market share and rank per area, area HHI with DOJ concentration flags, top-3 share, market-gap screening, and year-over-year branch openings/closures, deposit growth, and share shift.

Who it's for

• Bank M&A / corporate development teams — pre-screen deal markets: pro-forma HHI context, overlap, and the DOJ/Fed concentration picture per county before an application.
• Deposit brokers & treasury/funding desks — find where deposits pool and which institutions dominate or are gaining share.
• Fintech & banking-as-a-service partnership teams — spot concentrated markets (market_gap=true) where the top 3 banks hold most deposits and challengers have room.
• CRE site selection & retail-network planners — branch density, openings, and closures by county/MSA.
• Analysts, journalists, researchers — clean, ranked deposit-share tables without wrestling the raw SOD download.

Example input

{
  "state": "CO",
  "year": 2024,
  "compareYear": 2023,
  "rollupLevel": "county",
  "mode": "banks",
  "maxResults": 500
}

• mode: "banks" (default) → one row per bank × area with share, rank, and the area's stats.
• mode: "areas" → one compact summary row per area (a concentration screen).
• Omit state to roll up the full national file (slower; ~77k branches fetched).
• compareYear triggers a second fetch and fills all yoy_* fields.

Output fields (one row per bank×area, or per area)

year, rollup_level, area_name, area_code, state, bank_name, cert (FDIC certificate — join key to FDIC Financials/BankFind), branch_count, total_deposits_usd, market_share_pct, rank, area_total_deposits_usd, area_bank_count, area_branch_count, area_hhi, area_top3_share_pct, concentration_flag, market_gap, compare_year, yoy_branches_opened, yoy_branches_closed, yoy_deposit_growth_pct, yoy_share_shift_pts, source_url.

Notes:

• SOD reports deposits in thousands of dollars (DEPSUMBR); this actor converts to plain USD.
• HHI is the Herfindahl–Hirschman Index: the sum of squared market shares (0–10,000). concentration_flag follows the DOJ/FTC Horizontal Merger Guidelines (2010) screening thresholds: > 2,500 = highly concentrated, 1,500–2,500 = moderately concentrated — the bands long used in bank-merger competitive review (the DOJ 2023 banking addendum and the Fed/DOJ 1800/200 bank screen are stricter; use area_hhi directly for those).
• YoY branch "opened/closed" counts are net changes in branch counts per bank per area (area-level closures include banks that exited the market entirely).

Use as an MCP tool

This actor is callable by AI agents (Claude, Cursor, etc.) through mcp.apify.com. Field-level input and output descriptions make it a clean, chainable tool: e.g. "get the deposit market share and HHI for every county in Colorado, then compare 2023 vs 2024 branch closures."

FAQ

What is the FDIC Summary of Deposits? An annual FDIC survey (as of June 30) of deposits for every branch of every FDIC-insured institution — the standard dataset for deposit market-share and bank-merger competitive analysis.

How is deposit market share HHI calculated for bank mergers? Sum the squared deposit shares of every bank in the geographic market (county/MSA here). This actor computes it per area and flags DOJ concentration bands automatically.

Which banks are closing branches in my county? Set compareYear and read yoy_branches_closed per bank per county.

Do I need an API key? No — the FDIC BankFind Suite API is public and keyless.

How current is the data? SOD is annual; the 2024 survey (June 30, 2024) is the latest fully published as of mid-2026. Set year accordingly.

Is this the same as the FDIC market-share (Deposit Market Share Report) tool? Same underlying data, but delivered as a structured dataset with HHI, ranks, YoY deltas, and market-gap flags — ready for pipelines, spreadsheets, and AI agents.

Related actor

Pair with FDIC + NCUA Bank & Credit Union Health Rollup (same keyless FDIC API family) to overlay institution financial-health metrics on the deposit share leaders you find here — cert is the join key.

Pricing

Pay-per-event: you pay only per result row. Bounded by maxResults, so a county-level state screen costs cents.