Seafood City

UNION CITY, CA 94587 · O26efd62fe225 · 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 3 other
the most common name a source states
SEAFOOD CITY SUPERMARKET ab-inbev
seafood city union city doordash
SFC MARKETPLACE INC ca-abc (legal name)
Street
31840 ALVARADO BLVD
ca-abcno other value
City
UNION CITY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94587
ca-abcno other value
Pin
37.59145, -122.06984 map 2 other
doordash
138 m away ab-inbev
139 m away ca-abc
Phone
5104298739
overtureno other value
Licences
ca-abc 00420417|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6a9772147653; Oad836cec2923; Ob774849362e3

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
2937771
31840 ALVARADO BLVD, UNION CITY, CA, 9458737.59037, -122.070612026-11-112026-11-12
ca-abcSEAFOOD CITY
legal name: SFC MARKETPLACE INC
00420417|21|LIC|0
31840 ALVARADO BLVD, UNION CITY, CA, 9458737.59065, -122.071052026-10-082026-11-05
doordashseafood city union city
1534536
31840 Alvarado Blvd, Union City, CA, 9458737.59145, -122.069842026-10-082026-11-02
overtureSeafood City
b251b16d-2324-4a73-b321-97d42df0c189
31840 Alvarado Blvd, Union City, CA, 94587510429873937.59146, -122.069762026-11-062026-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
ca-abc SEAFOOD CITYoverture Seafood City1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 145 m apart · name similarity 1.00
ca-abc SEAFOOD CITYdoordash seafood city union city0.73Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
Both records are Seafood City at the same street address, 31840 Alvarado Blvd, Union City 94587; the DoorDash slug simply appends the city, and the off-sale licence fits a supermarket.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 88% confident — Both records give 31840 Alvarado Blvd, Union City, CA 94587, and the names match (SEAFOOD CITY vs. the DoorDash slug 'seafood city union city'). The records are about 140 m apart and the address is shared with another business, but the agreeing names settle it.
pair ebab27eeb7cba0fb223f
ab-inbev SEAFOOD CITY SUPERMARKETca-abc SEAFOOD CITY0.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 50 m apart · name similarity 0.67
ab-inbev SEAFOOD CITY SUPERMARKEToverture Seafood City0.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 143 m apart · name similarity 0.67

Attributes

Channel
off_premise — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SFC MARKETPLACE INC — 4 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:21.
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
105 within 1 mi · 420 within 3 mi
Off / on premise
26 / 75 within 1 mi · 100 / 271 within 3 mi
Selling alcohol
53 within 1 mi · 219 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (4,584 people per sq mi)
People within 3 mi
129,598 (101,518 adults 21+, 39,386 households) from 28 tract(s), tracts within 3 mi
Income
per capita $58,437 · median household ~$150,752 (weighted mean of tract medians)
Age and education
median age ~42.4 · bachelor's or higher 45%
Ethnicity
Hispanic 22% · White 16% · Black 4% · Asian 55%
Adults per alcohol outlet
461
Alcohol spend within 3 mi
$39,455,428 a year ($16,778,587 at home, $22,664,852 away) · $179,343 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 17:29insertab-inbev 2937771 ↔ ca-abc 00420417|21|LIC|0same address and namemerged14
2026-11-12 17:29insertab-inbev 2937771 ↔ overture b251b16d-2324-4a73-b321-97d42df0c189same address and namemerged14
2026-11-06 18:13insertca-abc 00420417|21|LIC|0 ↔ overture b251b16d-2324-4a73-b321-97d42df0c189same address and namemerged11
2026-11-02 23:02backfillca-abc 00420417|21|LIC|0 ↔ doordash 1534536Claude judge: samemerged