Jays Beer And Wine

Detroit, MI 48224 · O0ed383b19c09 · first seen 2026-10-08
5 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
Jays Beer And Wine 3 other
a source's own spelling of the licence name (record_title.py)
JAY'S BEER & WINE, INC. mi-lcc ×2
JAYS BEER & WINE ab-inbevvtinfo ×2
jay's beer and wine inc detroit doordash
Street
17300 Harper Ave
mi-lccno other value
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48224
mi-lccno other value
Pin
42.41772, -82.93381 map
doordashno other value
Phone
3136409909 1 other
vtinfo
5865247719 mi-lcc ×2
Licences
mi-lcc L-000425906 · mi-lcc L-000430454
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe2452c1ee464; O3bd891b1c190; Obe253b43a257; O240f3894ecd7; O2ed9bd5c27b4

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-inbevJAYS BEER & WINE
4235593
17300 HARPER AVE, DETROIT, MI, 4822442.41791, -82.933842026-11-112026-11-12
doordashjay's beer and wine inc detroit
31284120
17300 Harper Ave, Detroit, MI, 4822442.41772, -82.933812026-10-082026-11-12
mi-lccJAY'S BEER & WINE, INC.
L-000425906
17300 Harper Ave, Detroit, MI, 48224586524771942.41781, -82.933992026-11-032026-11-12
mi-lccJAY'S BEER & WINE, INC.
L-000430454
17300 Harper Ave, Detroit, MI, 48224586524771942.41781, -82.933992026-11-032026-11-12
snapJays Beer And Wine
snap|us|1357560
17300 Harper Ave, Detroit, MI, 4822442.41786, -82.933972026-11-192026-11-19
vtinfoJAYS BEER & WINE
31f20a3c16eb5e16
17300 HARPER AVE, DETROIT, MI, 48224313640990942.41767, -82.933732026-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 JAYS BEER & WINEdoordash jay's beer and wine inc detroit1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ab-inbev JAYS BEER & WINEmi-lcc JAY'S BEER & WINE, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev JAYS BEER & WINEmi-lcc JAY'S BEER & WINE, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev JAYS BEER & WINEsnap Jays Beer And Wine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev JAYS BEER & WINEvtinfo JAYS BEER & WINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
doordash jay's beer and wine inc detroitmi-lcc JAY'S BEER & WINE, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash jay's beer and wine inc detroitmi-lcc JAY'S BEER & WINE, INC.1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash jay's beer and wine inc detroitsnap Jays Beer And Wine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · name similarity 1.00
doordash jay's beer and wine inc detroitvtinfo JAYS BEER & WINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
mi-lcc JAY'S BEER & WINE, INC.mi-lcc JAY'S BEER & WINE, INC.1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc JAY'S BEER & WINE, INC.snap Jays Beer And Wine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
mi-lcc JAY'S BEER & WINE, INC.vtinfo JAYS BEER & WINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00 · phone: differs
mi-lcc JAY'S BEER & WINE, INC.snap Jays Beer And Wine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
mi-lcc JAY'S BEER & WINE, INC.vtinfo JAYS BEER & WINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00 · phone: differs
snap Jays Beer And Winevtinfo JAYS BEER & WINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
JAY'S BEER & WINE, 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 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
57 within 1 mi · 485 within 3 mi
Off / on premise
20 / 25 within 1 mi · 168 / 232 within 3 mi
Selling alcohol
31 within 1 mi · 262 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.20 mi
Setting
urban (5,025 people per sq mi)
People within 3 mi
142,070 (100,003 adults 21+, 54,505 households) from 48 tract(s), tracts within 3 mi
Income
per capita $37,014 · median household ~$73,571 (weighted mean of tract medians)
Age and education
median age ~37.6 · bachelor's or higher 32%
Ethnicity
Hispanic 2% · White 32% · Black 61% · Asian 1%
Adults per alcohol outlet
380
Alcohol spend within 3 mi
$32,193,915 a year ($15,052,368 at home, $17,126,610 away) · $122,410 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-19 20:37insertsnap snap|us|1357560 ↔ vtinfo 31f20a3c16eb5e16same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000430454 ↔ snap snap|us|1357560same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000425906 ↔ snap snap|us|1357560same address and namemerged17
2026-11-19 20:37insertdoordash 31284120 ↔ snap snap|us|1357560same address and namemerged17
2026-11-19 20:37insertab-inbev 4235593 ↔ snap snap|us|1357560same address and namemerged17
2026-11-12 14:25insertmi-lcc L-000425906 ↔ vtinfo 31f20a3c16eb5e16same address and namemerged12
2026-11-12 14:25insertdoordash 31284120 ↔ vtinfo 31f20a3c16eb5e16same address and namemerged12
2026-11-12 14:25insertab-inbev 4235593 ↔ vtinfo 31f20a3c16eb5e16same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000430454 ↔ vtinfo 31f20a3c16eb5e16same address and namemerged12
2026-11-11 12:56insertab-inbev 4235593 ↔ mi-lcc L-000430454same address and namemerged12
2026-11-11 12:56insertab-inbev 4235593 ↔ mi-lcc L-000425906same address and namemerged12
2026-11-11 12:56insertab-inbev 4235593 ↔ doordash 31284120same address and namemerged12
2026-11-03 13:33backfilldoordash 31284120 ↔ mi-lcc L-000430454same address and namemerged
2026-11-03 13:33backfilldoordash 31284120 ↔ mi-lcc L-000425906same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000425906 ↔ mi-lcc L-000430454one store listed twicemerged