First Roscoe Shell

SUN VALLEY, CA 91352 · O4b09dbfc8f97 · first seen 2026-10-08
6 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
First Roscoe Shell 2 other
a licence name in capitals, cleaned (derived; record_title.py)
SHELL ab-inbevovertureshellvtinfo ×4
B P ROSCOE INC ca-abc (legal name)
Street
12858 ROSCOE BLVD
shellno other value
City
SUN VALLEY
shellno other value
State
CA
shellno other value
ZIP
91352
shellno other value
Pin
34.22134, -118.41402 map 2 other
shell
71 m away ca-abc
71 m away inspections
Phone
8189882321 1 other
shell
8189880690 vtinfo
Licences
ca-abc 00366472|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6be6499b86df; Ofb5e79f88574; O69d9101130d2; O893d4c79c4dc; O522991efba0c

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
2017384
12858 ROSCOE BLVD, SUN VALLEY, CA, 9135234.22161, -118.413662026-11-112026-11-12
ca-abcFIRST ROSCOE SHELL
legal name: B P ROSCOE INC
00366472|20|LIC|0
12858 ROSCOE BLVD, SUN VALLEY, CA, 9135234.22160, -118.413312026-10-082026-11-05
inspectionsFIRST ROSCOE SHELL
inspections|la|FA0013674|PR0041100
12858 ROSCOE BLVD, Sun Valley, CA, 9135234.22160, -118.413312026-11-192026-11-20
overtureShell
b057c103-867f-41fc-94fb-76f801290e87
12858 Roscoe Blvd, Sun Valley, CA, 91352818988232134.22134, -118.414082026-11-132026-11-13
shellShell
10008390
12858 ROSCOE BLVD, SUN VALLEY, CA, 91352818988232134.22134, -118.414022026-11-102026-11-12
vtinfoSHELL
ce1ccb6b8f7cd1c2
12858 ROSCOE BLVD, SUN VALLEY, CA, 91352818988069034.22131, -118.414042026-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 SHELLoverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 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 44 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 49 m apart · name similarity 1.00
ca-abc FIRST ROSCOE SHELLinspections FIRST ROSCOE 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 6 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 5 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 4 m apart · name similarity 1.00 · phone: differs
ab-inbev SHELLca-abc FIRST ROSCOE SHELL0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Shell station at same address, names agree
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at the same street address (12858 Roscoe Blvd, Sun Valley, CA) with coordinates about 32 m apart, and the California licensee's trade name 'FIRST ROSCOE SHELL' is the Shell-branded station the ab-inbev record calls 'SHELL', so they most likely describe one station.
pair 2b6d7b0766b5c4f7eb9e
ca-abc FIRST ROSCOE SHELLvtinfo SHELL0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Shell station name, same address, off-sale store
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 12858 Roscoe Blvd, Sun Valley, CA 91352, about 75 m apart, and the name 'SHELL' appears in both, with the California licence trade name 'FIRST ROSCOE SHELL' probably being the local Shell station's DBA. The shared building (two businesses at the address) lowers confidence somewhat.
pair 15e1c6916814ec997aff

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
B P ROSCOE 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:33.
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
43 within 1 mi · 1,103 within 3 mi
Off / on premise
15 / 23 within 1 mi · 271 / 661 within 3 mi
Selling alcohol
16 within 1 mi · 432 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.06 mi
Setting
urban (10,913 people per sq mi)
People within 3 mi
308,564 (229,552 adults 21+, 93,395 households) from 84 tract(s), tracts within 3 mi
Income
per capita $28,254 · median household ~$69,827 (weighted mean of tract medians)
Age and education
median age ~36.4 · bachelor's or higher 20%
Ethnicity
Hispanic 68% · White 24% · Black 3% · Asian 9%
Adults per alcohol outlet
530
Alcohol spend within 3 mi
$56,631,138 a year ($26,458,392 at home, $30,147,259 away) · $130,788 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-19 20:37insertca-abc 00366472|20|LIC|0 ↔ vtinfo ce1ccb6b8f7cd1c2Claude judge: samemerged17
2026-11-19 20:37insertca-abc 00366472|20|LIC|0 ↔ inspections inspections|la|FA0013674|PR0041100same address and namemerged17
2026-11-13 14:10insertoverture b057c103-867f-41fc-94fb-76f801290e87 ↔ vtinfo ce1ccb6b8f7cd1c2same address and namemerged15
2026-11-13 14:10insertab-inbev 2017384 ↔ overture b057c103-867f-41fc-94fb-76f801290e87same address and namemerged15
2026-11-13 14:10insertoverture b057c103-867f-41fc-94fb-76f801290e87 ↔ shell 10008390same address and namemerged15
2026-11-12 17:29insertab-inbev 2017384 ↔ ca-abc 00366472|20|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2017384 ↔ vtinfo ce1ccb6b8f7cd1c2same address and namemerged12
2026-11-12 14:25insertshell 10008390 ↔ vtinfo ce1ccb6b8f7cd1c2same address and namemerged12
2026-11-11 12:56insertab-inbev 2017384 ↔ shell 10008390same address and namemerged12