Skip to main content
MortRadarTERMINAL
State markets/Missouri/Franklin County

COUNTY MORTGAGE MARKET · FIPS 29071

Franklin County, Missouri

Who lends in Franklin County, how much, and to whom — built from HMDA public mortgage disclosure data, U.S. Census ACS housing estimates and FEMA's National Risk Index.

Origination volume · 2025

$575.3M

Origination volumeSum of loan amount over HMDA records with action taken = 1.

Originations · 2025

2,455

OriginationsCount of HMDA records with action taken = 1 (loan originated) in the activity year.

Denial rate · 2025

13.9%

Denial rateApplications denied (action taken = 3) divided by applications acted upon (actions 1-5).

Lenders active · 2025

229

Lenders activeDistinct LEIs with at least one application acted upon (HMDA action taken 1-5, 7 or 8) in the county and year.

Market structure

How spread out lending is across the 229 lenders that originated in Franklin County in 2025. HHI is the Herfindahl-Hirschman index over lender shares.

Concentration (HHI)

285

unconcentrated

Top-5 lender share

29.9%

of originations

Purchase

66.9%

1,417 loans

Refinance

33.1%

701 loans

Origination trend

Annual mortgage origination volume and loan count in Franklin County, 2023–2025. Pick a window, export the graph or its data, or click a year to open every record behind it.

Lenders in Franklin County

Sort, filter, add columns, export, or open a row for the lender's card. Each row links to the lender's company page and to its Franklin County loan records. The panel states which source answered and exactly which lenders that source covers.

ORIGINATION FLOOR
Hide the long tail of lenders with only a handful of loans here.
FULL RECORD LIST FOR FRANKLIN COUNTY

TOP TEN LENDERS IN FRANKLIN COUNTY · 10

The ten largest lenders by origination volume — the precomputed county leaderboard, not the whole market.

1–10 OF 10 LENDERS

Loading every lender that acted on an application in this county. The rows below are the precomputed county leaderboard — the ten largest by volume, not the whole market.

139$40.8M$40.8M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
127$40.7M$40.7M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
168$34.7M$34.7M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
131$29.2M$29.2M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
107$26.8M$26.8M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
89$20.3M$20.3M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
72$17.7M$17.7M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
90$17.5M$17.5M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
54$17.3M$17.3M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.
69$15.7M$15.7M originated in Franklin County, 2025Share needs a county-wide denominator, which the narrower fallback source does not carry.

Source: the precomputed county lender leaderboard (lender_county_year) — its ten largest lenders by origination volume, not the county. As of HMDA activity year 2025. Denial rate = denials / decisioned applications (originated + approved-but-not-accepted + denied).

ZIP areas in Franklin County

All 23 ZIP Code Tabulation Areas that touch Franklin County, built by grouping the county's census tracts through the Census 2020 crosswalk. A ZCTA approximates a USPS ZIP code; HMDA itself reports no postal geography, so each row opens the tracts behind it, where the records are exact.

TRACT FLOOR
Hide the ZIP areas that only clip a corner of this county.
23 OF 23 ZIP AREASEVERY ZIP AREA TOUCHING THE COUNTY — NO ROWS WITHHELD
TOP LENDERRECORDS
55 of the 8 Franklin County tracts this ZIP area touches sit mostly inside it.23,4017.6%6,954TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
44 of the 10 Franklin County tracts this ZIP area touches sit mostly inside it.17,27410.3%4,498TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
33 of the 7 Franklin County tracts this ZIP area touches sit mostly inside it.10,0008.9%2,804TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
33 of the 8 Franklin County tracts this ZIP area touches sit mostly inside it.8,5399.6%2,744TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
22 of the 5 Franklin County tracts this ZIP area touches sit mostly inside it.8,1898.0%2,514TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
22 of the 4 Franklin County tracts this ZIP area touches sit mostly inside it.7,3478.4%2,471TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
22 of the 5 Franklin County tracts this ZIP area touches sit mostly inside it.6,31812.8%1,558TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
22 of the 2 Franklin County tracts this ZIP area touches sit mostly inside it.5,8435.4%2,023TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
11 of the 3 Franklin County tracts this ZIP area touches sit mostly inside it.5,4068.6%1,811OPEN →This ZIP area is one census tract here, so its records open directly and exactly.
22 of the 4 Franklin County tracts this ZIP area touches sit mostly inside it.4,5999.0%1,554TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
11 of the 4 Franklin County tracts this ZIP area touches sit mostly inside it.4,1165.9%1,513OPEN →This ZIP area is one census tract here, so its records open directly and exactly.
11 of the 2 Franklin County tracts this ZIP area touches sit mostly inside it.3,6505.9%1,321OPEN →This ZIP area is one census tract here, so its records open directly and exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 4 tracts of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 2 tracts of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 2 tracts of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 2 tracts of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.
0This ZIP area clips 1 tract of Franklin County but is the dominant ZIP for none of them, so it owns no figures here.TRACTS →HMDA reports no ZIP. This opens the ZIP area's tract list, where each tract's records open exactly.

28 of Franklin County’s 28 census tracts are grouped into the ZIP areas above, with none left over. The two add up to the county exactly, because each tract is counted once. A ZCTA — ZIP Code Tabulation Area — is the U.S. Census Bureau's area approximation of a USPS ZIP code, not the ZIP code itself. HMDA reports no postal geography at all, so these rows are census tracts grouped by the Census 2020 tract-to-ZCTA relationship file: each tract is counted once, in the single ZCTA covering the most of its land. Housing figures are HMDA tract attributes for activity year 2025, summed over the tracts each ZIP area owns — a ZIP area that owns no tract shows an em-dash, never a zero.

Census tracts in Franklin County

All 28 tracts, with the FFIEC income character and HMDA housing attributes of each. Open a tract for its own lender ranking, or open its records directly.

28 OF 28 TRACTSEVERY TRACT IN THE COUNTY — NO ROWS WITHHELD
TOP LENDERRECORDS
Middle114.5%2,5348.6%OPEN →
Upper183.1%2,0659.5%OPEN →
Middle90.0%2,22410.0%OPEN →
Upper125.1%1,8576.4%OPEN →
Moderate65.0%5,2319.7%OPEN →
Middle119.4%6,4356.7%OPEN →
Upper121.0%2,9697.4%OPEN →
Middle84.3%4,7149.0%OPEN →
Middle83.1%5,4068.6%OPEN →
Middle116.2%4,0524.7%OPEN →
Middle101.8%2,9414.6%OPEN →
Middle104.7%4,1165.9%OPEN →
Middle81.7%2,9026.2%OPEN →
Middle90.1%4,21110.2%OPEN →
Moderate69.5%3,66511.8%OPEN →
Middle80.6%4,3778.8%OPEN →
Middle88.5%5,02110.7%OPEN →
Middle95.3%3,32610.6%OPEN →
Middle107.1%4,45810.8%OPEN →
Moderate59.2%2,99215.2%OPEN →
Middle82.7%5,3857.8%OPEN →
Middle81.5%1,96210.1%OPEN →
Middle84.2%2,7937.3%OPEN →
Moderate65.6%3,3149.2%OPEN →
Moderate64.8%3,8939.9%OPEN →
Moderate64.1%3,6505.9%OPEN →
Moderate58.8%4,0889.3%OPEN →
Middle97.4%4,1016.8%OPEN →

Source: FFIEC census-tract file (income level, MSA, urban/rural) and HMDA tract attributes (population, minority share, housing units), latest loaded activity year. The whole county is listed — the table is filtered and paged in the browser over the complete set, never a server-side slice of it.

Housing & households

U.S. Census American Community Survey 2024 estimates — the demand side behind the lending figures above.

Population

105,950

Median household income

$73,165

Median home value

$227,600

Median gross rent

$893

per month

Owner-occupied

76.5%

of occupied units

Housing units

46,312

7.1% vacant

Poverty rate

8.2%

Unemployment

4.3%

Natural-hazard exposure

FEMA National Risk Index ratings for this county — expected annual loss, social vulnerability and community resilience, plus the individual perils rated Relatively High or above.

Overall risk

Relatively Moderate

score 83.5

Social vulnerability

Relatively Low

Community resilience

Relatively High

ELEVATED PERILS

Strong wind Relatively High

Federal disaster history

Months in which a FEMA disaster declaration was active in this county, from the declarations series.

Months with an active declaration

81

Declarations recorded

24

Incident types on record: Biological, Drought, Flood, Hurricane, Severe Ice Storm, Severe Storm.

Everything we hold on Franklin County

12 data areas have rows for this county. Each one is one click away below; the 18 we checked and did not find at county grain are named at the end with the reason.

LOAN-LEVEL

The individual HMDA application and origination records behind every figure on this page, pre-filtered to Franklin County.

HMDA loan-level (hmda_loan_wide, county_code)

Open the loan explorer for Franklin CountyEvery reported application and origination in FIPS 29071, filterable on rate, amount, income, purpose and action taken. Loan-level tier.

VA

VA-guaranteed lending in Franklin County by fiscal year — the veteran channel, which HMDA counts but does not separate from the rest of the government book at this grain.

VA Loan Guaranty geographic loan volume (va_geo_loan_volume, county_fips), folded to fiscal year

VA loans · FY2026

168

Purchase share

41.1%

69 loans

IRRRL refinances

68

Cash-out refinances

31

2026168696831
2025176944834
20241501061628
202310173226
2022904265
202140911825437
202033510917947
20192191402257
20181841121260
20172071024758
20161861005135
2015161834830

The most recent fiscal year is partial until VA closes it. This file carries no lender key, so VA volume cannot be attributed to a company.

BUILDING PERMITS

New residential units authorised in Franklin County — the supply-side leading indicator that runs ahead of purchase originations.

Census Building Permits Survey county series (census_building_permits, geo_id at geo_level 'county')

HOUSING SUPPLY · CENSUS BUILDING PERMITS

Franklin County building permits

New privately-owned housing units authorized by building permits — the supply-side leading indicator that runs ahead of housing starts and the purchase-origination pipeline. Single-family (SF, 1-unit) vs. multifamily (MF, 2+ units), by year.

Single-family · 2025

458

−8.6% vs 2024

Multifamily · 2025

336

+110.0% vs 2024

Total authorized · 2025

794

+20.1% vs 2024

Permit valuation · 2025

$204.4M

authorized construction value

Units authorized by year

Franklin County · total permitted units · hover for the single-family split

UNITS · SF IN TOOLTIP
02505007501K1990199219941996199820002002200420062008201020122014201620182020202220242025794 units

Source: U.S. Census Bureau Building Permits Survey (BPS), imputed totals (the published “units authorized” headline). SF = 1-unit; MF = 2+ units. Public no-login Census data. Attribution.

MIGRATION & WEALTH

IRS county-to-county migration flows for Franklin County, showing population movement and wealth transfer.

IRS county-to-county migration flows (irs_county_migration, self_geoid)

outflow2223Foreign - Other flows, FR
inflow2223Foreign - Other flows, FR
inflow2223St. Louis County, MO533873$58.0M
outflow2223St. Louis County, MO344546$25.2M
inflow2223Jefferson County, MO283523$14.5M
outflow2223Other flows - South, DS245411$20.8M
inflow2223Other flows - South, DS230430$13.6M
outflow2223Jefferson County, MO219353$10.3M
outflow2223Other flows - Midwest, DS183285$9.4M
inflow2223Crawford County, MO178336$7.9M
outflow2223Crawford County, MO178365$7.5M
inflow2223Other flows - Midwest, DS173323$10.2M
inflow2223Other flows - West, DS172317$10.9M
inflow2223St. Charles County, MO156261$13.1M
outflow2223St. Charles County, MO136224$8.4M
outflow2223Other flows - West, DS116194$8.4M
inflow2223Gasconade County, MO102190$3.9M
outflow2223Gasconade County, MO96174$4.0M
outflow2223St. Louis city, MO84110$4.1M
inflow2223Warren County, MO82149$4.4M
outflow2223Warren County, MO73111$4.1M
inflow2223St. Louis city, MO73101$3.8M
outflow2223Washington County, MO53111$2.3M
outflow2223Boone County, MO4252$1.3M
outflow2223Phelps County, MO4060$1.8M
inflow2223Phelps County, MO3663$1.6M
inflow2223Greene County, MO3447$1.6M
outflow2223Greene County, MO3145$1.1M
inflow2223Washington County, MO3162$918K
outflow2223Madison County, IL2848$1.0M
inflow2223Other flows - Northeast, DS2444$1.7M
inflow2223Boone County, MO2444$1.5M
inflow2223Lincoln County, MO2344$1.2M
outflow2223Lincoln County, MO2343$1.5M
outflow2223Other flows - Northeast, DS2229$981K
inflow2223St. Francois County, MO2243$814K
inflow2223Jackson County, MO2238$1.2M
outflow2223St. Francois County, MO2129$606K
inflow2223St. Clair County, IL2042$1.2M
inflow2122Foreign - Other flows, FR
outflow2122Other flows - Northeast, DS
outflow2122Foreign - Other flows, FR
inflow2122St. Louis County, MO540947$56.3M
outflow2122St. Louis County, MO360571$26.4M
inflow2122Jefferson County, MO283533$14.2M
outflow2122Jefferson County, MO239432$13.8M
outflow2122Other flows - South, DS232406$12.9M
outflow2122Crawford County, MO210432$8.6M
inflow2122Other flows - South, DS207389$10.8M
inflow2122Crawford County, MO197383$8.1M
inflow2122St. Charles County, MO178332$12.2M
inflow2122Other flows - Midwest, DS172362$9.9M
outflow2122Other flows - Midwest, DS166284$8.0M
inflow2122Other flows - West, DS161315$13.2M
outflow2122St. Charles County, MO127215$12.5M
inflow2122St. Louis city, MO104160$7.1M
outflow2122Gasconade County, MO95183$3.8M
inflow2122Warren County, MO91181$6.4M
outflow2122Other flows - West, DS87143$4.6M
inflow2122Gasconade County, MO87161$3.8M
outflow2122Warren County, MO69111$2.7M
outflow2122St. Louis city, MO6483$2.6M
inflow2122Washington County, MO4585$1.4M
inflow2122Phelps County, MO4267$1.6M
outflow2122Lincoln County, MO4083$2.0M
outflow2122Washington County, MO4076$1.4M
inflow2122Other flows - Northeast, DS3658$2.2M
outflow2122Greene County, MO3451$1.5M
outflow2122Phelps County, MO3357$981K
inflow2122St. Francois County, MO3360$688K
inflow2122Boone County, MO3155$2.2M
inflow2122Greene County, MO2529$893K
inflow2122Madison County, IL2548$1.1M
outflow2122St. Francois County, MO2560$1.6M
outflow2122Boone County, MO2441$1.3M
outflow2122Maricopa County, AZ2131$1.2M
outflow2021Foreign - Other flows, FR
inflow2021Foreign - Other flows, FR
inflow2021St. Louis County, MO5861,021$41.0M
outflow2021St. Louis County, MO394633$26.0M
inflow2021Jefferson County, MO290547$14.5M
outflow2021Jefferson County, MO255434$11.5M
inflow2021Other flows - South, DS242468$15.0M
outflow2021Other flows - South, DS237435$15.8M
inflow2021Crawford County, MO212406$7.9M
inflow2021Other flows - Midwest, DS196352$11.6M
outflow2021Crawford County, MO185368$8.9M
inflow2021St. Charles County, MO144250$9.8M
outflow2021St. Charles County, MO144252$7.2M
inflow2021Other flows - West, DS142251$12.0M
outflow2021Other flows - Midwest, DS133231$5.4M
outflow2021Other flows - West, DS124199$5.7M
outflow2021Gasconade County, MO112204$4.1M
inflow2021Warren County, MO105204$5.0M
inflow2021St. Louis city, MO95157$5.8M
inflow2021Gasconade County, MO93162$3.7M
outflow2021Warren County, MO88169$4.4M
outflow2021St. Louis city, MO79103$3.0M
outflow2021Washington County, MO4082$1.3M
inflow2021Washington County, MO3876$1.4M
inflow2021Madison County, IL3366$2.2M
outflow2021Phelps County, MO3367$1.4M
outflow2021Boone County, MO3147$1.4M
inflow2021Phelps County, MO3152$1.2M
inflow2021Other flows - Northeast, DS2745$2.8M
inflow2021Greene County, MO2741$1.0M
outflow2021Other flows - Northeast, DS2439$1.1M
inflow2021St. Clair County, IL2447$1.8M
inflow2021St. Francois County, MO2241$646K
inflow2021Boone County, MO2228$622K
outflow2021Greene County, MO2032$683K
outflow2021Lincoln County, MO2035$1.0M
outflow1920Foreign - Other flows, FR
inflow1920Foreign - Other flows, FR
inflow1920St. Louis County, MO5501,041$42.9M
outflow1920St. Louis County, MO376687$21.6M
inflow1920Jefferson County, MO292545$12.8M
outflow1920Jefferson County, MO248492$9.2M
outflow1920Other flows - South, DS241507$45.7M
inflow1920Other flows - South, DS235446$13.2M
outflow1920Crawford County, MO235482$8.7M
inflow1920Crawford County, MO218443$8.0M
inflow1920St. Charles County, MO165290$9.9M
outflow1920Other flows - Midwest, DS163282$8.7M
inflow1920Other flows - Midwest, DS161310$19.8M
outflow1920St. Charles County, MO130231$7.1M
outflow1920Gasconade County, MO124270$4.3M
inflow1920Other flows - West, DS120213$10.0M
inflow1920Gasconade County, MO99187$3.5M
inflow1920St. Louis city, MO98145$5.3M
outflow1920Warren County, MO94180$4.2M
inflow1920Warren County, MO93173$4.1M
outflow1920Other flows - West, DS93163$5.1M
outflow1920St. Louis city, MO84112$-141.7M
inflow1920Phelps County, MO4772$1.7M
inflow1920St. Clair County, IL3970$3.0M
inflow1920Madison County, IL3879$1.8M
inflow1920Washington County, MO3778$1.2M
outflow1920Phelps County, MO3470$1.2M
outflow1920Greene County, MO3153$552K
outflow1920Washington County, MO2852$848K
inflow1920Greene County, MO2856$905K
outflow1920Boone County, MO2538$1.2M
inflow1920Lincoln County, MO2549$1.0M
inflow1920Other flows - Northeast, DS2543$2.0M
outflow1920Other flows - Northeast, DS2435$1.5M
inflow1920St. Francois County, MO2340$678K
outflow1920St. Francois County, MO2255$859K
outflow1920Madison County, IL2038$793K
outflow1819Foreign - Other flows, FR
inflow1819Foreign - Other flows, FR
inflow1819St. Louis County, MO478832$32.1M
outflow1819St. Louis County, MO378649$23.6M
inflow1819Jefferson County, MO265473$11.8M
outflow1819Other flows - South, DS235444$13.8M
outflow1819Crawford County, MO214414$7.8M
outflow1819Jefferson County, MO212385$8.5M
inflow1819Crawford County, MO193375$6.1M
inflow1819Other flows - South, DS188388$10.2M
inflow1819Other flows - Midwest, DS161296$10.1M
inflow1819St. Charles County, MO156275$7.8M
outflow1819St. Charles County, MO148232$6.3M
outflow1819Other flows - Midwest, DS145252$9.2M
inflow1819Other flows - West, DS123247$7.4M
inflow1819Gasconade County, MO115246$4.6M
outflow1819Other flows - West, DS115204$19.6M
outflow1819Gasconade County, MO113261$4.3M
outflow1819St. Louis city, MO86112$3.4M
inflow1819Warren County, MO86164$3.5M
inflow1819St. Louis city, MO76112$4.0M
outflow1819Warren County, MO73152$2.9M
outflow1819Washington County, MO4493$1.2M
outflow1819Phelps County, MO4076$1.4M
inflow1819Phelps County, MO3461$1.5M
inflow1819Washington County, MO3472$1.2M
inflow1819Lincoln County, MO3062$1.4M
inflow1819Madison County, IL2654$1.3M
outflow1819Lincoln County, MO2543$1.0M
inflow1819Other flows - Northeast, DS2442$2.0M
outflow1819Boone County, MO2331$982K
inflow1819St. Clair County, IL2347$1.6M
inflow1819Greene County, MO2246$672K
outflow1819Other flows - Northeast, DS2233$1.4M
outflow1819Madison County, IL2145$527K
outflow1819St. Francois County, MO2143$776K
inflow1718Foreign - Other flows, FR
outflow1718Foreign - Other flows, FR
inflow1718St. Louis County, MO477821$40.5M
outflow1718St. Louis County, MO436788$23.4M
outflow1718Other flows - South, DS276534$14.3M
inflow1718Jefferson County, MO274531$11.3M
outflow1718Jefferson County, MO228428$8.6M
inflow1718Other flows - South, DS218405$11.1M
inflow1718Crawford County, MO197368$5.6M
outflow1718Crawford County, MO179378$6.1M
inflow1718Other flows - Midwest, DS154290$8.8M
inflow1718St. Charles County, MO152272$7.3M
outflow1718Other flows - Midwest, DS150285$6.9M
outflow1718St. Charles County, MO122205$5.4M
inflow1718Other flows - West, DS116202$7.2M

UAD APPRAISALS

FHFA Uniform Appraisal Dataset aggregates for Franklin County.

FHFA UAD aggregate statistics (uad_aggregate_county, geoid) and appraisal-level public use file (uad_puf, county_fips)

2023PurchaseNo CharacteristicAll Appraisals707.0
2023PurchaseNo CharacteristicAll Appraisals0.2
2023RefinanceNo CharacteristicAll Appraisals253.0
2023PurchaseNo CharacteristicAll Appraisals1.0
2023BothNo CharacteristicAll Appraisals960.0
2023PurchaseNo CharacteristicAll Appraisals0.8
2023PurchaseNo CharacteristicAll Appraisals1.0
2023RefinanceNo CharacteristicAll Appraisals270,000.0
2023BothNo CharacteristicAll Appraisals251,000.0
2023PurchaseNo CharacteristicAll Appraisals250,000.0
2023PurchaseNo CharacteristicAll Appraisals0.1
2022PurchaseNo CharacteristicAll Appraisals1.0
2022BothNo CharacteristicAll Appraisals240,000.0
2022PurchaseNo CharacteristicAll Appraisals0.2
2022PurchaseNo CharacteristicAll Appraisals240,000.0
2022PurchaseNo CharacteristicAll Appraisals1.0
2022RefinanceNo CharacteristicAll Appraisals551.0
2022PurchaseNo CharacteristicAll Appraisals0.1
2022PurchaseNo CharacteristicAll Appraisals0.8
2022RefinanceNo CharacteristicAll Appraisals243,000.0
2022BothNo CharacteristicAll Appraisals1,387.0
2022PurchaseNo CharacteristicAll Appraisals836.0
2021PurchaseNo CharacteristicAll Appraisals1.0
2021RefinanceNo CharacteristicAll Appraisals250,000.0
2021BothNo CharacteristicAll Appraisals2,501.0
2021PurchaseNo CharacteristicAll Appraisals1.0
2021PurchaseNo CharacteristicAll Appraisals1,106.0
2021PurchaseNo CharacteristicAll Appraisals0.2
2021RefinanceNo CharacteristicAll Appraisals1,395.0
2021PurchaseNo CharacteristicAll Appraisals0.1
2021BothNo CharacteristicAll Appraisals237,000.0
2021PurchaseNo CharacteristicAll Appraisals0.7
2021PurchaseNo CharacteristicAll Appraisals222,500.0
2020PurchaseNo CharacteristicAll Appraisals0.1
2020PurchaseNo CharacteristicAll Appraisals1.0
2020BothNo CharacteristicAll Appraisals2,890.0
2020PurchaseNo CharacteristicAll Appraisals1,039.0
2020PurchaseNo CharacteristicAll Appraisals0.8
2020BothNo CharacteristicAll Appraisals230,600.0
2020RefinanceNo CharacteristicAll Appraisals252,000.0
2020RefinanceNo CharacteristicAll Appraisals1,851.0
2020PurchaseNo CharacteristicAll Appraisals200,000.0
2020PurchaseNo CharacteristicAll Appraisals1.0
2020PurchaseNo CharacteristicAll Appraisals0.2
2019PurchaseNo CharacteristicAll Appraisals0.0
2019PurchaseNo CharacteristicAll Appraisals1.0
2019BothNo CharacteristicAll Appraisals210,000.0
2019PurchaseNo CharacteristicAll Appraisals958.0
2019PurchaseNo CharacteristicAll Appraisals0.2
2019PurchaseNo CharacteristicAll Appraisals1.0
2019RefinanceNo CharacteristicAll Appraisals240,000.0
2019BothNo CharacteristicAll Appraisals1,914.0
2019RefinanceNo CharacteristicAll Appraisals956.0
2019PurchaseNo CharacteristicAll Appraisals180,000.0
2019PurchaseNo CharacteristicAll Appraisals0.8
2018RefinanceNo CharacteristicAll Appraisals220,000.0
2018BothNo CharacteristicAll Appraisals1,438.0
2018PurchaseNo CharacteristicAll Appraisals853.0
2018RefinanceNo CharacteristicAll Appraisals585.0
2018BothNo CharacteristicAll Appraisals185,000.0
2018PurchaseNo CharacteristicAll Appraisals170,000.0
2018PurchaseNo CharacteristicAll Appraisals0.8
2018PurchaseNo CharacteristicAll Appraisals0.0
2018PurchaseNo CharacteristicAll Appraisals0.1
2018PurchaseNo CharacteristicAll Appraisals1.0
2018PurchaseNo CharacteristicAll Appraisals1.0
2017RefinanceNo CharacteristicAll Appraisals215,000.0
2017PurchaseNo CharacteristicAll Appraisals1.0
2017PurchaseNo CharacteristicAll Appraisals1.1
2017PurchaseNo CharacteristicAll Appraisals0.1
2017PurchaseNo CharacteristicAll Appraisals0.0
2017BothNo CharacteristicAll Appraisals1,607.0
2017PurchaseNo CharacteristicAll Appraisals911.0
2017PurchaseNo CharacteristicAll Appraisals171,000.0
2017RefinanceNo CharacteristicAll Appraisals696.0
2017PurchaseNo CharacteristicAll Appraisals0.9
2017BothNo CharacteristicAll Appraisals190,000.0
2016PurchaseNo CharacteristicAll Appraisals782.0
2016RefinanceNo CharacteristicAll Appraisals219,500.0
2016PurchaseNo CharacteristicAll Appraisals1.0
2016PurchaseNo CharacteristicAll Appraisals171,000.0
2016PurchaseNo CharacteristicAll Appraisals0.8
2016PurchaseNo CharacteristicAll Appraisals0.0
2016BothNo CharacteristicAll Appraisals196,000.0
2016PurchaseNo CharacteristicAll Appraisals1.0
2016PurchaseNo CharacteristicAll Appraisals0.1
2016BothNo CharacteristicAll Appraisals1,860.0
2016RefinanceNo CharacteristicAll Appraisals1,078.0
2015PurchaseNo CharacteristicAll Appraisals1.0
2015PurchaseNo CharacteristicAll Appraisals169,000.0
2015PurchaseNo CharacteristicAll Appraisals0.1
2015RefinanceNo CharacteristicAll Appraisals200,000.0
2015BothNo CharacteristicAll Appraisals1,612.0
2015RefinanceNo CharacteristicAll Appraisals863.0
2015PurchaseNo CharacteristicAll Appraisals0.0
2015PurchaseNo CharacteristicAll Appraisals0.8
2015PurchaseNo CharacteristicAll Appraisals749.0
2015BothNo CharacteristicAll Appraisals182,000.0
2015PurchaseNo CharacteristicAll Appraisals1.0
2014BothNo CharacteristicAll Appraisals185,000.0

ECONOMY & INCOME

Local economy indicators — BLS unemployment rates and BEA personal income for Franklin County.

BLS Local Area Unemployment Statistics (bls_laus_county_month, geoid) and BEA personal income (bea_county_income, geo_fips)

BLS Local Area Unemployment

2026-0553,86652,1321,7343.2%
2026-0453,97652,2121,7643.3%
2026-0353,76951,6042,1654.0%
2026-0253,62851,3372,2914.3%
2026-0153,49451,1692,3254.3%
2025-1253,86752,2261,6413.0%
2025-1153,94152,2691,6723.1%
2025-0953,75952,0231,7363.2%
2025-0854,19952,0722,1273.9%
2025-0754,88252,6452,2374.1%
2025-0654,54752,4142,1333.9%
2025-0554,01652,0281,9883.7%
2025-0454,10852,2661,8423.4%
2025-0353,83451,5922,2424.2%
2025-0253,76151,4082,3534.4%
2025-0153,67451,3832,2914.3%
2024-1253,53551,8121,7233.2%
2024-1153,53951,8941,6453.1%
2024-1053,87652,2221,6543.1%
2024-0953,69552,2041,4912.8%
2024-0854,11552,0922,0233.7%
2024-0755,00352,7912,2124.0%
2024-0654,42152,3642,0573.8%
2024-0553,89152,0061,8853.5%
2024-0453,74752,0851,6623.1%
2024-0353,50651,5401,9663.7%
2024-0253,41451,3512,0633.9%
2024-0153,46551,4592,0063.8%
2023-1252,78451,3331,4512.7%
2023-1153,11451,7401,3742.6%
2023-1053,35051,8091,5412.9%
2023-0953,01551,7071,3082.5%
2023-0853,54751,9221,6253.0%
2023-0754,11752,3821,7353.2%
2023-0653,65051,9331,7173.2%
2023-0553,25051,6721,5783.0%
2023-0453,09151,7701,3212.5%
2023-0352,91551,3161,5993.0%
2023-0252,68651,0051,6813.2%
2023-0152,36250,7421,6203.1%
2022-1252,05250,8291,2232.3%
2022-1151,92850,7571,1712.3%
2022-1052,23251,0421,1902.3%
2022-0951,76650,8359311.8%
2022-0852,16750,7891,3782.6%
2022-0752,71651,3361,3802.6%
2022-0652,39151,1911,2002.3%
2022-0552,05550,9151,1402.2%
2022-0451,81650,7921,0242.0%
2022-0351,93050,4521,4782.8%
2022-0251,66450,0991,5653.0%
2022-0151,64649,8441,8023.5%
2021-1251,18049,8271,3532.6%
2021-1151,18049,8691,3112.6%
2021-1051,35949,8171,5423.0%
2021-0951,00949,6021,4072.8%
2021-0851,18549,2591,9263.8%
2021-0751,73849,7511,9873.8%
2021-0651,53049,3662,1644.2%
2021-0551,08949,1151,9743.9%
2021-0451,07749,0811,9963.9%
2021-0351,02548,5752,4504.8%
2021-0251,41148,5602,8515.5%
2021-0150,83447,9882,8465.6%
2020-1250,61248,1852,4274.8%
2020-1150,54348,2672,2764.5%
2020-1050,86648,6302,2364.4%
2020-0950,55748,0972,4604.9%
2020-0851,37848,2503,1286.1%
2020-0752,44248,1524,2908.2%
2020-0650,49045,8834,6079.1%
2020-0548,15342,7525,40111.2%
2020-0449,46243,5065,95612.0%
2020-0352,12849,7972,3314.5%
2020-0252,37650,4371,9393.7%
2020-0152,12350,0742,0493.9%
2019-1251,95150,2351,7163.3%
2019-1151,85150,3081,5433.0%
2019-1052,15050,4161,7343.3%
2019-0951,63450,3921,2422.4%
2019-0851,86750,1701,6973.3%
2019-0752,52350,7301,7933.4%
2019-0651,90150,3231,5783.0%
2019-0551,44349,8751,5683.0%
2019-0451,36449,8781,4862.9%
2019-0351,31149,4571,8543.6%
2019-0251,40749,4341,9733.8%
2019-0150,96348,9821,9813.9%
2018-1250,99749,4811,5163.0%
2018-1150,77849,4681,3102.6%
2018-1050,88049,6941,1862.3%
2018-0950,67749,5151,1622.3%
2018-0850,88549,4141,4712.9%
2018-0751,88450,2141,6703.2%
2018-0651,49049,8891,6013.1%
2018-0551,08449,6231,4612.9%
2018-0451,18549,5741,6113.1%
2018-0351,15349,0612,0924.1%
2018-0251,22648,9722,2544.4%
2018-0150,63548,5782,0574.1%

BEA Personal Income

2024$6.34B107,256$59K
2023$6.04B106,444$57K
2022$5.66B105,865$53K
2021$5.52B105,317$52K
2020$5.14B104,867$49K
2019$4.79B104,149$46K
2018$4.56B103,973$44K
2017$4.42B103,567$43K
2016$4.20B102,953$41K
2015$4.07B102,429$40K
2014$3.87B102,055$38K
2013$3.76B101,819$37K
2012$3.67B101,401$36K
2011$3.59B101,657$35K
2010$3.48B101,432$34K
2009$3.46B101,422$34K
2008$3.60B101,149$36K
2007$3.42B100,265$34K
2006$3.25B99,341$33K
2005$3.04B98,417$31K
2004$2.90B97,465$30K
2003$2.73B96,480$28K
2002$2.69B95,771$28K
2001$2.59B94,872$27K
2000$2.43B94,050$26K
1999$2.26B92,914$24K
1998$2.17B91,697$24K
1997$2.06B90,710$23K
1996$1.90B89,357$21K
1995$1.82B87,584$21K
1994$1.71B85,586$20K
1993$1.55B84,234$18K
1992$1.46B83,253$18K
1991$17K

NFIP FLOOD CLAIMS

FEMA National Flood Insurance Program (NFIP) realised flood loss claims in Franklin County.

FEMA NFIP redacted claims (nfip_claim, county_code)

2026-03-17$0No
2025-05-19$0Yes
2024-11-08$14K$9K$5KNo
2024-11-08$42K$28K$14KNo
2024-11-08$2K$2K$0Yes
2024-11-08$0$0$0No
2024-11-08$58K$58K$0Yes
2024-11-07$52K$41K$11KNo
2024-11-07$11K$11K$0Yes
2024-11-06$11K$10K$1KYes
2024-11-06$11K$11K$112.56No
2024-11-06$19K$15K$5KYes
2024-11-05$337K$273K$63KNo
2024-11-05$26K$23K$3KNo
2024-11-05$70K$18K$52KNo
2024-11-05$9K$7K$2KYes
2024-11-05$36K$30K$6KNo
2024-11-05$22K$21K$1KNo
2024-11-05$37K$33K$4KNo
2024-07-16$20K$20K$0Yes
2023-04-15$2K$2K$0Yes
2019-08-30$1K$1K$0Yes
2019-05-02$5K$5K$0Yes
2019-04-25$0No
2019-02-25$0Yes
2017-05-09$8K$8K$0No
2017-05-06$6K$6K$0Yes
2017-05-05$33K$33K$0Yes
2017-05-05$64K$64K$0No
2017-05-05$34K$29K$5KYes
2017-05-04$117K$90K$0Yes
2017-05-04$32K$32K$229.6No
2017-05-04$52K$52K$0No
2017-05-03$27K$27K$0No
2017-05-03$0No
2017-05-03$35K$35K$0No
2017-05-03$17K$17K$0No
2017-05-02$1.0M$500K$500KNo
2017-05-02$77K$77K$0No
2017-05-02$2K$2K$0No
2017-05-02$25K$25K$0Yes
2017-05-02$9K$7K$1KNo
2017-05-02$7K$7K$0No
2017-05-02$6K$6K$0No
2017-05-02$110K$110K$0No
2017-05-02$41K$41K$0No
2017-05-02$12K$12K$0No
2017-05-02$12K$12K$0No
2017-05-02$51K$51K$0No
2017-05-02$15K$15K$0Yes
2017-05-02$4K$4K$0No
2017-05-02$21K$21K$0No
2017-05-02$2K$2K$0No
2017-05-02$28K$28K$0Yes
2017-05-02$33K$33K$0Yes
2017-05-02$15K$15K$0No
2017-05-02$21K$21K$0No
2017-05-02$12K$12K$0No
2017-05-02$9K$9K$0No
2017-05-02$37K$37K$0No
2017-05-02$17K$17K$0No
2017-05-02$70K$50K$20KNo
2017-05-02$11K$11K$0No
2017-05-02$0Yes
2017-05-02$100K$100K$0No
2017-05-02$34K$30K$3KNo
2017-05-02$93K$93K$0No
2017-05-02$0No
2017-05-02$110K$110K$0No
2017-05-02$4K$4K$0No
2017-05-02$5K$5K$0Yes
2017-05-02$65K$65K$0No
2017-05-02$37K$37K$0No
2017-05-02$59K$44K$15KYes
2017-05-02$7K$7K$0No
2017-05-01$29K$29K$0Yes
2017-05-01$12K$12K$0Yes
2017-05-01$1K$1K$0Yes
2017-05-01$26K$20K$6KNo
2017-05-01$133K$103K$0Yes
2017-05-01$60K$60K$0No
2017-05-01$10K$10K$0No
2017-05-01$114K$114K$0No
2017-05-01$35K$35K$0No
2017-05-01$202K$202K$0No
2017-05-01$2K$2K$0No
2017-05-01$4K$4K$0No
2017-05-01$3K$3K$0No
2017-05-01$56K$56K$0No
2017-05-01$7K$4K$3KYes
2017-05-01$5K$5K$0No
2017-05-01$7K$7K$0Yes
2017-05-01$35K$23K$12KNo
2017-05-01$106K$102K$5KNo
2017-05-01$44K$31K$13KNo
2017-05-01$31K$24K$7KYes
2017-05-01$24K$19K$5KNo
2017-05-01$619.26$619.26$0No
2017-05-01$2K$0$2KYes
2017-05-01$29K$19K$10KNo

ALSO CHECKED

18 more data areas were checked for Franklin County and did not earn a tab. A missing tab and an unasked question look the same on screen, so each one is named with the reason it is missing.

  • WRONG GRAIN
    FHA

    FHA Neighborhood Watch DOES publish county rows, but keys them on a free-text county NAME (“CHITTENDEN|VT”), not a FIPS code, and the single-family endorsement snapshot's property_county is likewise free text. Joining either to a county FIPS by name would attribute one county's delinquency to another wherever a name repeats, so FHA is a state-grain tab only until a curated name→FIPS crosswalk exists

  • WRONG GRAIN
    Fannie / Freddie

    the FHFA public-use database publishes single-family acquisitions at STATE and CENSUS-TRACT grain; no county rollup is published or loaded, and rolling tracts up to counties would double-count the tracts that straddle a county line

  • WRONG GRAIN
    GSE credit-risk transfer

    CAS and STACR loan-level disclosures publish PROPERTY STATE and a 3-digit zip; neither carries a county code, so credit-risk-transfer collateral cannot be attributed to a county

  • WRONG GRAIN
    Ginnie Mae

    Ginnie Mae's loan-level disclosure publishes PROPERTY STATE and nothing finer — there is no county, ZIP or tract field in the file, so agency-pool collateral has no county grain at all. The same is true of the UMBS pool file (fhfa_mbs_pool), which carries only CA/NY/FL/TX/PR concentration percentages

  • WRONG GRAIN
    Housing finance agency

    a housing finance agency is a STATE-chartered body — county is not a grain it has. Its programmes reach counties, but the agency itself is one row per state: hfa_agency is keyed on state_code and carries no county column, and there is no county-level agency underneath it to aggregate from

  • WRONG GRAIN
    CUSO network

    the NCUA CUSO Registry publishes a CUSO's city and STATE and no county at all (cuso_registry, migration 0195). A county FIPS does exist on the member-credit-union side (cuso_credit_union_link.cu_county_fips), but it is the CREDIT UNION'S CHARTER ADDRESS — where the institution is registered, not where the mortgage service it buys is delivered — so a county tab built on it would pin a statewide, often multi-state, service relationship onto the one county a charter document happens to name

  • WRONG GRAIN
    Subservicing map

    the same absence, one grain finer: subservicing_relationships holds no property or collateral column at all, so there is nothing to aggregate to a county. Where a client is a state HFA, the state housing finance agency area on this hub carries that agency and its named master servicer at its own state grain

  • WRONG GRAIN
    Co-issue MSR

    the same absence, and worse at county grain: Ginnie's loan-level disclosure publishes property STATE and nothing finer — no county, ZIP or tract field exists in the file — so even the collateral split that is rejected above at state grain is not available here at all

  • WRONG GRAIN
    MSR transfer graph

    the same absence at a finer grain, with no additional route to one: ginnie_servicing_transfers has no county column and the Ginnie loan-level disclosure it would have to be joined to publishes property state and nothing finer — no county, ZIP or tract field exists in either file

  • WRONG GRAIN
    Builder & realtor JV

    the same absence, one grain finer: the affiliation corpus has no geographic column at all, so nothing can be aggregated to a county. The affiliate lender's actual county-level originations are on the HMDA area of the county hub, keyed on the lender rather than on its parent

  • WRONG GRAIN
    Non-QM deal calendar

    the same structural gap, one grain finer: a 144A non-QM deal publishes no asset-level file at all, so there is no loan, no property and therefore no county to attribute anything to. This is the one absence on this hub that no future load can close

  • WRONG GRAIN
    Agency-MBS demand

    the same absence, and Ginnie's disclosure has no county field at any grain, so even the collateral allocation that is rejected above at state grain cannot be computed here

  • WRONG GRAIN
    Complaints-rate stack

    the same broken denominator, plus a numerator that does not reach county either: the CFPB publishes a complaint's state and a partially redacted ZIP and no county, so neither half of this ratio exists at county grain

  • WRONG GRAIN
    NMLS licensing

    NMLS licences are issued by a STATE regulator and the industry report is published by state agency and quarter; there is no county in the licensing system to aggregate to

  • WRONG GRAIN
    CFPB complaints

    the CFPB publishes a complaint's STATE and a partially redacted ZIP; it publishes no county, and deriving one from a redacted ZIP would put complaints in the wrong county wherever a ZIP straddles a county line

  • WRONG GRAIN
    State enforcement

    enforcement orders are issued by a STATE regulator against a licensee; they carry no property or county

  • WRONG GRAIN
    WARN notices

    a WARN notice names an employer, a CITY and a region — no county code — and matching city to county by name is ambiguous in most states

  • WRONG GRAIN
    Mortgage employment

    the QCEW extract loaded here holds STATE and METRO area types only — the county-level QCEW file is a separate, far larger download that is not loaded, so county mortgage employment cannot be shown honestly

Several of the areas above are published only at state grain. They are all on the MO state hub, which carries the same registry at the grain those sources actually have.

Go deeper

EVERY HMDA RECORD IN FRANKLIN COUNTYOpens the loan explorer already filtered to county FIPS 29071.

See the Missouri state market profile for the statewide picture, the Missouri state hub for every dataset we hold on the state in one place, or the national lender leaderboard for who is largest across every market.

Sources: HMDA public loan-level disclosure (CFPB/FFIEC) aggregated to county-year; U.S. Census Bureau American Community Survey; FEMA National Risk Index and disaster declarations. Figures are as loaded — see data attribution.

Fair-lending context: denial rates and demographic figures shown here are descriptive statistics derived from public HMDA and U.S. Census data. HMDA does not contain the credit, income, or underwriting variables that explain most lending outcomes, so a difference between lenders or areas is a statistical observation about published data — not evidence of, and not a determination of, discrimination or redlining by any institution.