JOHN BREWERS

Waltham, MA 02453 · O08b60c01e387 · first seen 2026-10-08
6 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
JOHN BREWERS 4 other
the most common name a source states
John Brewer's Tavern overtureubereats ×2
John Brewers Tavern toast (legal name)
john brewers tavern waltham doordash
John Brewers Tavern Waltham 39 Main Street toast
Street
39 Main St 1 other
ubereats
39 Main Street toast
City
Waltham
ubereatsno other value
State
MA
ubereatsno other value
ZIP
02453
ubereatsno other value
Pin
42.37457, -71.20985 map
ubereatsno other value
Phone
7818949700
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe1bbbb76aefb; O5dc192bd71a9; Oedf8c505e335; O0b805c07ee3a; O79ecac37a777

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-inbevJOHN BREWERS
175665
39 MAIN ST, WALTHAM, MA, 0245342.37443, -71.209962026-11-112026-11-11
doordashjohn brewers tavern waltham
33824783
39 Main St, Waltham, MA, 0245342.37461, -71.209882026-10-082026-11-11
overtureJohn Brewer's Tavern
af8eaa97-1a70-4ab6-8049-1eae2990cab6
39 Main St, Waltham, MA, 02453781894970042.37461, -71.209882026-11-062026-11-11
toastJohn Brewers Tavern Waltham 39 Main Street
legal name: John Brewers Tavern
74608d85-5e12-4f45-b552-6b3af093222c
39 Main Street, Waltham, MA, 02453781894970042.37468, -71.209842026-11-062026-11-12
ubereatsJohn Brewer's Tavern
8lfmH6tWVjO6U6HeS0Cu3g
39 Main St, Waltham, MA, 0245342.37457, -71.209852026-10-142026-11-11
vtinfoJOHN BREWERS
ffd36613e7e37042
39 MAIN ST, WALTHAM, MA, 02453781894970042.37463, -71.209872026-11-112026-11-17

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 JOHN BREWERSvtinfo JOHN BREWERS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
doordash john brewers tavern walthamoverture John Brewer's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
doordash john brewers tavern walthamtoast John Brewers Tavern Waltham 39 Main Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · matched through the licence's legal name: John Brewers Tavern · name similarity 1.00
overture John Brewer's Taverntoast John Brewers Tavern Waltham 39 Main Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · matched through the licence's legal name: John Brewers Tavern · name similarity 1.00 · phone: equal
overture John Brewer's Tavernubereats John Brewer's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
toast John Brewers Tavern Waltham 39 Main Streetubereats John Brewer's Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · matched through the licence's legal name: John Brewers Tavern · name similarity 1.00
ab-inbev JOHN BREWERSdoordash john brewers tavern waltham0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 21 m apart · name similarity 0.72
ab-inbev JOHN BREWERSoverture John Brewer's Tavern0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 22 m apart · name similarity 0.72
ab-inbev JOHN BREWERStoast John Brewers Tavern Waltham 39 Main Street0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 29 m apart · matched through the licence's legal name: John Brewers Tavern · name similarity 0.72
ab-inbev JOHN BREWERSubereats John Brewer's Tavern0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 18 m apart · name similarity 0.72
doordash john brewers tavern walthamvtinfo JOHN BREWERS0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 2 m apart · name similarity 0.72
overture John Brewer's Tavernvtinfo JOHN BREWERS0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 2 m apart · name similarity 0.72 · phone: equal
toast John Brewers Tavern Waltham 39 Main Streetvtinfo JOHN BREWERS0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 6 m apart · matched through the licence's legal name: John Brewers Tavern · name similarity 0.72 · phone: equal
ubereats John Brewer's Tavernvtinfo JOHN BREWERS0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 7 m apart · name similarity 0.72
doordash john brewers tavern walthamubereats John Brewer's Tavern0.66Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (96% confident; asked as a “near” pair)
The DoorDash slug 'john brewers tavern waltham' is John Brewer's Tavern with the city appended, and both records give the same street address, 39 Main St, Waltham 02453, with only one business known t
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 95% confident — Both records give the same street address, city, and ZIP (39 Main St, Waltham 02453), coordinates are within about 5 meters, the names match (John Brewer's Tavern, DoorDash slug with city appended), and no other business is held at that address.
  • Claude Haiku 5.5, prompt v4: same, 96% confident — Both records give the same street address, city, and ZIP (39 Main St, Waltham, 02453), coordinates are about 5 meters apart, the only business at that address matches the name John Brewer's Tavern, and the DoorDash slug is just the name with punctuation removed and the city appended.
pair 64644aab2d331a545b3c

Attributes

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

Trade area

Other outlets
60 within 1 mi · 602 within 3 mi
Off / on premise
20 / 30 within 1 mi · 113 / 362 within 3 mi
Selling alcohol
26 within 1 mi · 256 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.65 mi
Setting
urban (6,174 people per sq mi)
People within 3 mi
174,575 (134,424 adults 21+, 70,523 households) from 42 tract(s), tracts within 3 mi
Income
per capita $77,518 · median household ~$145,796 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 69%
Ethnicity
Hispanic 9% · White 67% · Black 5% · Asian 14%
Adults per alcohol outlet
523
Alcohol spend within 3 mi
$68,042,367 a year ($29,077,496 at home, $38,942,158 away) · $264,756 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-12 14:25inserttoast 74608d85-5e12-4f45-b552-6b3af093222c ↔ vtinfo ffd36613e7e37042same address and namemerged12
2026-11-12 14:25insertab-inbev 175665 ↔ toast 74608d85-5e12-4f45-b552-6b3af093222csame address and namemerged12
2026-11-12 14:25insertoverture af8eaa97-1a70-4ab6-8049-1eae2990cab6 ↔ toast 74608d85-5e12-4f45-b552-6b3af093222csame address and namemerged12
2026-11-12 14:25inserttoast 74608d85-5e12-4f45-b552-6b3af093222c ↔ ubereats 8lfmH6tWVjO6U6HeS0Cu3gsame address and namemerged12
2026-11-12 14:25insertdoordash 33824783 ↔ toast 74608d85-5e12-4f45-b552-6b3af093222csame address and namemerged12
2026-11-11 12:56insertoverture af8eaa97-1a70-4ab6-8049-1eae2990cab6 ↔ vtinfo ffd36613e7e37042same address and namemerged12
2026-11-11 12:56insertubereats 8lfmH6tWVjO6U6HeS0Cu3g ↔ vtinfo ffd36613e7e37042same address and namemerged12
2026-11-11 12:56insertdoordash 33824783 ↔ vtinfo ffd36613e7e37042same address and namemerged12
2026-11-11 12:56insertab-inbev 175665 ↔ overture af8eaa97-1a70-4ab6-8049-1eae2990cab6same address and namemerged12
2026-11-11 12:56insertab-inbev 175665 ↔ ubereats 8lfmH6tWVjO6U6HeS0Cu3gsame address and namemerged12
2026-11-11 12:56insertab-inbev 175665 ↔ doordash 33824783same address and namemerged12
2026-11-11 12:56insertab-inbev 175665 ↔ vtinfo ffd36613e7e37042same address and namemerged12
2026-11-06 18:13insertoverture af8eaa97-1a70-4ab6-8049-1eae2990cab6 ↔ ubereats 8lfmH6tWVjO6U6HeS0Cu3gsame address and namemerged11
2026-11-06 18:13insertdoordash 33824783 ↔ overture af8eaa97-1a70-4ab6-8049-1eae2990cab6same address and namemerged11
2026-11-02 23:02backfilldoordash 33824783 ↔ ubereats 8lfmH6tWVjO6U6HeS0Cu3gClaude judge: samemerged