Shell

Warren, MI 48088 · O07cab690ca88 · first seen 2026-11-03
5 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
Shell 2 other
the most common name a source states
NAA PETROLEUM, INC. mi-lcc (legal name) ×2
SHELL FOOD MART ab-inbevvtinfo ×2
Street
27027 SCHOENHERR RD
shellno other value
City
WARREN
shellno other value
State
MI
shellno other value
ZIP
48088
shellno other value
Pin
42.49316, -82.98787 map 2 other
shell
52 m away mi-lcc ×2
76 m away ab-inbev
Phone
5867566797 1 other
shell
3136058933 mi-lcc ×2
Licences
mi-lcc L-000314391 · mi-lcc L-000489001
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4423d7c8a243; O93623daf72de; O82ad2420ee61; Oe681f4fa7d62; O8f11abd3f27a

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 FOOD MART
3349459
27027 SCHOENHERR RD, WARREN, MI, 4808842.49364, -82.987202026-11-112026-11-12
mi-lccShell
legal name: NAA PETROLEUM, INC.
L-000314391
27027 Schoenherr Rd, Warren, MI, 48088313605893342.49323, -82.987242026-11-032026-11-05
mi-lccShell
legal name: NAA PETROLEUM, INC.
L-000489001
27027 Schoenherr Rd, Warren, MI, 48088313605893342.49323, -82.987242026-11-032026-11-05
overtureShell
79bb3f80-870e-4cfb-b5fa-af93c33fb483
27027 Schoenherr Rd, Warren, MI, 48088586756679742.49311, -82.987832026-11-062026-11-06
shellShell
10082259
27027 SCHOENHERR RD, WARREN, MI, 48088586756679742.49316, -82.987872026-11-102026-11-10
vtinfoSHELL FOOD MART
58e5c1d390c73167
27027 SCHOENHERR RD, WARREN, MI, 48088586756679742.49318, -82.987862026-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 SHELL FOOD MARTvtinfo SHELL FOOD MART1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 75 m apart · name similarity 1.00
mi-lcc Shellmi-lcc Shell1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc Shelloverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00 · phone: differs
mi-lcc Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 52 m apart · name similarity 1.00 · phone: differs
mi-lcc Shelloverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00 · phone: differs
mi-lcc Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 52 m apart · name similarity 1.00 · phone: differs
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELL FOOD MARTmi-lcc Shell0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.55 · same street + ZIP · pins 46 m apart · name similarity 0.42
ab-inbev SHELL FOOD MARTmi-lcc Shell0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.55 · same street + ZIP · pins 46 m apart · name similarity 0.42
ab-inbev SHELL FOOD MARToverture Shell0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + ZIP · pins 78 m apart · name similarity 0.42
ab-inbev SHELL FOOD MARTshell Shell0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + ZIP · pins 76 m apart · name similarity 0.42
mi-lcc Shellvtinfo SHELL FOOD MART0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.55 · same street + city + state · pins 51 m apart · name similarity 0.42 · phone: differs
mi-lcc Shellvtinfo SHELL FOOD MART0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.55 · same street + city + state · pins 51 m apart · name similarity 0.42 · phone: differs
overture Shellvtinfo SHELL FOOD MART0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + city + state · pins 8 m apart · name similarity 0.42 · phone: equal
shell Shellvtinfo SHELL FOOD MART0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: food, mart · name Jaro-Winkler 0.00 · same street + city + state · pins 2 m apart · name similarity 0.42 · phone: equal

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
NAA PETROLEUM, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
23 within 1 mi · 343 within 3 mi
Off / on premise
5 / 9 within 1 mi · 126 / 113 within 3 mi
Selling alcohol
14 within 1 mi · 220 within 3 mi
Nearest
same channel 0.11 mi · licensed 0.14 mi
Setting
urban (5,012 people per sq mi)
People within 3 mi
141,724 (106,740 adults 21+, 58,333 households) from 49 tract(s), tracts within 3 mi
Income
per capita $33,361 · median household ~$64,331 (weighted mean of tract medians)
Age and education
median age ~39.0 · bachelor's or higher 18%
Ethnicity
Hispanic 3% · White 60% · Black 26% · Asian 6%
Adults per alcohol outlet
483
Alcohol spend within 3 mi
$31,950,381 a year ($15,336,226 at home, $16,599,634 away) · $144,572 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-12 17:29insertmi-lcc L-000314391 ↔ vtinfo 58e5c1d390c73167same address and namemerged14
2026-11-12 17:29insertoverture 79bb3f80-870e-4cfb-b5fa-af93c33fb483 ↔ vtinfo 58e5c1d390c73167same address and namemerged14
2026-11-12 17:29insertmi-lcc L-000489001 ↔ vtinfo 58e5c1d390c73167same address and namemerged14
2026-11-12 17:29insertshell 10082259 ↔ vtinfo 58e5c1d390c73167same address and namemerged14
2026-11-12 17:29insertab-inbev 3349459 ↔ mi-lcc L-000314391same address and namemerged14
2026-11-12 17:29insertab-inbev 3349459 ↔ overture 79bb3f80-870e-4cfb-b5fa-af93c33fb483same address and namemerged14
2026-11-12 17:29insertab-inbev 3349459 ↔ mi-lcc L-000489001same address and namemerged14
2026-11-12 17:29insertab-inbev 3349459 ↔ shell 10082259same address and namemerged14
2026-11-12 14:25insertab-inbev 3349459 ↔ vtinfo 58e5c1d390c73167same address and namemerged12
2026-11-10 17:05insertmi-lcc L-000314391 ↔ shell 10082259same address and namemerged12
2026-11-10 17:05insertoverture 79bb3f80-870e-4cfb-b5fa-af93c33fb483 ↔ shell 10082259same address and namemerged12
2026-11-10 17:05insertmi-lcc L-000489001 ↔ shell 10082259same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000314391 ↔ overture 79bb3f80-870e-4cfb-b5fa-af93c33fb483same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000489001 ↔ overture 79bb3f80-870e-4cfb-b5fa-af93c33fb483same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000314391 ↔ mi-lcc L-000489001one store listed twicemerged