Shell

SAN BRUNO, CA 94066 · O7ad3920ffb31 · 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
Shell 3 other
the most common name a source states
ROARING KITTEN INC ca-abc (legal name)
TANFORAN SHELL ca-abc
The Hangry Planet-Shell Tanforan ubereats
Street
1199 EL CAMINO REAL
shellno other value
City
SAN BRUNO
shellno other value
State
CA
shellno other value
ZIP
94066
shellno other value
Pin
37.63632, -122.42147 map 1 other
shell
88 m away ab-inbev
Phone
6505897058
shellno other value
Licences
ca-abc 00570468|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od5bbb742795a; Odc4d675b8259; Obf6856b0cfe6; O98b433e12713; Oc51b21495d4f

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
4994169
1199 EL CAMINO REAL, SAN BRUNO, CA, 9406637.63569, -122.420872026-11-112026-11-12
ca-abcTANFORAN SHELL
legal name: ROARING KITTEN INC
00570468|20|LIC|0
1199 EL CAMINO REAL, SAN BRUNO, CA, 9406637.63674, -122.421482026-10-082026-11-05
overtureShell
430e78d5-8dcf-402b-883e-a2f207b77379
1199 El Camino Real, San Bruno, CA, 94066650589705837.63637, -122.421442026-11-132026-11-13
shellShell
10008221
1199 EL CAMINO REAL, SAN BRUNO, CA, 94066650589705837.63632, -122.421472026-11-102026-11-12
ubereatsThe Hangry Planet-Shell Tanforan
vK9fUPnGQOGOW9tK0Ui-ow
1199 El Camino Real, San Bruno, CA, 9406637.63631, -122.421502026-10-282026-11-16
vtinfoSHELL
837d10c32253d0ba
1199 EL CAMINO REAL, SAN BRUNO, CA, 94066650589705837.63631, -122.421502026-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 HANGRY PLANETubereats The Hangry Planet-Shell Tanforan0.57one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 6cbfefde284584e4d22f · person: None · rule: names contained at one address · stratum: near
ab-inbev SHELLca-abc SAN BRUNO SHELL0.42one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 4d8545aea697cb0c8943 · person: None · rule: names contained at one address · stratum: same-address
ca-abc SAN BRUNO SHELLvtinfo SHELL0.42one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: eff9180244b7dad5283a · person: None · rule: names contained at one address · stratum: same-address
ca-abc SAN BRUNO SHELLubereats The Hangry Planet-Shell Tanforan0.27one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 0d60a6260330f4af071f · person: None · rule: names contained at one address · stratum: same-address
ab-inbev SHELLoverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 91 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 88 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 89 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 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 8 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 3 m apart · name similarity 1.00 · phone: equal
ca-abc TANFORAN SHELLubereats The Hangry Planet-Shell Tanforan0.58one name contains the other, same addressmergedjudge: None · pair_id: ab76f32ff36e306e4a04 · person: None · rule: names contained at one address · stratum: near
ab-inbev SHELLca-abc TANFORAN SHELL0.51Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Shell station same address, Tanforan Shell trade name
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records sit at the identical street address 1199 El Camino Real, San Bruno, and the ABC licence's trade name 'TANFORAN SHELL' is the same Shell brand as the AB InBev account 'SHELL', with coordinates about 128 m apart; the shared-building count of 5 weakens this somewhat, but the names agree.
pair 4b3de3a990e18a150c24
ab-inbev SHELLubereats The Hangry Planet-Shell Tanforan0.28one name contains the other, same addressmergedjudge: None · pair_id: 9c2c5dc500f1b4ffd9bc · person: None · rule: names contained at one address · stratum: same-address
ubereats The Hangry Planet-Shell Tanforanvtinfo SHELL0.28one name contains the other, same addressmergedjudge: None · pair_id: 589e9f7cf586597a7914 · 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
ROARING KITTEN INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 7, computed 2026-11-16 17:18.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
181 within 1 mi · 620 within 3 mi
Off / on premise
37 / 98 within 1 mi · 123 / 343 within 3 mi
Selling alcohol
113 within 1 mi · 418 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.00 mi
Setting
urban (4,779 people per sq mi)
People within 3 mi
135,118 (107,439 adults 21+, 46,736 households) from 31 tract(s), tracts within 3 mi
Income
per capita $64,004 · median household ~$140,633 (weighted mean of tract medians)
Age and education
median age ~42.9 · bachelor's or higher 43%
Ethnicity
Hispanic 27% · White 27% · Black 2% · Asian 42%
Adults per alcohol outlet
256
Alcohol spend within 3 mi
$45,022,004 a year ($19,316,754 at home, $25,690,869 away) · $107,451 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-09 23:07.

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 00678299|20|APP|0 ↔ ubereats vK9fUPnGQOGOW9tK0Ui-owone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertubereats vK9fUPnGQOGOW9tK0Ui-ow ↔ vtinfo 837d10c32253d0baone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4994169 ↔ ubereats vK9fUPnGQOGOW9tK0Ui-owone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4994169 ↔ ca-abc 00678299|20|APP|0one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00678299|20|APP|0 ↔ vtinfo 837d10c32253d0baone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4741508 ↔ ubereats vK9fUPnGQOGOW9tK0Ui-owone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00570468|20|LIC|0 ↔ ubereats vK9fUPnGQOGOW9tK0Ui-owone name contains the other, same addressmerged15
2026-11-13 14:10insertoverture 430e78d5-8dcf-402b-883e-a2f207b77379 ↔ vtinfo 837d10c32253d0basame address and namemerged15
2026-11-13 14:10insertoverture 430e78d5-8dcf-402b-883e-a2f207b77379 ↔ shell 10008221same address and namemerged15
2026-11-13 14:10insertab-inbev 4994169 ↔ overture 430e78d5-8dcf-402b-883e-a2f207b77379same address and namemerged15
2026-11-12 17:29insertab-inbev 4994169 ↔ ca-abc 00570468|20|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertshell 10008221 ↔ vtinfo 837d10c32253d0basame address and namemerged12
2026-11-12 14:25insertab-inbev 4994169 ↔ vtinfo 837d10c32253d0basame address and namemerged12
2026-11-11 12:56insertab-inbev 4994169 ↔ shell 10008221same address and namemerged12