Fixing Deposit Maps Distorted by Deposits Booked at Head Offices
On this page
Problem statement
Map bank deposits by county from the Summary of Deposits and Manhattan holds nearly a tenth of the country's money, Salt Lake County more than Los Angeles, and a suburban county in South Dakota more than Chicago. None of that describes where depositors live. Banks book deposits gathered online, by phone, from national corporate accounts and from credit-card and brokerage businesses at a few offices, often a main office in a state chosen for its banking law. This page finds the offices behind the distortion, measures how much of the total they hold, and compares deposits per resident with and without them.
Quick answer
Sum deposits by county and look at the top:
c = sod.groupby("STCNTYBR").deposits.sum().sort_values(ascending=False)
print((c.head(6) / 1e9).round(0).to_string())
print(f"top 6 counties' share of all deposits: {c.head(6).sum() / c.sum():.1%}")
STCNTYBR
36061 1774.0
49035 1021.0
46083 532.0
06037 502.0
37119 452.0
17031 442.0
top 6 counties' share of all deposits: 26.1%
New York County, Manhattan, has $1,774 billion, Salt Lake County, Utah, $1,021 billion, and Lincoln County, South Dakota, $532 billion, ahead of Los Angeles County at $502 billion. Mecklenburg County, North Carolina, home of Charlotte, and Cook County, Illinois, follow. These six counties hold 26.1% of all deposits in the country.
Main offices, giant branches and per-resident figures
1. The main offices behind them
m = sod[sod.BRNUM == 0].nlargest(6, "deposits")
print(m.assign(bn=(m.deposits / 1e9).round(0))[["NAMEFULL", "CITYBR", "STALPBR", "STCNTYBR", "bn"]].to_string(index=False))
print(f"share of all deposits booked at main offices: {sod.loc[sod.BRNUM == 0, 'deposits'].sum() / sod.deposits.sum():.1%}")
NAMEFULL CITYBR STALPBR STCNTYBR bn
Citibank, National Association Sioux Falls SD 46083 522.0
Bank of America, National Association Charlotte NC 37119 312.0
Goldman Sachs Bank USA New York NY 36061 226.0
The Bank of New York Mellon New York NY 36061 224.0
Morgan Stanley Private Bank, National Association Purchase NY 36119 212.0
Charles Schwab Bank, SSB Westlake TX 48121 210.0
share of all deposits booked at main offices: 29.0%
Main offices explain several of them. Citibank's main office in Sioux Falls, South Dakota, in Lincoln County, books $522 billion; Bank of America's in Charlotte $312 billion; Goldman Sachs and Bank of New York Mellon book $226 billion and $224 billion in Manhattan, and Morgan Stanley's private bank in Purchase, New York, and Charles Schwab's bank in Westlake, Texas, $212 billion and $210 billion. Salt Lake County's total comes largely from industrial banks and other national banks chartered in Utah, which gather deposits from across the country. Main offices hold 29.0% of all deposits.
2. Branches with deposits but no customers
z = sod[(sod.BRNUM != 0)]
print(f"branches over $10 billion: {(z.deposits > 1e10).sum()}")
print(z.nlargest(4, "deposits").assign(bn=lambda d: (d.deposits / 1e9).round(0))[["NAMEFULL", "NAMEBR", "CITYBR", "STALPBR", "BRSERTYP", "bn"]].to_string(index=False))
branches over $10 billion: 66
NAMEFULL NAMEBR CITYBR STALPBR BRSERTYP bn
JPMorgan Chase Bank, National Association Madison And 47Th St Branch New York NY 11 727.0
Wells Fargo Bank, National Association Colonial Branch Sioux Falls SD 11 344.0
Capital One, National Association Www.Capitalone360.Com Branch Wilmington DE 13 274.0
Bank of America, National Association San Francisco Main Branch San Francisco CA 11 176.0
Leaving main offices out is not enough. 66 ordinary branches hold more than $10 billion each, and the largest are national booking offices in disguise: JPMorgan's Madison and 47th Street branch in Manhattan with $727 billion, Wells Fargo's Colonial branch in Sioux Falls with $344 billion, Capital One's internet branch in Wilmington with $274 billion, and Bank of America's San Francisco main branch with $176 billion.
3. Per resident, with and without
pop = pd.read_csv(Z.open("co-est2024-alldata.csv"), encoding="latin-1", dtype={"STATE": str, "COUNTY": str})
pop = pop[pop.SUMLEV == 50].assign(GEOID=lambda d: d.STATE + d.COUNTY).set_index("GEOID").POPESTIMATE2024
allc = c / pop.reindex(c.index)
brc = sod[sod.BRNUM != 0].groupby("STCNTYBR").deposits.sum() / pop
print(pd.DataFrame({"all_offices": allc, "branches_only": brc}).loc[["39049", "10003", "46099", "36061"]].round(0).to_string())
all_offices branches_only
STCNTYBR
39049 73960.0 42634.0
10003 744146.0 512569.0
46099 1733308.0 1680980.0
36061 1068526.0 719208.0
Per resident, the distortion is extreme. Including all offices, Minnehaha County, South Dakota, has $1,733,308 of deposits per resident, New Castle County, Delaware, $744,146 and Manhattan $1,068,526. Dropping main offices barely changes Minnehaha, whose deposits sit in a branch, and only cuts Manhattan to $719,208, because JPMorgan books its national deposits at a branch there. Franklin County, Ohio, where Huntington National Bank has its main office in Columbus, falls from $73,960 to $42,634 per resident. Per-resident deposit maps need the largest offices removed, not just main offices.
A capped map
The data used on this page
The FDIC's Summary of Deposits for 2015 and 2025, every office of every FDIC-insured institution with its deposits as of 30 June, from the BankFind Suite API, downloaded on 28 October 2026 and saved on this site, because banks amend past reports and the API serves the revised figures. Public domain. Deposits are reported in thousands of dollars. County populations are the Census Bureau's Vintage 2024 estimates, tract centres of population its 2020 census file, and boundaries its 2024 cartographic files, all public domain.
from pathlib import Path
import zipfile
import geopandas as gpd
import numpy as np
import pandas as pd
import requests
Path("data").mkdir(exist_ok=True)
# FDIC Summary of Deposits for 2015 and 2025 (every branch, deposits as of 30 June) from the BankFind Suite API, with
# the Census Bureau's 2024 county population estimates, 2020 tract centres of population, counties and states.
# Saved 28 October 2026: the API serves revised years as banks amend their reports.
# Live: https://api.fdic.gov/banks/sod?filters=YEAR:2025&limit=10000&offset=0
ARCHIVE = "fdic-sod-2026-10-28.zip"
if not Path(f"data/{ARCHIVE}").exists():
Path(f"data/{ARCHIVE}").write_bytes(requests.get(f"https://data.spatialworkflow.io/{ARCHIVE}", timeout=600).content)
Z = zipfile.ZipFile(f"data/{ARCHIVE}")
for f in ["cb_2024_us_county_20m.zip", "cb_2024_us_state_20m.zip"]:
Path(f"data/{f}").write_bytes(Z.read(f))
def read_sod(year):
d = pd.read_csv(Z.open(f"fdic-sod-{year}.csv"), dtype={"ZIPBR": str})
d["STCNTYBR"] = d.STCNTYBR.astype(str).str.zfill(5) # county FIPS, stored as a number
d["deposits"] = d.DEPSUMBR * 1000 # reported in thousands of dollars
return d
sod = read_sod(2025)
print(f"FDIC Summary of Deposits 2025: {len(sod):,} offices, ${sod.deposits.sum() / 1e12:,.2f} trillion in deposits")
FDIC Summary of Deposits 2025: 76,097 offices, $18.10 trillion in deposits
Example 1: a capped map
b = sod[(sod.BRNUM != 0)]
cap = b.deposits.quantile(0.999)
capped = b.deposits.clip(upper=cap).groupby(b.STCNTYBR).sum()
print(f"99.9th percentile branch: ${cap / 1e9:.2f} billion; branches above it: {(b.deposits > cap).sum()}")
print(f"counties whose total falls by over half when those are capped: {((capped / b.groupby('STCNTYBR').deposits.sum()) < 0.5).sum()}")
99.9th percentile branch: $8.66 billion; branches above it: 72
counties whose total falls by over half when those are capped: 13
A simple fix caps each branch at the 99.9th percentile, $8.66 billion, which affects 72 branches. With the cap, 13 counties lose more than half of their deposit total, the booking centres, while every other county is unchanged. The capped map shows where branches gather local deposits; the uncapped one shows where banks keep their books.
Internal links
- Deposit market share β the HHI this distortion inflates
- The largest banks β deposits per office by bank
- Branch service types β internet offices that book national deposits
- Reading the survey β the deposit column and its units