MEGA Liquor and Smoke

Marcellus, MI 49067 · O36d1174736b4 · first seen 2026-11-03
4 sourcesoff premise · liquor_storechain: Mega Liquor & Smoke Rochester - #9alcohol: 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
MEGA Liquor and Smoke 3 other
a source's own spelling of the licence name (record_title.py)
MEGA LIQUOR & SMOKE ab-inbevvtinfo ×2
MEGA LIQUOR & SMOKE # 104 mi-lcc ×2
VISHAL, INC. mi-lcc (legal name) ×2
Street
52990 M 40 1 other
mi-lcc
52990 M-40 overture
City
Marcellus
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49067
mi-lccno other value
Pin
42.02721, -85.82504 map 1 other
overture
67 m away ab-inbev
Phone
2696461116 1 other
vtinfo
2695063085 mi-lcc ×2
Licences
mi-lcc L-000404071 · mi-lcc L-000404072
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of46655011dde; Obb17a249ef7e; O5dea20239120; O7ac4e82015af

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-inbevMEGA LIQUOR & SMOKE
4135841
52990 M 40, MARCELLUS, MI, 4906742.02778, -85.824752026-11-132026-11-13
mi-lccMEGA LIQUOR & SMOKE # 104
legal name: VISHAL, INC.
L-000404071
52990 M 40, Marcellus, MI, 49067269506308542.02733, -85.824922026-11-032026-11-06
mi-lccMEGA LIQUOR & SMOKE # 104
legal name: VISHAL, INC.
L-000404072
52990 M 40, Marcellus, MI, 49067269506308542.02733, -85.824922026-11-032026-11-06
overtureMEGA Liquor and Smoke
20461f2b-1f79-4322-b41c-6ab52fc0c92d
52990 M-40, Marcellus, MI, 49067269646111642.02721, -85.825042026-11-062026-11-06
vtinfoMEGA LIQUOR & SMOKE
8cbbfc1ebcef4b9d
52990 M 40, MARCELLUS, MI, 49067269646111642.02728, -85.825222026-11-142026-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 MEGA LIQUOR & SMOKEoverture MEGA Liquor and Smoke1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 67 m apart · name similarity 1.00
ab-inbev MEGA LIQUOR & SMOKEvtinfo MEGA LIQUOR & SMOKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 68 m apart · name similarity 1.00
mi-lcc MEGA LIQUOR & SMOKE # 104mi-lcc MEGA LIQUOR & SMOKE # 1041.00one store listed twicemergedsame street + ZIP · name: identical
overture MEGA Liquor and Smokevtinfo MEGA LIQUOR & SMOKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 · phone: equal
ab-inbev MEGA LIQUOR & SMOKEmi-lcc MEGA LIQUOR & SMOKE # 1040.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 52 m apart · name similarity 0.82
ab-inbev MEGA LIQUOR & SMOKEmi-lcc MEGA LIQUOR & SMOKE # 1040.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 52 m apart · name similarity 0.82
mi-lcc MEGA LIQUOR & SMOKE # 104overture MEGA Liquor and Smoke0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 16 m apart · name similarity 0.82 · phone: differs
mi-lcc MEGA LIQUOR & SMOKE # 104vtinfo MEGA LIQUOR & SMOKE0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 25 m apart · name similarity 0.82 · phone: differs
mi-lcc MEGA LIQUOR & SMOKE # 104overture MEGA Liquor and Smoke0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 16 m apart · name similarity 0.82 · phone: differs
mi-lcc MEGA LIQUOR & SMOKE # 104vtinfo MEGA LIQUOR & SMOKE0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 25 m apart · name similarity 0.82 · phone: differs

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
Mega Liquor & Smoke Rochester - #9 — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
VISHAL, INC. — 9 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 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
9 within 1 mi · 10 within 3 mi
Off / on premise
6 / 0 within 1 mi · 6 / 1 within 3 mi
Selling alcohol
9 within 1 mi · 10 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.05 mi
Setting
rural (none people per sq mi)
People within 3 mi
2,953 (2,262 adults 21+, 1,151 households) from 1 tract(s), the nearest tract
Income
per capita $32,254 · median household ~$73,125 (weighted mean of tract medians)
Age and education
median age ~44.1 · bachelor's or higher 14%
Ethnicity
Hispanic 1% · White 93% · Black 1% · Asian 0%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$631,854 a year ($303,829 at home, $327,788 away) · none 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-14 20:23insertmi-lcc L-000404071 ↔ vtinfo 8cbbfc1ebcef4b9dsame address and namemerged15
2026-11-14 20:23insertmi-lcc L-000404072 ↔ vtinfo 8cbbfc1ebcef4b9dsame address and namemerged15
2026-11-14 20:23insertoverture 20461f2b-1f79-4322-b41c-6ab52fc0c92d ↔ vtinfo 8cbbfc1ebcef4b9dsame address and namemerged15
2026-11-14 20:23insertab-inbev 4135841 ↔ vtinfo 8cbbfc1ebcef4b9dsame address and namemerged15
2026-11-13 17:47insertab-inbev 4135841 ↔ mi-lcc L-000404071same address and namemerged15
2026-11-13 17:47insertab-inbev 4135841 ↔ mi-lcc L-000404072same address and namemerged15
2026-11-13 17:47insertab-inbev 4135841 ↔ overture 20461f2b-1f79-4322-b41c-6ab52fc0c92dsame address and namemerged15
2026-11-06 18:13insertmi-lcc L-000404072 ↔ overture 20461f2b-1f79-4322-b41c-6ab52fc0c92dsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000404071 ↔ overture 20461f2b-1f79-4322-b41c-6ab52fc0c92dsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000404071 ↔ mi-lcc L-000404072one store listed twicemerged