The book's checklist
- Lower cost of livingEveryday prices run 13.3% below the U.S. average in the parts of South Dakota outside metro areas.
- More house for the moneyA typical home costs 1.7 years of the typical household's income here. Across the U.S. it's 4.1.
- Schools in townNo public schools inside the town. The nearest public school is Holgate Middle School, a middle school, about 12 miles away. The nearest public high school is Central High School, about 14 miles away.
- A hospital close bySanford Medical Center Aberdeen in Aberdeen, about 13 miles away, has the nearest emergency room.
- Within reach of a big cityMinneapolis is about 249 miles away as the crow flies. The book suggests staying within about 60 miles if you'll miss big-city sports, concerts and theater.
Not enough data for: A safer neighborhood.
A check means the town meets the book's rule of thumb; an empty box is something to weigh; a question mark means too little data.
Columbia meets 3 of the 5 rules of thumb we have data for. Frank and Dave's free book explains how to weigh the rest for your family.
Of the towns on this site, the nearest with 2,500 or more people and an emergency room in town is Aberdeen, SD, about 13 miles away in a straight line. Its emergency room is at Avera St. Lukes. A typical home there is valued at $217,300 (Census survey, 2020-2024). It has 9 public schools.
Sources: Medicare hospital data; Census Bureau American Community Survey, 2020-2024; NCES Common Core of Data, 2023-24.
For a lifetime
Homes and money
- Typical home value, as owners valued them in 2020-2024
- $96,500U.S.: $332,700; South Dakota: $257,400
- Home prices since then
- Up 12%Brown County, 2022 to 2025
- Typical household income
- $58,295U.S.: $80,734; South Dakota: $75,081
- Typical property tax bill
- $1,333 a yearSouth Dakota: $2,724
- Everyday prices
- 86.7U.S. average = 100 (the parts of South Dakota outside metro areas)
- Housing costs (U.S. average = 100)
- 59.1Rural South Dakota
- Homes, 2020 Census count
- 74
- Homes owned by the people living in them, 2020 Census count
- 88%
- Vacation and seasonal homes, 2020 Census count
- 3%
- Empty homes, for any reason, 2020 Census count
- 7%
The Census survey reached too few homes in a town this size to measure internet.
County prices have moved up 12% since 2022. Check current listings before you budget.
Sources: Census Bureau American Community Survey, 2020-2024; 2020 Census; FHFA county house price index; BEA Regional Price Parities, 2024.
Read next: How to buy a house in a small town
The people
- Population, 2025 estimate
- 1552020 estimate: 157
- People per square mile
- 102Mixes the 2025 estimate with 1.5 square miles of land (2025 Gazetteer)
- Median age, 2020 Census count
- 37.7 years
- Age 65 and older, 2020 Census count
- 18%
- Under 18, 2020 Census count
- 26%
Sources: Census Bureau population estimates, 2025; 2020 Census; Census Bureau Gazetteer, 2025.
Work
- Work from home
- 8%U.S.: 15%; South Dakota: 10%
- Below the poverty line
- 4%U.S.: 12%; South Dakota: 12%
Source: Census Bureau American Community Survey, 2020-2024.
Read next: How to keep working when you move to a small town
Health care
Nearest emergency room: Sanford Medical Center Aberdeen, Aberdeen, SD, about 13 miles away. It's a general hospital. Medicare gives it 4 of 5 stars.
Look up doctors, clinics and the hospitals themselves on Medicare's Care Compare. Ask where the most serious cases are sent.
Source: Medicare hospital data.
Schools
There are no public schools inside Columbia itself. The nearest public school is Holgate Middle School, a middle school, about 12 miles away. The nearest public high school is Central High School, about 14 miles away.
See each school on the federal school search, then check test scores and graduation rates on South Dakota's school report card.
Source: NCES Common Core of Data, 2023-24.
Read next: How to choose a school when you move to a small town
Weather
- January average low
- 0°F
- July average high
- 83°F
- Days 90°F or hotter
- 9 a year
- Nights at or below freezing
- 179 a year
- Rain and melted snow
- 22.5 inches a year
- Snow
- 38 inches a year
- Elevation
- 1,300 feet
Weather station: Columbia 8 N (7 miles away). Averages for 1991 to 2020.
Sources: NOAA climate normals, 1991-2020; USGS elevation data.
Getting around
Straight-line miles. The road is always longer, and as the book says, an interstate at 70 is a different trip from a farm road at 45. Check the real drive: Sanford Medical Center Aberdeen, Fargo, Minneapolis.
Brown County is outside any metro area, with 20,000 or more people in its towns, not next to a metro area (USDA rural-urban code 5, on a scale where 1 is the biggest metro areas and 9 the most rural counties).
For a day
Read about Columbia's history on Wikipedia.
Know Columbia? Tell us what a visitor shouldn't miss: mainstreet@smalltownguide.com.
Nearby
Straight-line miles.
Small towns
- Westport, SD81 people, 9 miles
- Aberdeen, SD28,000 people, 13 miles
- Claremont, SD107 people, 15 miles
- Groton, SD1,340 people, 15 miles
- Frederick, SD205 people, 18 miles
- Hecla, SD190 people, 20 miles
- Stratford, SD58 people, 21 miles
- Warner, SD449 people, 22 miles
Nearest bigger towns
- Aberdeen, SD28,000 people, 13 miles
- Watertown, SD24,000 people, 74 miles
- Milbank, SD3,500 people, 86 miles
Other towns in Brown County
- Aberdeen, SD28,000 people, 13 miles
- Groton, SD1,340 people, 15 miles
- Warner, SD449 people, 22 miles
- Frederick, SD205 people, 18 miles
- Hecla, SD190 people, 20 miles
- Claremont, SD107 people, 15 miles
- Westport, SD81 people, 9 miles
- Stratford, SD58 people, 21 miles
- Verdon, SD6 people, 28 miles
See every town in Brown County
Unincorporated places nearby
Communities under 2,500 people, too small for a page of their own.
- Prairiewood Village, SD (unincorporated)474 people, 9 miles
Sources (12)
Show all 12 sources
- U.S. Census Bureau, Population Estimates (Vintage 2025)
- U.S. Census Bureau, American Community Survey 2020-2024 5-year estimates
- U.S. Census Bureau, 2020 Census Demographic and Housing Characteristics
- U.S. Bureau of Economic Analysis, Regional Price Parities, 2024
- Centers for Medicare & Medicaid Services, Hospital General Information
- National Center for Education Statistics, Common Core of Data, 2023-24 (via the Urban Institute Education Data Portal)
- NOAA National Centers for Environmental Information, U.S. Climate Normals 1991-2020
- U.S. Geological Survey, 3D Elevation Program
- USDA Economic Research Service, Rural-Urban Continuum Codes, 2023
- Federal Housing Finance Agency, House Price Index for counties (all transactions)
- U.S. Census Bureau, 2025 Gazetteer files and 2020 urban areas
- Office of Management and Budget, metropolitan and micropolitan statistical areas, 2023
Census survey figures are estimates with a margin of error; we leave out any figure whose margin is too wide to be useful. Data last gathered November 19, 2026. See something wrong? Write to mainstreet@smalltownguide.com.