BMIE BluFoodies Market Intelligence Engine

← Search

BMIE Market 17859

Columbia County, Pennsylvania · ZCTA boundaries as of 2020

Profile

Population (current estimate)2,701
2020–2024 ACS 5-year estimate ±285 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B01003_001E · on 2020 boundaries · retrieved 2026-09-05
Households1,051
2020–2024 ACS 5-year estimate ±120 · 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 count3,106
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · POP10 · on 2010 boundaries · retrieved 2026-09-04
Housing units1,449
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · HU10 · on 2010 boundaries · retrieved 2026-09-04
Median household income$75,515
2020–2024 ACS 5-year estimate ±9,519 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B19013_001E · on 2020 boundaries · retrieved 2026-09-05
Median age48.8
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$842
2020–2024 ACS 5-year estimate ±52 · 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$224,800
2020–2024 ACS 5-year estimate ±21,662 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B25077_001E · on 2020 boundaries · retrieved 2026-09-05
Land area37.8 sq mi
Census Gazetteer 2020
Restaurants3
2023 · U.S. Census Bureau, ZIP Code Business Patterns 2023 detail (NAICS2022) · by USPS ZIP 17859
Restaurants per 10,000 residents12.9
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+0.0%
DERIVED: 2013 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, 20-year-25.0%
DERIVED: 2003 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, Longest on file+50.0%
DERIVED: 1994 → 2023, ZIP Code Business Patterns restaurants
Projected restaurants, 20283 (range 1–5)
FORECAST · linear trend v1 fitted to 2009–2023 (11 points, -0.1 per year, r² 0.18) · 80% range · confidence Low · momentum, not a guarantee
Projected population, 5 years aheadNeeds more ACS years on file
BMIE Market Score47 / 100
MODELED · bmie_market_score v1 · confidence High · why?
Consumer Market Score53 / 100
MODELED · consumer_market_score v1 · confidence High · why?
Restaurant Opportunity Score50 / 100
MODELED · restaurant_opportunity_score v1 · confidence High · why?
Market Momentum Score34 / 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: 47 (High confidence)

ComponentValueRankWeightAdds
Consumer Market Score52.65340%+21.0
Restaurant Opportunity Score50.55035%+17.7
Market Momentum Score33.73425%+8.4
Health index, advertising, whitespace, competition and risk components join in later versions.

Consumer Market Score: 53 (High confidence)

ComponentValueRankWeightAdds
Population (ACS)2,7015040%+20.1
Median household income (ACS)75,5155640%+22.4
Households (ACS)1,0515020%+10.1
Percentile-rank composite. No spending model yet: income and size stand in for spending capacity.

Restaurant Opportunity Score: 50 (High confidence)

ComponentValueRankWeightAdds
10-year restaurant growth03535%+12.3
Restaurants per 10,000 residents (lower = more room)11.16825%+17.0
Population (ACS)2,7015020%+10.1
Median household income (ACS)75,5155620%+11.2
Whitespace, competition and demand signals are not yet available; this version uses growth, density, size and income only.

Market Momentum Score: 34 (High confidence)

ComponentValueRankWeightAdds
5-year restaurant growth04250%+20.9
10-year restaurant growth03530%+10.5
20-year restaurant growth-251220%+2.3
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 (11)

By cuisine

American 1 · Bakery 1 · Breakfast 1 · Burgers 1 · Coffee 1 · Dessert 1 · Ice cream / frozen desserts 1 · Italian 1 · Juice / smoothies 1 · Pizza 1 · Sandwiches 1

By type

Restaurant (service type not stated) 6 · Bar 3 · Dessert 2 · Quick service 2 · Bakery 1 · Café 1 · Juice, smoothie, tea 1 · Winery / distillery / taproom 1

NameTypeCuisineAddressStatus
2 Kings PizzaRestaurant (service type not stated)Pizza · Italian1832 PA-487open
Diggers DiversionBar2617 PA-487open
G S Edwards IncRestaurant (service type not stated)47 Harrison Rdopen
Hess MarketRestaurant (service type not stated)Burgers2344 State Route 487open
Magic 5 WineWinery / distillery / taproom · Bar1549 PA-487open
Melonie'S Kold KupQuick service · Juice, smoothie, tea · DessertIce cream / frozen desserts · Juice / smoothies2764 State Route 487open
Mid Mod Maven LLCBakery · DessertBakery · Dessert215 Main Stopen
Our Place on the RidgeRestaurant (service type not stated) · CaféCoffee975 Ridge Rdopen
Pickering WineryBar1549 State Route 487open
The Full Bull Table & MarketRestaurant (service type not stated)Breakfast · American2001 State Rte 254open
Tiffany SubsQuick service · Restaurant (service type not stated)Sandwiches2040 PA-487open
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
1994321SIC1987
1995431SIC1987
1996541SIC1987
1997541SIC1987
199854221NAICS1997
199965321NAICS1997
200065321NAICS1997
200143121NAICS1997
200254311NAICS1997
20034431NAICS2002
20045541NAICS2002
20054431NAICS2002
20062211NAICS2002
20073321NAICS2002
20083321NAICS2007
20093321NAICS2007
20104431NAICS2007
20114431NAICS2007
20123321NAICS2012
201343211NAICS2012
2014431111NAICS2012
2015431111NAICS2012
201632111NAICS2012
20173NAICS2017
201843NAICS2017
201943NAICS2017
202333NAICS2022
U.S. Census Bureau, ZIP Code Business Patterns, by USPS ZIP 17859. 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)

None within 5 miles.