Coach Liquor

Waterford, MI 48329 · O07ddf7d372fe · first seen 2026-11-03
4 sourcesoff premise · liquor_storealcohol: 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
Coach Liquor 2 other
a licence name in capitals, cleaned (derived; record_title.py)
COACH LIQUOR SHOP ab-inbevvtinfo ×2
Coach Liquor Shoppe overture
Street
5939 Andersonville Rd
mi-lccno other value
City
Waterford
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48329
mi-lccno other value
Pin
42.70053, -83.40640 map 1 other
overture
70 m away ab-inbev
Phone
2486232655 1 other
vtinfo
2489109541 mi-lcc ×2
Licences
mi-lcc L-000439301 · mi-lcc L-000439302
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od5bd0e4f9d22; Oca3cc72f4d69; Oe1b31233a51f; O640586648073

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-inbevCOACH LIQUOR SHOP
2541655
5939 ANDERSONVILLE RD, WATERFORD, MI, 4832942.70023, -83.407162026-11-112026-11-11
mi-lccCOACH LIQUOR
L-000439301
5939 Andersonville Rd, Waterford, MI, 48329248910954142.70054, -83.406492026-11-032026-11-04
mi-lccCOACH LIQUOR
L-000439302
5939 Andersonville Rd, Waterford, MI, 48329248910954142.70054, -83.406492026-11-032026-11-04
overtureCoach Liquor Shoppe
0aad8cf6-8048-451a-902c-61f4943b5c19
5939 Andersonville Rd, Waterford, MI, 48329248623265542.70053, -83.406402026-11-062026-11-06
vtinfoCOACH LIQUOR SHOP
5d7aa62557cf4235
5939 ANDERSONVILLE RD, WATERFORD, MI, 48329248623265542.70041, -83.406382026-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 COACH LIQUOR SHOPmi-lcc COACH LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ab-inbev COACH LIQUOR SHOPmi-lcc COACH LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00
ab-inbev COACH LIQUOR SHOPvtinfo COACH LIQUOR SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 67 m apart · name similarity 1.00
mi-lcc COACH LIQUORmi-lcc COACH LIQUOR1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc COACH LIQUORvtinfo COACH LIQUOR SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00 · phone: differs
mi-lcc COACH LIQUORvtinfo COACH LIQUOR SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00 · phone: differs
ab-inbev COACH LIQUOR SHOPoverture Coach Liquor Shoppe0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 70 m apart · name similarity 0.72
mi-lcc COACH LIQUORoverture Coach Liquor Shoppe0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 7 m apart · name similarity 0.72 · phone: differs
mi-lcc COACH LIQUORoverture Coach Liquor Shoppe0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 7 m apart · name similarity 0.72 · phone: differs
overture Coach Liquor Shoppevtinfo COACH LIQUOR SHOP0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 14 m apart · name similarity 0.72 · phone: equal

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
37 within 1 mi · 243 within 3 mi
Off / on premise
8 / 20 within 1 mi · 54 / 139 within 3 mi
Selling alcohol
23 within 1 mi · 122 within 3 mi
Nearest
same channel 0.20 mi · licensed 0.20 mi
Setting
suburban (1,464 people per sq mi)
People within 3 mi
41,400 (31,303 adults 21+, 16,967 households) from 11 tract(s), tracts within 3 mi
Income
per capita $46,907 · median household ~$93,181 (weighted mean of tract medians)
Age and education
median age ~41.5 · bachelor's or higher 36%
Ethnicity
Hispanic 7% · White 83% · Black 3% · Asian 2%
Adults per alcohol outlet
254
Alcohol spend within 3 mi
$12,209,385 a year ($5,549,548 at home, $6,654,026 away) · $99,263 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-15 16:24insertoverture 0aad8cf6-8048-451a-902c-61f4943b5c19 ↔ vtinfo 5d7aa62557cf4235same address and namemerged15
2026-11-15 16:24insertmi-lcc L-000439301 ↔ vtinfo 5d7aa62557cf4235same address and namemerged15
2026-11-15 16:24insertab-inbev 2541655 ↔ vtinfo 5d7aa62557cf4235same address and namemerged15
2026-11-15 16:24insertmi-lcc L-000439302 ↔ vtinfo 5d7aa62557cf4235same address and namemerged15
2026-11-11 12:56insertab-inbev 2541655 ↔ overture 0aad8cf6-8048-451a-902c-61f4943b5c19same address and namemerged12
2026-11-11 12:56insertab-inbev 2541655 ↔ mi-lcc L-000439302same address and namemerged12
2026-11-11 12:56insertab-inbev 2541655 ↔ mi-lcc L-000439301same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000439302 ↔ overture 0aad8cf6-8048-451a-902c-61f4943b5c19same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000439301 ↔ overture 0aad8cf6-8048-451a-902c-61f4943b5c19same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000439301 ↔ mi-lcc L-000439302one store listed twicemerged