Home / Coffee shops & beverage bars / Missouri / Boone County, MO
How many coffee shops exist per person present — residents plus daytime workers — by ZIP code, compared with the U.S. average. Establishment data: Census ZBP 2023. Population: ACS 2024 5-year. 14 ZIP codes analyzed.
Includes: Coffee shops · Espresso bars · Boba / bubble tea shops · Juice & smoothie bars · Ice cream & frozen yogurt shops. Counted together because official statistics use one 722515 code.
Why a range: Census does not publish a ZIP-by-industry count when that ZIP has 0–2 businesses. 10 ZIP cells in this county are withheld, 7 of them with residents. Each could hold 0, 1, or 2 businesses: counting them all as 0 gives the low end, counting them all as 2 gives the high end — the data cannot say where the truth sits. The density range uses only the populated cells, since ZIPs without residents are excluded from per-person rates. How ranges work
46 coffee shops are counted in Boone County — 2.0 per 10,000 people present (residents + daytime workers), 95% of the U.S. rate of 2.1.
On the comparable ZIP set (ZIPs with a published count in every year), the total has risen 60% between 2015 and 2023 (25 → 40). That set is smaller than today's county total. 2020–2021 were pandemic-distorted, and Census rounds counts, so small moves are within noise.
Measured supply density is highest in 65010 (Ashland), 65201 (Columbia), 65203 (Columbia) — well above the national rate. On measured density alone, the lowest-density residential ZIPs with a published count are 65202 (Columbia), 65203 (Columbia), 65201 (Columbia).
BLS QCEW puts the latest county-wide count (2026 Q1) at 52 establishments, the freshest available signal.
Measured density: Boone County sits at 95% of the U.S. rate for coffee shops. 7 ZIPs with population have no published count (each 0–2 businesses), so the true per-capita rate is between 95% and 123% of the U.S. rate. Why. The highest measured density is in 65010 and 65201; the lowest measured density is in 65202 and 65203.
This is a supply-side read: it counts existing coffee shops and the people present, not foot traffic, income, rent, or whether locals want more. Treat low density as a question to check, not an answer.
Boone County had an estimated 192,154 residents on July 1, 2024 — 4.4% more than in 2020 (+8,104). In the latest year it gained 2,016 people: births minus deaths +671, international migration +1,674, domestic migration −346. Components are published separately and may not sum exactly.
100,071 jobs were located in the county in 2022 (+4.9% since 2019), and 81,108 employed residents lived there (+4.5% since 2019). LODES counts wage and salary jobs covered by unemployment insurance plus federal jobs; it excludes the self-employed and military, and counts jobs rather than unique people. 2019→2022 spans the pandemic, so read it as one change, not a trend.
Population and migration say whether the customer base is growing. They do not say whether people want another business of this type. Definitions and limits → · Full county detail →
No ZIP had a statistically significant decrease.
ACS 5-year estimates for 2015–2019 and 2020–2024. Only ZIPs with at least 2,000 residents in both windows and a change larger than the survey margin of error (90%) are listed — small ZIPs move a lot on paper without a real signal.
Census Nonemployer Statistics counts businesses with no paid employees — a separate universe from the employer establishments counted above; a business is in one or the other, never both. They are not storefronts by definition: many are home-based, mobile, or part-time.
We show them beside the density index, not inside it. In categories such as nail and beauty salons, child care, and pet care, one-person businesses can outnumber employer establishments, so the employer-only count understates how many businesses exist. That is not evidence of higher demand.
Receipts are gross revenue reported for these businesses — not profit, and not the size of the local market. Census publishes this only at county level, so it is not shown on the ZIP map. See methodology.
Each ZIP area is shaded by its density of this business type per person present (residents + workers) vs. the U.S. average. Click any ZIP to zoom to its boundary, see its numbers, and switch to aerial imagery. Individual mapped shops appear as dots at street level — Show locations zooms you in to them (scroll or double-click to zoom).
Map data © OpenStreetMap contributors, tiles by OpenFreeMap.
White dots are ZIP totals from the official Census count — the bigger the dot, the more coffee shops in that ZIP. They are aggregated, not individual shops. Turquoise dots are individual locations mapped in OpenStreetMap, shown only at street level; they are crowd-sourced and indicative, may be incomplete, and do not equal the official counts. Only the official ZIP totals feed the saturation index.
Number of coffee shops in Boone County across 2015–2023, on a consistent set of ZIP codes present in every year — so changes are real, not ZIP-boundary artifacts. 2015/2018 are pre-pandemic baselines; 2020/2021 are COVID-distorted.
These ZIPs have far more workers (or visitors) than residents, so their counts are driven by daytime and visitor demand — not a place to read "shortage" from resident numbers alone.
| ZIP | Neighborhood | Type | Residents | Workers | Coffee shops | Index |
|---|---|---|---|---|---|---|
| 65216 | Columbia | Employment hub | 202 | 912 | 0–2 | — |
Scroll the table sideways to see all columns.
Click a column header to sort. Index = coffee shops per 10,000 people present (residents + 0.5×workers) ÷ the U.S. average. 100% = exactly average.
| ZIP | Neighborhood | Residents | Workers | Coffee shops | Per 10k | Index | Status |
|---|---|---|---|---|---|---|---|
| 65010 | Ashland | 7,205 | 945 | 3 | 3.9 | 186% | High density |
| 65201 | Columbia | 50,011 | 37,104 | 23 | 3.4 | 160% | High density |
| 65203 | Columbia | 61,539 | 25,525 | 17 | 2.3 | 109% | Above average |
| 65202 | Columbia | 47,327 | 15,312 | 3 | 0.5 | 26% | Far below average |
| 65039 | Hartsburg | 3,076 | 296 | 0–2 | — | — | Not published |
| 65205 | Columbia | — | 460 | 0–2 | — | — | Not published |
| 65211 | Columbia | — | 257 | 0–2 | — | — | Not published |
| 65216 | Columbia | 202 | 912 | 0–2 | — | — | Not published |
| 65218 | Columbia | — | 1,588 | 0–2 | — | — | Not published |
| 65240 | Centralia | 8,830 | 1,680 | 0–2 | — | — | Not published |
| 65255 | Hallsville | 5,216 | 371 | 0–2 | — | — | Not published |
| 65256 | Harrisburg | 2,011 | 187 | 0–2 | — | — | Not published |
| 65279 | Rocheport | 1,940 | 237 | 0–2 | — | — | Not published |
| 65284 | Sturgeon | 2,316 | 163 | 0–2 | — | — | Not published |
Scroll the table sideways to see all columns.
The numbers above tell you how the market looks. To find a specific storefront, these marketplaces list available retail space for lease.
Open vacancy data (actual empty units) is only published by some cities; where it exists we show it directly. Listings above are third-party.
Census withholds some ZIP-by-industry cells to protect small businesses. 0–2 means the cell was not published (Census publishes industry counts only at 3+ per ZIP), so the ZIP is left unranked rather than counted as zero. ~ means the count is estimated from the broader industry group and can be off by a business or two.
When a data vintage changes or a section of this report is revised, we post it to a public update feed. No email address, no account, no tracking — and nothing is sent unless something actually changed.
Establishments. U.S. Census ZIP Code Business Patterns (ZBP 2023), NAICS 722515 — snack & non-alcoholic beverage bars (incl. coffee shops). Counts establishments with paid employees. ZBP is published annually with a ~2-year lag.
Fresh county signal. BLS QCEW (quarterly) is newer than ZBP — 2026 Q1 shows 52 establishments county-wide for this industry. It cannot be broken down by ZIP.
Population. U.S. Census American Community Survey 2024 5-year ZCTA population (table B01003). Workers are the ZIP's total employment from the same 2023 ZBP file.
Demand ("people present"). Demand comes from residents and daytime workers: residents + 0.5 × workers. This is the single documented assumption in the model and can be tuned.
Index. index = (ZIP establishments ÷ ZIP demand × 10,000) ÷ the U.S. average for this industry (2.10 per 10,000 present). It is a supply-side density measure; it does not capture income, rent, tourism, or whether locals actually want more.
BizGapMap — free, no-login small-business saturation reports for major U.S. counties. Built entirely from public U.S. Census, BLS, and IRS data (ZBP 2023, ACS 2024 5-year, PEP 2024, LODES, QCEW, IRS SOI). No forecasts, no revenue guesses — withheld cells are marked, and the few derived counts are labelled as estimates.