Home / Pharmacies & drug stores / Ohio / Franklin County, OH
How many pharmacies 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. 48 ZIP codes analyzed.
Includes: Pharmacies · Drug stores · Community & compounding pharmacies. Counted together because official statistics use one 446110 code.
Why a range: Census does not publish a ZIP-by-industry count when that ZIP has 0–2 businesses. 27 ZIP cells in this county are withheld, 22 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
108 pharmacies are counted in Franklin County — 0.6 per 10,000 people present (residents + daytime workers), 61% of the U.S. rate of 1.0.
On the comparable ZIP set (ZIPs with a published count in every year), the total has risen 10% between 2015 and 2023 (93 → 102). 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 43068 (Reynoldsburg), 43085 (Columbus), 43224 (Columbus) — well above the national rate. On measured density alone, the lowest-density residential ZIPs with a published count are 43081 (Westerville), 43016 (Dublin), 43017 (Dublin).
Census County Business Patterns (2023) puts the county-wide count at 133 establishments, including locations in ZIP codes that do not map to a ZCTA — so it can run slightly above the sum of the ZIP rows on this page. It is annual, so it lags more than QCEW.
Measured density: Franklin County sits at 61% of the U.S. rate for pharmacies. 22 ZIPs with population have no published count (each 0–2 businesses), so the true per-capita rate is between 61% and 86% of the U.S. rate. Why. The highest measured density is in 43068 and 43085; the lowest measured density is in 43081 and 43016.
This is a supply-side read: it counts existing pharmacies 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.
Franklin County had an estimated 1,356,303 residents on July 1, 2024 — 2.4% more than in 2020 (+31,798). In the latest year it gained 17,400 people: births minus deaths +7,157, international migration +20,257, domestic migration −9,974. Components are published separately and may not sum exactly.
798,714 jobs were located in the county in 2022 (+0.1% since 2019), and 629,276 employed residents lived there (−1.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 pharmacies 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 pharmacies in Franklin 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 | Pharmacies | Index |
|---|---|---|---|---|---|---|
| 43215 | Columbus | Employment hub | 17,836 | 81,402 | 8 | 132% |
| 43109 | Brice | Employment hub | 152 | 420 | 0–2 | — |
| 43137 | Lockbourne | Employment hub | 2,415 | 5,722 | 0–2 | — |
Scroll the table sideways to see all columns.
Click a column header to sort. Index = pharmacies per 10,000 people present (residents + 0.5×workers) ÷ the U.S. average. 100% = exactly average.
| ZIP | Neighborhood | Residents | Workers | Pharmacies | Per 10k | Index | Status |
|---|---|---|---|---|---|---|---|
| 43068 | Reynoldsburg | 60,148 | 21,702 | 10 | 1.4 | 136% | Above average |
| 43085 | Columbus | 26,601 | 18,851 | 5 | 1.4 | 134% | Above average |
| 43215 | Columbus | 17,836 | 81,402 | 8 | 1.4 | 132% | Above average |
| 43224 | Columbus | 44,319 | 5,211 | 6 | 1.3 | 124% | Above average |
| 43223 | Columbus | 28,187 | 6,907 | 4 | 1.3 | 122% | Above average |
| 43228 | Columbus | 59,077 | 40,646 | 10 | 1.3 | 122% | Above average |
| 43229 | Columbus | 55,020 | 24,261 | 8 | 1.2 | 115% | Above average |
| 43220 | Columbus | 28,792 | 11,163 | 4 | 1.2 | 113% | Above average |
| 43227 | Columbus | 25,358 | 2,548 | 3 | 1.1 | 109% | Above average |
| 43201 | Columbus | 34,322 | 12,049 | 4 | 1.0 | 96% | Below average |
| 43213 | Columbus | 36,273 | 20,633 | 4 | 0.9 | 83% | Below average |
| 43204 | Columbus | 42,962 | 10,264 | 4 | 0.8 | 81% | Below average |
| 43026 | Hilliard | 65,238 | 20,895 | 6 | 0.8 | 77% | Below average |
| 43214 | Columbus | 26,776 | 23,249 | 3 | 0.8 | 76% | Below average |
| 43221 | Columbus | 35,293 | 7,315 | 3 | 0.8 | 75% | Below average |
| 43123 | Grove City | 67,626 | 28,211 | 6 | 0.7 | 71% | Below average |
| 43230 | Columbus | 58,076 | 26,798 | 5 | 0.7 | 68% | Below average |
| 43207 | Columbus | 47,272 | 19,877 | 4 | 0.7 | 68% | Below average |
| 43017 | Dublin | 41,613 | 41,270 | 4 | 0.6 | 62% | Below average |
| 43016 | Dublin | 46,362 | 21,786 | 3 | 0.5 | 51% | Below average |
| 43081 | Westerville | 65,020 | 27,088 | 4 | 0.5 | 49% | Far below average |
| 43004 | Blacklick | 31,477 | 3,385 | 0–2 | — | — | Not published |
| 43054 | New Albany | 27,594 | 23,717 | 0–2 | — | — | Not published |
| 43086 | Westerville | — | 44 | 0–2 | — | — | Not published |
| 43109 | Brice | 152 | 420 | 0–2 | — | — | Not published |
| 43110 | Canal Winchester | 43,544 | 9,919 | 0–2 | — | — | Not published |
| 43119 | Galloway | 29,660 | 1,635 | 0–2 | — | — | Not published |
| 43125 | Groveport | 14,803 | 22,323 | 0–2 | — | — | Not published |
| 43126 | Harrisburg | 306 | 156 | 0–2 | — | — | Not published |
| 43137 | Lockbourne | 2,415 | 5,722 | 0–2 | — | — | Not published |
| 43202 | Columbus | 20,854 | 4,762 | 0–2 | — | — | Not published |
| 43203 | Columbus | 8,618 | 1,133 | 0–2 | — | — | Not published |
| 43205 | Columbus | 12,618 | 15,507 | 0–2 | — | — | Not published |
| 43206 | Columbus | 21,996 | 6,245 | 0–2 | — | — | Not published |
| 43209 | Columbus | 28,193 | 6,987 | 0–2 | — | — | Not published |
| 43210 | Columbus | 12,164 | 11,062 | 0–2 | — | — | Not published |
| 43211 | Columbus | 22,313 | 3,165 | 0–2 | — | — | Not published |
| 43212 | Columbus | 23,405 | 16,465 | 0–2 | — | — | Not published |
| 43216 | Columbus | — | 1,479 | 0–2 | — | — | Not published |
| 43217 | Columbus | 2,091 | 3,429 | 0–2 | — | — | Not published |
| 43218 | Columbus | 0 | 243 | 0–2 | — | — | Not published |
| 43219 | Columbus | 32,338 | 52,768 | 0–2 | — | — | Not published |
| 43222 | Columbus | 4,819 | 9,053 | 0–2 | — | — | Not published |
| 43231 | Columbus | 23,009 | 10,825 | 0–2 | — | — | Not published |
| 43232 | Columbus | 47,364 | 9,656 | 0–2 | — | — | Not published |
| 43235 | Columbus | 44,589 | 16,817 | 0–2 | — | — | Not published |
| 43236 | Columbus | — | 42 | 0–2 | — | — | Not published |
| 43287 | Columbus | — | 624 | 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 446110 — pharmacies & drug stores. Counts establishments with paid employees. ZBP is published annually with a ~2-year lag.
Fresh county signal. This industry has no clean QCEW series, so the freshest county signal is Census County Business Patterns 2023: 133 establishments and $125M in annual payroll county-wide. This count includes locations in ZIP codes that do not map to a ZCTA, so it can be slightly higher than the sum of the ZIP rows. CBP is annual and slower than QCEW. 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 (1.03 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.