Skip to main content

Side-by-side

Columbia, SC vs St. Andrews, SC

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 St. Andrews, South Carolina, and its county
No photograph · map drawn from the dataset

South Carolina · Southeast

St. Andrews, SC

Remove

Average score

55/100

Population
19,868
Median home
$161,300

Where they differ

The 5 measures with the widest gap between the scores.

  • Educated population38 apart
  • Low crime28 apart
  • Small-town feel23 apart
  • Housing cost22 apart
  • Younger community20 apart

A · ColumbiaB · St. Andrews

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, St. Andrews, grouped by category
MeasureColumbia, SCSt. Andrews, SC

Cost & Taxes

6873
Affordability6666
Housing cost7597
Low state taxes4545
Low property tax8583
What’s measured

Affordability

What is measured for Affordability: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Price levelU.S. average = 100, BEA 202493.793.7
Measured forColumbia, SC metro areaColumbia, SC metro area
Housing rents price level79.579.5

Housing cost

What is measured for Housing cost: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Median home$264,300$161,300
Price-to-income4.8×3.5×
Median rent$1,204/mo$1,088/mo

Low state taxes

What is measured for Low state taxes: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
State income taxTop rate 6%Top rate 6%
Sales tax7.5%6% state + 1.5% average local7.5%6% state + 1.5% average local

Low property tax

What is measured for Low property tax: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Effective property tax rate0.64% of home value0.67% of home value

Work & Economy

7064
Job market8383
Remote-work infrastructure6463
Growing community6247
What’s measured

Job market

What is measured for Job market: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Unemployment rate3%3%

Remote-work infrastructure

What is measured for Remote-work infrastructure: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Households with a broadband subscriptionCensus ACS88.5%88.1%

Growing community

What is measured for Growing community: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Population change since 2020+5.8%+3.5%

Climate & Weather

5049
Warm climate8087
Cool climate2013
Four seasons7170
Sunshine5353
Low humidity77
Winter daylight6666
What’s measured

Warm climate

What is measured for Warm climate: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
January high56.3°F59.6°F
July high92.5°F95.6°F
NOAA 1991–2020 normals stationSandhill Rsch - Elgin, SC, 6.6 miColumbia Univ Of Sc, SC, 6.2 mi

Cool climate

What is measured for Cool climate: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
January high56.3°F59.6°F
July high92.5°F95.6°F
NOAA 1991–2020 normals stationSandhill Rsch - Elgin, SC, 6.6 miColumbia Univ Of Sc, SC, 6.2 mi

Four seasons

What is measured for Four seasons: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
January high56.3°F59.6°F
July high92.5°F95.6°F
NOAA 1991–2020 normals stationSandhill Rsch - Elgin, SC, 6.6 miColumbia Univ Of Sc, SC, 6.2 mi

Sunshine

What is measured for Sunshine: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Share of possible sunshine received64%64%
NOAA station (period of record)COLUMBIA, SC, 14 miCOLUMBIA, SC, 7.1 mi

Low humidity

What is measured for Low humidity: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
July mean dew point69.8°F69.8°F
NOAA hourly-normals stationColumbia, SC, 14 miColumbia, SC, 7.1 mi
Annual rainfall46.3 in48.1 in

Lower is drier.

Winter daylight

What is measured for Winter daylight: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Daylight at the December solstice, hours9.99.9

Nature & Environment

3029
Outdoor recreation2525
Public land access1212
Near the ocean or a Great Lake4341
Air quality6161
Drinking water88
What’s measured

Outdoor recreation

What is measured for Outdoor recreation: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Open public land in the countyPAD-US 4.03%3%
Near mountainsNoNo
Elevation, ftUSGS 3DEP323314
Terrain relief within 20 mi, fthighest point of the ring minus the place310250
Terrain relief within 40 mi, fthighest point of the ring minus the place101195
Nearest coast, miNatural Earth coastline99ocean105ocean
Within 30 miles of the coastNoNo

Public land access

What is measured for Public land access: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Open public land in the countyPAD-US 4.03%3%

Near the ocean or a Great Lake

What is measured for Near the ocean or a Great Lake: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Nearest coast, miNatural Earth coastline99ocean105ocean
Within 30 miles of the coastNoNo

Air quality

What is measured for Air quality: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Annual median AQI4747

Lower is cleaner.

Drinking water

What is measured for Drinking water: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Share of residents on a system with a recent health-based violation, 2023–2025 (lower scores higher)90.3%90.3%
Health-based violations per 10,000 people served0.20.2
Community water systems counted (county)3030

Regulatory violations, not taste or hardness.

Safety & Health

6474
Low crime3563
Low disaster risk6969
Health care access8889
What’s measured

Low crime

What is measured for Low crime: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Violent crime791 per 100,000 residents (city police agency)455.8 per 100,000 residents (county sheriff, county level)
Property crime3,156.7 per 100,000 residents (city police agency)1,797 per 100,000 residents (county sheriff, county level)
SourceFBI Crime Data API, 2025: Columbia Police Department (city police agency)FBI Crime Data API, 2025: Richland County Sheriff's Office (county sheriff, county level)

Low disaster risk

What is measured for Low disaster risk: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Expected property loss$1,107 per $1M of property per year$1,107 per $1M of property per year
Overall riskRelatively Moderate (93/100)Relatively Moderate (93/100)
TornadoRelatively High, 56% chance a yearRelatively High, 56% chance a year
Inland floodingRelatively High, about 3.8 events a yearRelatively High, about 3.8 events a year
HurricaneRelatively High, 19% chance a yearRelatively High, 19% chance a year
Winter weatherRelatively High, about 1.9 events a yearRelatively High, about 1.9 events a year

Health care access

What is measured for Health care access: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Physicians per 100k residents (county)376376
Primary-care physicians per 100k8080
Hospital beds per 100k303303
Nearest hospitalMUSC Health Columbia Medical Center Downtown, 6.3 miLexington Medical Center, West Columbia, 3.7 mi
Nearest hospital rated 3+ starsMUSC Health Columbia Medical Center Downtown, 6.3 mi (3 stars)Lexington Medical Center, West Columbia, 3.7 mi (3 stars)
Hospitals within 30 mi65
Best rating within 30 mi4 of 5 stars4 of 5 stars

Getting Around

6161
Walkability6165
Public transit4531
Short commutes6773
Airport access6264
Close to a major city7171
What’s measured

Walkability

What is measured for Walkability: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Walkability indexEPA Smart Location Database11.9 of 2012.4 of 20

Public transit

What is measured for Public transit: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Transit service near homesEPA Smart Location Database7.6 trips an hour at evening peak3.3 trips an hour at evening peak
Typical distance to a transit stop, m497658

Short commutes

What is measured for Short commutes: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Mean commute, min1822
CongestionTTI, Columbia SC48 hours of delay per commuter per yearNot measured here; the score uses commute time alone

Airport access

What is measured for Airport access: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Scheduled airports within 60 mi11
Nearest airport with scheduled serviceCAE, 14 miCAE, 7.9 mi
Nearest large airportCLT, 81 miCLT, 81 mi

Close to a major city

What is measured for Close to a major city: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Nearest metro of 1M+ peopleCharlotte, NC82 mi straight-lineCharlotte, NC83 mi straight-line

Amenities & Entertainment

6060
Cultural amenities8282
Performing arts & museums6464
Golf course access3535
What’s measured

Cultural amenities

What is measured for Cultural amenities: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Arts, entertainment & recreation establishments (county)128128
Restaurants & food-service establishments (county)829829
Population144,78819,868
Pro sportsunknownunknown
Power-4 college sportsYes, South Carolina (7.6 mi)Yes, South Carolina (5.9 mi)
Performing-arts companies in the county1717
Event promoters in the county1313
Museums and historic sites in the county33

Performing arts & museums

What is measured for Performing arts & museums: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Performing-arts companies in the county1717
Event promoters in the county1313
Museums and historic sites in the county33

Golf course access

What is measured for Golf course access: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Golf courses and country clubs in the county8 establishments8 establishments
Golf courses per 100,000 county residents1.91.9

Community & People

5247
Small-town feel6487
Big-city feel3210
Younger community9878
Older community222
Diversity6047
Educated population6426
Conservative community2020
Progressive community8080
Religious community5151
What’s measured

Small-town feel

What is measured for Small-town feel: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Population144,78819,868

Big-city feel

What is measured for Big-city feel: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Population144,78819,868

Younger community

What is measured for Younger community: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Median age, yrs28.633.2

Older community

What is measured for Older community: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Median age, yrs28.633.2
Residents aged 65+11.5%13.8%

Diversity

What is measured for Diversity: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Diversity index (0–1)0.600.47
Population144,78819,868
LGBTQ+ friendlinessunknownunknown

Educated population

What is measured for Educated population: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Adults with a bachelor's degree or higher45.9%25.7%

Conservative community

What is measured for Conservative community: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
GOP vote share31.8%31.8%

Progressive community

What is measured for Progressive community: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
GOP vote share31.8%31.8%

Religious community

What is measured for Religious community: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Congregations per 100k county residents119.4119.4
Congregations in the county (all faiths)497497
Adherents of all faiths57% of residents57% of residents

Families & Schools

6464
Education8181
Private school selection3939
Affordable childcare7272
Childcare availabilityunknownunknown
What’s measured

Education

What is measured for Education: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Pupil-teacher ratiocounty figure13.313.3
Per-pupil spending$17,000$17,000
UniversityUniversity of South Carolina-Columbia, 7.6 mi · 36,300 studentsUniversity of South Carolina-Columbia, 5.9 mi · 36,300 students
College townNoNo

Private school selection

What is measured for Private school selection: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Private schools per 100k5.85.8

Affordable childcare

What is measured for Affordable childcare: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Infant carestate median, 2022$199/wk$199/wk

Childcare availability

What is measured for Childcare availability: Columbia, St. Andrews
Measure A: Columbia, SC B: St. Andrews, SC
Childcare availabilityunknownunknown

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, St. Andrews
FigureColumbia, SCSt. Andrews, SC
Population144,78819,868
Price Level (BEA RPP)93.7 (avg=100)93.7 (avg=100)
Median Home Price$264,300$161,300
Median Rent / mo$1,204$1,088
State Income Tax (top)6%6%
Sales Tax (state + avg local)7.5%7.5%
Unemployment Rate3%3%
Broadband Subscription89%88%
Coworking / 100kunknownunknown
Violent Crimes / 100k (FBI)791455.8
Property Crimes / 100k (FBI)3,156.71,797
Jan High (°F)56.3°F59.6°F
Jul High (°F)92.5°F95.6°F
Possible Sunshine64%64%
July Dew Point (°F)69.8°F69.8°F
Annual Snow (in)0.4"0.2"
Annual Rain (in)46.3"48.1"
Annual AQI4747
Physicians / 100k (county)376376
Hospital Beds / 100k303303
Miles to 3+ Star Hospital6.3 mi3.7 mi
Residents on a system w/ violation90%90%
Walkability Index (EPA)11.9/2012.4/20
Transit Trips / hour7.63.3
Avg Commute (min)17.7 min21.8 min
Congestion Delay (h/yr)48 hunknown
Major Airports (60 mi)11
Public Land % (county)3%3%
Miles to the Coast (ocean or Great Lakes)99 mi105 mi
Elevation (USGS 3DEP)323 ft314 ft
Terrain Relief within 20 mi310 ft250 ft
Terrain Relief within 40 mi101 ft195 ft
Golf Courses / 100k (county)1.91.9
Performing-Arts Companies (county)1717
Event Promoters (county)1313
Museums & Historic Sites (county)33
Weekly Childcare Cost$198.93$198.93
Childcare Desert %unknownunknown
Private Schools / 100k5.85.8
Congregations / 100k (county)119119
Adherents / 1,000 (county)566566
GOP Vote Share32%32%
Median Age28.6 yrs33.2 yrs
Pop. Change Since 2020+5.8%+3.5%
Bachelor's Degree+46%26%
Miles to Nearest 1M+ Metro82 mi83 mi
Winter Daylight (hrs)9.99.9
Near MountainsNoNo
College TownNoNo
Columbia, SC vs St. Andrews, SC