Wal-Mart Supercenter #2559

Sterling Heights, MI 48312 · O0274ac66c10c · first seen 2026-11-03
7 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
Wal-Mart Supercenter #2559 7 other
a licence name in capitals, cleaned (derived; record_title.py)
WAL-MART STORES EAST, LIMITED PARTNERSHIP mi-lcc (legal name) ×2
WALMART SUPERCENTER ab-inbevvtinfo ×2
WAL-MART PHARMACY 10-2559 nppes
WAL-MART STORES EAST LP nppes (legal name)
Walmart walmart-stores
Walmart Pharmacy overture
Walmart Supercenter 2559 snap
Street
33201 Van Dyke Ave
walmart-storesno other value
City
Sterling Heights
walmart-storesno other value
State
MI
walmart-storesno other value
ZIP
48312
walmart-storesno other value
Pin
42.53844, -83.03249 map 6 other
walmart-stores
260 m away mi-lcc ×2
264 m away ab-inbev
260 m away nppes
170 m away overture
316 m away snap
169 m away vtinfo
Phone
5869397208 1 other
walmart-stores
5869398171 overture
Licences
mi-lcc L-000165313 · mi-lcc L-000213676
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of3a6160982a0; Oecde8cfd33c5; Oa7bb39732780; O81a971b89879; O259aee9cae9f; Oaeff3589aff8; O183b9767f494

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
2903520
33201 VAN DYKE AVE, STERLING HEIGHTS, MI, 4831242.53852, -83.029272026-11-112026-11-20
mi-lccWAL-MART SUPERCENTER #2559
legal name: WAL-MART STORES EAST, LIMITED PARTNERSHIP
L-000165313
33201 Van Dyke Ave, Sterling Heights, MI, 48312586939720842.53819, -83.029342026-11-032026-11-20
mi-lccWAL-MART SUPERCENTER #2559
legal name: WAL-MART STORES EAST, LIMITED PARTNERSHIP
L-000213676
33201 Van Dyke Ave, Sterling Heights, MI, 48312586939720842.53819, -83.029342026-11-032026-11-20
nppesWAL-MART PHARMACY 10-2559
legal name: WAL-MART STORES EAST LP
nppes|1801813019
33201 VAN DYKE AVE, Sterling Heights, MI, 4831242.53819, -83.029342026-11-202026-11-20
overtureWalmart Pharmacy
098bd700-926d-4719-869c-6570969d50dd
33201 Van Dyke Ave, Sterling Heights, MI, 48312586939817142.53814, -83.030462026-11-132026-11-20
snapWalmart Supercenter 2559
snap|us|270227
33201 Van Dyke Ave, Sterling Heights, MI, 4831242.53676, -83.029382026-11-192026-11-20
vtinfoWALMART SUPERCENTER
dc34f476626c66b0
33201 VAN DYKE AVE, STERLING HEIGHTS, MI, 48312586939720842.53814, -83.030472026-11-122026-11-20
walmart-storesWalmart
33201|48312
33201 Van Dyke Ave, Sterling Heights, 48312
ZIP lookup: Sterling Heights, MI
586939720842.53844, -83.032492026-11-102026-11-20

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 SUPERCENTERsnap Walmart Supercenter 25591.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 196 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 107 m apart · name similarity 1.00
mi-lcc WAL-MART SUPERCENTER #2559mi-lcc WAL-MART SUPERCENTER #25591.00one store listed twicemergedsame street + ZIP · name: identical
snap Walmart Supercenter 2559vtinfo WALMART SUPERCENTER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 178 m apart · name similarity 1.00
mi-lcc WAL-MART SUPERCENTER #2559snap Walmart Supercenter 25590.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mart, supercenter · name Jaro-Winkler 0.89 · same street + ZIP · pins 159 m apart · name similarity 0.61
mi-lcc WAL-MART SUPERCENTER #2559snap Walmart Supercenter 25590.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mart, supercenter · name Jaro-Winkler 0.89 · same street + ZIP · pins 159 m apart · name similarity 0.61
mi-lcc WAL-MART SUPERCENTER #2559nppes WAL-MART PHARMACY 10-25590.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mart, pharmacy, supercenter · name Jaro-Winkler 0.83 · same street + ZIP · pins 0 m apart · name similarity 0.59
mi-lcc WAL-MART SUPERCENTER #2559nppes WAL-MART PHARMACY 10-25590.59same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mart, pharmacy, supercenter · name Jaro-Winkler 0.83 · same street + ZIP · pins 0 m apart · name similarity 0.59
overture Walmart Pharmacywalmart-stores Walmart0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.48 · same street + ZIP · pins 170 m apart · name similarity 0.55 · phone: differs
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 264 m apart · name similarity 0.52
snap Walmart Supercenter 2559walmart-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 316 m apart · name similarity 0.52
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 + city + state · pins 169 m apart · name similarity 0.52 · phone: equal
nppes WAL-MART PHARMACY 10-2559overture Walmart Pharmacy0.49same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.78 · same street + ZIP · pins 93 m apart · name similarity 0.49
ab-inbev WALMART SUPERCENTERoverture Walmart Pharmacy0.48same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy, supercenter · name Jaro-Winkler 0.62 · same street + ZIP · pins 107 m apart · name similarity 0.48
overture Walmart Pharmacysnap Walmart Supercenter 25590.48same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy, supercenter · name Jaro-Winkler 0.62 · same street + ZIP · pins 177 m apart · name similarity 0.48
overture Walmart Pharmacyvtinfo WALMART SUPERCENTER0.48same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy, supercenter · name Jaro-Winkler 0.62 · same street + city + state · pins 1 m apart · name similarity 0.48 · phone: differs
ab-inbev WALMART SUPERCENTERmi-lcc WAL-MART SUPERCENTER #25590.44one name contains the other, same addressmergedjudge: None · pair_id: c01909355c2763bdaede · person: None · rule: names contained at one address · stratum: same-address
ab-inbev WALMART SUPERCENTERmi-lcc WAL-MART SUPERCENTER #25590.44one name contains the other, same addressmergedjudge: None · pair_id: f00dd7cbd94dc52b648f · person: None · rule: names contained at one address · stratum: same-address
mi-lcc WAL-MART SUPERCENTER #2559vtinfo WALMART SUPERCENTER0.44one name contains the other, same addressmergedjudge: None · pair_id: 87497568f57859f3add9 · person: None · rule: names contained at one address · stratum: same-address
mi-lcc WAL-MART SUPERCENTER #2559vtinfo WALMART SUPERCENTER0.44one name contains the other, same addressmergedjudge: None · pair_id: b63288cf904c3db25021 · person: None · rule: names contained at one address · stratum: same-address

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 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "grocery"
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

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-20 22:08insertoverture 098bd700-926d-4719-869c-6570969d50dd ↔ snap snap|us|270227same address and namemerged17
2026-11-20 22:08insertnppes nppes|1801813019 ↔ overture 098bd700-926d-4719-869c-6570969d50ddsame address and namemerged17
2026-11-20 22:08insertsnap snap|us|270227 ↔ walmart-stores 33201|48312same address and namemerged17
2026-11-20 22:08insertmi-lcc L-000165313 ↔ nppes nppes|1801813019same address and namemerged17
2026-11-20 22:08insertmi-lcc L-000213676 ↔ nppes nppes|1801813019same address and namemerged17
2026-11-20 22:08insertsnap snap|us|270227 ↔ vtinfo dc34f476626c66b0same address and namemerged17
2026-11-20 22:08insertab-inbev 2903520 ↔ snap snap|us|270227same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000165313 ↔ snap snap|us|270227same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000213676 ↔ snap snap|us|270227same address and namemerged17
2026-11-16 14:56insertmi-lcc L-000213676 ↔ vtinfo dc34f476626c66b0one name contains the other, same addressmerged15
2026-11-16 14:56insertmi-lcc L-000165313 ↔ vtinfo dc34f476626c66b0one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2903520 ↔ mi-lcc L-000165313one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 2903520 ↔ mi-lcc L-000213676one name contains the other, same addressmerged15
2026-11-13 14:10insertoverture 098bd700-926d-4719-869c-6570969d50dd ↔ vtinfo dc34f476626c66b0same address and namemerged15
2026-11-13 14:10insertab-inbev 2903520 ↔ overture 098bd700-926d-4719-869c-6570969d50ddsame address and namemerged15
2026-11-13 14:10insertoverture 098bd700-926d-4719-869c-6570969d50dd ↔ walmart-stores 33201|48312same address and namemerged15
2026-11-12 17:29insertvtinfo dc34f476626c66b0 ↔ walmart-stores 33201|48312same address and namemerged14
2026-11-12 17:29insertab-inbev 2903520 ↔ walmart-stores 33201|48312same address and namemerged14
2026-11-12 14:25insertab-inbev 2903520 ↔ vtinfo dc34f476626c66b0same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000165313 ↔ mi-lcc L-000213676one store listed twicemerged