BMIE Market 12017
Columbia County, New York · ZCTA boundaries as of 2020
Profile
| Population (current estimate) | 471 2020–2024 ACS 5-year estimate ±151 · American Community Survey 5-Year Estimates · ACS 5-Year 2024 (2020-2024) ZCTA · B01003_001E · on 2020 boundaries · retrieved 2026-09-05 |
|---|---|
| Households | 222 2020–2024 ACS 5-year estimate ±107 · 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 count | 435 2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · POP10 · on 2010 boundaries · retrieved 2026-09-04 |
| Housing units | 314 2010 Census count · Decennial Census · Census Gazetteer ZCTA 2010 · HU10 · on 2010 boundaries · retrieved 2026-09-04 |
| Median household income | Data source not yet connected |
| Median age | 57.1 2020–2024 ACS 5-year estimate ±13 · 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 | $1,583 2020–2024 ACS 5-year estimate ±918 · 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 | Data source not yet connected |
| Land area | 14.7 sq mi Census Gazetteer 2020 |
| Restaurants | 1 2005 · U.S. Census Bureau, ZIP Code Business Patterns 2005 detail (NAICS2002) · by USPS ZIP 12017 |
| Restaurants per 10,000 residents | Not yet derived |
| Restaurant growth, 5-year | +0.0% DERIVED: 2000 → 2005, ZIP Code Business Patterns restaurants |
| Projected restaurants, 2010 | 1 (range 0–3) FORECAST · linear trend v1 fitted to 1996–2005 (10 points, 0.0 per year, r² 0.08) · 80% range · confidence Low · momentum, not a guarantee |
| Projected population, 5 years ahead | Needs more ACS years on file |
| Consumer Market Score | 21 / 100 MODELED · consumer_market_score v1 · confidence Medium · why? |
Map
Boundary: U.S. Census Bureau cartographic file, 1:500k, 2020 vintage. Basemap © OpenStreetMap contributors.Trends
Historical lines are published counts. Dashed lines are derived: a least-squares trend through the last decade, extended as a FORECAST with its 80% range. Momentum, not a guarantee.
Restaurants by year, with trend and projection
ZIP Code Business Patterns, USPS ZIP 12017. Projection: linear trend v1, fitted 1996–2005, 0.0 restaurants per year, r² 0.08, confidence Low.Growth index (first year on file = 100)
Each category relative to its own first published count. Full/limited split is unavailable under SIC (before 1998).Mix of the food-service market
Share of all food-service establishments. "Other" = snack bars, caterers, contractors, mobile.Population and restaurants per 10,000 residents
Population points: 2010 Census count and ACS 5-year estimates on file (more vintages load over time). Density uses the population point within two years of each restaurant count. Population projection appears once three or more ACS years are loaded.Restaurant growth vs. New York and U.S. averages
Averages are the mean growth across all ZCTAs with the figure (state n = 1,510, U.S. n = 24,852). DERIVED from ZIP Code Business Patterns.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.
Consumer Market Score: 21 (Medium confidence)
| Component | Value | Rank | Weight | Adds |
|---|---|---|---|---|
| Population (ACS) | 471 | 21 | 40% | +13.7 |
| Households (ACS) | 222 | 23 | 20% | +7.8 |
A high score is a statistical position among all U.S. ZCTAs, not a prediction that a restaurant will succeed.
Restaurants on file
No listings loaded for this ZCTA yet. Counts above come from the Census; individual listings arrive from Overture Places.
Restaurant establishments over time
| Year | All food service | Restaurants | Full-service | Limited-service | Snack & beverage | Bars | Industry codes |
|---|---|---|---|---|---|---|---|
| 1996 | 1 | 1 | — | — | — | — | SIC1987 |
| 1997 | 1 | 1 | — | — | — | — | SIC1987 |
| 1998 | 2 | 2 | — | 1 | 1 | — | NAICS1997 |
| 1999 | 1 | 1 | — | — | 1 | — | NAICS1997 |
| 2000 | 1 | 1 | — | — | 1 | — | NAICS1997 |
| 2001 | 1 | 1 | — | — | 1 | — | NAICS1997 |
| 2002 | 1 | 1 | — | — | 1 | — | NAICS1997 |
| 2003 | 1 | 1 | — | — | 1 | — | NAICS2002 |
| 2004 | 1 | 1 | — | 1 | — | — | NAICS2002 |
| 2005 | 1 | 1 | 1 | — | — | — | NAICS2002 |