Shell

Dearborn Heights, MI 48127 · O1fcd6693de72 · 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
TEL-WARREN CONVENIENCE, INC. mi-lcc (legal name) ×2
TEL-WARREN SHELL mi-lcc ×2
Street
23955 W WARREN ST 1 other
shell
23955 W WARREN ab-inbevvtinfo ×2
City
DEARBORN HEIGHTS
shellno other value
State
MI
shellno other value
ZIP
48127
shellno other value
Pin
42.34107, -83.27263 map
shellno other value
Phone
3135623099
shellno other value
Licences
mi-lcc L-000246458 · mi-lcc L-000246459
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa64c5c2d043c; Ob4c75768ca10; O25c0fa968824; O23da0f247ddd; Ob5b7fffdcb73

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
2883662
23955 W WARREN, DEARBORN HEIGHTS, MI, 4812742.34139, -83.272572026-11-112026-11-12
mi-lccTEL-WARREN SHELL
legal name: TEL-WARREN CONVENIENCE, INC.
L-000246458
23955 W Warren St, Dearborn Heights, MI, 48127313562309942.34138, -83.272562026-11-032026-11-05
mi-lccTEL-WARREN SHELL
legal name: TEL-WARREN CONVENIENCE, INC.
L-000246459
23955 W Warren St, Dearborn Heights, MI, 48127313562309942.34138, -83.272562026-11-032026-11-05
overtureShell
e4044d37-522a-4dd4-a309-78a828a17b9b
23955 W Warren St, Dearborn Heights, MI, 48127313562309942.34092, -83.272842026-11-132026-11-13
shellShell
10009435
23955 W WARREN ST, DEARBORN HEIGHTS, MI, 48127313562309942.34107, -83.272632026-11-102026-11-12
vtinfoSHELL
3b6c985fdf23d66a
23955 W WARREN, DEARBORN HEIGHTS, MI, 48127313562309942.34101, -83.272202026-11-112026-11-13

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.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 57 m apart · name similarity 1.00 · street similarity 0.84
ab-inbev SHELLshell Shell1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 35 m apart · name similarity 1.00 · street similarity 0.84
ab-inbev SHELLvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 51 m apart · name similarity 1.00
mi-lcc TEL-WARREN SHELLmi-lcc TEL-WARREN SHELL1.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 25 m apart · name similarity 1.00 · phone: equal
overture Shellvtinfo SHELL1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 54 m apart · name similarity 1.00 · street similarity 0.84
shell Shellvtinfo SHELL1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 36 m apart · name similarity 1.00 · street similarity 0.84
ab-inbev SHELLmi-lcc TEL-WARREN SHELL0.41Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Shell station same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 23955 W Warren St, Dearborn Heights, MI 48127, about 2 m apart, and the Michigan record's trade name 'TEL-WARREN SHELL' matches the AB InBev record's 'SHELL' brand, so they likely describe one Shell station; the second business at the address lowers confidence somewhat.
pair 1c0fcd1aee8f4edec19f
mi-lcc TEL-WARREN SHELLvtinfo SHELL0.41Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “same-address” pair)
Same street address and ZIP, matching phone number, and 'TEL-WARREN SHELL' is the Shell station's licensed trade name, so these are one gas-station outlet.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 88% confident — Both records sit at the same street address in Dearborn Heights with an identical phone number, and the 0.05 km distance fits; record A is the Shell-branded operation (TEL-WARREN SHELL, legal entity TEL-WARREN CONVENIENCE) and record B is its SHELL listing in the brand finder.
pair 04c52c5e2fcca663f13b

Attributes

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

Trade area

Other outlets
42 within 1 mi · 354 within 3 mi
Off / on premise
7 / 22 within 1 mi · 96 / 149 within 3 mi
Selling alcohol
19 within 1 mi · 172 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.01 mi
Setting
urban (4,734 people per sq mi)
People within 3 mi
133,843 (95,034 adults 21+, 50,659 households) from 40 tract(s), tracts within 3 mi
Income
per capita $31,059 · median household ~$63,506 (weighted mean of tract medians)
Age and education
median age ~35.2 · bachelor's or higher 28%
Ethnicity
Hispanic 4% · White 61% · Black 31% · Asian 1%
Adults per alcohol outlet
549
Alcohol spend within 3 mi
$27,602,689 a year ($13,105,006 at home, $14,483,614 away) · $159,553 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-13 14:10insertoverture e4044d37-522a-4dd4-a309-78a828a17b9b ↔ vtinfo 3b6c985fdf23d66astreet written two waysmerged15
2026-11-13 14:10insertab-inbev 2883662 ↔ overture e4044d37-522a-4dd4-a309-78a828a17b9bstreet written two waysmerged15
2026-11-13 14:10insertoverture e4044d37-522a-4dd4-a309-78a828a17b9b ↔ shell 10009435same address and namemerged15
2026-11-12 17:29insertab-inbev 2883662 ↔ mi-lcc L-000246459Claude judge: samemerged14
2026-11-12 14:25insertmi-lcc L-000246458 ↔ vtinfo 3b6c985fdf23d66aClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 2883662 ↔ shell 10009435street written two waysmerged12
2026-11-11 12:56insertshell 10009435 ↔ vtinfo 3b6c985fdf23d66astreet written two waysmerged12
2026-11-11 12:56insertab-inbev 2883662 ↔ vtinfo 3b6c985fdf23d66asame address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000246458 ↔ mi-lcc L-000246459one store listed twicemerged