Shell

TROY, MI 48085 · O35f5d89a0e34 · first seen 2026-11-03
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
LONG LAKE & DEQUINDRE SHELL mi-lcc
STARCO MANAGEMENT COMPANY mi-lcc (legal name)
Street
2970 E LONG LAKE RD
shellno other value
City
TROY
shellno other value
State
MI
shellno other value
ZIP
48085
shellno other value
Pin
42.59265, -83.08950 map 3 other
shell
115 m away ab-inbev
93 m away mi-lcc
80 m away vtinfo
Phone
2486898200
shellno other value
Licences
mi-lcc L-000274565
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc7b5885b840d; Od46ef0b2ccac; O64019975f6b2; O55bf3b2ae7fe; O59c2596a835a

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
3361054
2970 E LONG LAKE RD, TROY, MI, 4808542.59292, -83.090852026-11-112026-11-12
mi-lccLONG LAKE & DEQUINDRE SHELL
legal name: STARCO MANAGEMENT COMPANY
L-000274565
2970 E Long Lake Rd, Troy, MI, 48085248689820042.59294, -83.090562026-11-032026-11-05
overtureShell
84f349f7-6ed5-47ba-b18a-f2d1fd858309
2970 E Long Lake Rd, Troy, MI, 48085248689820042.59266, -83.089492026-11-132026-11-13
shellShell
10009510
2970 E LONG LAKE RD, TROY, MI, 48085248689820042.59265, -83.089502026-11-102026-11-12
vtinfoSHELL
bfe28284e37d72c2
2970 E LONG LAKE RD, TROY, MI, 48085248689820042.59256, -83.090472026-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 115 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 115 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 51 m apart · name similarity 1.00
mi-lcc LONG LAKE & DEQUINDRE SHELLoverture e437d7e3-5509-4553-9f1b-1a5aa5310c6d1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 42 m apart · name similarity 1.00 · phone: equal
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 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 81 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 80 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELLmi-lcc LONG LAKE & DEQUINDRE SHELL0.29Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (92% confident; asked as a “same-address” pair)
Same street address and ZIP, and 'SHELL' and 'LONG LAKE & DEQUINDRE SHELL' are one Shell station; the second name is the licence's trade name for that location, and the coordinates are 24 m apart.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Shell station same address, licence name includes Shell
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at the same street address and ZIP, about 24 m apart, and Record B's trade name 'LONG LAKE & DEQUINDRE SHELL' contains the brand 'SHELL' from Record A; the address is shared with one other business, but the Shell name agreement supports one outlet.
pair 04c20d822677fa059364

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
STARCO MANAGEMENT COMPANY — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
26 within 1 mi · 335 within 3 mi
Off / on premise
11 / 11 within 1 mi · 86 / 201 within 3 mi
Selling alcohol
10 within 1 mi · 134 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (3,661 people per sq mi)
People within 3 mi
103,518 (79,110 adults 21+, 37,765 households) from 23 tract(s), tracts within 3 mi
Income
per capita $44,977 · median household ~$102,853 (weighted mean of tract medians)
Age and education
median age ~42.0 · bachelor's or higher 44%
Ethnicity
Hispanic 2% · White 70% · Black 5% · Asian 18%
Adults per alcohol outlet
586
Alcohol spend within 3 mi
$28,630,318 a year ($12,865,763 at home, $15,753,048 away) · $212,076 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-13 14:10insertoverture 84f349f7-6ed5-47ba-b18a-f2d1fd858309 ↔ vtinfo bfe28284e37d72c2same address and namemerged15
2026-11-13 14:10insertoverture 84f349f7-6ed5-47ba-b18a-f2d1fd858309 ↔ shell 10009510same address and namemerged15
2026-11-13 14:10insertab-inbev 3361054 ↔ overture 84f349f7-6ed5-47ba-b18a-f2d1fd858309same address and namemerged15
2026-11-12 14:25insertab-inbev 3361054 ↔ mi-lcc L-000274565Claude judge: samemerged12
2026-11-12 14:25insertab-inbev 3361054 ↔ vtinfo bfe28284e37d72c2same address and namemerged12
2026-11-12 14:25insertshell 10009510 ↔ vtinfo bfe28284e37d72c2same address and namemerged12
2026-11-11 12:56insertab-inbev 3361054 ↔ shell 10009510same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000274565 ↔ overture e437d7e3-5509-4553-9f1b-1a5aa5310c6dsame address and namemerged11