Columbia MO vs Sunnyvale CA — Cost of Living, Crime & Income Comparison 2026
Updated May 2026 · Source: US Census ACS 5-Year (2023), FBI CDE (2023), BLS OEWS (2024)
Columbia, MO
Missouri · Population: 127,200
- Median HH Income$64,488
- Median Home Price$323,876
- Unemployment3.9%
- Bachelor's+56.5%
Sunnyvale, CA
California · Population: 153,455
- Median HH Income$181,862
- Median Home Price$2,144,024
- Unemployment4.1%
- Bachelor's+69.2%
Detailed Comparison
Demographics
Population
Columbia
127,200
Sunnyvale
153,455
Sunnyvale +
Pop. Density / sq mi
Lower = more space
Columbia
N/A
Sunnyvale
N/A
Median Age
Columbia
29.2
Columbia +
Sunnyvale
35.1
Foreign Born
Columbia
8.1%
Sunnyvale
49.4%
Sunnyvale +
White
Columbia
74.3%
Columbia +
Sunnyvale
30.4%
Black
Columbia
12.1%
Columbia +
Sunnyvale
1.5%
Asian
Columbia
6.1%
Sunnyvale
49.4%
Sunnyvale +
Hispanic
Columbia
4.3%
Sunnyvale
16.7%
Sunnyvale +
Spanish at Home
Columbia
N/A
Sunnyvale
N/A
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Population | 127,200 | 153,455 | Sunnyvale + |
| Pop. Density / sq miLower = more space | N/A | N/A | - |
| Median Age | 29.2 | 35.1 | Columbia + |
| Foreign Born | 8.1% | 49.4% | Sunnyvale + |
| White | 74.3% | 30.4% | Columbia + |
| Black | 12.1% | 1.5% | Columbia + |
| Asian | 6.1% | 49.4% | Sunnyvale + |
| Hispanic | 4.3% | 16.7% | Sunnyvale + |
| Spanish at Home | N/A | N/A | - |
Economy
Median HH Income
Columbia
$64,488
Sunnyvale
$181,862
Sunnyvale +
Per Capita Income
Columbia
$37,359
Sunnyvale
$95,752
Sunnyvale +
Per Capita Personal Income (MSA)
BEA MSA-level
Columbia
$58,527
Sunnyvale
$77,230
Sunnyvale +
Unemployment Rate
Columbia
3.9%
Columbia +
Sunnyvale
4.1%
Poverty Rate
Columbia
20.0%
Sunnyvale
5.6%
Sunnyvale +
Bachelor's Degree+
Columbia
56.5%
Sunnyvale
69.2%
Sunnyvale +
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Median HH Income | $64,488 | $181,862 | Sunnyvale + |
| Per Capita Income | $37,359 | $95,752 | Sunnyvale + |
| Per Capita Personal Income (MSA)BEA MSA-level | $58,527 | $77,230 | Sunnyvale + |
| Unemployment Rate | 3.9% | 4.1% | Columbia + |
| Poverty Rate | 20.0% | 5.6% | Sunnyvale + |
| Bachelor's Degree+ | 56.5% | 69.2% | Sunnyvale + |
Housing
Median Home Value
Zillow ZHVI / Census ACS
Columbia
$323,876
Columbia +
Sunnyvale
$2,144,024
Homeownership Rate
Columbia
49.4%
Columbia +
Sunnyvale
43.8%
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Median Home ValueZillow ZHVI / Census ACS | $323,876 | $2,144,024 | Columbia + |
| Homeownership Rate | 49.4% | 43.8% | Columbia + |
Safety
Violent Crime / 100K
FBI CDE (state-level est.)
Columbia
501
Columbia +
Sunnyvale
503
Property Crime / 100K
FBI CDE (state-level est.)
Columbia
2418
Sunnyvale
2388
Sunnyvale +
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Violent Crime / 100KFBI CDE (state-level est.) | 501 | 503 | Columbia + |
| Property Crime / 100KFBI CDE (state-level est.) | 2418 | 2388 | Sunnyvale + |
Health
Obesity Rate
CDC PLACES
Columbia
30.1%
Sunnyvale
19.7%
Sunnyvale +
Diabetes Rate
CDC PLACES
Columbia
8.5%
Sunnyvale
8.3%
Sunnyvale +
Poor Mental Health
CDC PLACES — 14+ days/month
Columbia
19.1%
Sunnyvale
12.9%
Sunnyvale +
No Health Insurance
CDC PLACES
Columbia
8.4%
Sunnyvale
5.2%
Sunnyvale +
Binge Drinking
CDC PLACES
Columbia
18.5%
Sunnyvale
13.5%
Sunnyvale +
Current Smokers
CDC PLACES
Columbia
12.4%
Sunnyvale
6.7%
Sunnyvale +
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Obesity RateCDC PLACES | 30.1% | 19.7% | Sunnyvale + |
| Diabetes RateCDC PLACES | 8.5% | 8.3% | Sunnyvale + |
| Poor Mental HealthCDC PLACES — 14+ days/month | 19.1% | 12.9% | Sunnyvale + |
| No Health InsuranceCDC PLACES | 8.4% | 5.2% | Sunnyvale + |
| Binge DrinkingCDC PLACES | 18.5% | 13.5% | Sunnyvale + |
| Current SmokersCDC PLACES | 12.4% | 6.7% | Sunnyvale + |
Climate
Avg Annual Temp
NOAA 1991–2020 normal
Columbia
56.0°F
Sunnyvale
N/A
Annual Precipitation
NOAA 1991–2020 normal
Columbia
46.3 in
Sunnyvale
N/A
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Avg Annual TempNOAA 1991–2020 normal | 56.0°F | N/A | - |
| Annual PrecipitationNOAA 1991–2020 normal | 46.3 in | N/A | - |
Air Quality
PM2.5 Annual Avg
EPA AQS (state-level est.)
Columbia
9.3 µg/m³
Sunnyvale
7.9 µg/m³
Sunnyvale +
Good Air Days
AQI ≤ 50
Columbia
55.0%
Sunnyvale
75.0%
Sunnyvale +
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| PM2.5 Annual AvgEPA AQS (state-level est.) | 9.3 µg/m³ | 7.9 µg/m³ | Sunnyvale + |
| Good Air DaysAQI ≤ 50 | 55.0% | 75.0% | Sunnyvale + |
Commute
Mean Commute Time
Census ACS
Columbia
18.2 min
Columbia +
Sunnyvale
25.3 min
| Metric | Columbia, MO | Sunnyvale, CA | Better |
|---|---|---|---|
| Mean Commute TimeCensus ACS | 18.2 min | 25.3 min | Columbia + |
Which City is Right for You?
Sunnyvale leads in median household income at $181,862, while columbia offers more affordable housing with a median home price of $323,876. On public safety, Columbia is safer with a violent crime rate of 501 per 100,000 residents, compared to 503 in Sunnyvale. Columbia has a lower unemployment rate at 3.9%, and Sunnyvale has cleaner air (PM2.5 avg 7.9 µg/m³). For overall health outcomes, Sunnyvale scores better with a lower obesity rate of 19.7%.
Compare More Cities
Columbia, MO vs New York, NYColumbia, MO vs Los Angeles, CAChicago, IL vs Columbia, MOColumbia, MO vs Houston, TXColumbia, MO vs Phoenix, AZColumbia, MO vs Philadelphia, PA