Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

323 MB across 170 parts, newest sealed 12 November 2026 at 23:46 UTC. The first build wrote 170 parts and 1.7M rows.

All 3 checks passed.
  • One row per bank quarter passed.
  • Rows present passed.
  • Assets mostly present passed.

cert

integer

FDIC certificate number, the stable identifier of one insured bank.

24,064 distinct values, no chart

Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
24,064 · 1.4% of valid
Min
8
25%
8943
Median
16976
75%
27476
Max
91393

report_date

date

Quarter-end date the call report covers.

170 distinct values, no chart

Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
170 · 0% of valid

bank_name

string

Bank name as reported that quarter.

30,302 distinct values, no chart

Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
30,302 · 1.8% of valid

city

string

Headquarters city as reported that quarter.

  • CHICAGO1%
  • HOUSTON1%
  • LOS ANGELES1%
  • Other (7,375)
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
7,387 · 0.4% of valid

state

string

Two-letter headquarters state as reported that quarter.

  • TX9%
  • IL8%
  • MN5%
  • Other (44)
Valid
1,682,425 · 100%
Missing
191 · 0%
Missing over timeMissing share of state over time, 0% to 0%.
Distinct
56 · 0% of valid

state_name

string

Headquarters state name from the bank's current FDIC profile.

56 distinct values, no chart

Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of state_name over time, 0% to 1%.
Distinct
56 · 0% of valid

county

string

Headquarters county from the bank's current FDIC profile.

1,719 distinct values, no chart

Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of county over time, 0% to 1%.
Distinct
1,719 · 0.1% of valid

zip_code

string

Headquarters ZIP code from the bank's current FDIC profile.

11,465 distinct values, no chart

Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of zip_code over time, 0% to 1%.
Distinct
11,465 · 0.7% of valid

metro_area

string

Core-based statistical area of the headquarters, from the current FDIC profile.

  • Chicago-Naperville-Elgin, IL-IN-WI4%
  • New York-Newark-Jersey City, NY-NJ-PA3%
  • Dallas-Fort Worth-Arlington, TX2%
  • Other (902)
Valid
1,280,697 · 76.1%
Missing
401,919 · 23.9%
Missing over timeMissing share of metro_area over time, 21% to 29%.
Distinct
914 · 0.1% of valid

latitude

decimal

Headquarters latitude in degrees, from the current FDIC profile.

20,662 distinct values, no chart

Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of latitude over time, 0% to 1%.
Distinct
20,662 · 1.2% of valid
Min
-14.251760
25%
34.099953
Median
39.046189
75%
41.766080
Max
64.849087

longitude

decimal

Headquarters longitude in degrees, from the current FDIC profile.

20,657 distinct values, no chart

Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of longitude over time, 0% to 1%.
Distinct
20,657 · 1.2% of valid
Min
-170.674138
25%
-96.482344
Median
-89.926719
75%
-82.718456
Max
158.205600

primary_regulator

string

Primary federal regulator: OCC, FDIC or FED, from the current FDIC profile.

  • FDIC56%
  • OCC24%
  • FED14%
Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of primary_regulator over time, 0% to 1%.
Distinct
5 · 0% of valid

charter_class

string

FDIC charter class code as reported that quarter.

8 distinct values, no chart

Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
8 · 0% of valid

charter_class_name

string

Charter class in words, derived from the code.

  • State bank, not a Federal Reserve member51%
  • National bank22%
  • State bank, Federal Reserve member9%
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
8 · 0% of valid

specialization

string

FDIC asset-concentration group that quarter, such as agricultural, credit card or commercial lending.

  • Commercial lending38%
  • Agricultural21%
  • All other under $1 billion18%
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
9 · 0% of valid

size_tier

string

Asset size band that quarter, derived from total assets.

  • Under $100 million54%
  • $100 million to $1 billion39%
  • $1 billion to $10 billion6%
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
5 · 0% of valid

holding_company_name

string

Regulatory top holding company name, when the bank has one.

13,249 distinct values, no chart

Valid
1,107,773 · 65.8%
Missing
574,843 · 34.2%
Missing over timeMissing share of holding_company_name over time, 17% to 53%.
Distinct
13,249 · 1.2% of valid

holding_company_rssd_id

string

Federal Reserve RSSD identifier of the top holding company.

13,372 distinct values, no chart

Valid
1,107,773 · 65.8%
Missing
574,843 · 34.2%
Missing over timeMissing share of holding_company_rssd_id over time, 17% to 53%.
Distinct
13,372 · 1.2% of valid

rssd_id

string

Federal Reserve RSSD identifier of the bank.

23,484 distinct values, no chart

Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
23,484 · 1.4% of valid

website

string

Bank website from the current FDIC profile.

4,115 distinct values, no chart

Valid
650,503 · 38.7%
Missing
1,032,113 · 61.3%
Missing over timeMissing share of website over time, 4% to 82%.
Distinct
4,115 · 0.6% of valid

established_on

date

Date the bank was established.

11,687 distinct values, no chart

Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of established_on over time, 0% to 1%.
Distinct
11,687 · 0.7% of valid

closed_on

date

Date the bank stopped operating under this certificate, by failure, merger or closure. Null while active.

6,224 distinct values, no chart

Valid
1,009,541 · 60%
Missing
673,075 · 40%
Missing over timeMissing share of closed_on over time, 19% to 99%.
Distinct
6,224 · 0.6% of valid

is_active_today

boolean

Whether the bank is active in the current FDIC profile, not as of the report date.

  • false61%
  • true39%
Valid
1,671,620 · 99.3%
Missing
10,996 · 0.7%
Missing over timeMissing share of is_active_today over time, 0% to 1%.
Distinct
2 · 0% of valid

employees

integer

Full-time equivalent employees.

Histogram: 0 to 30029, 1,601,593; 30030 to 60058, 523; 60059 to 90087, 181; 90088 to 120116, 20; 120117 to 150145, 102; 150146 to 180174, 101; 180175 to 210203, 104; 210204 to 240232, 68
0240232
Valid
1,602,692 · 95.3%
Missing
79,924 · 4.7%
Missing over timeMissing share of employees over time, 0% to 18%.
Distinct
10,649 · 0.7% of valid
Min
0
25%
16
Median
32
75%
73
Max
240232

domestic_offices

integer

Number of domestic offices.

Histogram: 0 to 841, 1,681,153; 842 to 1682, 783; 1683 to 2523, 249; 2524 to 3364, 169; 3365 to 4206, 36; 4207 to 5047, 88; 5048 to 5888, 87; 5889 to 6729, 47
06729
Valid
1,682,612 · 100%
Missing
4 · 0%
Missing over timeMissing share of domestic_offices over time, 0% to 0%.
Distinct
1,845 · 0.1% of valid
Min
0
25%
1
Median
2
75%
5
Max
6729

total_assets_usd

integer

Total assets. US dollars.

Histogram: 1000 to 511414375875, 1,682,146; 511414375876 to 1022828750750, 159; 1022828750751 to 1534243125625, 120; 1534243125626 to 2045657500500, 123; 2045657500501 to 2557071875375, 34; 2557071875376 to 3068486250250, 12; 3068486250251 to 3579900625125, 15; 3579900625126 to 4091315000000, 7
10004091315000000
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
554,409 · 32.9% of valid
Min
1000
25%
36849000
Median
86130000
75%
227729000
Max
4091315000000

total_deposits_usd

integer

Total deposits, domestic and foreign offices. US dollars.

Histogram: 0 to 352535500000, 1,682,117; 352535500001 to 705071000000, 200; 705071000001 to 1057606500000, 95; 1057606500001 to 1410142000000, 101; 1410142000001 to 1762677500000, 51; 1762677500001 to 2115213000000, 24; 2115213000001 to 2467748500000, 9; 2467748500001 to 2820284000000, 18
02820284000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of total_deposits_usd over time, 0% to 0%.
Distinct
508,620 · 30.2% of valid
Min
0
25%
31461000
Median
73045000
75%
189880000
Max
2820284000000

domestic_deposits_usd

integer

Deposits held in domestic offices. US dollars.

Histogram: 0 to 278348750000, 1,682,081; 278348750001 to 556697500000, 285; 556697500001 to 835046250000, 69; 835046250001 to 1113395000000, 45; 1113395000001 to 1391743750000, 59; 1391743750001 to 1670092500000, 26; 1670092500001 to 1948441250000, 20; 1948441250001 to 2226790000000, 30
02226790000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of domestic_deposits_usd over time, 0% to 0%.
Distinct
507,847 · 30.2% of valid
Min
0
25%
31433000
Median
72949000
75%
189454000
Max
2226790000000

insured_deposits_usd

integer

Estimated FDIC-insured deposits. US dollars.

Histogram: -146531000 to 155539660375, 1,663,484; 155539660376 to 311225851750, 381; 311225851751 to 466912043125, 32; 466912043126 to 622598234500, 46; 622598234501 to 778284425875, 62; 778284425876 to 933970617250, 39; 933970617251 to 1089656808625, 22; 1089656808626 to 1245343000000, 20
-1465310001245343000000
Valid
1,664,086 · 98.9%
Missing
18,530 · 1.1%
Missing over timeMissing share of insured_deposits_usd over time, 0% to 21%.
Distinct
442,180 · 26.6% of valid
Min
-146531000
25%
27938000
Median
62671000
75%
155516000
Max
1245343000000

uninsured_deposits_usd

integer

Estimated uninsured deposits in domestic offices. US dollars.

Histogram: 0 to 174064250000, 1,040,484; 174064250001 to 348128500000, 192; 348128500001 to 522192750000, 36; 522192750001 to 696257000000, 84; 696257000001 to 870321250000, 52; 870321250001 to 1044385500000, 10; 1044385500001 to 1218449750000, 16; 1218449750001 to 1392514000000, 7
01392514000000
Valid
1,040,881 · 61.9%
Missing
641,735 · 38.1%
Missing over timeMissing share of uninsured_deposits_usd over time, 0% to 100%.
Distinct
130,599 · 12.5% of valid
Min
0
25%
0
Median
0
75%
118000
Max
1392514000000

brokered_deposits_usd

integer

Brokered deposits. US dollars.

Histogram: 0 to 18938625000, 1,665,074; 18938625001 to 37877250000, 365; 37877250001 to 56815875000, 192; 56815875001 to 75754500000, 119; 75754500001 to 94693125000, 49; 94693125001 to 113631750000, 31; 113631750001 to 132570375000, 19; 132570375001 to 151509000000, 6
0151509000000
Valid
1,665,855 · 99%
Missing
16,761 · 1%
Missing over timeMissing share of brokered_deposits_usd over time, 0% to 18%.
Distinct
98,385 · 5.9% of valid
Min
0
25%
0
Median
0
75%
0
Max
151509000000

core_deposits_usd

integer

Core deposits, the stable retail funding base. US dollars.

Histogram: -58457000 to 260505350125, 1,680,770; 260505350126 to 521069157250, 278; 521069157251 to 781632964375, 57; 781632964376 to 1042196771500, 49; 1042196771501 to 1302760578625, 59; 1302760578626 to 1563324385750, 24; 1563324385751 to 1823888192875, 20; 1823888192876 to 2084452000000, 30
-584570002084452000000
Valid
1,681,287 · 99.9%
Missing
1,329 · 0.1%
Missing over timeMissing share of core_deposits_usd over time, 0% to 0%.
Distinct
476,416 · 28.3% of valid
Min
-58457000
25%
27424000
Median
63249000
75%
164596000
Max
2084452000000

total_equity_usd

integer

Total equity capital. US dollars.

Histogram: -4565197000 to 38706702625, 1,677,851; 38706702626 to 81978602250, 300; 81978602251 to 125250501875, 53; 125250501876 to 168522401500, 126; 168522401501 to 211794301125, 76; 211794301126 to 255066200750, 37; 255066200751 to 298338100375, 8; 298338100376 to 341610000000, 17
-4565197000341610000000
Valid
1,678,468 · 99.8%
Missing
4,148 · 0.2%
Missing over timeMissing share of total_equity_usd over time, 0% to 0%.
Distinct
196,525 · 11.7% of valid
Min
-4565197000
25%
3341000
Median
8001000
75%
21450000
Max
341610000000

net_loans_usd

integer

Loans and leases net of allowance and unearned income. US dollars.

Histogram: -62969000 to 191899277125, 1,682,020; 191899277126 to 383861523250, 263; 383861523251 to 575823769375, 64; 575823769376 to 767786015500, 127; 767786015501 to 959748261625, 91; 959748261626 to 1151710507750, 34; 1151710507751 to 1343672753875, 11; 1343672753876 to 1535635000000, 5
-629690001535635000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of net_loans_usd over time, 0% to 0%.
Distinct
451,741 · 26.8% of valid
Min
-62969000
25%
18806000
Median
49418000
75%
141985000
Max
1535635000000

gross_loans_usd

integer

Loans and leases before the loss allowance. US dollars.

Histogram: -61697000 to 195143140125, 1,682,019; 195143140126 to 390347977250, 264; 390347977251 to 585552814375, 57; 585552814376 to 780757651500, 134; 780757651501 to 975962488625, 90; 975962488626 to 1171167325750, 35; 1171167325751 to 1366372162875, 10; 1366372162876 to 1561577000000, 6
-616970001561577000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of gross_loans_usd over time, 0% to 0%.
Distinct
454,729 · 27% of valid
Min
-61697000
25%
19108000
Median
50129000
75%
143973000
Max
1561577000000

real_estate_loans_usd

integer

All loans secured by real estate. US dollars.

Histogram: -354000 to 64220690250, 1,681,755; 64220690251 to 128441734500, 414; 128441734501 to 192662778750, 161; 192662778751 to 256883823000, 54; 256883823001 to 321104867250, 45; 321104867251 to 385325911500, 81; 385325911501 to 449546955750, 57; 449546955751 to 513768000000, 48
-354000513768000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of real_estate_loans_usd over time, 0% to 0%.
Distinct
391,796 · 23.3% of valid
Min
-354000
25%
8881000
Median
30692000
75%
101743000
Max
513768000000

construction_loans_usd

integer

Construction and land development loans. US dollars.

Histogram: -354000 to 4982796125, 1,678,723; 4982796126 to 9965946250, 660; 9965946251 to 14949096375, 152; 14949096376 to 19932246500, 80; 19932246501 to 24915396625, 58; 24915396626 to 29898546750, 7; 29898546751 to 34881696875, 5; 34881696876 to 39864847000, 5
-35400039864847000
Valid
1,679,690 · 99.8%
Missing
2,926 · 0.2%
Missing over timeMissing share of construction_loans_usd over time, 0% to 0%.
Distinct
139,388 · 8.3% of valid
Min
-354000
25%
79000
Median
1173000
75%
7626000
Max
39864847000

commercial_real_estate_loans_usd

integer

Loans secured by nonfarm nonresidential property. US dollars.

Histogram: -520003000 to 12611872375, 1,678,590; 12611872376 to 25743747750, 739; 25743747751 to 38875623125, 143; 38875623126 to 52007498500, 97; 52007498501 to 65139373875, 55; 65139373876 to 78271249250, 0; 78271249251 to 91403124625, 24; 91403124626 to 104535000000, 42
-520003000104535000000
Valid
1,679,690 · 99.8%
Missing
2,926 · 0.2%
Missing over timeMissing share of commercial_real_estate_loans_usd over time, 0% to 0%.
Distinct
233,037 · 13.9% of valid
Min
-520003000
25%
1215000
Median
6054000
75%
27617000
Max
104535000000

multifamily_loans_usd

integer

Loans secured by multifamily residential property. US dollars.

Histogram: -62774000 to 13359697750, 1,679,410; 13359697751 to 26782169500, 166; 26782169501 to 40204641250, 61; 40204641251 to 53627113000, 8; 53627113001 to 67049584750, 7; 67049584751 to 80472056500, 25; 80472056501 to 93894528250, 0; 93894528251 to 107317000000, 13
-62774000107317000000
Valid
1,679,690 · 99.8%
Missing
2,926 · 0.2%
Missing over timeMissing share of multifamily_loans_usd over time, 0% to 0%.
Distinct
102,681 · 6.1% of valid
Min
-62774000
25%
0
Median
276000
75%
2609000
Max
107317000000

residential_mortgage_loans_usd

integer

Loans secured by one to four family homes. US dollars.

Histogram: -38500000 to 47604495125, 1,678,948; 47604495126 to 95247490250, 312; 95247490251 to 142890485375, 140; 142890485376 to 190533480500, 49; 190533480501 to 238176475625, 48; 238176475626 to 285819470750, 100; 285819470751 to 333462465875, 71; 333462465876 to 381105461000, 21
-38500000381105461000
Valid
1,679,689 · 99.8%
Missing
2,927 · 0.2%
Missing over timeMissing share of residential_mortgage_loans_usd over time, 0% to 0%.
Distinct
268,064 · 16% of valid
Min
-38500000
25%
3844000
Median
13882000
75%
45643000
Max
381105461000

farmland_loans_usd

integer

Loans secured by farmland. US dollars.

Histogram: 0 to 383000000, 1,487,416; 383000001 to 766000000, 1,216; 766000001 to 1149000000, 262; 1149000001 to 1532000000, 83; 1532000001 to 1915000000, 45; 1915000001 to 2298000000, 39; 2298000001 to 2681000000, 47; 2681000001 to 3064000000, 19
03064000000
Valid
1,489,127 · 88.5%
Missing
193,489 · 11.5%
Missing over timeMissing share of farmland_loans_usd over time, 0% to 21%.
Distinct
71,929 · 4.8% of valid
Min
0
25%
18000
Median
737000
75%
3537000
Max
3064000000

commercial_industrial_loans_usd

integer

Commercial and industrial loans. US dollars.

Histogram: -833000 to 44205896125, 1,681,932; 44205896126 to 88412625250, 291; 88412625251 to 132619354375, 144; 132619354376 to 176826083500, 126; 176826083501 to 221032812625, 72; 221032812626 to 265239541750, 14; 265239541751 to 309446270875, 21; 309446270876 to 353653000000, 15
-833000353653000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of commercial_industrial_loans_usd over time, 0% to 0%.
Distinct
178,759 · 10.6% of valid
Min
-833000
25%
1426000
Median
5238000
75%
17044000
Max
353653000000

consumer_loans_usd

integer

Loans to individuals, including credit cards. US dollars.

Histogram: 0 to 43639301000, 1,677,863; 43639301001 to 87278602000, 400; 87278602001 to 130917903000, 246; 130917903001 to 174557204000, 94; 174557204001 to 218196505000, 47; 218196505001 to 261835806000, 10; 261835806001 to 305475107000, 11; 305475107001 to 349114408000, 5
0349114408000
Valid
1,678,676 · 99.8%
Missing
3,940 · 0.2%
Missing over timeMissing share of consumer_loans_usd over time, 0% to 0%.
Distinct
131,096 · 7.8% of valid
Min
0
25%
1389000
Median
3621000
75%
9188000
Max
349114408000

credit_card_loans_usd

integer

Credit card loans. US dollars.

Histogram: 0 to 32001901875, 1,675,620; 32001901876 to 64003803750, 213; 64003803751 to 96005705625, 164; 96005705626 to 128007607500, 83; 128007607501 to 160009509375, 69; 160009509376 to 192011411250, 18; 192011411251 to 224013313125, 7; 224013313126 to 256015215000, 5
0256015215000
Valid
1,676,179 · 99.6%
Missing
6,437 · 0.4%
Missing over timeMissing share of credit_card_loans_usd over time, 0% to 2%.
Distinct
46,972 · 2.8% of valid
Min
0
25%
0
Median
0
75%
118000
Max
256015215000

farm_loans_usd

integer

Loans to finance agricultural production. US dollars.

Histogram: 0 to 813500000, 1,487,238; 813500001 to 1627000000, 361; 1627000001 to 2440500000, 145; 2440500001 to 3254000000, 69; 3254000001 to 4067500000, 34; 4067500001 to 4881000000, 27; 4881000001 to 5694500000, 21; 5694500001 to 6508000000, 10
06508000000
Valid
1,487,905 · 88.4%
Missing
194,711 · 11.6%
Missing over timeMissing share of farm_loans_usd over time, 0% to 21%.
Distinct
65,741 · 4.4% of valid
Min
0
25%
0
Median
685000
75%
3894000
Max
6508000000

securities_usd

integer

Total securities. US dollars.

Histogram: -965382000 to 116877540750, 1,682,124; 116877540751 to 234720463500, 225; 234720463501 to 352563386250, 121; 352563386251 to 470406309000, 91; 470406309001 to 588249231750, 12; 588249231751 to 706092154500, 15; 706092154501 to 823935077250, 9; 823935077251 to 941778000000, 18
-965382000941778000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of securities_usd over time, 0% to 0%.
Distinct
269,919 · 16% of valid
Min
-965382000
25%
6954000
Median
18252000
75%
48488000
Max
941778000000

held_to_maturity_securities_usd

integer

Securities held to maturity, at amortized cost. US dollars.

Histogram: -1532625000 to 84040703125, 1,028,790; 84040703126 to 169614031250, 81; 169614031251 to 255187359375, 37; 255187359376 to 340760687500, 29; 340760687501 to 426334015625, 9; 426334015626 to 511907343750, 4; 511907343751 to 597480671875, 11; 597480671876 to 683054000000, 10
-1532625000683054000000
Valid
1,028,971 · 61.2%
Missing
653,645 · 38.8%
Missing over timeMissing share of held_to_maturity_securities_usd over time, 0% to 100%.
Distinct
102,965 · 10% of valid
Min
-1532625000
25%
0
Median
40000
75%
6466000
Max
683054000000

available_for_sale_securities_usd

integer

Securities available for sale, at fair value. US dollars.

Histogram: 0 to 69022000000, 954,080; 69022000001 to 138044000000, 314; 138044000001 to 207066000000, 88; 207066000001 to 276088000000, 144; 276088000001 to 345110000000, 73; 345110000001 to 414132000000, 16; 414132000001 to 483154000000, 1; 483154000001 to 552176000000, 5
0552176000000
Valid
954,721 · 56.7%
Missing
727,895 · 43.3%
Missing over timeMissing share of available_for_sale_securities_usd over time, 0% to 100%.
Distinct
211,195 · 22.1% of valid
Min
0
25%
5500000
Median
18574000
75%
54014000
Max
552176000000

cash_and_bank_balances_usd

integer

Cash and balances due from depository institutions. US dollars.

Histogram: -178000 to 95032219250, 1,682,262; 95032219251 to 190064616500, 204; 190064616501 to 285097013750, 72; 285097013751 to 380129411000, 39; 380129411001 to 475161808250, 16; 475161808251 to 570194205500, 14; 570194205501 to 665226602750, 2; 665226602751 to 760259000000, 6
-178000760259000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over timeMissing share of cash_and_bank_balances_usd over time, 0% to 0%.
Distinct
148,377 · 8.8% of valid
Min
-178000
25%
1769000
Median
4294000
75%
12133000
Max
760259000000

foreclosed_real_estate_usd

integer

Other real estate owned, mostly foreclosed property. US dollars.

Histogram: -37906000 to 691082250, 1,678,074; 691082251 to 1420070500, 244; 1420070501 to 2149058750, 77; 2149058751 to 2878047000, 27; 2878047001 to 3607035250, 21; 3607035251 to 4336023500, 16; 4336023501 to 5065011750, 5; 5065011751 to 5794000000, 3
-379060005794000000
Valid
1,678,467 · 99.8%
Missing
4,149 · 0.2%
Missing over timeMissing share of foreclosed_real_estate_usd over time, 0% to 0%.
Distinct
37,677 · 2.2% of valid
Min
-37906000
25%
0
Median
52000
75%
410000
Max
5794000000

noncurrent_loans_usd

integer

Loans 90 or more days past due or on nonaccrual. US dollars.

Histogram: -17196000 to 8224316625, 1,679,855; 8224316626 to 16465829250, 144; 16465829251 to 24707341875, 41; 24707341876 to 32948854500, 22; 32948854501 to 41190367125, 18; 41190367126 to 49431879750, 18; 49431879751 to 57673392375, 10; 57673392376 to 65914905000, 9
-1719600065914905000
Valid
1,680,117 · 99.9%
Missing
2,499 · 0.1%
Missing over timeMissing share of noncurrent_loans_usd over time, 0% to 2%.
Distinct
66,952 · 4% of valid
Min
-17196000
25%
106000
Median
468000
75%
1648000
Max
65914905000

past_due_30_89_days_usd

integer

Assets 30 to 89 days past due. US dollars.

Histogram: 0 to 2232875000, 710,132; 2232875001 to 4465750000, 281; 4465750001 to 6698625000, 117; 6698625001 to 8931500000, 72; 8931500001 to 11164375000, 50; 11164375001 to 13397250000, 22; 13397250001 to 15630125000, 10; 15630125001 to 17863000000, 7
017863000000
Valid
710,691 · 42.2%
Missing
971,925 · 57.8%
Missing over timeMissing share of past_due_30_89_days_usd over time, 0% to 100%.
Distinct
37,035 · 5.2% of valid
Min
0
25%
176000
Median
699000
75%
2042000
Max
17863000000

interest_income_ytd_usd

integer

Total interest income, year to date. US dollars.

Histogram: -6563000 to 21233132375, 1,677,629; 21233132376 to 42472827750, 192; 42472827751 to 63712523125, 74; 63712523126 to 84952218500, 17; 84952218501 to 106191913875, 5; 106191913876 to 127431609250, 3; 127431609251 to 148671304625, 1; 148671304626 to 169911000000, 3
-6563000169911000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over timeMissing share of interest_income_ytd_usd over time, 0% to 1%.
Distinct
116,774 · 7% of valid
Min
-6563000
25%
1333000
Median
3193000
75%
8198000
Max
169911000000

interest_expense_ytd_usd

integer

Total interest expense, year to date. US dollars.

Histogram: -159000000 to 9210500000, 1,675,988; 9210500001 to 18580000000, 133; 18580000001 to 27949500000, 30; 27949500001 to 37319000000, 14; 37319000001 to 46688500000, 7; 46688500001 to 56058000000, 3; 56058000001 to 65427500000, 2; 65427500001 to 74797000000, 2
-15900000074797000000
Valid
1,676,179 · 99.6%
Missing
6,437 · 0.4%
Missing over timeMissing share of interest_expense_ytd_usd over time, 0% to 2%.
Distinct
77,599 · 4.6% of valid
Min
-159000000
25%
464000
Median
1189000
75%
3174000
Max
74797000000

net_interest_income_ytd_usd

integer

Net interest income, year to date. US dollars.

Histogram: -466461000 to 11822596625, 1,677,572; 11822596626 to 24111654250, 182; 24111654251 to 36400711875, 93; 36400711876 to 48689769500, 55; 48689769501 to 60978827125, 15; 60978827126 to 73267884750, 4; 73267884751 to 85556942375, 0; 85556942376 to 97846000000, 3
-46646100097846000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over timeMissing share of net_interest_income_ytd_usd over time, 0% to 1%.
Distinct
94,123 · 5.6% of valid
Min
-466461000
25%
676000
Median
1712000
75%
4660000
Max
97846000000

noninterest_income_ytd_usd

integer

Noninterest income, year to date. US dollars.

Histogram: -1815900000 to 6691087500, 1,677,453; 6691087501 to 15198075000, 299; 15198075001 to 23705062500, 93; 23705062501 to 32212050000, 51; 32212050001 to 40719037500, 14; 40719037501 to 49226025000, 7; 49226025001 to 57733012500, 5; 57733012501 to 66240000000, 2
-181590000066240000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over timeMissing share of noninterest_income_ytd_usd over time, 0% to 1%.
Distinct
62,000 · 3.7% of valid
Min
-1815900000
25%
90000
Median
269000
75%
903000
Max
66240000000

noninterest_expense_ytd_usd

integer

Noninterest expense, year to date. US dollars.

Histogram: -172742000 to 10614850750, 1,677,529; 10614850751 to 21402443500, 200; 21402443501 to 32190036250, 99; 32190036251 to 42977629000, 59; 42977629001 to 53765221750, 26; 53765221751 to 64552814500, 5; 64552814501 to 75340407250, 3; 75340407251 to 86128000000, 3
-17274200086128000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over timeMissing share of noninterest_expense_ytd_usd over time, 0% to 1%.
Distinct
86,451 · 5.2% of valid
Min
-172742000
25%
570000
Median
1418000
75%
3906000
Max
86128000000

loan_loss_provision_ytd_usd

integer

Provision for credit losses, year to date. US dollars.

Histogram: -9296000000 to -4459588500, 4; -4459588499 to 376823000, 1,637,284; 376823001 to 5213234500, 2,031; 5213234501 to 10049646000, 86; 10049646001 to 14886057500, 30; 14886057501 to 19722469000, 8; 19722469001 to 24558880500, 6; 24558880501 to 29395292000, 1
-929600000029395292000
Valid
1,639,450 · 97.4%
Missing
43,166 · 2.6%
Missing over timeMissing share of loan_loss_provision_ytd_usd over time, 0% to 18%.
Distinct
35,965 · 2.2% of valid
Min
-9296000000
25%
3000
Median
58000
75%
247000
Max
29395292000

net_charge_offs_ytd_usd

integer

Loan charge-offs net of recoveries, year to date. US dollars.

Histogram: -179647000 to 2343683875, 1,602,356; 2343683876 to 4867014750, 230; 4867014751 to 7390345625, 56; 7390345626 to 9913676500, 25; 9913676501 to 12437007375, 14; 12437007376 to 14960338250, 10; 14960338251 to 17483669125, 3; 17483669126 to 20007000000, 4
-17964700020007000000
Valid
1,602,698 · 95.3%
Missing
79,918 · 4.7%
Missing over timeMissing share of net_charge_offs_ytd_usd over time, 0% to 18%.
Distinct
33,270 · 2.1% of valid
Min
-179647000
25%
0
Median
21000
75%
149000
Max
20007000000

net_income_ytd_usd

integer

Net income, year to date. US dollars.

Histogram: -24593679000 to -14956719125, 3; -14956719124 to -5319759250, 3; -5319759249 to 4317200625, 1,677,540; 4317200626 to 13954160500, 289; 13954160501 to 23591120375, 63; 23591120376 to 33228080250, 18; 33228080251 to 42865040125, 5; 42865040126 to 52502000000, 3
-2459367900052502000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over timeMissing share of net_income_ytd_usd over time, 0% to 1%.
Distinct
70,525 · 4.2% of valid
Min
-24593679000
25%
113000
Median
394000
75%
1239000
Max
52502000000

return_on_assets_pct

decimal

Annualized net income as a percent of average assets.

Histogram: -761.90480000000002 to -559.09067500000003, 1; -559.09067500000003 to -356.27654999999993, 0; -356.27654999999993 to -153.46242500000005, 16; -153.46242500000005 to 49.351699999999994, 1,681,823; 49.351699999999994 to 252.16582500000004, 730; 252.16582500000004 to 454.97994999999997, 37; 454.97994999999997 to 657.79407500000002, 8; 657.79407500000002 to 860.60820000000001, 1
-761.9048860.6082
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
110,007 · 6.5% of valid
Min
-761.9048
25%
0.5444
Median
0.9745
75%
1.3656
Max
860.6082

return_on_equity_pct

decimal

Annualized net income as a percent of average equity.

Histogram: -354657.79999999999 to -272694.32500000001, 2; -272694.32500000001 to -190730.84999999998, 0; -190730.84999999998 to -108767.375, 2; -108767.375 to -26803.899999999994, 13; -26803.899999999994 to 55159.575000000012, 1,663,854; 55159.575000000012 to 137123.04999999999, 1; 137123.04999999999 to 219086.52499999999, 0; 219086.52499999999 to 301050, 1
-354657.8000301050.0000
Valid
1,663,873 · 98.9%
Missing
18,743 · 1.1%
Missing over timeMissing share of return_on_equity_pct over time, 0% to 3%.
Distinct
27,446 · 1.6% of valid
Min
-354657.8000
25%
5.7400
Median
10.3400
75%
14.8500
Max
301050.0000

net_interest_margin_pct

decimal

Annualized net interest income as a percent of average earning assets.

Histogram: -4515.1514999999999 to -3810.1325624999999, 1; -3810.1325624999999 to -3105.113625, 1; -3105.113625 to -2400.0946875, 1; -2400.0946875 to -1695.07575, 7; -1695.07575 to -990.05681249999998, 14; -990.05681249999998 to -285.03787499999999, 19; -285.03787499999999 to 419.98106250000001, 1,682,558; 419.98106250000001 to 1125, 15
-4515.15151125.0000
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
94,501 · 5.6% of valid
Min
-4515.1515
25%
3.4037
Median
4.0463
75%
4.6962
Max
1125.0000

efficiency_ratio_pct

decimal

Noninterest expense as a percent of revenue. Lower is more efficient.

Histogram: -2280 to 46130, 1,682,597; 46130 to 94540, 11; 94540 to 142950, 3; 142950 to 191360, 1; 191360 to 239770, 1; 239770 to 288180, 1; 288180 to 336590, 1; 336590 to 385000, 1
-2280.0000385000.0000
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
534,540 · 31.8% of valid
Min
-2280.0000
25%
48.3434
Median
62.5060
75%
74.3151
Max
385000.0000

noncurrent_loans_pct

decimal

Noncurrent loans as a percent of gross loans.

Histogram: -18.9192 to 29.911049999999999, 1,679,570; 29.911049999999999 to 78.741299999999995, 2,833; 78.741299999999995 to 127.57155, 210; 127.57155 to 176.40180000000001, 2; 176.40180000000001 to 225.23205000000002, 0; 225.23205000000002 to 274.06229999999999, 0; 274.06229999999999 to 322.89255000000003, 0; 322.89255000000003 to 371.72280000000001, 1
-18.9192371.7228
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
121,604 · 7.2% of valid
Min
-18.9192
25%
0.2726
Median
0.9020
75%
2.1829
Max
371.7228

net_charge_off_rate_pct

decimal

Annualized net charge-offs as a percent of average loans.

Histogram: -57200 to -49932.528225000002, 1; -49932.528225000002 to -42665.056449999996, 1; -42665.056449999996 to -35397.584674999998, 2; -35397.584674999998 to -28130.1129, 0; -28130.1129 to -20862.641124999998, 0; -20862.641124999998 to -13595.16935, 0; -13595.16935 to -6327.6975750000001, 0; -6327.6975750000001 to 939.77419999999995, 1,682,612
-57200.0000939.7742
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
79,464 · 4.7% of valid
Min
-57200.0000
25%
0.0000
Median
0.0603
75%
0.3443
Max
939.7742

loan_loss_reserve_pct

decimal

Loss allowance as a percent of gross loans.

Histogram: -11.2477 to 90.158262500000006, 1,682,569; 90.158262500000006 to 191.56422499999999, 43; 191.56422499999999 to 292.97018750000001, 0; 292.97018750000001 to 394.37615, 1; 394.37615 to 495.78211249999998, 1; 495.78211249999998 to 597.18807500000003, 0; 597.18807500000003 to 698.59403750000001, 1; 698.59403750000001 to 800, 1
-11.2477800.0000
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
71,002 · 4.2% of valid
Min
-11.2477
25%
0.9296
Median
1.2492
75%
1.7207
Max
800.0000

tier1_leverage_ratio_pct

decimal

Tier 1 capital as a percent of average assets.

Histogram: -1524.0690999999999 to 56978.939537500002, 1,682,613; 56978.939537500002 to 115481.948175, 0; 115481.948175 to 173984.95681249999, 1; 173984.95681249999 to 232487.96544999999, 0; 232487.96544999999 to 290990.97408750001, 0; 290990.97408750001 to 349493.98272500001, 1; 349493.98272500001 to 407996.9913625, 0; 407996.9913625 to 466500, 1
-1524.0691466500.0000
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
223,931 · 13.3% of valid
Min
-1524.0691
25%
7.5268
Median
9.0961
75%
11.2169
Max
466500.0000

cet1_ratio_pct

decimal

Common equity tier 1 capital as a percent of risk-weighted assets.

Histogram: -2300 to 32317.045449999998, 1,682,595; 32317.045449999998 to 66934.090899999996, 19; 66934.090899999996 to 101551.13634999999, 1; 101551.13634999999 to 136168.18179999999, 0; 136168.18179999999 to 170785.22725, 0; 170785.22725 to 205402.27269999997, 0; 205402.27269999997 to 240019.31814999998, 0; 240019.31814999998 to 274636.36359999998, 1
-2300.0000274636.3636
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
308,070 · 18.3% of valid
Min
-2300.0000
25%
0.0000
Median
12.0666
75%
16.8866
Max
274636.3636

total_capital_ratio_pct

decimal

Total risk-based capital as a percent of risk-weighted assets.

Histogram: -16629.6296 to 19778.619549999996, 1,682,581; 19778.619549999996 to 56186.868699999992, 32; 56186.868699999992 to 92595.117849999981, 2; 92595.117849999981 to 129003.367, 0; 129003.367 to 165411.61614999999, 0; 165411.61614999999 to 201819.86529999998, 0; 201819.86529999998 to 238228.11444999996, 0; 238228.11444999996 to 274636.36359999998, 1
-16629.6296274636.3636
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
314,539 · 18.7% of valid
Min
-16629.6296
25%
0.0000
Median
13.2758
75%
18.1547
Max
274636.3636

loans_to_deposits_pct

decimal

Net loans as a percent of total deposits.

Histogram: -82.055899999999994 to 2649140.7010875, 1,682,571; 2649140.7010875 to 5298363.458075, 33; 5298363.458075 to 7947586.2150625, 7; 7947586.2150625 to 10596808.97205, 1; 10596808.97205 to 13246031.729037501, 1; 13246031.729037501 to 15895254.486025, 1; 15895254.486025 to 18544477.243012499, 1; 18544477.243012499 to 21193700, 1
-82.055921193700.0000
Valid
1,682,616 · 100%
Missing
0 · 0%
Distinct
726,500 · 43.2% of valid
Min
-82.0559
25%
55.6654
Median
70.1834
75%
83.7914
Max
21193700.0000

uninsured_deposit_share_pct

decimal

Estimated uninsured deposits as a percent of domestic deposits, derived.

Histogram: 0 to 651.31614999999999, 1,031,239; 651.31614999999999 to 1302.6323, 1; 1302.6323 to 1953.9484499999999, 0; 1953.9484499999999 to 2605.2646, 6; 2605.2646 to 3256.5807500000001, 4; 3256.5807500000001 to 3907.8968999999997, 0; 3907.8968999999997 to 4559.2130500000003, 0; 4559.2130500000003 to 5210.5291999999999, 1
0.00005210.5292
Valid
1,031,251 · 61.3%
Missing
651,365 · 38.7%
Missing over timeMissing share of uninsured_deposit_share_pct over time, 1% to 100%.
Distinct
198,992 · 19.3% of valid
Min
0.0000
25%
0.0000
Median
0.0000
75%
0.7581
Max
5210.5292

brokered_deposit_share_pct

decimal

Brokered deposits as a percent of total deposits, derived.

Histogram: 0 to 875.25698750000004, 1,653,804; 875.25698750000004 to 1750.5139750000001, 0; 1750.5139750000001 to 2625.7709625000002, 0; 2625.7709625000002 to 3501.0279500000001, 0; 3501.0279500000001 to 4376.2849375000005, 0; 4376.2849375000005 to 5251.5419250000004, 0; 5251.5419250000004 to 6126.7989125000004, 0; 6126.7989125000004 to 7002.0559000000003, 2
0.00007002.0559
Valid
1,653,806 · 98.3%
Missing
28,810 · 1.7%
Missing over timeMissing share of brokered_deposit_share_pct over time, 0% to 18%.
Distinct
154,964 · 9.4% of valid
Min
0.0000
25%
0.0000
Median
0.0000
75%
0.0000
Max
7002.0559

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 guidance, which uses total capital.

Histogram: -4481903.8461999996 to 600819.1345750005, 1,678,417; 600819.1345750005 to 5683542.1153500006, 13; 5683542.1153500006 to 10766265.096124999, 0; 10766265.096124999 to 15848988.0769, 0; 15848988.0769 to 20931711.057675, 0; 20931711.057675 to 26014434.038449999, 2; 26014434.038449999 to 31097157.019225001, 4; 31097157.019225001 to 36179880, 8
-4481903.846236179880.0000
Valid
1,678,444 · 99.8%
Missing
4,172 · 0.2%
Missing over timeMissing share of commercial_real_estate_to_equity_pct over time, 0% to 0%.
Distinct
1,301,020 · 77.5% of valid
Min
-4481903.8462
25%
42.2405
Median
117.3945
75%
249.2991
Max
36179880.0000

failed_on

date

Date the bank failed, from the FDIC failures list, excluding open-bank assistance. Null for banks that never failed.

1,090 distinct values, no chart

Valid
89,952 · 5.3%
Missing
1,592,664 · 94.7%
Missing over timeMissing share of failed_on over time, 88% to 100%.
Distinct
1,090 · 1.2% of valid

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.

Histogram: 0 to 1930, 50,195; 1931 to 3860, 16,809; 3861 to 5790, 8,240; 5791 to 7720, 6,622; 7721 to 9651, 5,256; 9652 to 11581, 1,135; 11582 to 13511, 355; 13512 to 15441, 132
015441
Valid
88,744 · 5.3%
Missing
1,593,872 · 94.7%
Missing over timeMissing share of days_until_failure over time, 88% to 100%.
Distinct
9,828 · 11.1% of valid
Min
0
25%
753
Median
1628
75%
3771
Max
15441

failure_cost_usd

integer

FDIC's estimated cost of resolving the failure, in US dollars. Future information on rows before the failure.

2,755 distinct values, no chart

Valid
89,591 · 5.3%
Missing
1,593,025 · 94.7%
Missing over timeMissing share of failure_cost_usd over time, 88% to 100%.
Distinct
2,755 · 3.1% of valid
Min
-11380600
25%
5671000
Median
19969823
75%
70038599
Max
18744254463

Table profile

Profile of the served version, all rows, computed 16 Nov 2026, 17:48 UTC

PassedFreshnessLatest event 136 d before this version
PassedGapsNo empty years
PassedAnomaliesNo spikes or dips
PassedUnique keysEvery cert · report_date is unique
Rows per year
Rows per year, 43 buckets from 1 Jan 1984 to 1 Jan 2026, at most 72,182 rows.75k1 Jan 1984: 71,760 rows1 Jan 1985: 71,961 rows1 Jan 1986: 72,182 rows1 Jan 1987: 70,399 rows1 Jan 1988: 67,715 rows1 Jan 1989: 65,397 rows1 Jan 1990: 62,769 rows1 Jan 1991: 59,949 rows1 Jan 1992: 57,025 rows1 Jan 1993: 54,487 rows1 Jan 1994: 51,875 rows1 Jan 1995: 49,108 rows1 Jan 1996: 46,942 rows1 Jan 1997: 44,941 rows1 Jan 1998: 43,079 rows1 Jan 1999: 41,705 rows1 Jan 2000: 40,631 rows1 Jan 2001: 39,352 rows1 Jan 2002: 38,204 rows1 Jan 2003: 37,447 rows1 Jan 2004: 36,637 rows1 Jan 2005: 35,915 rows1 Jan 2006: 35,407 rows1 Jan 2007: 34,754 rows1 Jan 2008: 34,003 rows1 Jan 2009: 32,916 rows1 Jan 2010: 31,545 rows1 Jan 2011: 30,230 rows1 Jan 2012: 29,157 rows1 Jan 2013: 27,989 rows1 Jan 2014: 26,805 rows1 Jan 2015: 25,521 rows1 Jan 2016: 24,356 rows1 Jan 2017: 23,325 rows1 Jan 2018: 22,301 rows1 Jan 2019: 21,366 rows1 Jan 2020: 20,478 rows1 Jan 2021: 19,942 rows1 Jan 2022: 19,285 rows1 Jan 2023: 18,798 rows1 Jan 2024: 18,399 rows1 Jan 2025: 17,893 rows1 Jan 2026: 8,666 rows
Rows per year by cert, 10 of 24,064
Rows per year by cert, 10 of 24,064, with the share of years that have rows on the right.14100%35100%39100%41100%49100%50100%51100%52100%54100%58100%14: 170 rows, 0 of 43 buckets empty35: 170 rows, 0 of 43 buckets empty39: 170 rows, 0 of 43 buckets empty41: 170 rows, 0 of 43 buckets empty49: 170 rows, 0 of 43 buckets empty50: 170 rows, 0 of 43 buckets empty51: 170 rows, 0 of 43 buckets empty52: 170 rows, 0 of 43 buckets empty54: 170 rows, 0 of 43 buckets empty58: 170 rows, 0 of 43 buckets empty198519901995200020052010201520202025

Support

Talk to Mostly Right

Loading chat…