Roseville Liquor Shoppe

Roseville, MI 48066 · O2d81021a5a8e · 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
Roseville Liquor Shoppe 1 other
a source's own spelling of the licence name (record_title.py)
RAY'S LIQUOR, INC. mi-lcc (legal name) ×2
Street
26760 Gratiot Ave
mi-lccno other value
City
Roseville
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48066
mi-lccno other value
Pin
42.49332, -82.93866 map
overtureno other value
Phone
5867723933
vtinfono other value
Licences
mi-lcc L-000007631 · mi-lcc L-000017401
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O43e8215e4a80; O3c6be9f8a745; O56d3844d6287; Oeb2bf29dbe3e

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-inbevROSEVILLE LIQUOR SHOPPE
2550701
26760 GRATIOT AVE, ROSEVILLE, MI, 4806642.49317, -82.938982026-11-112026-11-11
mi-lccROSEVILLE LIQUOR SHOPPE
legal name: RAY'S LIQUOR, INC.
L-000007631
26760 Gratiot Ave, Roseville, MI, 48066586772393342.49321, -82.938942026-11-032026-11-06
mi-lccROSEVILLE LIQUOR SHOPPE
legal name: RAY'S LIQUOR, INC.
L-000017401
26760 Gratiot Ave, Roseville, MI, 48066586772393342.49321, -82.938942026-11-032026-11-06
overtureRoseville Liquor Shoppe
569fd948-410c-49eb-b3e2-cc3be0a9cf6d
26760 Gratiot Ave, Roseville, MI, 48066586772393342.49332, -82.938662026-11-062026-11-06
vtinfoROSEVILLE LIQUOR SHOPPE
1d094966eadcaa2c
26760 GRATIOT AVE, ROSEVILLE, MI, 48066586772393342.49329, -82.938582026-11-112026-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 ROSEVILLE LIQUOR SHOPPEmi-lcc ROSEVILLE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev ROSEVILLE LIQUOR SHOPPEmi-lcc ROSEVILLE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev ROSEVILLE LIQUOR SHOPPEoverture Roseville Liquor Shoppe1.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 ROSEVILLE LIQUOR SHOPPEvtinfo ROSEVILLE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
mi-lcc ROSEVILLE LIQUOR SHOPPEmi-lcc ROSEVILLE LIQUOR SHOPPE1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc ROSEVILLE LIQUOR SHOPPEoverture Roseville Liquor Shoppe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 · phone: equal
mi-lcc ROSEVILLE LIQUOR SHOPPEvtinfo ROSEVILLE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 · phone: equal
mi-lcc ROSEVILLE LIQUOR SHOPPEoverture Roseville Liquor Shoppe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 · phone: equal
mi-lcc ROSEVILLE LIQUOR SHOPPEvtinfo ROSEVILLE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00 · phone: equal
overture Roseville Liquor Shoppevtinfo ROSEVILLE LIQUOR SHOPPE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 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
RAY'S LIQUOR, INC. — 1 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:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
84 within 1 mi · 673 within 3 mi
Off / on premise
34 / 42 within 1 mi · 212 / 327 within 3 mi
Selling alcohol
40 within 1 mi · 347 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.04 mi
Setting
urban (5,048 people per sq mi)
People within 3 mi
142,740 (109,574 adults 21+, 61,797 households) from 53 tract(s), tracts within 3 mi
Income
per capita $36,230 · median household ~$67,458 (weighted mean of tract medians)
Age and education
median age ~40.4 · bachelor's or higher 20%
Ethnicity
Hispanic 3% · White 65% · Black 26% · Asian 2%
Adults per alcohol outlet
315
Alcohol spend within 3 mi
$34,751,378 a year ($16,588,541 at home, $18,147,961 away) · $99,860 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-11 12:56insertab-inbev 2550701 ↔ overture 569fd948-410c-49eb-b3e2-cc3be0a9cf6dsame address and namemerged12
2026-11-11 12:56insertab-inbev 2550701 ↔ vtinfo 1d094966eadcaa2csame address and namemerged12
2026-11-11 12:56insertoverture 569fd948-410c-49eb-b3e2-cc3be0a9cf6d ↔ vtinfo 1d094966eadcaa2csame address and namemerged12
2026-11-11 12:56insertab-inbev 2550701 ↔ mi-lcc L-000007631same address and namemerged12
2026-11-11 12:56insertmi-lcc L-000007631 ↔ vtinfo 1d094966eadcaa2csame address and namemerged12
2026-11-11 12:56insertab-inbev 2550701 ↔ mi-lcc L-000017401same address and namemerged12
2026-11-11 12:56insertmi-lcc L-000017401 ↔ vtinfo 1d094966eadcaa2csame address and namemerged12
2026-11-06 18:13insertmi-lcc L-000007631 ↔ overture 569fd948-410c-49eb-b3e2-cc3be0a9cf6dsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000017401 ↔ overture 569fd948-410c-49eb-b3e2-cc3be0a9cf6dsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000007631 ↔ mi-lcc L-000017401one store listed twicemerged