Del Mar Shell

Del Mar, CA 92014 · O0f5918419e0c · 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
Del Mar Shell 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Shell overtureshellvtinfo ×3
STRAM INC ca-abc (legal name) ×2
Street
2205 VIA DE LA VALLE
shellno other value
City
DEL MAR 1 other
shell
SAN DIEGO ca-abcca-tobacco ×3
State
CA
shellno other value
ZIP
92014
shellno other value
Pin
32.97919, -117.25537 map
shellno other value
Phone
8587559216
shellno other value
Licences
ca-abc 00150175|20|APP|0 · ca-abc 00150175|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc7dcc000ad4e; Obdcd42aa3c0e; O8402d8f0898e; O3e1c5daa55f0; O8435f4eaed80; O1ea6ad91c9d3

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-abcDEL MAR SHELL
legal name: STRAM INC
00150175|20|APP|0
2205 VIA DE LA VALLE, SAN DIEGO, CA, 9201432.97948, -117.255412026-10-082026-11-05
ca-abcDEL MAR SHELL
legal name: STRAM INC
00150175|20|LIC|0
2205 VIA DE LA VALLE, SAN DIEGO, CA, 9201432.97948, -117.255412026-10-082026-11-05
ca-tobaccoDEL MAR SHELL
ca-tobacco|091244821
2205 VIA DE LA VALLE, San Diego, CA, 9201432.97948, -117.255412026-11-202026-11-22
inspectionsDEL MAR SHELL
inspections|sdcounty|DEH2002-FFPN-314858
2205 VIA DE LA VALLE, Del Mar, CA, 9201432.97948, -117.255412026-11-202026-11-22
overtureShell
a1c09e43-0ac6-4de5-a834-64d1daf8e5f3
2205 Via de La Valle, Del Mar, CA, 92014858755921632.97922, -117.255392026-11-132026-11-16
shellShell
10005995
2205 VIA DE LA VALLE, DEL MAR, CA, 92014858755921632.97919, -117.255372026-11-102026-11-16
vtinfoSHELL
51c4a7d671af9c66
2205 VIA DE LA VALLE, DEL MAR, CA, 92014858755921632.97908, -117.255312026-11-122026-11-16

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
ca-abc DEL MAR SHELLca-abc DEL MAR SHELL1.00one licence filemergedfile: 00150175 · same_address
ca-abc DEL MAR SHELLca-tobacco DEL MAR SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc DEL MAR SHELLinspections DEL MAR SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc DEL MAR SHELLca-tobacco DEL MAR SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc DEL MAR SHELLinspections DEL MAR SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-tobacco DEL MAR SHELLinspections DEL MAR SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture 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 · phone: equal
overture Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00 · phone: equal
shell Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 m apart · name similarity 1.00 · phone: equal
ca-abc DEL MAR SHELLvtinfo SHELL0.44one name contains the other, same addressmergedjudge: None · pair_id: 1d43e957ee695422103b · person: None · rule: names contained at one address · stratum: same-address
ca-abc DEL MAR SHELLvtinfo SHELL0.44one name contains the other, same addressmergedjudge: None · pair_id: 17b8d4a1b2f641da8916 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
STRAM INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 11, computed 2026-11-20 23:32.
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
69 within 1 mi · 314 within 3 mi
Off / on premise
11 / 48 within 1 mi · 49 / 210 within 3 mi
Selling alcohol
45 within 1 mi · 223 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.02 mi
Setting
suburban (1,942 people per sq mi)
People within 3 mi
54,917 (41,219 adults 21+, 22,701 households) from 14 tract(s), tracts within 3 mi
Income
per capita $98,626 · median household ~$181,540 (weighted mean of tract medians)
Age and education
median age ~45.5 · bachelor's or higher 80%
Ethnicity
Hispanic 12% · White 64% · Black 0% · Asian 20%
Adults per alcohol outlet
184
Alcohol spend within 3 mi
$24,685,853 a year ($10,336,560 at home, $14,342,772 away) · $110,205 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-20 22:08insertca-abc 00150175|20|LIC|0 ↔ inspections inspections|sdcounty|DEH2002-FFPN-314858same address and namemerged17
2026-11-20 22:08insertca-tobacco ca-tobacco|091244821 ↔ inspections inspections|sdcounty|DEH2002-FFPN-314858same address and namemerged17
2026-11-20 22:08insertca-abc 00150175|20|LIC|0 ↔ ca-tobacco ca-tobacco|091244821same address and namemerged17
2026-11-20 22:08insertca-abc 00150175|20|APP|0 ↔ inspections inspections|sdcounty|DEH2002-FFPN-314858same address and namemerged17
2026-11-20 22:08insertca-abc 00150175|20|APP|0 ↔ ca-tobacco ca-tobacco|091244821same address and namemerged17
2026-11-16 14:56insertca-abc 00150175|20|LIC|0 ↔ vtinfo 51c4a7d671af9c66one name contains the other, same addressmerged15
2026-11-16 14:56insertca-abc 00150175|20|APP|0 ↔ vtinfo 51c4a7d671af9c66one name contains the other, same addressmerged15
2026-11-13 14:10insertoverture a1c09e43-0ac6-4de5-a834-64d1daf8e5f3 ↔ vtinfo 51c4a7d671af9c66same address and namemerged15
2026-11-13 14:10insertoverture a1c09e43-0ac6-4de5-a834-64d1daf8e5f3 ↔ shell 10005995same address and namemerged15
2026-11-12 14:25insertshell 10005995 ↔ vtinfo 51c4a7d671af9c66same address and namemerged12
2026-10-09 13:59backfillca-abc 00150175|20|APP|0 ↔ ca-abc 00150175|20|LIC|0one licence filemerged