WALMART SUPERCENTER

Rochester Hills, MI 48309 · O287c0e1d8c60 · first seen 2026-11-03
5 sourcesoff premise · grocerychain: Walmartalcohol: 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
WALMART SUPERCENTER 3 other
the most common name a source states
WAL-MART STORES EAST, LIMITED PARTNERSHIP mi-lcc (legal name) ×2
WAL-MART SUPERCENTER #2354 mi-lcc ×2
Walmart walmart-stores
Street
2500 S Adams Rd
walmart-storesno other value
City
Rochester Hills 1 other
walmart-stores
ROCHESTER ab-inbevvtinfo ×2
State
MI
walmart-storesno other value
ZIP
48309
walmart-storesno other value
Pin
42.64290, -83.19862 map 1 other
walmart-stores
196 m away mi-lcc ×2
Phone
2488530433
walmart-storesno other value
Licences
mi-lcc L-000165599 · mi-lcc L-000165600
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O809d2564419e; Oe4579394c059; Oc01d9859934f; O98c3fbc29c67; O9dd5fa8f51ba

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-inbevWALMART SUPERCENTER
2907706
2500 S ADAMS RD, ROCHESTER, MI, 48309
ZIP lookup: Rochester Hills, MI
42.64286, -83.198342026-11-112026-11-12
mi-lccWAL-MART SUPERCENTER #2354
legal name: WAL-MART STORES EAST, LIMITED PARTNERSHIP
L-000165599
2500 S Adams Rd, Rochester Hills, MI, 48309248853043342.64123, -83.199382026-11-032026-11-05
mi-lccWAL-MART SUPERCENTER #2354
legal name: WAL-MART STORES EAST, LIMITED PARTNERSHIP
L-000165600
2500 S Adams Rd, Rochester Hills, MI, 48309248853043342.64123, -83.199382026-11-032026-11-05
overtureWalmart Supercenter
76425945-846c-492f-bfef-f5cabfc2975a
2500 S Adams Rd, Rochester Hills, MI, 48309248853043342.64290, -83.198622026-11-132026-11-13
vtinfoWALMART SUPERCENTER
9b2c8fcb8abc4951
2500 S ADAMS RD, ROCHESTER, MI, 48309
ZIP lookup: Rochester Hills, MI
248853043342.64311, -83.198652026-11-122026-11-14
walmart-storesWalmart
2500|48309
2500 S Adams Rd, Rochester Hills, MI, 48309248853043342.64290, -83.198622026-11-102026-11-12

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 WALMART SUPERCENTERoverture Walmart Supercenter1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ab-inbev WALMART SUPERCENTERvtinfo WALMART SUPERCENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 37 m apart · name similarity 1.00
mi-lcc WAL-MART SUPERCENTER #2354mi-lcc WAL-MART SUPERCENTER #23541.00one store listed twicemergedsame street + ZIP · name: identical
overture Walmart Supercentervtinfo WALMART SUPERCENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00 · phone: equal
ab-inbev WALMART SUPERCENTERwalmart-stores Walmart0.52same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supercenter · name Jaro-Winkler 0.46 · same street + ZIP · pins 23 m apart · name similarity 0.52
overture Walmart Supercenterwalmart-stores Walmart0.52same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supercenter · name Jaro-Winkler 0.46 · same street + ZIP · pins 0 m apart · name similarity 0.52 · phone: equal
vtinfo WALMART SUPERCENTERwalmart-stores Walmart0.52same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: supercenter · name Jaro-Winkler 0.46 · same street + ZIP · pins 23 m apart · name similarity 0.52 · phone: equal
ab-inbev WALMART SUPERCENTERmi-lcc WAL-MART SUPERCENTER #23540.44Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Same Walmart Supercenter, same address; Rochester/Rochester Hills same ZIP.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 92% confident — Both records are a Walmart Supercenter at 2500 S Adams Rd, ZIP 48309, with coordinates about 0.2 km apart; B is the store-numbered legal filing of the same chain store, and the city difference is only the postal name Rochester versus Rochester Hills.
pair 2817c2698048bd9f0834

Attributes

Channel
off_premise · grocery — chain-locator
Chain
Walmart — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
WAL-MART STORES EAST, LIMITED PARTNERSHIP — 94 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",
   "grocery"
  ]
 ]
}

Trade area

Other outlets
15 within 1 mi · 156 within 3 mi
Off / on premise
4 / 5 within 1 mi · 41 / 52 within 3 mi
Selling alcohol
6 within 1 mi · 103 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.11 mi
Setting
suburban (1,604 people per sq mi)
People within 3 mi
45,346 (34,502 adults 21+, 17,971 households) from 14 tract(s), tracts within 3 mi
Income
per capita $58,751 · median household ~$117,412 (weighted mean of tract medians)
Age and education
median age ~42.7 · bachelor's or higher 59%
Ethnicity
Hispanic 8% · White 65% · Black 8% · Asian 14%
Adults per alcohol outlet
332
Alcohol spend within 3 mi
$15,120,906 a year ($6,670,392 at home, $8,444,217 away) · $145,393 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-14 20:23insertvtinfo 9b2c8fcb8abc4951 ↔ walmart-stores 2500|48309same address and namemerged15
2026-11-14 20:23insertoverture 76425945-846c-492f-bfef-f5cabfc2975a ↔ vtinfo 9b2c8fcb8abc4951same address and namemerged15
2026-11-13 14:10insertoverture 76425945-846c-492f-bfef-f5cabfc2975a ↔ walmart-stores 2500|48309same address and namemerged15
2026-11-13 14:10insertab-inbev 2907706 ↔ overture 76425945-846c-492f-bfef-f5cabfc2975asame address and namemerged15
2026-11-12 17:29insertab-inbev 2907706 ↔ mi-lcc L-000165599Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2907706 ↔ walmart-stores 2500|48309same address and namemerged14
2026-11-12 14:25insertab-inbev 2907706 ↔ vtinfo 9b2c8fcb8abc4951same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000165599 ↔ mi-lcc L-000165600one store listed twicemerged