Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

153 MB across 33 parts, newest sealed 12 November 2026 at 21:50 UTC. The first build wrote 33 parts and 2.9M rows.

All 2 checks passed.
  • One row per branch year passed.
  • Rows present passed.

survey_date

date

The 30 June the deposits were measured on.

33 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
33 · 0% of valid

survey_year

integer

Year of the survey.

33 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
33 · 0% of valid
Min
1994
25%
2002
Median
2010
75%
2018
Max
2026

cert

integer

FDIC certificate number of the bank, joining to bank_quarter_financials.

15,513 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
15,513 · 0.5% of valid
Min
8
25%
3890
Median
11491
75%
23220
Max
91393

branch_number

integer

The bank's own number for the branch. Zero is the main office.

10,464 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
10,464 · 0.4% of valid
Min
0
25%
5
Median
69
75%
724
Max
10579

branch_id

string

FDIC's unique number for the branch, stable across years and owners.

153,601 distinct values, no chart

Valid
2,778,575 · 95.9%
Missing
120,261 · 4.1%
Missing over timeMissing share of branch_id over time, 0% to 10%.
Distinct
153,601 · 5.5% of valid

bank_name

string

Bank name that year.

19,011 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
19,011 · 0.7% of valid

branch_name

string

Branch name.

164,417 distinct values, no chart

Valid
2,898,833 · 100%
Missing
3 · 0%
Missing over timeMissing share of branch_name over time, 0% to 0%.
Distinct
164,417 · 5.7% of valid

address

string

Street address of the branch.

270,945 distinct values, no chart

Valid
2,898,777 · 100%
Missing
59 · 0%
Missing over timeMissing share of address over time, 0% to 0%.
Distinct
270,945 · 9.3% of valid

city

string

City of the branch.

  • Houston1%
  • Chicago1%
  • New York City1%
  • Other (15,211)
Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
15,223 · 0.5% of valid

state

string

Two-letter state of the branch.

  • CA8%
  • TX7%
  • FL6%
  • Other (47)
Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
59 · 0% of valid

zip_code

string

ZIP code of the branch.

24,317 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
24,317 · 0.8% of valid

county

string

County of the branch.

1,990 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
1,990 · 0.1% of valid

county_fips

string

Five-digit state and county FIPS code of the branch.

3,236 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
3,236 · 0.1% of valid

metro_area

string

Metropolitan statistical area of the branch.

  • New York-Newark-Jersey City, NY-NJ-PA7%
  • Chicago-Naperville-Elgin, IL-IN-WI3%
  • Los Angeles-Long Beach-Anaheim, CA3%
  • Other (492)
Valid
2,266,703 · 78.2%
Missing
632,133 · 21.8%
Missing over timeMissing share of metro_area over time, 21% to 23%.
Distinct
504 · 0% of valid

latitude

decimal

Branch latitude in degrees.

472,056 distinct values, no chart

Valid
2,671,332 · 92.2%
Missing
227,504 · 7.8%
Missing over timeMissing share of latitude over time, 0% to 22%.
Distinct
472,056 · 17.7% of valid
Min
-35.259600
25%
34.161881
Median
39.035436
75%
41.492900
Max
158.227518

longitude

decimal

Branch longitude in degrees.

487,304 distinct values, no chart

Valid
2,671,326 · 92.2%
Missing
227,510 · 7.8%
Missing over timeMissing share of longitude over time, 0% to 22%.
Distinct
487,304 · 18.2% of valid
Min
-170.718610
25%
-96.284966
Median
-86.722217
75%
-79.923047
Max
174.124000

branch_deposits_usd

integer

Deposits booked at the branch on the survey date, in US dollars.

Histogram: 0 to 94931569250, 2,898,621; 94931569251 to 189863138500, 138; 189863138501 to 284794707750, 46; 284794707751 to 379726277000, 14; 379726277001 to 474657846250, 8; 474657846251 to 569589415500, 2; 569589415501 to 664520984750, 5; 664520984751 to 759452554000, 2
0759452554000
Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
321,662 · 11.1% of valid
Min
0
25%
16198000
Median
36601000
75%
74452000
Max
759452554000

service_type_code

integer

FDIC branch service type code.

15 distinct values, no chart

Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
15 · 0% of valid
Min
11
25%
11
Median
11
75%
11
Max
30

service_type

string

Branch service type in words, derived from the code.

  • Full service, brick and mortar92%
  • Full service, retail4%
  • Limited service, drive-through3%
Valid
2,898,148 · 100%
Missing
688 · 0%
Missing over timeMissing share of service_type over time, 0% to 0%.
Distinct
12 · 0% of valid

is_main_office

boolean

Whether the row is the bank's main office.

  • false91%
  • true9%
Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

established_on

date

Date the branch was established.

23,943 distinct values, no chart

Valid
908,548 · 31.3%
Missing
1,990,288 · 68.7%
Missing over timeMissing share of established_on over time, 0% to 100%.
Distinct
23,943 · 2.6% of valid

bank_branch_count

integer

Number of offices the bank reported that year, derived.

Histogram: 1 to 823, 2,101,287; 824 to 1646, 220,234; 1647 to 2469, 119,153; 2470 to 3291, 127,222; 3292 to 4114, 32,171; 4115 to 4937, 94,727; 4938 to 5760, 118,008; 5761 to 6582, 86,034
16582
Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
968 · 0% of valid
Min
1
25%
11
Median
101
75%
1041
Max
6582

branch_share_of_county_pct

decimal

The branch's deposits as a percent of all deposits in its county that year, derived.

Histogram: 0 to 12.5, 2,680,923; 12.5 to 25, 130,582; 25 to 37.5, 44,741; 37.5 to 50, 20,225; 50 to 62.5, 9,579; 62.5 to 75, 4,790; 75 to 87.5, 2,184; 87.5 to 100, 5,789
0.0000100.0000
Valid
2,898,813 · 100%
Missing
23 · 0%
Missing over timeMissing share of branch_share_of_county_pct over time, 0% to 0%.
Distinct
271,904 · 9.4% of valid
Min
0.0000
25%
0.1484
Median
0.6650
75%
2.8777
Max
100.0000

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.

Histogram: 0 to 12.5, 1,716,094; 12.5 to 25, 708,420; 25 to 37.5, 278,431; 37.5 to 50, 112,783; 50 to 62.5, 46,862; 62.5 to 75, 18,991; 75 to 87.5, 7,470; 87.5 to 100, 9,762
0.0000100.0000
Valid
2,898,813 · 100%
Missing
23 · 0%
Missing over timeMissing share of bank_share_of_county_pct over time, 0% to 0%.
Distinct
307,102 · 10.6% of valid
Min
0.0000
25%
3.0514
Median
9.3803
75%
19.4267
Max
100.0000

county_deposits_usd

integer

Total deposits of all banks' branches in the county that year, in US dollars, derived.

Histogram: 0 to 238878592500, 2,807,324; 238878592501 to 477757185000, 67,366; 477757185001 to 716635777500, 14,246; 716635777501 to 955514370000, 2,900; 955514370001 to 1194392962500, 3,113; 1194392962501 to 1433271555000, 0; 1433271555001 to 1672150147500, 1,715; 1672150147501 to 1911028740000, 2,172
01911028740000
Valid
2,898,836 · 100%
Missing
0 · 0%
Distinct
100,813 · 3.5% of valid
Min
0
25%
986806000
Median
4725025000
75%
23116437000
Max
1911028740000

Table profile

Profile of the served version, all rows, computed 16 Nov 2026, 18:09 UTC

WarningFreshnessLatest event 136 d before this version
WarningGaps352 empty months, Jul 1994 to May 1995, Jul 1995 to May 1996, Jul 1996 to May 1997 and 29 more
WarningAnomaliesSpike on Jun 2000, 85,492 rows against about 0, and 19 more
PassedUnique keysEvery survey_year · cert · branch_number is unique
Rows per month
Rows per month, 385 buckets from 1 Jun 1994 to 1 Jun 2026, at most 99,550 rows, 352 empty, 20 marked as anomalies.100k1 Jun 1994: 81,297 rows1 Jul 1994: 0 rows1 Aug 1994: 0 rows1 Sept 1994: 0 rows1 Oct 1994: 0 rows1 Nov 1994: 0 rows1 Dec 1994: 0 rows1 Jan 1995: 0 rows1 Feb 1995: 0 rows1 Mar 1995: 0 rows1 Apr 1995: 0 rows1 May 1995: 0 rows1 Jun 1995: 80,999 rows1 Jul 1995: 0 rows1 Aug 1995: 0 rows1 Sept 1995: 0 rows1 Oct 1995: 0 rows1 Nov 1995: 0 rows1 Dec 1995: 0 rows1 Jan 1996: 0 rows1 Feb 1996: 0 rows1 Mar 1996: 0 rows1 Apr 1996: 0 rows1 May 1996: 0 rows1 Jun 1996: 81,375 rows1 Jul 1996: 0 rows1 Aug 1996: 0 rows1 Sept 1996: 0 rows1 Oct 1996: 0 rows1 Nov 1996: 0 rows1 Dec 1996: 0 rows1 Jan 1997: 0 rows1 Feb 1997: 0 rows1 Mar 1997: 0 rows1 Apr 1997: 0 rows1 May 1997: 0 rows1 Jun 1997: 82,109 rows1 Jul 1997: 0 rows1 Aug 1997: 0 rows1 Sept 1997: 0 rows1 Oct 1997: 0 rows1 Nov 1997: 0 rows1 Dec 1997: 0 rows1 Jan 1998: 0 rows1 Feb 1998: 0 rows1 Mar 1998: 0 rows1 Apr 1998: 0 rows1 May 1998: 0 rows1 Jun 1998: 83,314 rows1 Jul 1998: 0 rows1 Aug 1998: 0 rows1 Sept 1998: 0 rows1 Oct 1998: 0 rows1 Nov 1998: 0 rows1 Dec 1998: 0 rows1 Jan 1999: 0 rows1 Feb 1999: 0 rows1 Mar 1999: 0 rows1 Apr 1999: 0 rows1 May 1999: 0 rows1 Jun 1999: 84,312 rows1 Jul 1999: 0 rows1 Aug 1999: 0 rows1 Sept 1999: 0 rows1 Oct 1999: 0 rows1 Nov 1999: 0 rows1 Dec 1999: 0 rows1 Jan 2000: 0 rows1 Feb 2000: 0 rows1 Mar 2000: 0 rows1 Apr 2000: 0 rows1 May 2000: 0 rows1 Jun 2000: 85,492 rows, spike, about 0 expected1 Jul 2000: 0 rows1 Aug 2000: 0 rows1 Sept 2000: 0 rows1 Oct 2000: 0 rows1 Nov 2000: 0 rows1 Dec 2000: 0 rows1 Jan 2001: 0 rows1 Feb 2001: 0 rows1 Mar 2001: 0 rows1 Apr 2001: 0 rows1 May 2001: 0 rows1 Jun 2001: 86,069 rows, spike, about 0 expected1 Jul 2001: 0 rows1 Aug 2001: 0 rows1 Sept 2001: 0 rows1 Oct 2001: 0 rows1 Nov 2001: 0 rows1 Dec 2001: 0 rows1 Jan 2002: 0 rows1 Feb 2002: 0 rows1 Mar 2002: 0 rows1 Apr 2002: 0 rows1 May 2002: 0 rows1 Jun 2002: 86,577 rows, spike, about 0 expected1 Jul 2002: 0 rows1 Aug 2002: 0 rows1 Sept 2002: 0 rows1 Oct 2002: 0 rows1 Nov 2002: 0 rows1 Dec 2002: 0 rows1 Jan 2003: 0 rows1 Feb 2003: 0 rows1 Mar 2003: 0 rows1 Apr 2003: 0 rows1 May 2003: 0 rows1 Jun 2003: 87,785 rows, spike, about 0 expected1 Jul 2003: 0 rows1 Aug 2003: 0 rows1 Sept 2003: 0 rows1 Oct 2003: 0 rows1 Nov 2003: 0 rows1 Dec 2003: 0 rows1 Jan 2004: 0 rows1 Feb 2004: 0 rows1 Mar 2004: 0 rows1 Apr 2004: 0 rows1 May 2004: 0 rows1 Jun 2004: 89,785 rows, spike, about 0 expected1 Jul 2004: 0 rows1 Aug 2004: 0 rows1 Sept 2004: 0 rows1 Oct 2004: 0 rows1 Nov 2004: 0 rows1 Dec 2004: 0 rows1 Jan 2005: 0 rows1 Feb 2005: 0 rows1 Mar 2005: 0 rows1 Apr 2005: 0 rows1 May 2005: 0 rows1 Jun 2005: 92,043 rows, spike, about 0 expected1 Jul 2005: 0 rows1 Aug 2005: 0 rows1 Sept 2005: 0 rows1 Oct 2005: 0 rows1 Nov 2005: 0 rows1 Dec 2005: 0 rows1 Jan 2006: 0 rows1 Feb 2006: 0 rows1 Mar 2006: 0 rows1 Apr 2006: 0 rows1 May 2006: 0 rows1 Jun 2006: 94,752 rows, spike, about 0 expected1 Jul 2006: 0 rows1 Aug 2006: 0 rows1 Sept 2006: 0 rows1 Oct 2006: 0 rows1 Nov 2006: 0 rows1 Dec 2006: 0 rows1 Jan 2007: 0 rows1 Feb 2007: 0 rows1 Mar 2007: 0 rows1 Apr 2007: 0 rows1 May 2007: 0 rows1 Jun 2007: 97,274 rows, spike, about 0 expected1 Jul 2007: 0 rows1 Aug 2007: 0 rows1 Sept 2007: 0 rows1 Oct 2007: 0 rows1 Nov 2007: 0 rows1 Dec 2007: 0 rows1 Jan 2008: 0 rows1 Feb 2008: 0 rows1 Mar 2008: 0 rows1 Apr 2008: 0 rows1 May 2008: 0 rows1 Jun 2008: 99,163 rows, spike, about 0 expected1 Jul 2008: 0 rows1 Aug 2008: 0 rows1 Sept 2008: 0 rows1 Oct 2008: 0 rows1 Nov 2008: 0 rows1 Dec 2008: 0 rows1 Jan 2009: 0 rows1 Feb 2009: 0 rows1 Mar 2009: 0 rows1 Apr 2009: 0 rows1 May 2009: 0 rows1 Jun 2009: 99,550 rows, spike, about 0 expected1 Jul 2009: 0 rows1 Aug 2009: 0 rows1 Sept 2009: 0 rows1 Oct 2009: 0 rows1 Nov 2009: 0 rows1 Dec 2009: 0 rows1 Jan 2010: 0 rows1 Feb 2010: 0 rows1 Mar 2010: 0 rows1 Apr 2010: 0 rows1 May 2010: 0 rows1 Jun 2010: 98,520 rows, spike, about 0 expected1 Jul 2010: 0 rows1 Aug 2010: 0 rows1 Sept 2010: 0 rows1 Oct 2010: 0 rows1 Nov 2010: 0 rows1 Dec 2010: 0 rows1 Jan 2011: 0 rows1 Feb 2011: 0 rows1 Mar 2011: 0 rows1 Apr 2011: 0 rows1 May 2011: 0 rows1 Jun 2011: 98,194 rows, spike, about 0 expected1 Jul 2011: 0 rows1 Aug 2011: 0 rows1 Sept 2011: 0 rows1 Oct 2011: 0 rows1 Nov 2011: 0 rows1 Dec 2011: 0 rows1 Jan 2012: 0 rows1 Feb 2012: 0 rows1 Mar 2012: 0 rows1 Apr 2012: 0 rows1 May 2012: 0 rows1 Jun 2012: 97,341 rows, spike, about 0 expected1 Jul 2012: 0 rows1 Aug 2012: 0 rows1 Sept 2012: 0 rows1 Oct 2012: 0 rows1 Nov 2012: 0 rows1 Dec 2012: 0 rows1 Jan 2013: 0 rows1 Feb 2013: 0 rows1 Mar 2013: 0 rows1 Apr 2013: 0 rows1 May 2013: 0 rows1 Jun 2013: 96,340 rows, spike, about 0 expected1 Jul 2013: 0 rows1 Aug 2013: 0 rows1 Sept 2013: 0 rows1 Oct 2013: 0 rows1 Nov 2013: 0 rows1 Dec 2013: 0 rows1 Jan 2014: 0 rows1 Feb 2014: 0 rows1 Mar 2014: 0 rows1 Apr 2014: 0 rows1 May 2014: 0 rows1 Jun 2014: 94,725 rows, spike, about 0 expected1 Jul 2014: 0 rows1 Aug 2014: 0 rows1 Sept 2014: 0 rows1 Oct 2014: 0 rows1 Nov 2014: 0 rows1 Dec 2014: 0 rows1 Jan 2015: 0 rows1 Feb 2015: 0 rows1 Mar 2015: 0 rows1 Apr 2015: 0 rows1 May 2015: 0 rows1 Jun 2015: 93,272 rows, spike, about 0 expected1 Jul 2015: 0 rows1 Aug 2015: 0 rows1 Sept 2015: 0 rows1 Oct 2015: 0 rows1 Nov 2015: 0 rows1 Dec 2015: 0 rows1 Jan 2016: 0 rows1 Feb 2016: 0 rows1 Mar 2016: 0 rows1 Apr 2016: 0 rows1 May 2016: 0 rows1 Jun 2016: 91,834 rows, spike, about 0 expected1 Jul 2016: 0 rows1 Aug 2016: 0 rows1 Sept 2016: 0 rows1 Oct 2016: 0 rows1 Nov 2016: 0 rows1 Dec 2016: 0 rows1 Jan 2017: 0 rows1 Feb 2017: 0 rows1 Mar 2017: 0 rows1 Apr 2017: 0 rows1 May 2017: 0 rows1 Jun 2017: 89,849 rows, spike, about 0 expected1 Jul 2017: 0 rows1 Aug 2017: 0 rows1 Sept 2017: 0 rows1 Oct 2017: 0 rows1 Nov 2017: 0 rows1 Dec 2017: 0 rows1 Jan 2018: 0 rows1 Feb 2018: 0 rows1 Mar 2018: 0 rows1 Apr 2018: 0 rows1 May 2018: 0 rows1 Jun 2018: 88,075 rows, spike, about 0 expected1 Jul 2018: 0 rows1 Aug 2018: 0 rows1 Sept 2018: 0 rows1 Oct 2018: 0 rows1 Nov 2018: 0 rows1 Dec 2018: 0 rows1 Jan 2019: 0 rows1 Feb 2019: 0 rows1 Mar 2019: 0 rows1 Apr 2019: 0 rows1 May 2019: 0 rows1 Jun 2019: 86,392 rows, spike, about 0 expected1 Jul 2019: 0 rows1 Aug 2019: 0 rows1 Sept 2019: 0 rows1 Oct 2019: 0 rows1 Nov 2019: 0 rows1 Dec 2019: 0 rows1 Jan 2020: 0 rows1 Feb 2020: 0 rows1 Mar 2020: 0 rows1 Apr 2020: 0 rows1 May 2020: 0 rows1 Jun 2020: 84,982 rows1 Jul 2020: 0 rows1 Aug 2020: 0 rows1 Sept 2020: 0 rows1 Oct 2020: 0 rows1 Nov 2020: 0 rows1 Dec 2020: 0 rows1 Jan 2021: 0 rows1 Feb 2021: 0 rows1 Mar 2021: 0 rows1 Apr 2021: 0 rows1 May 2021: 0 rows1 Jun 2021: 81,791 rows1 Jul 2021: 0 rows1 Aug 2021: 0 rows1 Sept 2021: 0 rows1 Oct 2021: 0 rows1 Nov 2021: 0 rows1 Dec 2021: 0 rows1 Jan 2022: 0 rows1 Feb 2022: 0 rows1 Mar 2022: 0 rows1 Apr 2022: 0 rows1 May 2022: 0 rows1 Jun 2022: 79,172 rows1 Jul 2022: 0 rows1 Aug 2022: 0 rows1 Sept 2022: 0 rows1 Oct 2022: 0 rows1 Nov 2022: 0 rows1 Dec 2022: 0 rows1 Jan 2023: 0 rows1 Feb 2023: 0 rows1 Mar 2023: 0 rows1 Apr 2023: 0 rows1 May 2023: 0 rows1 Jun 2023: 77,770 rows1 Jul 2023: 0 rows1 Aug 2023: 0 rows1 Sept 2023: 0 rows1 Oct 2023: 0 rows1 Nov 2023: 0 rows1 Dec 2023: 0 rows1 Jan 2024: 0 rows1 Feb 2024: 0 rows1 Mar 2024: 0 rows1 Apr 2024: 0 rows1 May 2024: 0 rows1 Jun 2024: 76,727 rows1 Jul 2024: 0 rows1 Aug 2024: 0 rows1 Sept 2024: 0 rows1 Oct 2024: 0 rows1 Nov 2024: 0 rows1 Dec 2024: 0 rows1 Jan 2025: 0 rows1 Feb 2025: 0 rows1 Mar 2025: 0 rows1 Apr 2025: 0 rows1 May 2025: 0 rows1 Jun 2025: 76,097 rows1 Jul 2025: 0 rows1 Aug 2025: 0 rows1 Sept 2025: 0 rows1 Oct 2025: 0 rows1 Nov 2025: 0 rows1 Dec 2025: 0 rows1 Jan 2026: 0 rows1 Feb 2026: 0 rows1 Mar 2026: 0 rows1 Apr 2026: 0 rows1 May 2026: 0 rows1 Jun 2026: 75,859 rows1996199820002002200420062008201020122014201620182020202220242026

Support

Talk to Mostly Right

Loading chat…