Shell

VACAVILLE, CA 95688 · O1067dffbd04a · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: Shellalcohol: 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 3 other
the most common name a source states
SHELL FOOD MART ab-inbevvtinfo ×2
AU ENERGY LLC ca-abc (legal name)
MERCHANT SHELL ca-abc
Street
950 MERCHANT STREET 1 other
shell
950 MERCHANT ST ab-inbevca-abcoverturevtinfo ×4
City
VACAVILLE
shellno other value
State
CA
shellno other value
ZIP
95688
shellno other value
Pin
38.34795, -121.99767 map 2 other
shell
56 m away ab-inbev
54 m away ca-abc
Phone
7074489165 1 other
shell
7074489110 vtinfo
Licences
ca-abc 00534184|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob4cd7ab29cf2; O8ceb68589913; O3079f3af1f39; Of31767d46de3

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 FOOD MART
1347440
950 MERCHANT ST, VACAVILLE, CA, 9568838.34811, -121.997062026-11-112026-11-12
ca-abcMERCHANT SHELL
legal name: AU ENERGY LLC
00534184|20|LIC|0
950 MERCHANT ST, VACAVILLE, CA, 9568838.34809, -121.997072026-10-082026-11-12
overtureShell
0b48dc51-a162-43d6-8882-1bd85e477aea
950 Merchant St, Vacaville, CA, 95688707448916538.34793, -121.997592026-11-132026-11-13
shellShell
10010258
950 MERCHANT STREET, VACAVILLE, CA, 95688707448916538.34795, -121.997672026-11-102026-11-10
vtinfoSHELL FOOD MART
4ba38b417fc59947
950 MERCHANT ST, VACAVILLE, CA, 95688707448911038.34801, -121.997562026-11-142026-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 SHELL FOOD MARTvtinfo SHELL FOOD MART1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 45 m apart · name similarity 1.00
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELL FOOD MARTca-abc MERCHANT SHELL0.43Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (88% confident; asked as a “same-address” pair)
Both records are the Shell station's convenience store at 950 Merchant St, Vacaville, and the off-sale beer and wine licence fits a food mart, so 'Shell Food Mart' and 'Merchant Shell' are one outlet
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Shell food mart same address
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records sit at the same address (2 m apart) and carry the Shell brand, and the ABC licence is an off-sale beer and wine store, which fits a Shell food mart; the names differ in word order, so the match is not certain.
pair 06e9909c688efac59442
ab-inbev SHELL FOOD MARToverture Shell0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + ZIP · pins 50 m apart · name similarity 0.42
ab-inbev SHELL FOOD MARTshell Shell0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + ZIP · pins 56 m apart · name similarity 0.42
overture Shellvtinfo SHELL FOOD MART0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + ZIP · pins 10 m apart · name similarity 0.42 · phone: differs
shell Shellvtinfo SHELL FOOD MART0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + ZIP · pins 12 m apart · name similarity 0.42 · phone: differs

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
AU ENERGY LLC — 70 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 9, computed 2026-11-17 18:20.
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
111 within 1 mi · 390 within 3 mi
Off / on premise
28 / 71 within 1 mi · 111 / 239 within 3 mi
Selling alcohol
76 within 1 mi · 210 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
suburban (2,426 people per sq mi)
People within 3 mi
68,607 (51,803 adults 21+, 22,706 households) from 15 tract(s), tracts within 3 mi
Income
per capita $42,837 · median household ~$108,698 (weighted mean of tract medians)
Age and education
median age ~39.1 · bachelor's or higher 24%
Ethnicity
Hispanic 30% · White 54% · Black 9% · Asian 8%
Adults per alcohol outlet
246
Alcohol spend within 3 mi
$18,203,367 a year ($8,084,888 at home, $10,110,335 away) · $86,272 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-14 20:23insertshell 10010258 ↔ vtinfo 4ba38b417fc59947same address and namemerged15
2026-11-14 20:23insertoverture 0b48dc51-a162-43d6-8882-1bd85e477aea ↔ vtinfo 4ba38b417fc59947same address and namemerged15
2026-11-14 20:23insertab-inbev 1347440 ↔ vtinfo 4ba38b417fc59947same address and namemerged15
2026-11-13 14:10insertab-inbev 1347440 ↔ overture 0b48dc51-a162-43d6-8882-1bd85e477aeasame address and namemerged15
2026-11-13 14:10insertoverture 0b48dc51-a162-43d6-8882-1bd85e477aea ↔ shell 10010258same address and namemerged15
2026-11-12 17:29insertab-inbev 1347440 ↔ shell 10010258same address and namemerged14
2026-11-12 14:25insertab-inbev 1347440 ↔ ca-abc 00534184|20|LIC|0Claude judge: samemerged12