Home / Hotels & motels / Ohio / Franklin County, OH
How many hotels 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: Hotels · Motels · Motor inns. Counted together because official statistics use one 721110 code.
Why a range: Census does not publish a ZIP-by-industry count when that ZIP has 0–2 businesses. 32 ZIP cells in this county are withheld, 27 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
195 hotels are counted in Franklin County — 1.1 per 10,000 people present (residents + daytime workers), 82% of the U.S. rate of 1.4.
On the comparable ZIP set (ZIPs with a published count in every year), the total has risen 14% between 2015 and 2023 (160 → 182). 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 43202 (Columbus), 43017 (Dublin), 43219 (Columbus) — well above the national rate. On measured density alone, the lowest-density residential ZIPs with a published count are 43026 (Hilliard), 43068 (Reynoldsburg), 43016 (Dublin).
Census County Business Patterns (2023) puts the county-wide count at 218 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 82% of the U.S. rate for hotels. 27 ZIPs with population have no published count (each 0–2 businesses), so the true per-capita rate is between 82% and 105% of the U.S. rate. Why. The highest measured density is in 43202 and 43017; the lowest measured density is in 43026 and 43068.
This is a supply-side read: it counts existing hotels 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.
Not shown. Census publishes hotels only combined with other traveler accommodation (NAICS 7211), so a hotels-and-motels-only nonemployer count is not published.
Census Nonemployer Statistics 2024 (NAICS 2022). We do not approximate this figure.
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 hotels 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 hotels 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 | Hotels | Index |
|---|---|---|---|---|---|---|
| 43215 | Columbus | Employment hub | 17,836 | 81,402 | 24 | 297% |
| 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 = hotels per 10,000 people present (residents + 0.5×workers) ÷ the U.S. average. 100% = exactly average.
| ZIP | Neighborhood | Residents | Workers | Hotels | Per 10k | Index | Status |
|---|---|---|---|---|---|---|---|
| 43215 | Columbus | 17,836 | 81,402 | 24 | 4.1 | 297% | Very high density |
| 43202 | Columbus | 20,854 | 4,762 | 9 | 3.9 | 281% | Very high density |
| 43017 | Dublin | 41,613 | 41,270 | 22 | 3.5 | 256% | Very high density |
| 43219 | Columbus | 32,338 | 52,768 | 16 | 2.7 | 197% | High density |
| 43228 | Columbus | 59,077 | 40,646 | 20 | 2.5 | 182% | High density |
| 43235 | Columbus | 44,589 | 16,817 | 13 | 2.5 | 178% | High density |
| 43229 | Columbus | 55,020 | 24,261 | 15 | 2.2 | 162% | High density |
| 43123 | Grove City | 67,626 | 28,211 | 18 | 2.2 | 160% | High density |
| 43054 | New Albany | 27,594 | 23,717 | 8 | 2.0 | 147% | Above average |
| 43232 | Columbus | 47,364 | 9,656 | 9 | 1.7 | 125% | Above average |
| 43213 | Columbus | 36,273 | 20,633 | 8 | 1.7 | 124% | Above average |
| 43212 | Columbus | 23,405 | 16,465 | 5 | 1.6 | 114% | Above average |
| 43230 | Columbus | 58,076 | 26,798 | 10 | 1.4 | 101% | Above average |
| 43016 | Dublin | 46,362 | 21,786 | 6 | 1.0 | 76% | Below average |
| 43068 | Reynoldsburg | 60,148 | 21,702 | 6 | 0.8 | 61% | Below average |
| 43026 | Hilliard | 65,238 | 20,895 | 6 | 0.8 | 57% | Below average |
| 43004 | Blacklick | 31,477 | 3,385 | 0–2 | — | — | Not published |
| 43081 | Westerville | 65,020 | 27,088 | 0–2 | — | — | Not published |
| 43085 | Columbus | 26,601 | 18,851 | 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 |
| 43201 | Columbus | 34,322 | 12,049 | 0–2 | — | — | Not published |
| 43203 | Columbus | 8,618 | 1,133 | 0–2 | — | — | Not published |
| 43204 | Columbus | 42,962 | 10,264 | 0–2 | — | — | Not published |
| 43205 | Columbus | 12,618 | 15,507 | 0–2 | — | — | Not published |
| 43206 | Columbus | 21,996 | 6,245 | 0–2 | — | — | Not published |
| 43207 | Columbus | 47,272 | 19,877 | 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 |
| 43214 | Columbus | 26,776 | 23,249 | 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 |
| 43220 | Columbus | 28,792 | 11,163 | 0–2 | — | — | Not published |
| 43221 | Columbus | 35,293 | 7,315 | 0–2 | — | — | Not published |
| 43222 | Columbus | 4,819 | 9,053 | 0–2 | — | — | Not published |
| 43223 | Columbus | 28,187 | 6,907 | 0–2 | — | — | Not published |
| 43224 | Columbus | 44,319 | 5,211 | 0–2 | — | — | Not published |
| 43227 | Columbus | 25,358 | 2,548 | 0–2 | — | — | Not published |
| 43231 | Columbus | 23,009 | 10,825 | 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 721110 — hotels (except casino hotels) and motels. 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: 218 establishments and $193M 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.38 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.