BIG RAY'S MARKET, LLC

Sterling Heights, MI 48312 · O28549f98a8ee · first seen 2026-10-08
4 sourcesoff premise · liquor_storealcohol: 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
BIG RAY'S MARKET, LLC 2 other
the most common name a source states
BIG RAYS SMOKE BEER LOTTO ab-inbevvtinfo ×2
big ray's market sterling heights doordash
Street
35800 Van Dyke Ave
mi-lccno other value
City
Sterling Heights
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48312
mi-lccno other value
Pin
42.55734, -83.02828 map 2 other
doordash
71 m away mi-lcc ×2
66 m away ab-inbev
Phone
5869778930 1 other
vtinfo
5862024362 mi-lcc ×2
Licences
mi-lcc L-000499151 · mi-lcc L-000499160
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9ae4a6e0c8fc; O2d10f269f773; Ocaef32ce91c0; O7800ee1aab87

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-inbevBIG RAYS SMOKE BEER LOTTO
4822726
35800 VAN DYKE AVE, STERLING HEIGHTS, MI, 4831242.55789, -83.027962026-11-112026-11-12
doordashbig ray's market sterling heights
45109897
35800 Van Dyke Ave, Sterling Heights, MI, 4831242.55734, -83.028282026-10-082026-11-03
mi-lccBIG RAY'S MARKET, LLC
L-000499151
35800 Van Dyke Ave, Sterling Heights, MI, 48312586202436242.55705, -83.029052026-11-032026-11-04
mi-lccBIG RAY'S MARKET, LLC
L-000499160
35800 Van Dyke Ave, Sterling Heights, MI, 48312586202436242.55705, -83.029052026-11-032026-11-04
vtinfoBIG RAYS SMOKE BEER LOTTO
3f1ca36e7268cc44
35800 VAN DYKE AVE, STERLING HEIGHTS, MI, 48312586977893042.55738, -83.028372026-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 BIG RAYS SMOKE BEER LOTTOvtinfo BIG RAYS SMOKE BEER LOTTO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 66 m apart · name similarity 1.00
doordash big ray's market sterling heightsmi-lcc BIG RAY'S MARKET, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash big ray's market sterling heightsmi-lcc BIG RAY'S MARKET, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc BIG RAY'S MARKET, LLCmi-lcc BIG RAY'S MARKET, LLC1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev BIG RAYS SMOKE BEER LOTTOdoordash big ray's market sterling heights0.42Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (92% confident; asked as a “same-address” pair)
Both records share the distinctive 'Big Ray's' name at the same street address and ZIP, and they are 66 m apart. Only one business is known at that address, so 'Smoke Beer Lotto' and 'market' read as
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Big Ray's same address.
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 35800 Van Dyke Ave, Sterling Heights, MI 48312 with about 66 m between coordinates, the only business at that address, and the names 'BIG RAYS SMOKE BEER LOTTO' and 'big ray's market' reasonably refer to the same independent store, though the wording differs somewhat.
pair 026e4e3f5d4c48acb163

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BIG RAY'S MARKET, LLC — 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 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
73 within 1 mi · 373 within 3 mi
Off / on premise
10 / 49 within 1 mi · 91 / 196 within 3 mi
Selling alcohol
28 within 1 mi · 186 within 3 mi
Nearest
same channel 0.40 mi · licensed 0.08 mi
Setting
urban (3,558 people per sq mi)
People within 3 mi
100,592 (76,885 adults 21+, 38,207 households) from 27 tract(s), tracts within 3 mi
Income
per capita $35,220 · median household ~$75,134 (weighted mean of tract medians)
Age and education
median age ~40.9 · bachelor's or higher 28%
Ethnicity
Hispanic 3% · White 75% · Black 9% · Asian 10%
Adults per alcohol outlet
411
Alcohol spend within 3 mi
$23,711,189 a year ($11,067,272 at home, $12,632,427 away) · $126,798 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-12 14:25insertab-inbev 4822726 ↔ doordash 45109897Claude judge: samemerged12
2026-11-12 14:25insertab-inbev 4822726 ↔ vtinfo 3f1ca36e7268cc44same address and namemerged12
2026-11-03 13:33backfilldoordash 45109897 ↔ mi-lcc L-000499160same address and namemerged
2026-11-03 13:33backfilldoordash 45109897 ↔ mi-lcc L-000499151same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000499151 ↔ mi-lcc L-000499160one store listed twicemerged