Lions Wine & Deli

Waterford, MI 48327 · O331723be7bc3 · first seen 2026-11-03
5 sourceson premise · baralcohol: 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
Lions Wine & Deli 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Lions overture
TN4 INC. mi-lcc
Street
6500 Hatchery Rd
mi-lccno other value
City
Waterford 1 other
mi-lcc
Waterford Twp overture
State
MI
mi-lccno other value
ZIP
48327
mi-lccno other value
Pin
42.67439, -83.41671 map 2 other
overture
122 m away ab-inbev
109 m away mi-lcc
Phone
2486662440
vtinfono other value
Licences
mi-lcc L-000491601
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od9ceb69bbd7b; O5977637a46fb; O6cdaf944ac37; O37f476656033

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-inbevLIONS WINE & DELI
2763368
6500 HATCHERY RD, WATERFORD, MI, 4832742.67340, -83.417362026-11-112026-11-13
mi-lccTN4 INC.
L-000491601
6500 Hatchery Rd, Waterford, MI, 48327248666244042.67342, -83.416852026-11-032026-11-18
overtureLions
7688e2c6-d5b3-45e1-ae71-499897e7ebb0
6500 Hatchery Rd, Waterford Twp, MI, 48327
ZIP lookup: Waterford, MI
248666244042.67439, -83.416712026-11-132026-11-13
snapLIONS WINE & DELI
snap|us|352824
6500 Hatchery Rd, Waterford, MI, 4832742.67426, -83.416392026-11-192026-11-19
vtinfoLIONS WINE & DELI
75265518bd2f23d1
6500 HATCHERY RD, WATERFORD, MI, 48327248666244042.67440, -83.416722026-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 LIONS WINE & DELIsnap LIONS WINE & DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 124 m apart · name similarity 1.00
ab-inbev LIONS WINE & DELIvtinfo LIONS WINE & DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 123 m apart · name similarity 1.00
snap LIONS WINE & DELIvtinfo LIONS WINE & DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev LIONS WINE & DELIoverture Lions0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, wine · name Jaro-Winkler 0.78 · same street + ZIP · pins 122 m apart · name similarity 0.42
overture Lionssnap LIONS WINE & DELI0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, wine · name Jaro-Winkler 0.78 · same street + ZIP · pins 30 m apart · name similarity 0.42
overture Lionsvtinfo LIONS WINE & DELI0.42same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, wine · name Jaro-Winkler 0.78 · same street + ZIP · pins 1 m apart · name similarity 0.42 · phone: equal
mi-lcc TN4 INC.vtinfo LIONS WINE & DELI0.06Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Phone equal; entity and trade name at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 75% confident — Both records share the exact street address and an identical phone number, and the Michigan licence name TN4 INC. is plausibly the legal entity behind the Lions Wine & Deli trade name, though the building holds three businesses and the names differ.
pair 8383026f6c7fb4a0e98f

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TN4 INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
10 within 1 mi · 234 within 3 mi
Off / on premise
3 / 4 within 1 mi · 63 / 124 within 3 mi
Selling alcohol
6 within 1 mi · 123 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.07 mi
Setting
suburban (1,625 people per sq mi)
People within 3 mi
45,955 (36,001 adults 21+, 19,639 households) from 14 tract(s), tracts within 3 mi
Income
per capita $45,351 · median household ~$81,639 (weighted mean of tract medians)
Age and education
median age ~43.1 · bachelor's or higher 32%
Ethnicity
Hispanic 6% · White 84% · Black 4% · Asian 2%
Adults per alcohol outlet
290
Alcohol spend within 3 mi
$13,327,484 a year ($6,133,157 at home, $7,188,721 away) · $107,480 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-19 20:37insertoverture 7688e2c6-d5b3-45e1-ae71-499897e7ebb0 ↔ snap snap|us|352824same address and namemerged17
2026-11-19 20:37insertab-inbev 2763368 ↔ snap snap|us|352824same address and namemerged17
2026-11-19 20:37insertsnap snap|us|352824 ↔ vtinfo 75265518bd2f23d1same address and namemerged17
2026-11-18 18:58insertmi-lcc L-000491601 ↔ vtinfo 75265518bd2f23d1Claude judge: samemerged15
2026-11-15 16:24insertoverture 7688e2c6-d5b3-45e1-ae71-499897e7ebb0 ↔ vtinfo 75265518bd2f23d1same address and namemerged15
2026-11-15 16:24insertab-inbev 2763368 ↔ vtinfo 75265518bd2f23d1same address and namemerged15
2026-11-13 14:10insertab-inbev 2763368 ↔ overture 7688e2c6-d5b3-45e1-ae71-499897e7ebb0same address and namemerged15