Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 94541 | ca-abc | no other value |
| Pin | 37.66641, -122.11908 map 1 other | ubereats | 97 m away ca-abc |
| Phone | 5102007466 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SHELL SHOCK SEAFOOD RESTAURANT 4230855 | 20413 HESPERIAN BLVD, HAYWARD, CA, 94541 | 37.66624, -122.11860 | 2026-11-11 | 2026-11-11 | |
| ca-abc | SHELL SHOCK SEAFOOD RESTAURANT legal name: SHELL SHOCK SEAFOOD HOUSE 00602714|41|LIC|0 | 20413 HESPERIAN BLVD, HAYWARD, CA, 94541 | 37.66577, -122.11833 | 2026-10-08 | 2026-11-06 | |
| doordash | shell shock seafood house hayward 1104434 | 20413 Hesperian Boulevard, Hayward, CA, 94541 | 37.66645, -122.11892 | 2026-10-08 | 2026-11-06 | |
| overture | Shell Shock Seafood House 4fe2c981-aa1a-4b8f-be41-471b0552e927 | 20413 Hesperian Blvd, Hayward, CA, 94541 | 5102007466 | 37.66641, -122.11885 | 2026-11-06 | 2026-11-06 |
| ubereats | Shell Shock Seafood House UK5aV85IQ0Gl-aoIHPIJng | 20413 Hesperian Blvd, Hayward, CA, 94541 | 37.66641, -122.11908 | 2026-10-20 | 2026-11-06 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev SHELL SHOCK SEAFOOD RESTAURANT | ca-abc SHELL SHOCK SEAFOOD RESTAURANT | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00 |
| ca-abc SHELL SHOCK SEAFOOD RESTAURANT | overture Shell Shock Seafood House | 1.00 | same address and name | merged | address 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 hayward | overture Shell Shock Seafood House | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00 |
| doordash shell shock seafood house hayward | ubereats Shell Shock Seafood House | 1.00 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00 |
| overture Shell Shock Seafood House | ubereats Shell Shock Seafood House | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00 |
| ca-abc SHELL SHOCK SEAFOOD RESTAURANT | doordash shell shock seafood house hayward | 0.68 | Claude judge: same | merged | 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:
pair 92f71bf20be6a259f87f |
| ca-abc SHELL SHOCK SEAFOOD RESTAURANT | ubereats Shell Shock Seafood House | 0.68 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-11 12:56 | insert | ab-inbev 4230855 ↔ ca-abc 00602714|41|LIC|0 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | ca-abc 00602714|41|LIC|0 ↔ overture 4fe2c981-aa1a-4b8f-be41-471b0552e927 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | overture 4fe2c981-aa1a-4b8f-be41-471b0552e927 ↔ ubereats UK5aV85IQ0Gl-aoIHPIJng | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 1104434 ↔ overture 4fe2c981-aa1a-4b8f-be41-471b0552e927 | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00602714|41|LIC|0 ↔ doordash 1104434 | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00602714|41|LIC|0 ↔ ubereats UK5aV85IQ0Gl-aoIHPIJng | Claude judge: same | merged | |
| 2026-10-20 21:04 | backfill | doordash 1104434 ↔ ubereats UK5aV85IQ0Gl-aoIHPIJng | same address and name | merged |