Off Shore Pub & Grub

Lorain, OH 44052 · O33d62a7240ce · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
Off Shore Pub & Grub 3 other
a source's own spelling of the licence name (record_title.py)
OFF SHORE PUB AND GRUB ab-inbevvtinfo ×2
Offshore Pub And Grub overture
offshore pub and grub lorain doordash
Street
1407 Colorado Ave 1 other
ubereats
1407 Colorado Avenue doordash
City
Lorain
ubereatsno other value
State
OH
ubereatsno other value
ZIP
44052
ubereatsno other value
Pin
41.46566, -82.15656 map
ubereatsno other value
Phone
4402882062 1 other
vtinfo
4402452628 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O64b8c96a34ca; Odcfbc8809a8e; O57cfb317b306; Ob0479ea12d90

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-inbevOFF SHORE PUB AND GRUB
3528531
1407 COLORADO AVE, LORAIN, OH, 4405241.46557, -82.156132026-11-132026-11-13
doordashoffshore pub and grub lorain
27516886
1407 Colorado Avenue, Lorain, OH, 4405241.46569, -82.156692026-10-082026-11-13
overtureOffshore Pub And Grub
022450f0-fdb0-4f11-9985-81f754c24da9
1407 Colorado Ave, Lorain, OH, 44052440245262841.46580, -82.156632026-11-062026-11-06
ubereatsOff Shore Pub & Grub
cOM91U2bUj2VUavXWDapVA
1407 Colorado Ave, Lorain, OH, 4405241.46566, -82.156562026-10-292026-10-29
vtinfoOFF SHORE PUB AND GRUB
e1a9f6a62cc5204f
1407 COLORADO AVE, LORAIN, OH, 44052440288206241.46576, -82.156712026-11-172026-11-18

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 OFF SHORE PUB AND GRUBubereats Off Shore Pub & Grub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00
ab-inbev OFF SHORE PUB AND GRUBvtinfo OFF SHORE PUB AND GRUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 53 m apart · name similarity 1.00
doordash offshore pub and grub lorainoverture Offshore Pub And Grub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 m apart · name similarity 1.00
ubereats Off Shore Pub & Grubvtinfo OFF SHORE PUB AND GRUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
ab-inbev OFF SHORE PUB AND GRUBdoordash offshore pub and grub lorain0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 49 m apart · name similarity 0.57
ab-inbev OFF SHORE PUB AND GRUBoverture Offshore Pub And Grub0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 49 m apart · name similarity 0.57
doordash offshore pub and grub lorainubereats Off Shore Pub & Grub0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 11 m apart · name similarity 0.57
doordash offshore pub and grub lorainvtinfo OFF SHORE PUB AND GRUB0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 8 m apart · name similarity 0.57
overture Offshore Pub And Grububereats Off Shore Pub & Grub0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 16 m apart · name similarity 0.57
overture Offshore Pub And Grubvtinfo OFF SHORE PUB AND GRUB0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 9 m apart · name similarity 0.57 · phone: differs

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Heaven Hill +4 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
33 within 1 mi · 152 within 3 mi
Off / on premise
9 / 16 within 1 mi · 55 / 54 within 3 mi
Selling alcohol
17 within 1 mi · 95 within 3 mi
Nearest
same channel 0.03 mi · licensed none within 3 mi
Setting
suburban (1,691 people per sq mi)
People within 3 mi
47,816 (34,760 adults 21+, 19,987 households) from 16 tract(s), tracts within 3 mi
Income
per capita $25,962 · median household ~$50,112 (weighted mean of tract medians)
Age and education
median age ~38.2 · bachelor's or higher 12%
Ethnicity
Hispanic 29% · White 53% · Black 18% · Asian 0%
Adults per alcohol outlet
362
Alcohol spend within 3 mi
$8,977,812 a year ($4,466,906 at home, $4,506,271 away) · $93,519 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-17 17:19insertoverture 022450f0-fdb0-4f11-9985-81f754c24da9 ↔ vtinfo e1a9f6a62cc5204fsame address and namemerged15
2026-11-17 17:19insertdoordash 27516886 ↔ vtinfo e1a9f6a62cc5204fsame address and namemerged15
2026-11-17 17:19insertubereats cOM91U2bUj2VUavXWDapVA ↔ vtinfo e1a9f6a62cc5204fsame address and namemerged15
2026-11-17 17:19insertab-inbev 3528531 ↔ vtinfo e1a9f6a62cc5204fsame address and namemerged15
2026-11-13 14:10insertab-inbev 3528531 ↔ overture 022450f0-fdb0-4f11-9985-81f754c24da9same address and namemerged15
2026-11-13 14:10insertab-inbev 3528531 ↔ doordash 27516886same address and namemerged15
2026-11-13 14:10insertab-inbev 3528531 ↔ ubereats cOM91U2bUj2VUavXWDapVAsame address and namemerged15
2026-11-12 14:25insertdoordash 27516886 ↔ ubereats cOM91U2bUj2VUavXWDapVAsame address and namemerged12
2026-11-12 14:25insertdoordash 27516886 ↔ overture 022450f0-fdb0-4f11-9985-81f754c24da9same address and namemerged12
2026-11-06 18:13insertoverture 022450f0-fdb0-4f11-9985-81f754c24da9 ↔ ubereats cOM91U2bUj2VUavXWDapVAsame address and namemerged11