AMMAR SHELL

Farmington Hills, MI 48334 · O2b7fede4d67a · first seen 2026-10-08
6 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
AMMAR SHELL 3 other
the most common name a source states
SHELL ab-inbevovertureshellvtinfo ×4
AMMAR STATION INVESTORS, INC. mi-lcc (legal name) ×2
northwestern shell farmington hills doordash
Street
31529 NORTHWESTERN HWY
shellno other value
City
FARMINGTON HILLS 1 other
shell
FARMINGTON ab-inbevvtinfo ×2
State
MI
shellno other value
ZIP
48334
shellno other value
Pin
42.51814, -83.33962 map
shellno other value
Phone
2487372323
shellno other value
Licences
mi-lcc L-000162310 · mi-lcc L-000164854
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa5f4c8900613; Ob5688d14b440; Od4c6dcf7b7d3; O607457c07aa3; O5e3a3d6778a2; O55c3ad4157fd

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
2915035
31529 NORTHWESTERN HWY, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
42.51836, -83.339462026-11-112026-11-13
doordashnorthwestern shell farmington hills
34205137
31529 Northwestern Hwy, Farmington Hills, MI, 4833442.51815, -83.339602026-10-082026-11-13
mi-lccAMMAR SHELL
legal name: AMMAR STATION INVESTORS, INC.
L-000162310
31529 Northwestern Hwy, Farmington Hills, MI, 4833424873723232026-11-032026-11-13
mi-lccAMMAR SHELL
legal name: AMMAR STATION INVESTORS, INC.
L-000164854
31529 Northwestern Hwy, Farmington Hills, MI, 4833424873723232026-11-032026-11-13
overtureShell
0db8733b-8705-47c9-ae52-441d8e9a7090
31529 Northwestern Hwy, Farmington Hills, MI, 48334248737232342.51810, -83.339612026-11-132026-11-13
shellShell
10009461
31529 NORTHWESTERN HWY, FARMINGTON HILLS, MI, 48334248737232342.51814, -83.339622026-11-102026-11-13
vtinfoSHELL
31e0e1fc9673b025
31529 NORTHWESTERN HWY, FARMINGTON, MI, 48334
ZIP lookup: Farmington Hills, MI
248737232342.51796, -83.339492026-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 31 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 28 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 44 m apart · name similarity 1.00
mi-lcc AMMAR SHELLmi-lcc AMMAR 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 4 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 + ZIP · pins 18 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 + ZIP · pins 22 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELLmi-lcc AMMAR SHELL0.56Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Shell station at same address, Ammar Shell
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 78% confident — Both records sit at 31529 Northwestern Hwy, ZIP 48334, and the ab-inbev 'SHELL' account matches the mi-lcc licensee's trade name 'AMMAR SHELL' (legal entity AMMAR STATION INVESTORS), with the city difference being only a postal-versus-municipal name; the shared building with 3 businesses lowers confidence somewhat.
pair 4afe5f06734d3a50dfc3
doordash northwestern shell farmington hillsmi-lcc AMMAR SHELL0.41Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “same-address” pair)
Shell station at same address, same brand
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records give the identical street address, ZIP and city in Farmington Hills, MI, and the DoorDash slug 'northwestern shell' matches the Michigan licence's trade name 'AMMAR SHELL', so they likely describe the same Shell station; confidence is tempered because three businesses share the address and the slug is only a partial name.
pair 1f5002a73da9ffc2c939
doordash northwestern shell farmington hillsmi-lcc AMMAR SHELL0.41Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Shell station at same address, both Shell names.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 72% confident — Both records give the identical street address, ZIP and city (31529 Northwestern Hwy, Farmington Hills 48334), and the shared distinctive word 'shell' links the DoorDash slug 'northwestern shell' to the Michigan licence trade name 'AMMAR SHELL', though the building holds three businesses so the match rests mainly on the name token.
pair 145cfb2cafb9dad0fef4

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
AMMAR STATION INVESTORS, 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"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "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-14 20:23insertoverture 0db8733b-8705-47c9-ae52-441d8e9a7090 ↔ vtinfo 31e0e1fc9673b025same address and namemerged15
2026-11-14 20:23insertshell 10009461 ↔ vtinfo 31e0e1fc9673b025same address and namemerged15
2026-11-13 14:10insertab-inbev 2915035 ↔ overture 0db8733b-8705-47c9-ae52-441d8e9a7090same address and namemerged15
2026-11-13 14:10insertoverture 0db8733b-8705-47c9-ae52-441d8e9a7090 ↔ shell 10009461same address and namemerged15
2026-11-12 17:29insertdoordash 34205137 ↔ mi-lcc L-000162310Claude judge: samemerged14
2026-11-12 17:29insertdoordash 34205137 ↔ mi-lcc L-000164854Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2915035 ↔ mi-lcc L-000162310Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2915035 ↔ vtinfo 31e0e1fc9673b025same address and namemerged12
2026-11-11 12:56insertab-inbev 2915035 ↔ shell 10009461same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000162310 ↔ mi-lcc L-000164854one store listed twicemerged