Shell Food Mart

SANTA ROSA, CA 95407 · O12b36e15def9 · first seen 2026-11-10
4 sourcesoff premise · conveniencechain: Shellalcohol: alcohol

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 Food Mart 1 other
a licence name in capitals, cleaned (derived; record_title.py)
Shell overtureshell ×2
Street
3785 SANTA ROSA AVE
shellno other value
City
SANTA ROSA
shellno other value
State
CA
shellno other value
ZIP
95407
shellno other value
Pin
38.38678, -122.71407 map 3 other
shell
164 m away ab-inbev
82 m away overture
74 m away vtinfo
Phone
7075859655
shellno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of5eb33a5ac63; O6b81328d9a5b; Ofc9b4ac14359

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
2855514
3785 SANTA ROSA AVE, SANTA ROSA, CA, 9540738.38822, -122.713672026-11-112026-11-12
overtureShell
c2bde6b2-7c3e-4744-bc58-d7497a0a1802
3785 Santa Rosa Ave, Santa Rosa, CA, 95407707585965538.38749, -122.713832026-11-132026-11-13
shellShell
10008345
3785 SANTA ROSA AVE, SANTA ROSA, CA, 95407707585965538.38678, -122.714072026-11-102026-11-10
vtinfoSHELL FOOD MART
249fc6aee1dcc921
3785 SANTA ROSA AVE, SANTA ROSA, CA, 95407707585965538.38744, -122.714152026-11-122026-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 MARTca-abc TODD ROAD SHELL0.37one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d23928809cda11b1cefc · person: None · rule: names contained at one address · stratum: same-address
ca-abc TODD ROAD SHELLvtinfo SHELL FOOD MART0.37one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 906835ec7b1c2efc44a5 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev SHELL FOOD MARTvtinfo SHELL FOOD MART1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 96 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 82 m apart · name similarity 1.00 · phone: equal
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 82 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 164 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 + city + state · pins 29 m apart · name similarity 0.42 · phone: equal
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 + city + state · pins 74 m apart · name similarity 0.42 · phone: equal

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +3 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
23 within 1 mi · 319 within 3 mi
Off / on premise
13 / 3 within 1 mi · 111 / 143 within 3 mi
Selling alcohol
19 within 1 mi · 200 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
suburban (2,156 people per sq mi)
People within 3 mi
60,949 (43,483 adults 21+, 20,458 households) from 13 tract(s), tracts within 3 mi
Income
per capita $37,939 · median household ~$91,312 (weighted mean of tract medians)
Age and education
median age ~35.4 · bachelor's or higher 22%
Ethnicity
Hispanic 51% · White 39% · Black 3% · Asian 8%
Adults per alcohol outlet
216
Alcohol spend within 3 mi
$14,590,765 a year ($6,627,129 at home, $7,956,646 away) · $72,591 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 00534412|20|LIC|0 ↔ vtinfo 249fc6aee1dcc921one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 2855514 ↔ ca-abc 00534412|20|LIC|0one name contains the other, same addressheld: same-source-conflict15
2026-11-13 14:10insertoverture c2bde6b2-7c3e-4744-bc58-d7497a0a1802 ↔ vtinfo 249fc6aee1dcc921same address and namemerged15
2026-11-13 14:10insertab-inbev 2855514 ↔ overture c2bde6b2-7c3e-4744-bc58-d7497a0a1802same address and namemerged15
2026-11-13 14:10insertoverture c2bde6b2-7c3e-4744-bc58-d7497a0a1802 ↔ shell 10008345same address and namemerged15
2026-11-12 17:29insertshell 10008345 ↔ vtinfo 249fc6aee1dcc921same address and namemerged14
2026-11-12 17:29insertab-inbev 2855514 ↔ shell 10008345same address and namemerged14
2026-11-12 14:25insertab-inbev 2855514 ↔ vtinfo 249fc6aee1dcc921same address and namemerged12