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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
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 time
Distinct
2 · 0% of valid
employees
integer
Full-time equivalent employees.
0240232
Valid
1,602,692 · 95.3%
Missing
79,924 · 4.7%
Missing over time
Distinct
10,649 · 0.7% of valid
Min
0
25%
16
Median
32
75%
73
Max
240232
domestic_offices
integer
Number of domestic offices.
06729
Valid
1,682,612 · 100%
Missing
4 · 0%
Missing over time
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.
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.
02820284000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
02226790000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
-1465310001245343000000
Valid
1,664,086 · 98.9%
Missing
18,530 · 1.1%
Missing over time
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.
01392514000000
Valid
1,040,881 · 61.9%
Missing
641,735 · 38.1%
Missing over time
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.
0151509000000
Valid
1,665,855 · 99%
Missing
16,761 · 1%
Missing over time
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.
-584570002084452000000
Valid
1,681,287 · 99.9%
Missing
1,329 · 0.1%
Missing over time
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.
-4565197000341610000000
Valid
1,678,468 · 99.8%
Missing
4,148 · 0.2%
Missing over time
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.
-629690001535635000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
-616970001561577000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
-354000513768000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
-35400039864847000
Valid
1,679,690 · 99.8%
Missing
2,926 · 0.2%
Missing over time
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.
-520003000104535000000
Valid
1,679,690 · 99.8%
Missing
2,926 · 0.2%
Missing over time
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.
-62774000107317000000
Valid
1,679,690 · 99.8%
Missing
2,926 · 0.2%
Missing over time
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.
-38500000381105461000
Valid
1,679,689 · 99.8%
Missing
2,927 · 0.2%
Missing over time
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.
03064000000
Valid
1,489,127 · 88.5%
Missing
193,489 · 11.5%
Missing over time
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.
-833000353653000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
0349114408000
Valid
1,678,676 · 99.8%
Missing
3,940 · 0.2%
Missing over time
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.
0256015215000
Valid
1,676,179 · 99.6%
Missing
6,437 · 0.4%
Missing over time
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.
06508000000
Valid
1,487,905 · 88.4%
Missing
194,711 · 11.6%
Missing over time
Distinct
65,741 · 4.4% of valid
Min
0
25%
0
Median
685000
75%
3894000
Max
6508000000
securities_usd
integer
Total securities. US dollars.
-965382000941778000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
-1532625000683054000000
Valid
1,028,971 · 61.2%
Missing
653,645 · 38.8%
Missing over time
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.
0552176000000
Valid
954,721 · 56.7%
Missing
727,895 · 43.3%
Missing over time
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.
-178000760259000000
Valid
1,682,615 · 100%
Missing
1 · 0%
Missing over time
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.
-379060005794000000
Valid
1,678,467 · 99.8%
Missing
4,149 · 0.2%
Missing over time
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.
-1719600065914905000
Valid
1,680,117 · 99.9%
Missing
2,499 · 0.1%
Missing over time
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.
017863000000
Valid
710,691 · 42.2%
Missing
971,925 · 57.8%
Missing over time
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.
-6563000169911000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over time
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.
-15900000074797000000
Valid
1,676,179 · 99.6%
Missing
6,437 · 0.4%
Missing over time
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.
-46646100097846000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over time
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.
-181590000066240000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over time
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.
-17274200086128000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over time
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.
-929600000029395292000
Valid
1,639,450 · 97.4%
Missing
43,166 · 2.6%
Missing over time
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.
-17964700020007000000
Valid
1,602,698 · 95.3%
Missing
79,918 · 4.7%
Missing over time
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.
-2459367900052502000000
Valid
1,677,924 · 99.7%
Missing
4,692 · 0.3%
Missing over time
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.
-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.
-354657.8000301050.0000
Valid
1,663,873 · 98.9%
Missing
18,743 · 1.1%
Missing over time
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.
-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.
-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.
-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.
-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.
-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.
-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.
-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.
-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.
-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.
0.00005210.5292
Valid
1,031,251 · 61.3%
Missing
651,365 · 38.7%
Missing over time
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.
0.00007002.0559
Valid
1,653,806 · 98.3%
Missing
28,810 · 1.7%
Missing over time
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.
-4481903.846236179880.0000
Valid
1,678,444 · 99.8%
Missing
4,172 · 0.2%
Missing over time
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 time
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.
015441
Valid
88,744 · 5.3%
Missing
1,593,872 · 94.7%
Missing over time
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 time
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