Best Price Beer & Tobacco

WATERFORD, MI 48329 · O05a7917a11a7 · first seen 2026-11-03
3 sourcesoff premise · liquor_storealcohol: licensed1 licence

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
Best Price Beer & Tobacco 2 other
a licence name in capitals, cleaned (derived; record_title.py)
BEST PRICE-BEER & TOBACCO mi-lcc
KTIPS, INC. mi-lcc (legal name)
Street
6482-6484 Williams Lake Rd 1 other
mi-lcc
6482 WILLIAMS LAKE RD ab-inbevvtinfo ×2
City
Waterford
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48329
mi-lccno other value
Pin
42.68626, -83.41669 map
mi-lccno other value
Phone
2484109489
vtinfono other value
Licences
mi-lcc L-000232801
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc030c5b91413; Od23f7e7f13e6

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-inbevBEST PRICE BEER & TOBACCO
3631410
6482 WILLIAMS LAKE RD, WATERFORD, MI, 4832942.68629, -83.416652026-11-112026-11-11
mi-lccBEST PRICE-BEER & TOBACCO
legal name: KTIPS, INC.
L-000232801
6482-6484 Williams Lake Rd, Waterford, MI, 48329248410948942.68626, -83.416692026-11-032026-11-18
vtinfoBEST PRICE BEER & TOBACCO
2c9e6dbb283a2fab
6482 WILLIAMS LAKE RD, WATERFORD, MI, 48329248410948942.68616, -83.416852026-11-152026-11-15

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 BEST PRICE BEER & TOBACCOmi-lcc BEST PRICE-BEER & TOBACCO1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Same name and address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name BEST PRICE BEER & TOBACCO at 6482 Williams Lake Rd in Waterford, MI (ZIP 48329), with coordinates 5 m apart and no other business at that address, so they describe one outlet despite the suite range and punctuation difference.
pair 848f790d4ab3ae9c68ac
ab-inbev BEST PRICE BEER & TOBACCOvtinfo BEST PRICE BEER & TOBACCO1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
mi-lcc BEST PRICE-BEER & TOBACCOvtinfo BEST PRICE BEER & TOBACCO1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Same name, address, phone
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records share the same street address, ZIP, and phone number, and the names are essentially identical (BEST PRICE-BEER & TOBACCO vs BEST PRICE BEER & TOBACCO), with coordinates 17 m apart and only one business at the address.
pair 2470c1526d5a7147ddcf

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
KTIPS, INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
13 within 1 mi · 226 within 3 mi
Off / on premise
4 / 5 within 1 mi · 54 / 120 within 3 mi
Selling alcohol
9 within 1 mi · 121 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
suburban (1,365 people per sq mi)
People within 3 mi
38,581 (29,994 adults 21+, 16,404 households) from 11 tract(s), tracts within 3 mi
Income
per capita $44,744 · median household ~$79,078 (weighted mean of tract medians)
Age and education
median age ~42.8 · bachelor's or higher 31%
Ethnicity
Hispanic 6% · White 84% · Black 4% · Asian 2%
Adults per alcohol outlet
246
Alcohol spend within 3 mi
$11,067,398 a year ($5,099,232 at home, $5,963,679 away) · $90,716 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-18 18:58insertab-inbev 3631410 ↔ mi-lcc L-000232801Claude judge: samemerged15
2026-11-18 18:58insertmi-lcc L-000232801 ↔ vtinfo 2c9e6dbb283a2fabClaude judge: samemerged15
2026-11-15 16:24insertab-inbev 3631410 ↔ vtinfo 2c9e6dbb283a2fabsame address and namemerged15