The Liquor Book

Sterling Heights, MI 48314 · O14df87f419df · 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
The Liquor Book 1 other
a source's own spelling of the licence name (record_title.py)
LIQUOR BOOK ab-inbevmi-lccvtinfo ×4
Street
43904 Mound Rd
mi-lccno other value
City
Sterling Heights
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48314
mi-lccno other value
Pin
42.61585, -83.05107 map 1 other
overture
85 m away ab-inbev
Phone
5867391030
vtinfono other value
Licences
mi-lcc L-000237673 · mi-lcc L-000237680
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob415994cb810; O75249783cf01; O2cab4609c0c5; Of3202bb98d59

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-inbevLIQUOR BOOK
3669791
43904 MOUND RD, STERLING HEIGHTS, MI, 4831442.61656, -83.051452026-11-112026-11-11
mi-lccLIQUOR BOOK
L-000237673
43904 Mound Rd, Sterling Heights, MI, 48314586739103042.61587, -83.051422026-11-032026-11-06
mi-lccLIQUOR BOOK
L-000237680
43904 Mound Rd, Sterling Heights, MI, 48314586739103042.61587, -83.051422026-11-032026-11-06
overtureThe Liquor Book
107a7f19-5a0b-4640-a388-e40da2f9d1f9
43904 Mound Rd, Sterling Heights, MI, 48314586739103042.61585, -83.051072026-11-062026-11-06
vtinfoLIQUOR BOOK
5d344cec0e3f24bf
43904 MOUND RD, STERLING HEIGHTS, MI, 48314586739103042.61597, -83.050772026-11-122026-11-14

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 LIQUOR BOOKmi-lcc LIQUOR BOOK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00
ab-inbev LIQUOR BOOKmi-lcc LIQUOR BOOK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 77 m apart · name similarity 1.00
ab-inbev LIQUOR BOOKoverture The Liquor Book1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 85 m apart · name similarity 1.00
ab-inbev LIQUOR BOOKvtinfo LIQUOR BOOK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 86 m apart · name similarity 1.00
mi-lcc LIQUOR BOOKmi-lcc LIQUOR BOOK1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc LIQUOR BOOKoverture The Liquor Book1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00 · phone: equal
mi-lcc LIQUOR BOOKvtinfo LIQUOR BOOK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 54 m apart · name similarity 1.00 · phone: equal
mi-lcc LIQUOR BOOKoverture The Liquor Book1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00 · phone: equal
mi-lcc LIQUOR BOOKvtinfo LIQUOR BOOK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 54 m apart · name similarity 1.00 · phone: equal
overture The Liquor Bookvtinfo LIQUOR BOOK1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00 · 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:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
78 within 1 mi · 353 within 3 mi
Off / on premise
19 / 49 within 1 mi · 97 / 188 within 3 mi
Selling alcohol
28 within 1 mi · 167 within 3 mi
Nearest
same channel 0.41 mi · licensed 0.41 mi
Setting
suburban (2,909 people per sq mi)
People within 3 mi
82,254 (64,599 adults 21+, 33,548 households) from 21 tract(s), tracts within 3 mi
Income
per capita $42,307 · median household ~$86,173 (weighted mean of tract medians)
Age and education
median age ~42.8 · bachelor's or higher 34%
Ethnicity
Hispanic 3% · White 77% · Black 5% · Asian 10%
Adults per alcohol outlet
385
Alcohol spend within 3 mi
$22,465,532 a year ($10,324,883 at home, $12,131,266 away) · $133,723 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-12 14:25insertab-inbev 3669791 ↔ vtinfo 5d344cec0e3f24bfsame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000237680 ↔ vtinfo 5d344cec0e3f24bfsame address and namemerged12
2026-11-12 14:25insertmi-lcc L-000237673 ↔ vtinfo 5d344cec0e3f24bfsame address and namemerged12
2026-11-12 14:25insertoverture 107a7f19-5a0b-4640-a388-e40da2f9d1f9 ↔ vtinfo 5d344cec0e3f24bfsame address and namemerged12
2026-11-11 12:56insertab-inbev 3669791 ↔ mi-lcc L-000237680same address and namemerged12
2026-11-11 12:56insertab-inbev 3669791 ↔ mi-lcc L-000237673same address and namemerged12
2026-11-11 12:56insertab-inbev 3669791 ↔ overture 107a7f19-5a0b-4640-a388-e40da2f9d1f9same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000237680 ↔ overture 107a7f19-5a0b-4640-a388-e40da2f9d1f9same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000237673 ↔ overture 107a7f19-5a0b-4640-a388-e40da2f9d1f9same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000237673 ↔ mi-lcc L-000237680one store listed twicemerged