Short North Placesas of 2026-04-23

Short North Places Data Analysis

Dataset for the shortnorth.org directory. Primary source: Short North Alliance (SNA) Business Directory. Enrichment layers: Google Places, OhioEventFinder, OpenStreetMap, Yelp Fusion, Experience Columbus, social scrape. Data as of 2026-04-23.

Dataset at a glance

295 businesses in the Short North Alliance directory, each geolocated with lat/lng. 129 are enriched with Google Places data via matched Place ID. 182 are corroborated by at least two enrichment sources in addition to SNA.

295
Businesses in the SNA directory
primary record set from the Short North Alliance
129
Google-enriched
matched to a Google Place ID
129
With Google ratings
avg 4.5 across 82,838 reviews
199
With 2+ enrichment layers
SNA + any of Google/OEF/OSM/Yelp/EC
Short North Alliance is the primary source. Every record originates from the SNA Business Directory. Google Place ID is the bridge identifier used to attach Google, OSM, Yelp, EC, OEF, and social enrichments.
100% of SNA records geolocated. Every record has a latitude + longitude, enabling map display and proximity-based enrichment matching.
182 places corroborated by 3+ sources. SNA plus at least two independent enrichment layers higher confidence that the record is an active, real place.
8 industries populated, spanning Eat + Drink, Shopping, Experiences, Services, Art + Culture, Stay, Community + Non-Profit, and Other shapes the directorys top-level facets.

Data sources

The SNA Business Directory is the primary dataset every record is an SNA business. Each row below shows how many of the 295 SNA records are enriched from that source.

SourceRecordsCoverage (of 295)
Google Places129
129/295 (44%)
OhioEventFinder (OEF)35
35/295 (12%)
OpenStreetMap85
85/295 (29%)
Yelp Fusion117
117/295 (40%)
Experience Columbus42
42/295 (14%)
Socials (SNA or scrape)172
172/295 (58%)
Logos (site / favicon / IG)143
143/295 (48%)

Coverage = number of SNA records enriched from that source out of 295 total.

Category vocabulary

SNA Industry taxonomy is the primary classification. Each business belongs to one of the 9 SNA Industries; sub-industries provide finer granularity within each industry.

SNA Industry (primary taxonomy)

IndustryCountShare
Eat + Drink141
48%
Shopping51
17%
Experiences44
15%
Services33
11%
Art + Culture13
4%
Stay6
2%
Community3
1%
Community + Non-Profit1
0%
Other3
1%

Sub-industry breakdown (drill-down within each industry)

Eat + Drink (141 businesses, 6 sub-industries)
Sub-IndustryCountShare (of 295)
Restaurant46
16%
Bar41
14%
Casual Dining19
6%
Coffee Shop12
4%
Dessert6
2%
Other3
1%
Shopping (51 businesses, 8 sub-industries)
Sub-IndustryCountShare (of 295)
Clothing + Accessories22
7%
Specialty12
4%
Other Shopping4
1%
Grocery + Convenience3
1%
Home Goods2
1%
Bookstore2
1%
Antiques + Collectables1
0%
Kids, Toys + Games1
0%
Services (33 businesses, 4 sub-industries)
Sub-IndustryCountShare (of 295)
Other Service12
4%
Professional Services5
2%
Beauty + Personal Care1
0%
Real Estate Services1
0%
Art + Culture (13 businesses, 2 sub-industries)
Sub-IndustryCountShare (of 295)
Art Gallery6
2%
Studio2
1%
Stay (6 businesses, 1 sub-industries)
Sub-IndustryCountShare (of 295)
Hotel6
2%
Community (3 businesses, 1 sub-industries)
Sub-IndustryCountShare (of 295)
Other Non-Profit1
0%
Community + Non-Profit (1 businesses, 1 sub-industries)
Sub-IndustryCountShare (of 295)
Other Non-Profit1
0%

Ratings and price (Google Places)

How Google rates and prices each place. Yelp contributes an independent rating and price for 145 records see the grouped coverage section below for side-by-side coverage.

Rating distribution (Google reviews)

BandCountShare
4.5 5.086
29%
4.0 4.534
12%
3.5 4.08
3%
Below 3.01
0%
No rating166
56%

Share is of all 295 places; rating availability is itself a signal of Google match strength.

Price level (Google)

LevelCountShare
$14
5%
$$48
16%
$$$2
1%
$$$$3
1%
Not specified228
77%

Google only populates price level for select types mostly food/drink.

Operational status (Google Places)

Googles current operational signal (businessStatus) for each place. Non-operational records warrant manual review before appearing in the directory.

StatusRecordsShare
Operational129
44%
Not populated yet166
56%

Field completeness

For each field group, how many of the 295 SNA records have a value populated by that source? Shade = percent populated. SNA is the primary source; enrichment columns show what each layer adds.

Field SNA Google OEF OSM Yelp EC Logo
Name295 (100%)129 (44%)35 (12%)
Address295 (100%)129 (44%)
Phone222 (75%)120 (41%)60 (20%)108 (37%)45 (15%)
Website126 (43%)123 (42%)66 (22%)
Description8 (3%)5 (2%)38 (13%)
Photo1 (0%)117 (40%)47 (16%)
Hours56 (19%)
Rating129 (44%)117 (40%)
Instagram129 (44%)
Facebook17 (6%)
Logo143 (48%)

Denominator is 295 (all SNA records). Empty cell = source does not carry that field.

Raw field coverage

Per-field coverage, sorted by population rate descending.

FieldCoverage
Coordinates
100% (295)
Name
100% (295)
[g] Business status
44% (129)
[g] Formatted address
44% (129)
[g] Rating
44% (129)
[g] User rating count
44% (129)
[g] displayName
44% (129)
[g] primaryType
44% (129)
[g] Website
42% (123)
[g] Phone
41% (120)
[yelp] Categories
40% (117)
[yelp] Photo
40% (117)
[yelp] Rating
40% (117)
[yelp] Review count
40% (117)
[yelp] Yelp page URL
40% (117)
[yelp] Phone
37% (108)
[social] Instagram
32% (95)
[social] Facebook
30% (89)
[yelp] Price
24% (72)
[g] Price level
23% (67)
[osm] Website
22% (66)
[yelp] Transactions
22% (64)
[g] Editorial summary
21% (63)
[osm] Phone
20% (60)
[osm] Opening hours
19% (56)
[ec] EC page URL
16% (47)
[ec] EC type
16% (47)
[ec] Photo
16% (47)
[ec] Phone
15% (45)
[ec] Editorial description
13% (38)
[oef] Local name
12% (35)
[social] X/Twitter
9% (27)
[osm] Cuisine
6% (17)
[social] TikTok
5% (14)
[social] YouTube
4% (13)
[osm] Outdoor seating
3% (10)
[social] LinkedIn
3% (8)
[oef] Description
2% (5)
[osm] Takeaway
1% (2)
[osm] Wheelchair
1% (2)
[oef] Primary image
0% (1)
[osm] Delivery
0% (1)

Prefixes: [g] Google, [oef] OhioEventFinder, [social] website-scrape, [osm] OpenStreetMap, [yelp] Yelp Fusion, [ec] Experience Columbus.

Places inventory 295

All 295 places. Filter by text; click a column header to sort. See the Data tab for the full column set.

Name Category Address Rating Reviews Price Link