Outlets /
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.
| Field | Master value | Taken from | What 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 | shell | no other value |
| City | SUN VALLEY | shell | no other value |
| State | CA | shell | no other value |
| ZIP | 91352 | shell | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | SHELL 2017384 | 12858 ROSCOE BLVD, SUN VALLEY, CA, 91352 | 34.22161, -118.41366 | 2026-11-11 | 2026-11-12 | |
| ca-abc | FIRST ROSCOE SHELL legal name: B P ROSCOE INC 00366472|20|LIC|0 | 12858 ROSCOE BLVD, SUN VALLEY, CA, 91352 | 34.22160, -118.41331 | 2026-10-08 | 2026-11-05 | |
| inspections | FIRST ROSCOE SHELL inspections|la|FA0013674|PR0041100 | 12858 ROSCOE BLVD, Sun Valley, CA, 91352 | 34.22160, -118.41331 | 2026-11-19 | 2026-11-20 | |
| overture | Shell b057c103-867f-41fc-94fb-76f801290e87 | 12858 Roscoe Blvd, Sun Valley, CA, 91352 | 8189882321 | 34.22134, -118.41408 | 2026-11-13 | 2026-11-13 |
| shell | Shell 10008390 | 12858 ROSCOE BLVD, SUN VALLEY, CA, 91352 | 8189882321 | 34.22134, -118.41402 | 2026-11-10 | 2026-11-12 |
| vtinfo | SHELL ce1ccb6b8f7cd1c2 | 12858 ROSCOE BLVD, SUN VALLEY, CA, 91352 | 8189880690 | 34.22131, -118.41404 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev SHELL | overture Shell | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00 |
| ab-inbev SHELL | shell Shell | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00 |
| ab-inbev SHELL | vtinfo SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 49 m apart · name similarity 1.00 |
| ca-abc FIRST ROSCOE SHELL | inspections FIRST ROSCOE SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 |
| overture Shell | shell Shell | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: equal |
| overture Shell | vtinfo SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00 · phone: differs |
| shell Shell | vtinfo SHELL | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: differs |
| ab-inbev SHELL | ca-abc FIRST ROSCOE SHELL | 0.38 | Claude judge: same | merged | 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:
pair 2b6d7b0766b5c4f7eb9e |
| ca-abc FIRST ROSCOE SHELL | vtinfo SHELL | 0.38 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-19 20:37 | insert | ca-abc 00366472|20|LIC|0 ↔ vtinfo ce1ccb6b8f7cd1c2 | Claude judge: same | merged | 17 |
| 2026-11-19 20:37 | insert | ca-abc 00366472|20|LIC|0 ↔ inspections inspections|la|FA0013674|PR0041100 | same address and name | merged | 17 |
| 2026-11-13 14:10 | insert | overture b057c103-867f-41fc-94fb-76f801290e87 ↔ vtinfo ce1ccb6b8f7cd1c2 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2017384 ↔ overture b057c103-867f-41fc-94fb-76f801290e87 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | overture b057c103-867f-41fc-94fb-76f801290e87 ↔ shell 10008390 | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | ab-inbev 2017384 ↔ ca-abc 00366472|20|LIC|0 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 2017384 ↔ vtinfo ce1ccb6b8f7cd1c2 | same address and name | merged | 12 |
| 2026-11-12 14:25 | insert | shell 10008390 ↔ vtinfo ce1ccb6b8f7cd1c2 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 2017384 ↔ shell 10008390 | same address and name | merged | 12 |