Shell

Sterling Heights, MI 48312 · O3c910aeb12f2 · 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 1 other
the most common name a source states
STERLING SHELL, INC. mi-lcc ×2
Street
11541 15 MILE RD
shellno other value
City
STERLING HEIGHTS
shellno other value
State
MI
shellno other value
ZIP
48312
shellno other value
Pin
42.55191, -83.01015 map
shellno other value
Phone
5862752266 1 other
shell
5862685320 vtinfo
Licences
mi-lcc L-000280133 · mi-lcc L-000280134
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O823582356419; Oeb339676b29c; Oe6223c1c7cd3; O68621397a03c; O477876f99817

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
3469275
11541 15 MILE RD, STERLING HEIGHTS, MI, 4831242.55175, -83.010142026-11-112026-11-13
mi-lccSTERLING SHELL, INC.
L-000280133
11541 15 Mile Rd, Sterling Heights, MI, 48312586275226642.55171, -83.010552026-11-032026-11-13
mi-lccSTERLING SHELL, INC.
L-000280134
11541 15 Mile Rd, Sterling Heights, MI, 48312586275226642.55171, -83.010552026-11-032026-11-13
overtureShell
ef181b79-990a-4aef-bc81-a9601aa44ed9
11541 15 Mile Rd, Sterling Heights, MI, 48312586275226642.55194, -83.010162026-11-132026-11-13
shellShell
12590690
11541 15 MILE RD, STERLING HEIGHTS, MI, 48312586275226642.55191, -83.010152026-11-102026-11-13
vtinfoSHELL
cf253457aaaeb0d5
11541 15 MILE RD, STERLING HEIGHTS, MI, 48312586268532042.55207, -83.010192026-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 21 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 18 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 36 m apart · name similarity 1.00
mi-lcc STERLING SHELL, INC.mi-lcc STERLING SHELL, INC.1.00one store listed twicemergedsame street + ZIP · name: identical
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 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 15 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 18 m apart · name similarity 1.00 · phone: differs
ab-inbev SHELLmi-lcc STERLING SHELL, INC.0.51Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Shell station licensee at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — Both records sit at the same street address (34 m apart) in Sterling Heights, MI, and the Michigan licence is held by 'STERLING SHELL, INC.', a legal entity that plausibly operates the Shell station named in the AB InBev record; the address and name agree, and the building appears to hold only these two listings.
pair 34c95b0be5d6d3674c4a

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
STERLING SHELL, 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:16.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-13 14:10insertoverture ef181b79-990a-4aef-bc81-a9601aa44ed9 ↔ vtinfo cf253457aaaeb0d5same address and namemerged15
2026-11-13 14:10insertoverture ef181b79-990a-4aef-bc81-a9601aa44ed9 ↔ shell 12590690same address and namemerged15
2026-11-13 14:10insertab-inbev 3469275 ↔ overture ef181b79-990a-4aef-bc81-a9601aa44ed9same address and namemerged15
2026-11-12 17:29insertab-inbev 3469275 ↔ mi-lcc L-000280134Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 3469275 ↔ vtinfo cf253457aaaeb0d5same address and namemerged12
2026-11-12 14:25insertshell 12590690 ↔ vtinfo cf253457aaaeb0d5same address and namemerged12
2026-11-11 12:56insertab-inbev 3469275 ↔ shell 12590690same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000280133 ↔ mi-lcc L-000280134one store listed twicemerged