BMIE BluFoodies Market Intelligence Engine

← Search

BMIE Market 17846

Columbia County, Pennsylvania · ZCTA boundaries as of 2020

Profile

Population (current estimate)3,621
2020–2024 ACS 5-year estimate ±357 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B01003_001E · on 2020 boundaries · retrieved 2026-09-05
Households1,416
2020–2024 ACS 5-year estimate ±126 · 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,738
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · POP10 · on 2010 boundaries · retrieved 2026-09-04
Housing units1,650
2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · HU10 · on 2010 boundaries · retrieved 2026-09-04
Median household income$66,591
2020–2024 ACS 5-year estimate ±5,955 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B19013_001E · on 2020 boundaries · retrieved 2026-09-05
Median age46.0
2020–2024 ACS 5-year estimate ±4 · 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$700
2020–2024 ACS 5-year estimate ±87 · 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,700
2020–2024 ACS 5-year estimate ±11,598 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B25077_001E · on 2020 boundaries · retrieved 2026-09-05
Land area46.8 sq mi
Census Gazetteer 2020
Restaurants4
2023 · U.S. Census Bureau, ZIP Code Business Patterns 2023 detail (NAICS2022) · by USPS ZIP 17846
Restaurants per 10,000 residents13.4
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-20.0%
DERIVED: 2013 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, 20-year+0.0%
DERIVED: 2003 → 2023, ZIP Code Business Patterns restaurants
Restaurant growth, Longest on file-20.0%
DERIVED: 1994 → 2023, ZIP Code Business Patterns restaurants
Projected restaurants, 20282 (range 0–5)
FORECAST · linear trend v1 fitted to 2013–2023 (11 points, -0.2 per year, r² 0.24) · 80% range · confidence Low · momentum, not a guarantee
Projected population, 5 years aheadNeeds more ACS years on file
BMIE Market Score42 / 100
MODELED · bmie_market_score v1 · confidence High · why?
Consumer Market Score50 / 100
MODELED · consumer_market_score v1 · confidence High · why?
Restaurant Opportunity Score41 / 100
MODELED · restaurant_opportunity_score v1 · confidence High · why?
Market Momentum Score31 / 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: 42 (High confidence)

ComponentValueRankWeightAdds
Consumer Market Score49.85040%+19.9
Restaurant Opportunity Score41.24135%+14.4
Market Momentum Score30.53125%+7.6
Health index, advertising, whitespace, competition and risk components join in later versions.

Consumer Market Score: 50 (High confidence)

ComponentValueRankWeightAdds
Population (ACS)3,6215540%+22.1
Median household income (ACS)66,5914240%+16.6
Households (ACS)1,4165520%+11.1
Percentile-rank composite. No spending model yet: income and size stand in for spending capacity.

Restaurant Opportunity Score: 41 (High confidence)

ComponentValueRankWeightAdds
10-year restaurant growth-201435%+4.8
Restaurants per 10,000 residents (lower = more room)11.16825%+17.1
Population (ACS)3,6215520%+11.1
Median household income (ACS)66,5914220%+8.3
Whitespace, competition and demand signals are not yet available; this version uses growth, density, size and income only.

Market Momentum Score: 31 (High confidence)

ComponentValueRankWeightAdds
5-year restaurant growth04250%+20.9
10-year restaurant growth-201430%+4.1
20-year restaurant growth02820%+5.6
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 (10)

By cuisine

American 2 · Dessert 2 · Italian 2 · Pizza 2 · Asian 1 · Bakery 1 · Coffee 1 · Ice cream / frozen desserts 1 · Sandwiches 1 · Thai 1

By type

Restaurant (service type not stated) 7 · Dessert 2 · Bakery 1 · Bar 1 · Café 1 · Casual dining 1 · Coffee shop 1 · Quick service 1

NameTypeCuisineAddressStatus
Alley Cat EateryRestaurant (service type not stated) · Casual diningAmerican30 Post Office Aveopen
Club ImaginationsBar147 Hogs Back Rdopen
Fran's Dairy BarDessertIce cream / frozen desserts · Dessert · American698 N State Stopen
Mikey's EmporiumRestaurant (service type not stated)316 State Route 442open
Millville PizzeriaRestaurant (service type not stated)Pizza · Italian342 S State Stopen
Old Town RoastCoffee shop · Restaurant (service type not stated) · CaféCoffee54 W Main Stopen
Original Italian PizzaRestaurant (service type not stated)Pizza · Italian410 S State Stopen
Sabrina’s Cheesecake Creations LLCBakery · DessertBakery · Dessert650 N State Stopen
Subway SubwayQuick service · Restaurant (service type not stated)Sandwiches533 North State Streetopen
The She Shed Thai FoodRestaurant (service type not stated)Thai · Asian2889 PA-42open
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
199465———1SIC1987
199565———1SIC1987
199653———2SIC1987
199786———2SIC1987
1998953112NAICS1997
1999853111NAICS1997
20008532—1NAICS1997
2001742111NAICS1997
2002733——1NAICS1997
20038431—2NAICS2002
20048431—2NAICS2002
20057321—2NAICS2002
20067321—2NAICS2002
2007841212NAICS2002
2008852211NAICS2007
2009863211NAICS2007
20109532—2NAICS2007
2011852211NAICS2007
2012852211NAICS2012
2013852211NAICS2012
2014963211NAICS2012
2015853111NAICS2012
201697421—NAICS2012
201785————NAICS2017
201874————NAICS2017
201964————NAICS2017
202054————NAICS2017
202186————NAICS2017
202264————NAICS2022
202364————NAICS2022
U.S. Census Bureau, ZIP Code Business Patterns, by USPS ZIP 17846. 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.