Skip to main content

Side-by-side

Columbia, TN vs Fairview, TN

Scores are 0–100, higher is better. “Best in row” marks the one place with the highest score on a measure.

The plates show each place’s average across every measure. Take the two-minute survey to see your own fit →

Map of Fairview, Tennessee, and its county
No photograph · map drawn from the dataset

Tennessee · Southeast

Fairview, TN

Remove

Average score

53/100

Population
10,535
Median home
$390,200

Where they differ

The 5 measures with the widest gap between the scores.

  • Drinking water66 apart
  • Performing arts & museums52 apart
  • Cultural amenities43 apart
  • Short commutes36 apart
  • Religious community36 apart

A · ColumbiaB · Fairview

The full table

Scores are 0–100, higher is better. Best in row marks the one highest score; equal scores are not marked.

Scores for Columbia, Fairview, grouped by category
MeasureColumbia, TNFairview, TN

Cost & Taxes

7269
Affordability5959
Housing cost6958
Low state taxes6868
Low property tax9192
What’s measured

Affordability

What is measured for Affordability: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Price levelU.S. average = 100, BEA 202496.396.3
Measured forNashville-Davidson--Murfreesboro--Franklin, TN metro areaNashville-Davidson--Murfreesboro--Franklin, TN metro area
Housing rents price level104.6104.6

Housing cost

What is measured for Housing cost: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Median home$308,700$390,200
Price-to-income4.8×4.3×
Median rent$1,197/mo$1,301/mo

Low state taxes

What is measured for Low state taxes: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
State income taxNo state income taxNo state income tax
Sales tax9.56%7% state + 2.56% average local9.56%7% state + 2.56% average local

Low property tax

What is measured for Low property tax: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Effective property tax rate0.5% of home value0.47% of home value

Work & Economy

8488
Job market8690
Remote-work infrastructure6675
Growing community100100
What’s measured

Job market

What is measured for Job market: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Unemployment rate2.8%2.5%

Remote-work infrastructure

What is measured for Remote-work infrastructure: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Households with a broadband subscriptionCensus ACS91.1%93.1%
Coworking spaces per 100k2unknown

Growing community

What is measured for Growing community: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Population change since 2020+17.3%+12.2%

Climate & Weather

4949
Warm climate6569
Cool climate3531
Four seasons8688
Sunshine3333
Low humidity1313
Winter daylight5958
What’s measured

Warm climate

What is measured for Warm climate: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
January high47.9°F49.5°F
July high88.8°F90.8°F
NOAA 1991–2020 normals stationColumbia 3 Wnw, TN, 3.3 miKingston Springs, TN, 8.4 mi

Cool climate

What is measured for Cool climate: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
January high47.9°F49.5°F
July high88.8°F90.8°F
NOAA 1991–2020 normals stationColumbia 3 Wnw, TN, 3.3 miKingston Springs, TN, 8.4 mi

Four seasons

What is measured for Four seasons: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
January high47.9°F49.5°F
July high88.8°F90.8°F
NOAA 1991–2020 normals stationColumbia 3 Wnw, TN, 3.3 miKingston Springs, TN, 8.4 mi

Sunshine

What is measured for Sunshine: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Share of possible sunshine received55%55%
NOAA station (period of record)NASHVILLE, TN, 40 miNASHVILLE, TN, 26 mi

Low humidity

What is measured for Low humidity: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
July mean dew point68°F68°F
NOAA hourly-normals stationNashville INTL AP, TN, 40 miNashville INTL AP, TN, 26 mi
Annual rainfall56.8 in50.6 in

Lower is drier.

Winter daylight

What is measured for Winter daylight: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Daylight at the December solstice, hours9.79.7

Nature & Environment

3923
Outdoor recreation1615
Public land access00
Near the ocean or a Great Lake00
Air quality8167
Drinking water10034
What’s measured

Outdoor recreation

What is measured for Outdoor recreation: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Open public land in the countyPAD-US 4.00.2%0.5%
Near mountainsNoNo
Elevation, ftUSGS 3DEP642858
Terrain relief within 20 mi, fthighest point of the ring minus the place3500
Terrain relief within 40 mi, fthighest point of the ring minus the place2580
Nearest coast, miNatural Earth coastline342ocean366ocean
Within 30 miles of the coastNoNo

Public land access

What is measured for Public land access: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Open public land in the countyPAD-US 4.00.2%0.5%

Near the ocean or a Great Lake

What is measured for Near the ocean or a Great Lake: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Nearest coast, miNatural Earth coastline342ocean366ocean
Within 30 miles of the coastNoNo

Air quality

What is measured for Air quality: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Annual median AQI3343

Lower is cleaner.

Drinking water

What is measured for Drinking water: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Share of residents on a system with a recent health-based violation, 2023–2025 (lower scores higher)0%30.5%
Health-based violations per 10,000 people served0.00.0
Community water systems counted (county)47

Regulatory violations, not taste or hardness.

Safety & Health

6576
Low crime6990
Low disaster risk5665
Health care access7073
What’s measured

Low crime

What is measured for Low crime: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Violent crime370.9 per 100,000 residents (city police agency)101.8 per 100,000 residents (city police agency)
Property crime1,497.5 per 100,000 residents (city police agency)620 per 100,000 residents (city police agency)
SourceFBI Crime Data API, 2025: Columbia Police Department (city police agency)FBI Crime Data API, 2025: Fairview Police Department (city police agency)

Low disaster risk

What is measured for Low disaster risk: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Expected property loss$1,266 per $1M of property per year$1,157 per $1M of property per year
Overall riskRelatively Low79/100Relatively Moderate (85/100)
TornadoRelatively High, 55% chance a yearunknown

Health care access

What is measured for Health care access: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Physicians per 100k residents (county)170590
Primary-care physicians per 100k41136
Hospital beds per 100k18375
Nearest hospitalMaury Regional Hospital, 1.7 miTristar Horizon Medical Center, Dickson, 15 mi
Nearest hospital rated 3+ starsMaury Regional Hospital, 1.7 mi (3 stars)Tristar Horizon Medical Center, Dickson, 15 mi (3 stars)
Hospitals within 30 mi59
Best rating within 30 mi5 of 5 stars5 of 5 stars

Getting Around

4640
Walkability2517
Public transit00
Short commutes4812
Airport access6676
Close to a major city8997
What’s measured

Walkability

What is measured for Walkability: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Walkability indexEPA Smart Location Database7.3 of 206.2 of 20

Public transit

What is measured for Public transit: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Transit service near homesEPA Smart Location Database0.0 trips an hour at evening peak0.0 trips an hour at evening peak

Short commutes

What is measured for Short commutes: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Mean commute, min2837
CongestionNot measured here; the score uses commute time aloneNot measured here; the score uses commute time alone

Airport access

What is measured for Airport access: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Scheduled airports within 60 mi11
Nearest airport with scheduled serviceBNA, 41 miBNA, 27 mi
Nearest large airportBNA, 41 miBNA, 27 mi

Close to a major city

What is measured for Close to a major city: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Nearest metro of 1M+ peopleNashville, TN40 mi straight-lineNashville, TN23 mi straight-line

Amenities & Entertainment

4476
Cultural amenities4790
Performing arts & museums3587
Golf course access5152
What’s measured

Cultural amenities

What is measured for Cultural amenities: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Arts, entertainment & recreation establishments (county)31380
Restaurants & food-service establishments (county)193559
Population48,81210,535
Pro sportsNoneNFL, NHL, MLSother leagues not known
Power-4 college sportsNonone within 30 milesYes, Vanderbilt (21 mi)
Performing-arts companies in the county699
Event promoters in the county018
Museums and historic sites in the county05
Not placed in these groups by the Census (counts are lower bounds)52

Performing arts & museums

What is measured for Performing arts & museums: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Performing-arts companies in the county699
Event promoters in the county018
Museums and historic sites in the county05
Not placed in these groups by the Census (counts are lower bounds)52

Golf course access

What is measured for Golf course access: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Golf courses and country clubs in the county4 establishments10 establishments
Golf courses per 100,000 county residents3.73.8

Community & People

5146
Small-town feel7794
Big-city feel204
Younger community6980
Older community3120
Diversity5130
Educated population2544
Conservative community8676
Progressive community1424
Religious community8246
What’s measured

Small-town feel

What is measured for Small-town feel: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Population48,81210,535

Big-city feel

What is measured for Big-city feel: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Population48,81210,535

Younger community

What is measured for Younger community: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Median age, yrs35.532.7

Older community

What is measured for Older community: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Median age, yrs35.532.7
Residents aged 65+15.5%12%

Diversity

What is measured for Diversity: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Diversity index (0–1)0.510.30
Population48,81210,535
LGBTQ+ friendlinessmoderateunknown

Educated population

What is measured for Educated population: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Adults with a bachelor's degree or higher25.4%35.3%

Conservative community

What is measured for Conservative community: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
GOP vote share71.8%65.4%

Progressive community

What is measured for Progressive community: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
GOP vote share71.8%65.4%

Religious community

What is measured for Religious community: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Congregations per 100k county residents211.9108.2
Congregations in the county (all faiths)214268
Adherents of all faiths43% of residents55% of residents

Families & Schools

4947
Education2426
Private school selection4749
Affordable childcare6767
Childcare availability58unknown
What’s measured

Education

What is measured for Education: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Pupil-teacher ratiocounty figure14.415.0
Per-pupil spending$12,100$13,300
UniversityNo 4-year university within 15 miNo 4-year university within 15 mi
College townNoNo

Private school selection

What is measured for Private school selection: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Private schools per 100k7.17.4

Affordable childcare

What is measured for Affordable childcare: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Infant carestate median, 2022$212/wk$212/wk

Childcare availability

What is measured for Childcare availability: Columbia, Fairview
Measure A: Columbia, TN B: Fairview, TN
Tracts that are childcare deserts42%unknown

Raw data

The measured figures behind the scores, county or state level where the label says so. Every figure and its source is on each place’s page.

Raw figures for Columbia, Fairview
FigureColumbia, TNFairview, TN
Population48,81210,535
Price Level (BEA RPP)96.3 (avg=100)96.3 (avg=100)
Median Home Price$308,700$390,200
Median Rent / mo$1,197$1,301
State Income Tax (top)NoneNone
Sales Tax (state + avg local)9.56%9.56%
Unemployment Rate2.8%2.5%
Broadband Subscription91%93%
Coworking / 100k2.0unknown
Violent Crimes / 100k (FBI)370.9101.8
Property Crimes / 100k (FBI)1,497.5620
Jan High (°F)47.9°F49.5°F
Jul High (°F)88.8°F90.8°F
Possible Sunshine55%55%
July Dew Point (°F)68°F68°F
Annual Snow (in)0.9"1.4"
Annual Rain (in)56.8"50.6"
Annual AQI3343
Physicians / 100k (county)170590
Hospital Beds / 100k18375
Miles to 3+ Star Hospital1.7 mi15 mi
Residents on a system w/ violation0%31%
Walkability Index (EPA)7.3/206.2/20
Transit Trips / hour0.00.0
Avg Commute (min)28 min37.1 min
Congestion Delay (h/yr)unknownunknown
Major Airports (60 mi)11
Public Land % (county)0%1%
Miles to the Coast (ocean or Great Lakes)342 mi366 mi
Elevation (USGS 3DEP)642 ft858 ft
Terrain Relief within 20 mi350 ft0 ft
Terrain Relief within 40 mi258 ft0 ft
Golf Courses / 100k (county)3.73.8
Performing-Arts Companies (county)699
Event Promoters (county)018
Museums & Historic Sites (county)05
Weekly Childcare Cost$211.67$211.67
Childcare Desert %42%unknown
Private Schools / 100k7.17.4
Congregations / 100k (county)212108
Adherents / 1,000 (county)431550
GOP Vote Share72%65%
Median Age35.5 yrs32.7 yrs
Pop. Change Since 2020+17.3%+12.2%
Bachelor's Degree+25%35%
Miles to Nearest 1M+ Metro40 mi23 mi
Winter Daylight (hrs)9.79.7
Near MountainsNoNo
College TownNoNo
Columbia, TN vs Fairview, TN