Skip to main content

Side-by-side

Columbia, IL vs Lemay, MO

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 Columbia, Illinois, and its county
No photograph · map drawn from the dataset

Illinois · Midwest

Columbia, IL

Remove

Average score

46/100

Population
10,919
Median home
$293,000
Map of Lemay, Missouri, and its county
No photograph · map drawn from the dataset

Missouri · Great Plains

Lemay, MO

Remove

Average score

57/100

Population
16,228
Median home
$152,200

Where they differ

The 5 measures with the widest gap between the scores.

  • Performing arts & museums76 apart
  • Cultural amenities60 apart
  • Drinking water56 apart
  • Educated population54 apart
  • Health care access53 apart

A · ColumbiaB · Lemay

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, Lemay, grouped by category
MeasureColumbia, ILLemay, MO

Cost & Taxes

5266
Affordability6262
Housing cost7199
Low state taxes4648
Low property tax3056
What’s measured

Affordability

What is measured for Affordability: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Price levelU.S. average = 100, BEA 202495.195.1
Measured forSt. Louis, MO-IL metro areaSt. Louis, MO-IL metro area
Housing rents price level7979

Housing cost

What is measured for Housing cost: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Median home$293,000$152,200
Price-to-income2.7×2.5×
Median rent$1,128/mo$881/mo

Low state taxes

What is measured for Low state taxes: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
State income taxFlat 4.95%Top rate 4.7%
Sales tax8.89%6.25% state + 2.64% average local8.41%4.22% state + 4.18% average local

Low property tax

What is measured for Low property tax: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Effective property tax rate1.83% of home value1.27% of home value

Work & Economy

6059
Job market8283
Remote-work infrastructure7777
Growing community2018
What’s measured

Job market

What is measured for Job market: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Unemployment rate3.1%3%

Remote-work infrastructure

What is measured for Remote-work infrastructure: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Households with a broadband subscriptionCensus ACS94%93.8%

Growing community

What is measured for Growing community: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Population change since 2020-0.8%-1.1%

Climate & Weather

4950
Warm climate5555
Cool climate4545
Four seasons100100
Sunshine3838
Low humidity1116
Winter daylight4746
What’s measured

Warm climate

What is measured for Warm climate: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
January high40.7°F40.7°F
July high88.5°F88.5°F
NOAA 1991–2020 normals stationCahokia, IL, 7.6 miCahokia, IL, 5.4 mi

Cool climate

What is measured for Cool climate: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
January high40.7°F40.7°F
July high88.5°F88.5°F
NOAA 1991–2020 normals stationCahokia, IL, 7.6 miCahokia, IL, 5.4 mi

Four seasons

What is measured for Four seasons: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
January high40.7°F40.7°F
July high88.5°F88.5°F
NOAA 1991–2020 normals stationCahokia, IL, 7.6 miCahokia, IL, 5.4 mi

Sunshine

What is measured for Sunshine: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Share of possible sunshine received57%57%
NOAA station (period of record)ST. LOUIS, MO, 22 miST. LOUIS, MO, 16 mi

Low humidity

What is measured for Low humidity: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
July mean dew point68.6°F66.8°F
NOAA hourly-normals stationBelleville Siu Rsch, IL, 20 miSt Louis Lambert INTL AP, MO, 16 mi
Annual rainfall42.8 in42.8 in

Lower is drier.

Winter daylight

What is measured for Winter daylight: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Daylight at the December solstice, hours9.59.5

Nature & Environment

2646
Outdoor recreation1729
Public land access030
Near the ocean or a Great Lake66
Air quality6367
Drinking water44100
What’s measured

Outdoor recreation

What is measured for Outdoor recreation: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Open public land in the countyPAD-US 4.01.7%5.6%
Near mountainsNoNo
Elevation, ftUSGS 3DEP464486
Terrain relief within 20 mi, fthighest point of the ring minus the place134293
Terrain relief within 40 mi, fthighest point of the ring minus the place437398
Nearest coast, miNatural Earth coastline266Great Lakes263Great Lakes
Within 30 miles of the coastNoNo

Public land access

What is measured for Public land access: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Open public land in the countyPAD-US 4.01.7%5.6%

Near the ocean or a Great Lake

What is measured for Near the ocean or a Great Lake: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Nearest coast, miNatural Earth coastline266Great Lakes263Great Lakes
Within 30 miles of the coastNoNo

Air quality

What is measured for Air quality: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Annual median AQI4643
Air quality from the nearest monitorSt. Clair County, 19 miunknown

Lower is cleaner.

Drinking water

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

Regulatory violations, not taste or hardness.

Safety & Health

4169
Low crimeunknownunknown
Low disaster risk4145
Health care access4093
What’s measured

Low crime

What is measured for Low crime: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Low crime rateunknownunknown

Low disaster risk

What is measured for Low disaster risk: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Expected property loss$1,480 per $1M of property per year$1,415 per $1M of property per year
Overall riskVery Low42/100Relatively High (99/100)
Heat waveunknownVery High, about 15 events a year
Winter weatherunknownVery High, about 8.7 events a year
Inland floodingunknownRelatively High, about 2.8 events a year
EarthquakeunknownRelatively High, 0.54% chance a year
TornadounknownRelatively High, 41% chance a year

Health care access

What is measured for Health care access: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Physicians per 100k residents (county)74561
Primary-care physicians per 100k32124
Hospital beds per 100k0372
Nearest hospitalMercy Hospital South, Saint Louis, 9.5 miMercy Hospital South, Saint Louis, 5.3 mi
Nearest hospital rated 3+ starsBarnes Jewish Hospital, Saint Louis, 12 mi (4 stars)Barnes Jewish Hospital, Saint Louis, 6.4 mi (4 stars)
Hospitals within 30 mi1922
Best rating within 30 mi5 of 5 stars5 of 5 stars

Getting Around

5469
Walkability3167
Public transit128
Short commutes5465
Airport access8387
Close to a major city100100
What’s measured

Walkability

What is measured for Walkability: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Walkability indexEPA Smart Location Database8.1 of 2012.8 of 20

Public transit

What is measured for Public transit: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Transit service near homesEPA Smart Location Database0.1 trips an hour at evening peak2.9 trips an hour at evening peak
Typical distance to a transit stop, munknown517

Short commutes

What is measured for Short commutes: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Mean commute, min2624
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, Lemay
Measure A: Columbia, IL B: Lemay, MO
Scheduled airports within 60 mi22
Nearest airport with scheduled serviceBLV, 22 miSTL, 16 mi
Nearest large airportSTL, 22 miSTL, 16 mi

Close to a major city

What is measured for Close to a major city: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Nearest metro of 1M+ peopleSt. Louis, MO12 mi straight-lineSt. Louis, MO8 mi straight-line

Amenities & Entertainment

4172
Cultural amenities3393
Performing arts & museums076
Golf course access8946
What’s measured

Cultural amenities

What is measured for Cultural amenities: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Arts, entertainment & recreation establishments (county)24484
Restaurants & food-service establishments (county)772,075
Population10,91916,228
Pro sportsMLB, NHL, MLSother leagues not knownMLB, NHL, MLSother leagues not known
Power-4 college sportsNonone within 30 milesNonone within 30 miles
Performing-arts companies in the county026
Event promoters in the county023
Museums and historic sites in the county016

Performing arts & museums

What is measured for Performing arts & museums: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Performing-arts companies in the county026
Event promoters in the county023
Museums and historic sites in the county016

Golf course access

What is measured for Golf course access: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Golf courses and country clubs in the county5 establishments31 establishments
Golf courses per 100,000 county residents14.23.1

Community & People

4741
Small-town feel9489
Big-city feel48
Younger community4064
Older community6036
Diversity1335
Educated population7016
Conservative community7929
Progressive community2171
Religious community4222
What’s measured

Small-town feel

What is measured for Small-town feel: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Population10,91916,228

Big-city feel

What is measured for Big-city feel: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Population10,91916,228

Younger community

What is measured for Younger community: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Median age, yrs42.436.7

Older community

What is measured for Older community: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Median age, yrs42.436.7
Residents aged 65+16.5%15%

Diversity

What is measured for Diversity: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Diversity index (0–1)0.130.35
Population10,91916,228
LGBTQ+ friendlinessunknownunknown

Educated population

What is measured for Educated population: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Adults with a bachelor's degree or higher49%20.4%

Conservative community

What is measured for Conservative community: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
GOP vote share67.3%37.4%

Progressive community

What is measured for Progressive community: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
GOP vote share67.3%37.4%

Religious community

What is measured for Religious community: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Congregations per 100k county residents100.169
Congregations in the county (all faiths)35693
Adherents of all faiths57% of residents51% of residents

Families & Schools

4782
Education5978
Private school selection3885
Affordable childcare43unknown
Childcare availabilityunknownunknown
What’s measured

Education

What is measured for Education: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Pupil-teacher ratiocounty figure15.612.3
Per-pupil spending$14,400$14,700
UniversitySaint Louis University, 12 mi · 18,000 studentsSaint Louis University, 7.6 mi · 18,000 students
College townNoNo

Private school selection

What is measured for Private school selection: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Private schools per 100k5.712.7

Affordable childcare

What is measured for Affordable childcare: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
Infant carestate median, 2022$278/wkunknown

Childcare availability

What is measured for Childcare availability: Columbia, Lemay
Measure A: Columbia, IL B: Lemay, MO
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, Lemay
FigureColumbia, ILLemay, MO
Population10,91916,228
Price Level (BEA RPP)95.1 (avg=100)95.1 (avg=100)
Median Home Price$293,000$152,200
Median Rent / mo$1,128$881
State Income Tax (top)4.95%4.7%
Sales Tax (state + avg local)8.89%8.41%
Unemployment Rate3.1%3%
Broadband Subscription94%94%
Coworking / 100kunknownunknown
Violent Crimes / 100k (FBI)unknownunknown
Property Crimes / 100k (FBI)unknownunknown
Jan High (°F)40.7°F40.7°F
Jul High (°F)88.5°F88.5°F
Possible Sunshine57%57%
July Dew Point (°F)68.6°F66.8°F
Annual Snow (in)13.8"13.8"
Annual Rain (in)42.8"42.8"
Annual AQI4643
Physicians / 100k (county)74561
Hospital Beds / 100k0372
Miles to 3+ Star Hospital12 mi6.4 mi
Residents on a system w/ violation17%0%
Walkability Index (EPA)8.1/2012.8/20
Transit Trips / hour0.12.9
Avg Commute (min)26.4 min23.7 min
Congestion Delay (h/yr)unknownunknown
Major Airports (60 mi)22
Public Land % (county)2%6%
Miles to the Coast (ocean or Great Lakes)266 mi263 mi
Elevation (USGS 3DEP)464 ft486 ft
Terrain Relief within 20 mi134 ft293 ft
Terrain Relief within 40 mi437 ft398 ft
Golf Courses / 100k (county)14.23.1
Performing-Arts Companies (county)026
Event Promoters (county)023
Museums & Historic Sites (county)016
Weekly Childcare Cost$278.33unknown
Childcare Desert %unknownunknown
Private Schools / 100k5.712.7
Congregations / 100k (county)10069
Adherents / 1,000 (county)573507
GOP Vote Share67%37%
Median Age42.4 yrs36.7 yrs
Pop. Change Since 2020-0.8%-1.1%
Bachelor's Degree+49%20%
Miles to Nearest 1M+ Metro12 mi8 mi
Winter Daylight (hrs)9.59.5
Near MountainsNoNo
College TownNoNo
Columbia, IL vs Lemay, MO