SEMMA LIQUOR SHOPPE

Detroit, MI 48228 · O1fdd3ddca917 · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Semma 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
SEMMA LIQUOR SHOPPE 5 other
the most common name a source states
JONATHON CORPORATION mi-lcc (legal name) ×2
SEMMAS LIQUOR SHOP ab-inbevvtinfo ×2
Semma Liquor Shop overture
Semma Liquor Store ubereats
semma party store detroit doordash
Street
19345 W Warren Ave 1 other
mi-lcc
19345 West Warren Avenue doordash
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48228
mi-lccno other value
Pin
42.34295, -83.23021 map
ubereatsno other value
Phone
3133367999
vtinfono other value
Licences
mi-lcc L-000413612 · mi-lcc L-000413613
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odeada06f8ee0; Odd384622ab68; O96694ee69cca; Oaf89a10e4d89; Oe23cae44e493; O86a8ccaff2c8

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-inbevSEMMAS LIQUOR SHOP
2549651
19345 W WARREN AVE, DETROIT, MI, 4822842.34316, -83.229842026-11-112026-11-11
doordashsemma party store detroit
23040099
19345 West Warren Avenue, Detroit, MI, 4822842.34293, -83.230202026-10-082026-11-11
mi-lccSEMMA LIQUOR SHOPPE
legal name: JONATHON CORPORATION
L-000413612
19345 W Warren Ave, Detroit, MI, 48228313336799942.34316, -83.229852026-11-032026-11-11
mi-lccSEMMA LIQUOR SHOPPE
legal name: JONATHON CORPORATION
L-000413613
19345 W Warren Ave, Detroit, MI, 48228313336799942.34316, -83.229852026-11-032026-11-11
overtureSemma Liquor Shop
fb2fa19f-2e30-478e-a708-c57c67ba0a4b
19345 W Warren Ave, Detroit, MI, 48228313336799942.34305, -83.230262026-11-062026-11-11
ubereatsSemma Liquor Store
nIRTCwRWVT28-fNWISPHSg
19345 W Warren Ave, Detroit, MI, 4822842.34295, -83.230212026-10-082026-11-11
vtinfoSEMMAS LIQUOR SHOP
a1dfbf9b1424e817
19345 W WARREN AVE, DETROIT, MI, 48228313336799942.34288, -83.230212026-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 SEMMAS LIQUOR SHOPvtinfo SEMMAS LIQUOR SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 43 m apart · name similarity 1.00
mi-lcc SEMMA LIQUOR SHOPPEmi-lcc SEMMA LIQUOR SHOPPE1.00one store listed twicemergedsame street + ZIP · name: identical
overture Semma Liquor Shopubereats Semma Liquor Store1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
mi-lcc SEMMA LIQUOR SHOPPEoverture Semma Liquor Shop0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 36 m apart · name similarity 0.72 · phone: equal
mi-lcc SEMMA LIQUOR SHOPPEubereats Semma Liquor Store0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · name similarity 0.72
mi-lcc SEMMA LIQUOR SHOPPEoverture Semma Liquor Shop0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 36 m apart · name similarity 0.72 · phone: equal
mi-lcc SEMMA LIQUOR SHOPPEubereats Semma Liquor Store0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · name similarity 0.72
ab-inbev SEMMAS LIQUOR SHOPoverture Semma Liquor Shop0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 37 m apart · name similarity 0.65
ab-inbev SEMMAS LIQUOR SHOPubereats Semma Liquor Store0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 38 m apart · name similarity 0.65
overture Semma Liquor Shopvtinfo SEMMAS LIQUOR SHOP0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 19 m apart · name similarity 0.65 · phone: equal
ubereats Semma Liquor Storevtinfo SEMMAS LIQUOR SHOP0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 8 m apart · name similarity 0.65
ab-inbev SEMMAS LIQUOR SHOPmi-lcc SEMMA LIQUOR SHOPPE0.53same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 1 m apart · name similarity 0.53
ab-inbev SEMMAS LIQUOR SHOPmi-lcc SEMMA LIQUOR SHOPPE0.53same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 1 m apart · name similarity 0.53
mi-lcc SEMMA LIQUOR SHOPPEvtinfo SEMMAS LIQUOR SHOP0.53same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 42 m apart · name similarity 0.53 · phone: equal
mi-lcc SEMMA LIQUOR SHOPPEvtinfo SEMMAS LIQUOR SHOP0.53same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 42 m apart · name similarity 0.53 · phone: equal
doordash semma party store detroitubereats Semma Liquor Store0.47Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair)
Both records share the distinctive name 'Semma' and the same street address and ZIP (19345 W Warren Ave, 48228), with only one business known there, so 'party store' and 'liquor store' are two labels
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at the same street address (19345 W Warren Ave, Detroit, ZIP 48228) with coordinates about 3 m apart, and the names 'Semma Party Store' and 'Semma Liquor Store' are the same distinctive independent operation; only one business is at that address and no suite or chain conflict exists.
  • Claude Haiku 5.5, prompt v6: same, 90% confident — Both records give the same street address in Detroit ZIP 48228 with coordinates about 3 m apart, only one business is at that address, and the names 'Semma Party Store' and 'Semma Liquor Store' are the same independent operation under near-identical names.
  • Claude Haiku 5.5, prompt v5: same, 90% confident — Both records sit at 19345 West Warren Avenue, Detroit 48228 with coordinates 3 m apart, and the names 'Semma party store' and 'Semma Liquor Store' point to one independent operation; no separate-premises rule applies and only one business is at the address.
pair 7e450c3b76bd080b13d3
doordash semma party store detroitmi-lcc SEMMA LIQUOR SHOPPE0.36Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Same address, Semma name shared; party store vs liquor shoppe same outlet.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 19345 West Warren Avenue (0.04 km apart, same ZIP) and share the distinctive name 'Semma', with the DoorDash slug 'semma party store' matching a liquor shop, so the mi-lcc licence 'SEMMA LIQUOR SHOPPE' is most likely the same outlet's delivery listing.
pair 20d95f04ae020d9106e4

Attributes

Channel
off_premise · liquor_store — ubereats-type
Chain
Semma Liquor Store — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
JONATHON CORPORATION — 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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
36 within 1 mi · 616 within 3 mi
Off / on premise
13 / 17 within 1 mi · 141 / 375 within 3 mi
Selling alcohol
21 within 1 mi · 226 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
urban (5,026 people per sq mi)
People within 3 mi
142,119 (94,571 adults 21+, 50,649 households) from 43 tract(s), tracts within 3 mi
Income
per capita $24,675 · median household ~$50,456 (weighted mean of tract medians)
Age and education
median age ~32.6 · bachelor's or higher 23%
Ethnicity
Hispanic 3% · White 54% · Black 39% · Asian 1%
Adults per alcohol outlet
417
Alcohol spend within 3 mi
$24,259,285 a year ($11,761,072 at home, $12,484,225 away) · $106,869 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 17:29insertdoordash 23040099 ↔ mi-lcc L-000413613Claude judge: samemerged14
2026-11-11 12:56insertmi-lcc L-000413613 ↔ vtinfo a1dfbf9b1424e817same address and namemerged12
2026-11-11 12:56insertmi-lcc L-000413612 ↔ vtinfo a1dfbf9b1424e817same address and namemerged12
2026-11-11 12:56insertab-inbev 2549651 ↔ mi-lcc L-000413613same address and namemerged12
2026-11-11 12:56insertab-inbev 2549651 ↔ mi-lcc L-000413612same address and namemerged12
2026-11-11 12:56insertoverture fb2fa19f-2e30-478e-a708-c57c67ba0a4b ↔ vtinfo a1dfbf9b1424e817same address and namemerged12
2026-11-11 12:56insertubereats nIRTCwRWVT28-fNWISPHSg ↔ vtinfo a1dfbf9b1424e817same address and namemerged12
2026-11-11 12:56insertab-inbev 2549651 ↔ overture fb2fa19f-2e30-478e-a708-c57c67ba0a4bsame address and namemerged12
2026-11-11 12:56insertab-inbev 2549651 ↔ ubereats nIRTCwRWVT28-fNWISPHSgsame address and namemerged12
2026-11-11 12:56insertab-inbev 2549651 ↔ vtinfo a1dfbf9b1424e817same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000413613 ↔ overture fb2fa19f-2e30-478e-a708-c57c67ba0a4bsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000413612 ↔ overture fb2fa19f-2e30-478e-a708-c57c67ba0a4bsame address and namemerged11
2026-11-06 18:13insertoverture fb2fa19f-2e30-478e-a708-c57c67ba0a4b ↔ ubereats nIRTCwRWVT28-fNWISPHSgsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000413613 ↔ ubereats nIRTCwRWVT28-fNWISPHSgsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000413612 ↔ ubereats nIRTCwRWVT28-fNWISPHSgsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000413612 ↔ mi-lcc L-000413613one store listed twicemerged
2026-11-02 23:02backfilldoordash 23040099 ↔ ubereats nIRTCwRWVT28-fNWISPHSgClaude judge: samemerged