Average Joe's Pub and Grill

Columbus, OH 43228 · O12c24ec14390 · first seen 2026-10-19
4 sourceson premise · baralcohol: alcohol

Golden record

One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.

FieldMaster valueTaken fromWhat other sources say
Name
Average Joe's Pub and Grill 3 other
a licence name in capitals, cleaned (derived; record_title.py)
AVERAGE JOES PUB AND GRILL ab-inbevvtinfo ×2
Average Joe's overture
Average Joe's Pub & Grill- Hilliard ubereats
Street
1515 Rome Hilliard Rd 1 other
ubereats
1515 HILLIARD ROME RD ab-inbevoverturevtinfo ×3
City
Columbus
ubereatsno other value
State
OH
ubereatsno other value
ZIP
43026 1 other
ubereats
43228 ab-inbevoverturevtinfo ×3
Pin
39.98223, -83.15225 map 2 other
ubereats
167 m away ab-inbev
106 m away vtinfo
Phone
6148788678 1 other
vtinfo
6148786978 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Occba9ceec695; O18ecd2bb7d74; Of7d92f64ec22

Carries

Products seen on this outlet’s shelf in store-level catalogs.

No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.

Sources

Every source record folded into this outlet, as the source states it.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevAVERAGE JOES PUB AND GRILL
3306862
1515 HILLIARD ROME RD, COLUMBUS, OH, 4322839.98311, -83.150672026-11-122026-11-18
overtureAverage Joe's
6ca4344e-9353-4b83-a933-a694e6c7f244
1515 Hilliard Rome Rd, Columbus, OH, 43228614878697839.98231, -83.152302026-11-132026-11-18
ubereatsAverage Joe's Pub & Grill- Hilliard
4JRlcIH_RwmQYPjQCJKFRw
1515 Rome Hilliard Rd, Columbus, OH, 43026
ZIP lookup: Hilliard, OH
39.98223, -83.152252026-10-192026-11-03
vtinfoAVERAGE JOES PUB AND GRILL
1ef69d8600e41a5e
1515 HILLIARD ROME RD, COLUMBUS, OH, 43228614878867839.98203, -83.151042026-11-202026-11-22

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev AVERAGE JOES PUB AND GRILLvtinfo AVERAGE JOES PUB AND GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 124 m apart · name similarity 1.00
ab-inbev AVERAGE JOES PUB AND GRILLubereats Average Joe's Pub & Grill- Hilliard0.81Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Same pub name, same street number, nearby
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records give the same street number and road (1515 Hilliard Rome Rd / Rome Hilliard Rd), about 167 m apart, and the names match (Average Joe's Pub & Grill), with the Uber Eats listing adding the Hilliard location; the ZIP codes differ (43228 vs 43026), and another business at the address leaves some doubt.
pair 6142bbee3617123e0eae
ab-inbev AVERAGE JOES PUB AND GRILLoverture Average Joe's0.60same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: grill, pub · name Jaro-Winkler 0.91 · same street + ZIP · pins 165 m apart · name similarity 0.60
overture Average Joe'svtinfo AVERAGE JOES PUB AND GRILL0.60same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: grill, pub · name Jaro-Winkler 0.91 · same street + city + state · pins 112 m apart · name similarity 0.60 · phone: differs

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
alcohol — channel bar
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
110 within 1 mi · 275 within 3 mi
Off / on premise
29 / 64 within 1 mi · 76 / 147 within 3 mi
Selling alcohol
39 within 1 mi · 124 within 3 mi
Nearest
same channel none within 3 mi · licensed 1.58 mi
Setting
suburban (2,813 people per sq mi)
People within 3 mi
79,548 (58,860 adults 21+, 32,540 households) from 18 tract(s), tracts within 3 mi
Income
per capita $42,428 · median household ~$87,820 (weighted mean of tract medians)
Age and education
median age ~35.1 · bachelor's or higher 41%
Ethnicity
Hispanic 12% · White 68% · Black 10% · Asian 5%
Adults per alcohol outlet
475
Alcohol spend within 3 mi
$22,553,823 a year ($10,297,812 at home, $12,246,513 away) · $181,886 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.

History

Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
WhenEventPairRuleDecisionRule version
2026-11-20 22:08insertoverture 6ca4344e-9353-4b83-a933-a694e6c7f244 ↔ vtinfo 1ef69d8600e41a5esame address and namemerged17
2026-11-20 22:08insertab-inbev 3306862 ↔ vtinfo 1ef69d8600e41a5esame address and namemerged17
2026-11-18 18:58insertab-inbev 3306862 ↔ ubereats 4JRlcIH_RwmQYPjQCJKFRwClaude judge: samemerged15
2026-11-13 14:10insertab-inbev 3306862 ↔ overture 6ca4344e-9353-4b83-a933-a694e6c7f244same address and namemerged15