ALCOSTA SHELL

DUBLIN, CA 94568 · O0614b8dd817a · first seen 2026-10-08
6 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
ALCOSTA SHELL 4 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)
rebel convenience stores dublin doordash
Street
8999 SAN RAMON RD
shellno other value
City
DUBLIN
shellno other value
State
CA
shellno other value
ZIP
94568
shellno other value
Pin
37.72286, -121.94179 map 1 other
shell
67 m away ab-inbev
Phone
9258284820 1 other
shell
9258283500 vtinfo
Licences
ca-abc 00436008|20|APP|0 · ca-abc 00674323|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocaf5108ac221; O490ed6777b33; Oaa1ab3edf94b; O98fe64a94f62; Of1686ae901b4; O89cdb3ee0341

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
2925474
8999 SAN RAMON RD, DUBLIN, CA, 9456837.72277, -121.941042026-11-112026-11-12
ca-abcALCOSTA SHELL
legal name: C & J COX CORPORATION
00436008|20|APP|0
8999 SAN RAMON RD, DUBLIN, CA, 9456837.72291, -121.942292026-10-082026-11-05
ca-abcALCOSTA SHELL
legal name: RADC ENTERPRISES INC
00674323|20|LIC|0
8999 SAN RAMON RD, DUBLIN, CA, 9456837.72291, -121.942292026-10-082026-11-05
doordashrebel convenience stores dublin
40589389
8999 San Ramon Rd, Dublin, CA, 9456837.72263, -121.941732026-10-082026-11-05
overtureShell
7ebe5b60-89ac-4b2f-b460-9b7cb714609c
8999 San Ramon Rd, Dublin, CA, 94568925828482037.72288, -121.941802026-11-132026-11-13
shellShell
10007871
8999 SAN RAMON RD, DUBLIN, CA, 94568925828482037.72286, -121.941792026-11-102026-11-12
vtinfoSHELL
51ce2d9a626c5369
8999 SAN RAMON RD, DUBLIN, CA, 94568925828350037.72273, -121.941842026-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 68 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 67 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 70 m apart · name similarity 1.00
ca-abc ALCOSTA SHELLca-abc ALCOSTA 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 2 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 16 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 15 m apart · name similarity 1.00 · phone: differs
ab-inbev SHELLca-abc ALCOSTA SHELL0.53Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (78% confident; asked as a “near” pair)
Shell station and Alcosta Shell licence, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records sit at 8999 San Ramon Rd, Dublin CA 94568 within about 0.1 km, and the ca-abc trade name 'ALCOSTA SHELL' carries the same Shell banner as the ab-inbev 'SHELL' account, so this looks like one gas station with an off-sale licence. Confidence is tempered because the building holds three businesses and the licence is only an application.
pair 3e819ead1b40c8dfdaf0
ab-inbev SHELLca-abc ALCOSTA SHELL0.53Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Shell and Alcosta Shell same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records sit at 8999 San Ramon Rd, Dublin CA 94568 with coordinates about 0.1 km apart, and B's trade name 'ALCOSTA SHELL' contains the 'SHELL' name from A, which suggests one Shell-branded station with its off-sale beer and wine licence; the three businesses at this address and the chain branding leave some doubt.
pair 0834979fe9370c134bc9
ca-abc ALCOSTA SHELLdoordash rebel convenience stores dublin0.17Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “same-address” pair)
Both records sit at the same street address and ZIP, and it is the only business our data holds there. A Shell station's convenience store branded as a Rebel store fits one operation, and the active o
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: different, 60% confident — The street address is shared by three businesses in the data, so the names must agree, and 'ALCOSTA SHELL' does not match 'Rebel Convenience Stores Dublin' even though the address and coordinates line up closely.
pair af2e2b1a5003ebdcace7

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:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
27 within 1 mi · 283 within 3 mi
Off / on premise
9 / 11 within 1 mi · 92 / 141 within 3 mi
Selling alcohol
17 within 1 mi · 170 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.02 mi
Setting
urban (3,001 people per sq mi)
People within 3 mi
84,841 (62,195 adults 21+, 29,238 households) from 15 tract(s), tracts within 3 mi
Income
per capita $80,719 · median household ~$193,717 (weighted mean of tract medians)
Age and education
median age ~40.2 · bachelor's or higher 66%
Ethnicity
Hispanic 12% · White 38% · Black 3% · Asian 43%
Adults per alcohol outlet
364
Alcohol spend within 3 mi
$33,008,374 a year ($13,754,469 at home, $19,244,867 away) · $193,031 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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:10insertshell 10007871 ↔ vtinfo 51ce2d9a626c5369same address and namemerged15
2026-11-13 14:10insertoverture 7ebe5b60-89ac-4b2f-b460-9b7cb714609c ↔ vtinfo 51ce2d9a626c5369same address and namemerged15
2026-11-13 14:10insertab-inbev 2925474 ↔ vtinfo 51ce2d9a626c5369same address and namemerged15
2026-11-13 14:10insertoverture 7ebe5b60-89ac-4b2f-b460-9b7cb714609c ↔ shell 10007871same address and namemerged15
2026-11-13 14:10insertab-inbev 2925474 ↔ overture 7ebe5b60-89ac-4b2f-b460-9b7cb714609csame address and namemerged15
2026-11-12 17:29insertab-inbev 2925474 ↔ ca-abc 00436008|20|APP|0Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2925474 ↔ ca-abc 00674323|20|LIC|0Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2925474 ↔ shell 10007871same address and namemerged12
2026-11-05 17:26backfillca-abc 00436008|20|APP|0 ↔ ca-abc 00674323|20|LIC|0one store listed twicemerged
2026-11-02 23:02backfillca-abc 00674323|20|LIC|0 ↔ doordash 40589389Claude judge: samemerged