SEAFOOD CITY SUPERMARKET

HAYWARD, CA 94545 · O00004cb33a71 · first seen 2026-10-08
4 sourcesoff premisealcohol: licensed1 licence

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
SEAFOOD CITY SUPERMARKET 3 other
the most common name a source states
seafood city hayward doordash
Seafood City Supermarket Hayward overture
SFC MILPITAS INC ca-abc (legal name)
Street
24536 HESPERIAN BLVD
ca-abcno other value
City
HAYWARD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94545
ca-abcno other value
Pin
37.64901, -122.10643 map 2 other
doordash
100 m away ab-inbev
190 m away ca-abc
Phone
5103008070
overtureno other value
Licences
ca-abc 00591147|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od37bd07f4b26; Oefba74c6bcaa; O6106acbd4149

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-inbevSEAFOOD CITY SUPERMARKET
4248377
24536 HESPERIAN BLVD, HAYWARD, CA, 9454537.64886, -122.107542026-11-112026-11-11
ca-abcSEAFOOD CITY SUPERMARKET
legal name: SFC MILPITAS INC
00591147|21|LIC|0
24536 HESPERIAN BLVD, HAYWARD, CA, 9454537.64997, -122.108212026-10-082026-11-11
doordashseafood city hayward
1533998
24536 Hesperian Blvd, Hayward, CA, 9454537.64901, -122.106432026-10-082026-11-11
overtureSeafood City Supermarket Hayward
bd52d6a2-b004-44b4-b917-c286b76a11f3
24536 Hesperian Blvd, Hayward, CA, 94545510300807037.64919, -122.106262026-11-062026-11-11

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
doordash seafood city haywardoverture Grill City0.39same address and nameheld same-source-conflictaddress similarity 1.00 · names match with these kind-of-place words set aside: grill, seafood · name Jaro-Winkler 0.78 · same street + ZIP · pins 12 m apart · name similarity 0.39
ab-inbev SEAFOOD CITY SUPERMARKETdoordash grill city hayward0.30one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 1719ca4a46ca65bdd6e6 · person: None · rule: names contained at one address · stratum: same-address
ca-abc SEAFOOD CITY SUPERMARKETdoordash grill city hayward0.30one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d21fb5d6b248df545724 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev SEAFOOD CITY SUPERMARKETca-abc SEAFOOD CITY SUPERMARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 137 m apart · name similarity 1.00
ab-inbev SEAFOOD CITY SUPERMARKEToverture Seafood City Supermarket Hayward0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.88 · same street + ZIP · pins 118 m apart · name similarity 0.80
ca-abc SEAFOOD CITY SUPERMARKEToverture Seafood City Supermarket Hayward0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.88 · same street + ZIP · pins 192 m apart · name similarity 0.80
doordash seafood city haywardoverture Seafood City Supermarket Hayward0.76same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 25 m apart · name similarity 0.76
ab-inbev SEAFOOD CITY SUPERMARKETdoordash seafood city hayward0.67same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: seafood, supermarket · name Jaro-Winkler 0.90 · same street + ZIP · pins 100 m apart · name similarity 0.67
ca-abc SEAFOOD CITY SUPERMARKETdoordash seafood city hayward0.67Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The names agree: the DoorDash slug 'seafood city hayward' is the Seafood City Supermarket name with the city appended. Both records give the same street address, and the ABC record is an off-sale mark
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records give the same street address, ZIP and city (24536 Hesperian Blvd, Hayward 94545), and the DoorDash slug 'seafood city hayward' matches the ABC name 'Seafood City Supermarket', so the names agree at a shared building; the 0.19 km gap is within normal geocoding error.
  • Claude Opus 5.5, prompt v3: unsure, 60% confident — Seafood City is a chain and the DoorDash record gives no street address, only the city, so the slug cannot be tied to the Hesperian Blvd premises.
pair f7a450d57498923cb0cb

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SFC MILPITAS INC — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
118 within 1 mi · 666 within 3 mi
Off / on premise
27 / 76 within 1 mi · 161 / 401 within 3 mi
Selling alcohol
47 within 1 mi · 340 within 3 mi
Nearest
same channel 0.15 mi · licensed 0.09 mi
Setting
urban (5,878 people per sq mi)
People within 3 mi
166,195 (126,256 adults 21+, 51,409 households) from 36 tract(s), tracts within 3 mi
Income
per capita $41,294 · median household ~$105,087 (weighted mean of tract medians)
Age and education
median age ~39.0 · bachelor's or higher 28%
Ethnicity
Hispanic 46% · White 17% · Black 7% · Asian 26%
Adults per alcohol outlet
370
Alcohol spend within 3 mi
$41,461,894 a year ($18,361,863 at home, $23,082,479 away) · $121,589 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-16 14:56insertca-abc 00591147|21|LIC|0 ↔ doordash 576329one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4248377 ↔ doordash 576329one name contains the other, same addressheld: same-source-conflict15
2026-11-12 17:29insertdoordash 1533998 ↔ overture ab3fc3be-92a1-4da0-aef5-9af77e6c4940same address and nameheld: same-source-conflict14
2026-11-12 17:29insertab-inbev 4248377 ↔ doordash 1533998same address and namemerged14
2026-11-11 12:56insertab-inbev 4248377 ↔ overture bd52d6a2-b004-44b4-b917-c286b76a11f3same address and namemerged12
2026-11-11 12:56insertab-inbev 4248377 ↔ ca-abc 00591147|21|LIC|0same address and namemerged12
2026-11-06 18:13insertdoordash 1533998 ↔ overture bd52d6a2-b004-44b4-b917-c286b76a11f3same address and namemerged11
2026-11-06 18:13insertca-abc 00591147|21|LIC|0 ↔ overture bd52d6a2-b004-44b4-b917-c286b76a11f3same address and namemerged11
2026-11-02 23:02backfillca-abc 00591147|21|LIC|0 ↔ doordash 1533998Claude judge: samemerged