Shoyu Restaurant and Bar

ANDOVER, MA 01810 · O59db73680618 · first seen 2026-10-08
4 sourceson premise · restaurantchain: Shoyu Chinese & Japanese Cuisinealcohol: 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
Shoyu Restaurant and Bar 2 other
a licence name in capitals, cleaned (derived; record_title.py)
ShoYu Restaurant & Bar Andover overture
shoyu restaurant and bar andover doordash
Street
40 Park Street 1 other
doordash
40 PARK ST ab-inbevoverturevtinfo ×3
City
Andover
doordashno other value
State
MA
doordashno other value
ZIP
01810
doordashno other value
Pin
42.65718, -71.13868 map
doordashno other value
Phone
9784091494
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O5b221139fcb4; Oaa0a0d430a84; Oe3186b6f831c

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-inbevSHOYU RESTAURANT AND BAR
4638257
40 PARK ST, ANDOVER, MA, 0181042.65729, -71.138962026-11-132026-11-13
doordashshoyu restaurant and bar andover
24938073
40 Park Street, Andover, MA, 0181042.65718, -71.138682026-10-082026-10-22
overtureShoYu Restaurant & Bar Andover
41a49bfe-1ab7-4cd3-ab09-4b24eedb3d7e
40 Park St, Andover, MA, 01810978409149442.65709, -71.138652026-11-062026-11-06
vtinfoSHOYU RESTAURANT AND BAR
1036df8aabda37ed
40 PARK ST, ANDOVER, MA, 01810978409149442.65717, -71.138622026-11-162026-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 SHOYUdoordash shoyu restaurant and bar andover0.37Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “control” pair)
Same distinctive name, adjacent street numbers, same town.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records name Shoyu in Andover, MA with ZIP 01810 and coordinates about 26 m apart, and only one business is held at the address; the 38 vs 40 Park St house-number gap is likely a numbering or geocoding difference within one building.
pair f28632b8a5ff40ca2ce0
ab-inbev SHOYU RESTAURANT AND BARdoordash shoyu restaurant and bar andover1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
ab-inbev SHOYU RESTAURANT AND BARvtinfo SHOYU RESTAURANT AND BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 31 m apart · name similarity 1.00
doordash shoyu restaurant and bar andoveroverture ShoYu Restaurant & Bar Andover1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
doordash shoyu restaurant and bar andovervtinfo SHOYU RESTAURANT AND BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00

Attributes

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

Trade area

Other outlets
55 within 1 mi · 206 within 3 mi
Off / on premise
10 / 32 within 1 mi · 47 / 119 within 3 mi
Selling alcohol
27 within 1 mi · 95 within 3 mi
Nearest
same channel 0.00 mi · licensed 2.31 mi
Setting
suburban (1,821 people per sq mi)
People within 3 mi
51,482 (36,903 adults 21+, 18,875 households) from 9 tract(s), tracts within 3 mi
Income
per capita $61,483 · median household ~$126,774 (weighted mean of tract medians)
Age and education
median age ~38.2 · bachelor's or higher 54%
Ethnicity
Hispanic 24% · White 67% · Black 3% · Asian 9%
Adults per alcohol outlet
384
Alcohol spend within 3 mi
$16,601,319 a year ($7,202,434 at home, $9,392,721 away) · $172,930 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-18 18:58insertab-inbev 4638963 ↔ doordash 24938073Claude judge: sameheld: same-source-conflict15
2026-11-16 14:56insertdoordash 24938073 ↔ vtinfo 1036df8aabda37edsame address and namemerged15
2026-11-16 14:56insertab-inbev 4638257 ↔ vtinfo 1036df8aabda37edsame address and namemerged15
2026-11-13 17:47insertab-inbev 4638257 ↔ doordash 24938073same address and namemerged15
2026-11-06 18:13insertdoordash 24938073 ↔ overture 41a49bfe-1ab7-4cd3-ab09-4b24eedb3d7esame address and namemerged11