BMIE BluFoodies Market Intelligence Engine

← Search

BMIE Market 12125

Columbia County, New York · ZCTA boundaries as of 2020

Profile

Population (current estimate)1,141
2020–2024 ACS 5-year estimate ±202 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B01003_001E · on 2020 boundaries · retrieved 2026-09-05
Households496
2020–2024 ACS 5-year estimate ±96 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B11001_001E · on 2020 boundaries · retrieved 2026-09-05
Population, 2010 Census count1,373
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · POP10 · on 2010 boundaries · retrieved 2026-09-04
Housing units763
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · HU10 · on 2010 boundaries · retrieved 2026-09-04
Median household income$55,625
2020–2024 ACS 5-year estimate ±21,651 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B19013_001E · on 2020 boundaries · retrieved 2026-09-05
Median age49.4
2020–2024 ACS 5-year estimate ±11 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B01002_001E · on 2020 boundaries · retrieved 2026-09-05
Median gross rent$960
2020–2024 ACS 5-year estimate ±29 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B25064_001E · on 2020 boundaries · retrieved 2026-09-05
Median home value$275,900
2020–2024 ACS 5-year estimate ±35,090 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B25077_001E · on 2020 boundaries · retrieved 2026-09-05
Land area16.0 sq mi
Census Gazetteer 2020
Restaurants6
2023 · U.S. Census Bureau, ZIP Code Business Patterns 2023 detail (NAICS2022) · by USPS ZIP 12125
Restaurants per 10,000 residents65.6
DERIVED: 2010 restaurants (ZIP) ÷ 2010 Census population (ZCTA) · different years, stated as such
Restaurant growth, 5-year+0.0%
DERIVED: 2018 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, 10-year-33.3%
DERIVED: 2013 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, 20-year-40.0%
DERIVED: 2003 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, Longest on file-45.5%
DERIVED: 1994 → 2023, ZIP Code Business Patterns restaurants
Projected restaurants, 20284 (range 2–6)
FORECAST · linear trend v1 fitted to 2013–2023 (11 points, -0.3 per year, r² 0.58) · 80% range · confidence Medium · momentum, not a guarantee
Projected population, 5 years aheadNeeds more ACS years on file
BMIE Market Score24 / 100
MODELED · bmie_market_score v1 · confidence High · why?
Consumer Market Score30 / 100
MODELED · consumer_market_score v1 · confidence High · why?
Restaurant Opportunity Score17 / 100
MODELED · restaurant_opportunity_score v1 · confidence High · why?
Market Momentum Score25 / 100
MODELED · market_momentum_score v1 · confidence High · why?

Map

Boundary: U.S. Census Bureau cartographic file, 1:500k, 2020 vintage. Basemap © OpenStreetMap contributors.

Why these scores?

Each score is a weighted average of national percentile ranks (0 = lowest of all ZCTAs with that figure, 100 = highest). Weights are set in the model registry, not in code, and every score carries its model version.

BMIE Market Score: 24 (High confidence)

ComponentValueRankWeightAdds
Consumer Market Score30.03040%+12.0
Restaurant Opportunity Score16.81735%+5.9
Market Momentum Score25.12525%+6.3
Health index, advertising, whitespace, competition and risk components join in later versions.

Consumer Market Score: 30 (High confidence)

ComponentValueRankWeightAdds
Population (ACS)1,1413440%+13.7
Median household income (ACS)55,6252240%+9.0
Households (ACS)4963620%+7.3
Percentile-rank composite. No spending model yet: income and size stand in for spending capacity.

Restaurant Opportunity Score: 17 (High confidence)

ComponentValueRankWeightAdds
10-year restaurant growth-33.3935%+3.2
Restaurants per 10,000 residents (lower = more room)52.6925%+2.2
Population (ACS)1,1413420%+6.9
Median household income (ACS)55,6252220%+4.5
Whitespace, competition and demand signals are not yet available; this version uses growth, density, size and income only.

Market Momentum Score: 25 (High confidence)

ComponentValueRankWeightAdds
5-year restaurant growth04250%+20.9
10-year restaurant growth-33.3930%+2.8
20-year restaurant growth-40720%+1.5
Restaurant-count growth only until population and income growth series exist.

A high score is a statistical position among all U.S. ZCTAs, not a prediction that a restaurant will succeed.

Restaurants on file (14)

By cuisine

American 3 · Coffee 2 · Italian 2 · Pizza 2 · Sandwiches 2 · BBQ 1 · Hot dogs 1

By type

Restaurant (service type not stated) 11 · Bar 4 · Café 2 · Casual dining 2 · Brewery / taproom 1 · Food truck 1 · Quick service 1

NameTypeCuisineAddressStatus
Blueberry Hill Market CafeCafé · Restaurant (service type not stated)Coffee · American515 US-20open
Gallup InnBar4 County Rte 5Aopen
Hilltown Country SmokehouseRestaurant (service type not stated)BBQ786 Route 20open
Jimmy D'sRestaurant (service type not stated)Pizza531 Columbia Pike Route 20open
Kendall House Roast BeefRestaurant (service type not stated)423 Route 20open
M and M's Tap and TavernCasual dining · Bar501 US-20open
Mario'sRestaurant (service type not stated)Italian · American458 US-20open
Mario's RestaurantRestaurant (service type not stated)Italian2557 County Route 5open
Maverick'sCafé · Restaurant (service type not stated)Coffee · Sandwiches502 Columbia Pikeopen
Nicholas's Dirty DogsQuick service · Restaurant (service type not stated)Hot dogs898 US-20open
Pillars RestaurantRestaurant (service type not stated)860 Route 20open
Roaring 20s Brewery & TaphouseBrewery / taproom · Bar565 US-20open
Smitty's PizzaRestaurant (service type not stated) · BarPizza · Sandwiches882 State Route 20open
The KShackFood truck · Restaurant (service type not stated) · Casual diningAmerican9 Tilden Rdopen
Listings: Overture Maps Places (CDLA-Permissive-2.0), matched into the BMIE restaurant master. Census establishment counts and listing counts differ by definition (Census counts employer establishments in the reference week; listings are places currently mapped).

Restaurant establishments over time

YearAll food serviceRestaurantsFull-serviceLimited-serviceSnack & beverageBarsIndustry codes
199412111SIC1987
19951091SIC1987
199615141SIC1987
199713121SIC1987
19981197111NAICS1997
199913119111NAICS1997
20001197111NAICS1997
20011086111NAICS1997
2002964112NAICS1997
200314105323NAICS2002
20041085212NAICS2002
20051074212NAICS2002
20061074212NAICS2002
200713105222NAICS2002
2008117522NAICS2007
2009128532NAICS2007
2010129632NAICS2007
2011129542NAICS2007
2012119541NAICS2012
2013119541NAICS2012
2014108441NAICS2012
2015108441NAICS2012
2016119451NAICS2012
201710844NAICS2017
2018864NAICS2017
2019864NAICS2017
20208633NAICS2017
20219734NAICS2017
20229734NAICS2022
20238633NAICS2022
U.S. Census Bureau, ZIP Code Business Patterns, by USPS ZIP 12125. Categories are BMIE roll-ups of the published SIC/NAICS codes (full vs limited service is not split under SIC). More years load in stages.

Nearby markets (within 5 miles)

ZCTADistanceRestaurantsYear
121953.3 mi12016
120294.9 mi12016
Distance is centroid to centroid (Census Gazetteer). Restaurants: latest ZBP year on file for that ZIP.