Willhaven Shell

Fair Oaks, CA 95864 · O06d051638837 · first seen 2026-10-08
2 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
Willhaven Shell 2 other
a licence name in capitals, cleaned (derived; record_title.py)
AU ENERGY LLC ca-abc (legal name)
WILLHAVIN SHELL overture
Street
3510 FAIR OAKS BLVD
ca-abcno other value
City
SACRAMENTO 1 other
ca-abc
Fair Oaks overture
State
CA
ca-abcno other value
ZIP
95864
ca-abcno other value
Pin
38.57376, -121.38248 map
overtureno other value
Phone
9163652051
overtureno other value
Licences
ca-abc 00565126|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O654db0cb47f3

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
ca-abcWILLHAVEN SHELL
legal name: AU ENERGY LLC
00565126|20|LIC|0
3510 FAIR OAKS BLVD, SACRAMENTO, CA, 9586438.57401, -121.382832026-10-082026-11-06
overtureWILLHAVIN SHELL
7fb95117-9a83-4768-90e1-8515d5d5d2a0
3510 Fair Oaks Blvd, Fair Oaks, CA, 95864
ZIP lookup: Sacramento, CA
916365205138.57376, -121.382482026-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
ab-inbev SHELL FOOD MARTca-abc WILLHAVEN SHELL0.29one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 89dc04de1624c016b3e7 · person: None · rule: names contained at one address · stratum: same-address
ca-abc WILLHAVEN SHELLvtinfo SHELL FOOD MART0.29one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d78a9475128c24794924 · person: None · rule: names contained at one address · stratum: same-address
ca-abc WILLHAVEN SHELLoverture WILLHAVIN SHELL0.63same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 41 m apart · name similarity 0.63

Attributes

Channel
off_premise — ca-licence
Chain
none
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 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
36 within 1 mi · 740 within 3 mi
Off / on premise
9 / 21 within 1 mi · 170 / 463 within 3 mi
Selling alcohol
23 within 1 mi · 418 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.04 mi
Setting
urban (4,785 people per sq mi)
People within 3 mi
135,281 (101,733 adults 21+, 55,805 households) from 34 tract(s), tracts within 3 mi
Income
per capita $50,216 · median household ~$92,778 (weighted mean of tract medians)
Age and education
median age ~37.8 · bachelor's or higher 44%
Ethnicity
Hispanic 21% · White 55% · Black 8% · Asian 10%
Adults per alcohol outlet
243
Alcohol spend within 3 mi
$39,836,124 a year ($18,000,460 at home, $21,818,281 away) · $95,074 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-16 14:56insertca-abc 00565126|20|LIC|0 ↔ vtinfo eb50ffb84f23b6fbone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 1347415 ↔ ca-abc 00565126|20|LIC|0one name contains the other, same addressheld: same-source-conflict15
2026-11-06 18:13insertca-abc 00565126|20|LIC|0 ↔ overture 7fb95117-9a83-4768-90e1-8515d5d5d2a0same address and namemerged11