Shell Shock Seafood House

Hayward, CA 94541 · O1fd1d806c830 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
Shell Shock Seafood House 2 other
the most common name a source states
SHELL SHOCK SEAFOOD RESTAURANT ab-inbevca-abc ×2
shell shock seafood house hayward doordash
Street
20413 HESPERIAN BLVD 1 other
ca-abc
20413 Hesperian Boulevard doordash
City
HAYWARD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94541
ca-abcno other value
Pin
37.66641, -122.11908 map 1 other
ubereats
97 m away ca-abc
Phone
5102007466
overtureno other value
Licences
ca-abc 00602714|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocd1e9be0b683; O87c1c997f1a9; O2ca7830476a3; Oed253f876b15

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-inbevSHELL SHOCK SEAFOOD RESTAURANT
4230855
20413 HESPERIAN BLVD, HAYWARD, CA, 9454137.66624, -122.118602026-11-112026-11-11
ca-abcSHELL SHOCK SEAFOOD RESTAURANT
legal name: SHELL SHOCK SEAFOOD HOUSE
00602714|41|LIC|0
20413 HESPERIAN BLVD, HAYWARD, CA, 9454137.66577, -122.118332026-10-082026-11-06
doordashshell shock seafood house hayward
1104434
20413 Hesperian Boulevard, Hayward, CA, 9454137.66645, -122.118922026-10-082026-11-06
overtureShell Shock Seafood House
4fe2c981-aa1a-4b8f-be41-471b0552e927
20413 Hesperian Blvd, Hayward, CA, 94541510200746637.66641, -122.118852026-11-062026-11-06
ubereatsShell Shock Seafood House
UK5aV85IQ0Gl-aoIHPIJng
20413 Hesperian Blvd, Hayward, CA, 9454137.66641, -122.119082026-10-202026-11-06

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 SHELL SHOCK SEAFOOD RESTAURANTca-abc SHELL SHOCK SEAFOOD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
ca-abc SHELL SHOCK SEAFOOD RESTAURANToverture Shell Shock Seafood House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 85 m apart · matched through the licence's legal name: SHELL SHOCK SEAFOOD HOUSE · name similarity 1.00
doordash shell shock seafood house haywardoverture Shell Shock Seafood House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
doordash shell shock seafood house haywardubereats Shell Shock Seafood House1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
overture Shell Shock Seafood Houseubereats Shell Shock Seafood House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
ca-abc SHELL SHOCK SEAFOOD RESTAURANTdoordash shell shock seafood house hayward0.68Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The two records share the same distinctive 'Shell Shock Seafood' name and the same street address, 20413 Hesperian Blvd, Hayward 94541, and only one business is known at that address, so they describe
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records sit at 20413 Hesperian Blvd, Hayward 94541 with a ~92 m coordinate gap, the only business at that address is in our data, and the names match (Shell Shock Seafood, with the DoorDash slug adding the city), so this is one seafood restaurant listed by the state licence and by DoorDash.
pair 92f71bf20be6a259f87f
ca-abc SHELL SHOCK SEAFOOD RESTAURANTubereats Shell Shock Seafood House0.68Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The two records share the same street address and ZIP, with only one business recorded there, and the distinctive name 'Shell Shock Seafood' matches on both sides ('Restaurant' vs 'House'), fitting th
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records sit at 20413 Hesperian Blvd, Hayward 94541, with coordinates about 0.1 km apart, the only business at that address in the data, and the names Shell Shock Seafood Restaurant and Shell Shock Seafood House are near-identical; the CA licence is an eating-place restaurant licence, consistent with a seafood restaurant.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records sit at 20413 Hesperian Blvd, Hayward 94541, with one business counted at that address, and the names Shell Shock Seafood Restaurant and Shell Shock Seafood House are near-identical; the California licence is an active restaurant licence that fits a seafood restaurant listed on Uber Eats.
pair 25a2e79779d89cb27894

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
96 within 1 mi · 823 within 3 mi
Off / on premise
27 / 58 within 1 mi · 222 / 491 within 3 mi
Selling alcohol
47 within 1 mi · 424 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.04 mi
Setting
urban (6,856 people per sq mi)
People within 3 mi
193,854 (147,615 adults 21+, 63,048 households) from 39 tract(s), tracts within 3 mi
Income
per capita $42,939 · median household ~$104,366 (weighted mean of tract medians)
Age and education
median age ~39.7 · bachelor's or higher 29%
Ethnicity
Hispanic 41% · White 20% · Black 10% · Asian 27%
Adults per alcohol outlet
347
Alcohol spend within 3 mi
$49,955,626 a year ($22,131,267 at home, $27,803,051 away) · $117,543 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-11 12:56insertab-inbev 4230855 ↔ ca-abc 00602714|41|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00602714|41|LIC|0 ↔ overture 4fe2c981-aa1a-4b8f-be41-471b0552e927same address and namemerged11
2026-11-06 18:13insertoverture 4fe2c981-aa1a-4b8f-be41-471b0552e927 ↔ ubereats UK5aV85IQ0Gl-aoIHPIJngsame address and namemerged11
2026-11-06 18:13insertdoordash 1104434 ↔ overture 4fe2c981-aa1a-4b8f-be41-471b0552e927same address and namemerged11
2026-11-02 23:02backfillca-abc 00602714|41|LIC|0 ↔ doordash 1104434Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00602714|41|LIC|0 ↔ ubereats UK5aV85IQ0Gl-aoIHPIJngClaude judge: samemerged
2026-10-20 21:04backfilldoordash 1104434 ↔ ubereats UK5aV85IQ0Gl-aoIHPIJngsame address and namemerged