Shell

COVINA, CA 91722 · O26bfffec1a64 · first seen 2026-10-08
5 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 2 other
the most common name a source states
AZUSA SHELL ca-abc
MID CITY FUEL INC ca-abc (legal name)
Street
871 W SAN BERNARDINO RD
shellno other value
City
COVINA
shellno other value
State
CA
shellno other value
ZIP
91722
shellno other value
Pin
34.08938, -117.90745 map 1 other
shell
79 m away ab-inbev
Phone
6269674741
shellno other value
Licences
ca-abc 00647949|20|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oded7d7a3fcbb; O6ebba2b100b2; O4156cb704cd7; Oaff47e2d8a60

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
539397
871 W SAN BERNARDINO RD, COVINA, CA, 9172234.08918, -117.906632026-11-112026-11-13
ca-abcAZUSA SHELL
legal name: MID CITY FUEL INC
00647949|20|LIC|0
871 W SAN BERNARDINO RD, COVINA, CA, 9172234.08913, -117.907052026-10-082026-11-16
overtureShell
aac8ddc3-8a88-44cc-b07b-8ded8b9a12fd
871 W San Bernardino Rd, Covina, CA, 91722626967474134.08931, -117.907442026-11-132026-11-13
shellShell
10007853
871 W SAN BERNARDINO RD, COVINA, CA, 91722626967474134.08938, -117.907452026-11-102026-11-13
vtinfoSHELL
4ce08c8633c2903f
871 W SAN BERNARDINO RD, COVINA, CA, 91722626967474134.08937, -117.907412026-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 76 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 79 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 75 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 8 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 7 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 4 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELLca-abc AZUSA SHELL0.56one name contains the other, same addressmergedjudge: None · pair_id: f435ae7bc73e694ed2c4 · person: None · rule: names contained at one address · stratum: near
ca-abc AZUSA SHELLvtinfo SHELL0.56one name contains the other, same addressmergedjudge: None · pair_id: 2646222b1387cc1cc0e2 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
MID CITY FUEL INC — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off — CA 20
Rule version 9, computed 2026-11-17 18:21.
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
125 within 1 mi · 885 within 3 mi
Off / on premise
31 / 82 within 1 mi · 238 / 515 within 3 mi
Selling alcohol
60 within 1 mi · 436 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.03 mi
Setting
urban (7,065 people per sq mi)
People within 3 mi
199,759 (150,054 adults 21+, 59,195 households) from 41 tract(s), tracts within 3 mi
Income
per capita $35,866 · median household ~$97,371 (weighted mean of tract medians)
Age and education
median age ~38.2 · bachelor's or higher 26%
Ethnicity
Hispanic 63% · White 22% · Black 4% · Asian 18%
Adults per alcohol outlet
343
Alcohol spend within 3 mi
$44,800,887 a year ($20,096,020 at home, $24,684,882 away) · $102,519 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 00647949|20|LIC|0 ↔ vtinfo 4ce08c8633c2903fone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 539397 ↔ ca-abc 00647949|20|LIC|0one name contains the other, same addressmerged15
2026-11-13 14:10insertoverture aac8ddc3-8a88-44cc-b07b-8ded8b9a12fd ↔ vtinfo 4ce08c8633c2903fsame address and namemerged15
2026-11-13 14:10insertoverture aac8ddc3-8a88-44cc-b07b-8ded8b9a12fd ↔ shell 10007853same address and namemerged15
2026-11-13 14:10insertab-inbev 539397 ↔ overture aac8ddc3-8a88-44cc-b07b-8ded8b9a12fdsame address and namemerged15
2026-11-12 14:25insertshell 10007853 ↔ vtinfo 4ce08c8633c2903fsame address and namemerged12
2026-11-12 14:25insertab-inbev 539397 ↔ vtinfo 4ce08c8633c2903fsame address and namemerged12
2026-11-11 12:56insertab-inbev 539397 ↔ shell 10007853same address and namemerged12