J's American Pub

LIMA, OH 45805 · O6649321489ea · first seen 2026-11-13
3 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
J's American Pub 1 other
a source's own spelling of the licence name (record_title.py)
JS AMERICAN PUB ab-inbevvtinfo ×2
Street
2307 SPENCERVILLE RD
ab-inbevno other value
City
LIMA
ab-inbevno other value
State
OH
ab-inbevno other value
ZIP
45805
ab-inbevno other value
Pin
40.73013, -84.14064 map 1 other
overture
157 m away ab-inbev
Phone
4193058555 1 other
vtinfo
4192294637 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oca0cb66d7071; O7743c41b7edd

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-inbevJS AMERICAN PUB
3427810
2307 SPENCERVILLE RD, LIMA, OH, 4580540.73033, -84.142482026-11-132026-11-20
overtureJ's American Pub
bf373d66-cd10-4dc2-958e-9e330fd98e3f
2307 Spencerville Rd, Lima, OH, 45805419229463740.73013, -84.140642026-11-132026-11-20
vtinfoJS AMERICAN PUB
6ab8656e9c6152cf
2307 SPENCERVILLE RD, LIMA, OH, 45805419305855540.73026, -84.140792026-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 JS AMERICAN PUBoverture J's American Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 157 m apart · name similarity 1.00
ab-inbev JS AMERICAN PUBvtinfo JS AMERICAN PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 143 m apart · name similarity 1.00
overture J's American Pubvtinfo JS AMERICAN PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00 · 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:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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 bf373d66-cd10-4dc2-958e-9e330fd98e3f ↔ vtinfo 6ab8656e9c6152cfsame address and namemerged17
2026-11-20 22:08insertab-inbev 3427810 ↔ vtinfo 6ab8656e9c6152cfsame address and namemerged17
2026-11-13 19:03insertab-inbev 3427810 ↔ overture bf373d66-cd10-4dc2-958e-9e330fd98e3fsame address and namemerged15