HOPYARD SHELL

PLEASANTON, CA 94588 · O64465ade6b55 · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: Shellalcohol: licensed2 licences

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
HOPYARD SHELL 3 other
the most common name a source states
SHELL ab-inbevovertureshellvtinfo ×4
C & J COX CORPORATION ca-abc (legal name)
RADC ENTERPRISES INC ca-abc (legal name)
Street
5251 HOPYARD RD
shellno other value
City
PLEASANTON
shellno other value
State
CA
shellno other value
ZIP
94588
shellno other value
Pin
37.69836, -121.90356 map
shellno other value
Phone
9255941058 1 other
shell
9254630980 vtinfo
Licences
ca-abc 00403655|20|APP|0 · ca-abc 00674337|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc3b52572c27d; Odc6dfc5b2af1; O8637f7687aa9; Oa7a83fe76ae8; O66ddbf39cd52

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
2354426
5251 HOPYARD RD, PLEASANTON, CA, 9458837.69839, -121.903592026-11-112026-11-11
ca-abcHOPYARD SHELL
legal name: C & J COX CORPORATION
00403655|20|APP|0
5251 HOPYARD RD, PLEASANTON, CA, 9458837.69809, -121.903722026-10-082026-11-12
ca-abcHOPYARD SHELL
legal name: RADC ENTERPRISES INC
00674337|20|LIC|0
5251 HOPYARD RD, PLEASANTON, CA, 9458837.69809, -121.903722026-10-082026-11-12
overtureShell
54bb2386-476b-4044-814a-32e90deb7438
5251 Hopyard Rd, Pleasanton, CA, 94588925594105837.69838, -121.903652026-11-132026-11-13
shellShell
10008154
5251 HOPYARD RD, PLEASANTON, CA, 94588925594105837.69836, -121.903562026-11-102026-11-10
vtinfoSHELL
2b0d212174b0bfaa
5251 HOPYARD RD, PLEASANTON, CA, 94588925463098037.69851, -121.903522026-11-132026-11-14

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 SHELLoverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev SHELLshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
ab-inbev SHELLvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00
ca-abc HOPYARD SHELLca-abc HOPYARD SHELL1.00one store listed twicemergedsame street + ZIP · name: identical
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00 · phone: equal
overture Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00 · phone: differs
shell Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00 · phone: differs
ab-inbev SHELLca-abc HOPYARD SHELL0.53Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Shell vs Hopyard Shell, same address, off-sale store licence.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records sit at 5251 Hopyard Rd, Pleasanton, 94588, about 35 m apart, and the names align: the AB InBev account 'SHELL' matches the ABC licence trade name 'HOPYARD SHELL', a Shell-branded station. The shared building (3 businesses at the address) and a licence that is only an application lower confidence.
pair 11f382294abcade3c548

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off — CA 20
Rule version 7, computed 2026-11-16 17:17.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
129 within 1 mi · 718 within 3 mi
Off / on premise
29 / 83 within 1 mi · 156 / 471 within 3 mi
Selling alcohol
67 within 1 mi · 355 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.05 mi
Setting
urban (3,310 people per sq mi)
People within 3 mi
93,582 (70,165 adults 21+, 34,142 households) from 17 tract(s), tracts within 3 mi
Income
per capita $78,674 · median household ~$180,228 (weighted mean of tract medians)
Age and education
median age ~39.9 · bachelor's or higher 66%
Ethnicity
Hispanic 14% · White 35% · Black 4% · Asian 44%
Adults per alcohol outlet
197
Alcohol spend within 3 mi
$37,245,296 a year ($15,616,024 at home, $21,619,017 away) · $104,622 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-13 14:10insertab-inbev 2354426 ↔ vtinfo 2b0d212174b0bfaasame address and namemerged15
2026-11-13 14:10insertshell 10008154 ↔ vtinfo 2b0d212174b0bfaasame address and namemerged15
2026-11-13 14:10insertoverture 54bb2386-476b-4044-814a-32e90deb7438 ↔ vtinfo 2b0d212174b0bfaasame address and namemerged15
2026-11-13 14:10insertab-inbev 2354426 ↔ overture 54bb2386-476b-4044-814a-32e90deb7438same address and namemerged15
2026-11-13 14:10insertoverture 54bb2386-476b-4044-814a-32e90deb7438 ↔ shell 10008154same address and namemerged15
2026-11-12 17:29insertab-inbev 2354426 ↔ ca-abc 00403655|20|APP|0Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2354426 ↔ shell 10008154same address and namemerged12
2026-11-05 17:26backfillca-abc 00403655|20|APP|0 ↔ ca-abc 00674337|20|LIC|0one store listed twicemerged