BMIE BluFoodies Market Intelligence Engine

← Search

BMIE Market 12106

Columbia County, New York · ZCTA boundaries as of 2020

Profile

Population (current estimate)1,864
2020–2024 ACS 5-year estimate ±259 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B01003_001E · on 2020 boundaries · retrieved 2026-09-05
Households940
2020–2024 ACS 5-year estimate ±144 · 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 count2,193
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · POP10 · on 2010 boundaries · retrieved 2026-09-04
Housing units1,057
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · HU10 · on 2010 boundaries · retrieved 2026-09-04
Median household income$75,714
2020–2024 ACS 5-year estimate ±15,725 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B19013_001E · on 2020 boundaries · retrieved 2026-09-05
Median age54.9
2020–2024 ACS 5-year estimate ±5 · 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$977
2020–2024 ACS 5-year estimate ±208 · 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$278,100
2020–2024 ACS 5-year estimate ±57,946 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B25077_001E · on 2020 boundaries · retrieved 2026-09-05
Land area14.3 sq mi
Census Gazetteer 2020
Restaurants7
2023 · U.S. Census Bureau, ZIP Code Business Patterns 2023 detail (NAICS2022) · by USPS ZIP 12106
Restaurants per 10,000 residents18.2
DERIVED: 2010 restaurants (ZIP) ÷ 2010 Census population (ZCTA) · different years, stated as such
Restaurant growth, 5-year+75.0%
DERIVED: 2018 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, 10-year+75.0%
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+600.0%
DERIVED: 1994 → 2023, ZIP Code Business Patterns restaurants
Projected restaurants, 20289 (range 7–11)
FORECAST · linear trend v1 fitted to 2013–2023 (11 points, +0.4 per year, r² 0.67) · 80% range · confidence Medium · momentum, not a guarantee
Projected population, 5 years aheadNeeds more ACS years on file
BMIE Market Score60 / 100
MODELED · bmie_market_score v1 · confidence High · why?
Consumer Market Score50 / 100
MODELED · consumer_market_score v1 · confidence High · why?
Restaurant Opportunity Score55 / 100
MODELED · restaurant_opportunity_score v1 · confidence High · why?
Market Momentum Score85 / 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: 60 (High confidence)

ComponentValueRankWeightAdds
Consumer Market Score49.55040%+19.8
Restaurant Opportunity Score54.65535%+19.1
Market Momentum Score85.18525%+21.3
Health index, advertising, whitespace, competition and risk components join in later versions.

Consumer Market Score: 50 (High confidence)

ComponentValueRankWeightAdds
Population (ACS)1,8644340%+17.4
Median household income (ACS)75,7145640%+22.5
Households (ACS)9404820%+9.7
Percentile-rank composite. No spending model yet: income and size stand in for spending capacity.

Restaurant Opportunity Score: 55 (High confidence)

ComponentValueRankWeightAdds
10-year restaurant growth758935%+31.0
Restaurants per 10,000 residents (lower = more room)37.61525%+3.6
Population (ACS)1,8644320%+8.7
Median household income (ACS)75,7145620%+11.3
Whitespace, competition and demand signals are not yet available; this version uses growth, density, size and income only.

Market Momentum Score: 85 (High confidence)

ComponentValueRankWeightAdds
5-year restaurant growth759450%+46.9
10-year restaurant growth758930%+26.6
20-year restaurant growth405820%+11.7
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 (12)

By cuisine

Bakery 2 · European 2 · Ice cream / frozen desserts 2 · Pizza 2 · Spanish / tapas 2 · American 1 · German / Eastern European 1 · Mediterranean 1 · Middle Eastern 1 · Sandwiches 1

By type

Restaurant (service type not stated) 8 · Bar 5 · Bakery 2 · Dessert 2 · Specialty food shop 1 · Quick service 1

NameTypeCuisineAddressStatus
Black Forest FlammkuchenBar · Restaurant (service type not stated)German / Eastern European7 Hudson Stopen
Broad Street Bagel Co.Bakery · Quick service · Specialty food shopBakery · Sandwiches1 Broad Stopen
Carolina HouseRestaurant (service type not stated)American59 Broad Streetopen
Dutch DessertsBakery · DessertBakery · Ice cream / frozen desserts30 Sunset Aveopen
DYADBarSpanish / tapas16 hudson streetopen
Hamrah's Lebanese Foods & TakeawayRestaurant (service type not stated)Middle Eastern · Mediterranean3 Albany Aveopen
Isola Wine and TapasBarSpanish / tapas16 Hudson Stopen
Labella Brick Oven PizzaRestaurant (service type not stated) · BarPizza6 Broad Stopen
MorningbirdRestaurant (service type not stated) · BarEuropean4 Hudson Stopen
Mr. Finn's Ice Cream ShoppeRestaurant (service type not stated) · DessertIce cream / frozen desserts6 Broad Stopen
SaisonnierRestaurant (service type not stated)European11 Chatham Stopen
The FlammerieRestaurant (service type not stated)Pizza7 Hudson Stopen
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
199411————SIC1987
199522————SIC1987
199655————SIC1987
199744————SIC1987
199899621—NAICS1997
1999443—1—NAICS1997
200077421—NAICS1997
200155311—NAICS1997
200255221—NAICS1997
200355311—NAICS2002
200444211—NAICS2002
20054321——NAICS2002
20063321——NAICS2002
2007332—1—NAICS2002
2008553—2—NAICS2007
2009443—1—NAICS2007
201044211—NAICS2007
201144211—NAICS2007
201233111—NAICS2012
2013443—1—NAICS2012
2014221—1—NAICS2012
2015332—1—NAICS2012
2016554—1—NAICS2012
201744————NAICS2017
201854————NAICS2017
201964————NAICS2017
202075————NAICS2017
202175—3——NAICS2017
20221174———NAICS2022
202311733——NAICS2022
U.S. Census Bureau, ZIP Code Business Patterns, by USPS ZIP 12106. 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
121732.2 mi12016
121742.5 mi—
121843.8 mi122023
121304.6 mi12006
Distance is centroid to centroid (Census Gazetteer). Restaurants: latest ZBP year on file for that ZIP.