SAMS CLUB

Ypsilanti, MI 48197 · O39dda19cc256 · first seen 2026-11-03
4 sourcesoff premise · predictedalcohol: 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
SAMS CLUB 3 other
the most common name a source states
SAM'S CLUB #6667 mi-lcc ×2
SAM'S EAST, INC. (AN ARKANSAS CORPORATION) mi-lcc (legal name) ×2
Sam's Club overture
Street
5450 Carpenter Rd
mi-lccno other value
City
Ypsilanti
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48197
mi-lccno other value
Pin
42.20894, -83.68242 map 3 other
overture
238 m away mi-lcc ×2
296 m away ab-inbev
66 m away vtinfo
Phone
7344341326
vtinfono other value
Licences
mi-lcc L-000106519 · mi-lcc L-000214630
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O77f2288fc3bc; O909d0fe14728; O7a7c5e018ab0; O6fbce3e045ad

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-inbevSAMS CLUB
187275
5450 CARPENTER RD, YPSILANTI, MI, 4819742.21051, -83.679522026-11-112026-11-16
mi-lccSAM'S CLUB #6667
legal name: SAM'S EAST, INC. (AN ARKANSAS CORPORATION)
L-000106519
5450 Carpenter Rd, Ypsilanti, MI, 48197734434132642.20940, -83.679602026-11-032026-11-05
mi-lccSAM'S CLUB #6667
legal name: SAM'S EAST, INC. (AN ARKANSAS CORPORATION)
L-000214630
5450 Carpenter Rd, Ypsilanti, MI, 48197734434132642.20940, -83.679602026-11-032026-11-05
overtureSam's Club
2c193d4c-41de-40c4-a140-93e5e9d1855f
5450 Carpenter Rd, Ypsilanti, MI, 48197734434132642.20894, -83.682422026-11-132026-11-16
vtinfoSAMS CLUB
b3e19bd3a6531d07
5450 CARPENTER RD, YPSILANTI, MI, 48197734434132642.20946, -83.682042026-11-132026-11-16

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 SAMS CLUBoverture Sam's Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 296 m apart · name similarity 1.00
ab-inbev SAMS CLUBvtinfo SAMS CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 238 m apart · name similarity 1.00
mi-lcc SAM'S CLUB #6667mi-lcc SAM'S CLUB #66671.00one store listed twicemergedsame street + ZIP · name: identical
overture Sam's Clubvtinfo SAMS CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 66 m apart · name similarity 1.00 · phone: equal
ab-inbev SAMS CLUBmi-lcc SAM'S CLUB #66670.72one name contains the other, same addressmergedjudge: None · pair_id: ec3ee4eba458913020e8 · person: None · rule: names contained at one address · stratum: near
ab-inbev SAMS CLUBmi-lcc SAM'S CLUB #66670.72one name contains the other, same addressmergedjudge: None · pair_id: 66dc183f9a9f56538f8a · person: None · rule: names contained at one address · stratum: near
mi-lcc SAM'S CLUB #6667vtinfo SAMS CLUB0.72one name contains the other, same addressmergedjudge: None · pair_id: f57ddb6b41cafb81b6a2 · person: None · rule: names contained at one address · stratum: near
mi-lcc SAM'S CLUB #6667vtinfo SAMS CLUB0.72one name contains the other, same addressmergedjudge: None · pair_id: 9e01af05cf2abbb150f6 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SAM'S EAST, INC. (AN ARKANSAS CORPORATION) — 23 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:16.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
15 within 1 mi · 127 within 3 mi
Off / on premise
8 / 2 within 1 mi · 36 / 67 within 3 mi
Selling alcohol
11 within 1 mi · 61 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.14 mi
Setting
suburban (1,523 people per sq mi)
People within 3 mi
43,062 (33,184 adults 21+, 18,224 households) from 15 tract(s), tracts within 3 mi
Income
per capita $44,838 · median household ~$85,927 (weighted mean of tract medians)
Age and education
median age ~37.0 · bachelor's or higher 57%
Ethnicity
Hispanic 7% · White 61% · Black 16% · Asian 11%
Adults per alcohol outlet
535
Alcohol spend within 3 mi
$12,424,008 a year ($5,687,782 at home, $6,731,443 away) · $200,387 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-16 14:56insertmi-lcc L-000214630 ↔ vtinfo b3e19bd3a6531d07one name contains the other, same addressmerged15
2026-11-16 14:56insertmi-lcc L-000106519 ↔ vtinfo b3e19bd3a6531d07one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 187275 ↔ mi-lcc L-000214630one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 187275 ↔ mi-lcc L-000106519one name contains the other, same addressmerged15
2026-11-13 14:10insertab-inbev 187275 ↔ vtinfo b3e19bd3a6531d07same address and namemerged15
2026-11-13 14:10insertoverture 2c193d4c-41de-40c4-a140-93e5e9d1855f ↔ vtinfo b3e19bd3a6531d07same address and namemerged15
2026-11-13 14:10insertab-inbev 187275 ↔ overture 2c193d4c-41de-40c4-a140-93e5e9d1855fsame address and namemerged15
2026-11-03 13:33backfillmi-lcc L-000106519 ↔ mi-lcc L-000214630one store listed twicemerged