Mega Liquor & Smoke

SAINT JOSEPH, MI 49085 · O6dddbbc7fbe0 · 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 & Smoke 3 other
a licence name in capitals, cleaned (derived; record_title.py)
MEGA LIQUOR & SMOKE #105 mi-lcc ×2
VISHAL, INC. mi-lcc (legal name) ×2
Mega Liquor and Smoke Store overture
Street
4031 M 139 1 other
mi-lcc
4031 M-139 overture
City
ST JOSEPH 2 other
mi-lcc
SAINT JOSEPH ab-inbevvtinfo ×2
Royalton Twp overture
State
MI
mi-lccno other value
ZIP
49085
mi-lccno other value
Pin
42.04468, -86.43477 map 2 other
overture
151 m away ab-inbev
51 m away vtinfo
Phone
2694702716 2 other
vtinfo
2695063085 mi-lcc ×2
2694088281 overture
Licences
mi-lcc L-000417103 · mi-lcc L-000417104
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc5fe6cf41088; Oac1a0682741b; Oc93bffcf3da9; O9a8ce0695375

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
4302424
4031 M 139, SAINT JOSEPH, MI, 4908542.04336, -86.435192026-11-112026-11-11
mi-lccMEGA LIQUOR & SMOKE #105
legal name: VISHAL, INC.
L-000417103
4031 M 139, ST JOSEPH, MI, 49085269506308542.04488, -86.435212026-11-032026-11-05
mi-lccMEGA LIQUOR & SMOKE #105
legal name: VISHAL, INC.
L-000417104
4031 M 139, ST JOSEPH, MI, 49085269506308542.04488, -86.435212026-11-032026-11-05
overtureMega Liquor and Smoke Store
d84785b0-47f1-4e93-a676-a40f12a4f6c5
4031 M-139, Royalton Twp, MI, 49085269408828142.04468, -86.434772026-11-062026-11-06
vtinfoMEGA LIQUOR & SMOKE
20a9f025611d85c1
4031 M 139, SAINT JOSEPH, MI269470271642.04476, -86.434162026-11-162026-11-18

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 Smoke Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 151 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 + city + state · pins 177 m apart · name similarity 1.00
mi-lcc MEGA LIQUOR & SMOKE #105mi-lcc MEGA LIQUOR & SMOKE #1051.00one store listed twicemergedsame street + ZIP · name: identical
overture Mega Liquor and Smoke Storevtinfo MEGA LIQUOR & SMOKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 51 m apart · name similarity 1.00 · phone: differs
ab-inbev MEGA LIQUOR & SMOKEmi-lcc MEGA LIQUOR & SMOKE #1050.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 169 m apart · name similarity 0.82
ab-inbev MEGA LIQUOR & SMOKEmi-lcc MEGA LIQUOR & SMOKE #1050.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 169 m apart · name similarity 0.82
mi-lcc MEGA LIQUOR & SMOKE #105overture Mega Liquor and Smoke Store0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 43 m apart · name similarity 0.82 · phone: differs
mi-lcc MEGA LIQUOR & SMOKE #105vtinfo MEGA LIQUOR & SMOKE0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 88 m apart · name similarity 0.82 · phone: differs
mi-lcc MEGA LIQUOR & SMOKE #105overture Mega Liquor and Smoke Store0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 43 m apart · name similarity 0.82 · phone: differs
mi-lcc MEGA LIQUOR & SMOKE #105vtinfo MEGA LIQUOR & SMOKE0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.82 · same street + ZIP · pins 88 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:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
13 within 1 mi · 100 within 3 mi
Off / on premise
4 / 4 within 1 mi · 37 / 40 within 3 mi
Selling alcohol
8 within 1 mi · 48 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.11 mi
Setting
rural (458 people per sq mi)
People within 3 mi
12,953 (9,609 adults 21+, 5,097 households) from 3 tract(s), tracts within 3 mi
Income
per capita $43,613 · median household ~$90,964 (weighted mean of tract medians)
Age and education
median age ~43.3 · bachelor's or higher 38%
Ethnicity
Hispanic 2% · White 71% · Black 17% · Asian 3%
Adults per alcohol outlet
196
Alcohol spend within 3 mi
$3,679,935 a year ($1,652,810 at home, $2,025,122 away) · $75,101 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-17 17:19insertmi-lcc L-000417104 ↔ vtinfo 20a9f025611d85c1same address and namemerged15
2026-11-17 17:19insertmi-lcc L-000417103 ↔ vtinfo 20a9f025611d85c1same address and namemerged15
2026-11-17 17:19insertoverture d84785b0-47f1-4e93-a676-a40f12a4f6c5 ↔ vtinfo 20a9f025611d85c1same address and namemerged15
2026-11-16 14:56insertab-inbev 4302424 ↔ vtinfo 20a9f025611d85c1same address and namemerged15
2026-11-11 12:56insertab-inbev 4302424 ↔ mi-lcc L-000417104same address and namemerged12
2026-11-11 12:56insertab-inbev 4302424 ↔ mi-lcc L-000417103same address and namemerged12
2026-11-11 12:56insertab-inbev 4302424 ↔ overture d84785b0-47f1-4e93-a676-a40f12a4f6c5same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000417104 ↔ overture d84785b0-47f1-4e93-a676-a40f12a4f6c5same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000417103 ↔ overture d84785b0-47f1-4e93-a676-a40f12a4f6c5same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000417103 ↔ mi-lcc L-000417104one store listed twicemerged