Piper L S

Detroit, MI 48234 · O23bbbbeef29b · first seen 2026-10-10
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
Piper L S 4 other
a licence name in capitals, cleaned (derived; record_title.py)
BEYY, INC. mi-lcc (legal name) ×2
PIPER LIQUOR mi-lcc ×2
piper liquor detroit doordash
Piper Liquor Shoppe snap
Street
5017 E Nevada St
mi-lccno other value
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48234
mi-lccno other value
Pin
42.42628, -83.05258 map
doordashno other value
Phone
3138915245
vtinfono other value
Licences
mi-lcc L-000135155 · mi-lcc L-000135156
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8635a1add0be; O4cb6d105fe16; Of308f29f8908; Od339736f58cd; Ob2b52df10fec

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-inbevPIPER L S
2540227
5017 E NEVADA ST, DETROIT, MI, 4823442.42616, -83.052352026-11-112026-11-12
doordashpiper liquor detroit
30428600
5017 E Nevada St, Detroit, MI, 4823442.42628, -83.052582026-10-102026-10-11
mi-lccPIPER LIQUOR
legal name: BEYY, INC.
L-000135155
5017 E Nevada St, Detroit, MI, 48234313891524542.42615, -83.052812026-11-032026-11-05
mi-lccPIPER LIQUOR
legal name: BEYY, INC.
L-000135156
5017 E Nevada St, Detroit, MI, 48234313891524542.42615, -83.052812026-11-032026-11-05
snapPiper Liquor Shoppe
snap|us|1381701
5017 E Nevada St, Detroit, MI, 4823442.42611, -83.052542026-11-192026-11-19
vtinfoPIPER L S
5a10299b4d7d453d
5017 E NEVADA ST, DETROIT, MI, 48234313891524542.42632, -83.052552026-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 PIPER L Svtinfo PIPER L S1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
doordash piper liquor detroitmi-lcc PIPER LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash piper liquor detroitmi-lcc PIPER LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc PIPER LIQUORmi-lcc PIPER LIQUOR1.00one store listed twicemergedsame street + ZIP · name: identical
doordash piper liquor detroitsnap Piper Liquor Shoppe0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 19 m apart · name similarity 0.72
mi-lcc PIPER LIQUORsnap Piper Liquor Shoppe0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 22 m apart · name similarity 0.72
mi-lcc PIPER LIQUORsnap Piper Liquor Shoppe0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 22 m apart · name similarity 0.72
ab-inbev PIPER L Smi-lcc PIPER LIQUOR0.46Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Piper L S abbreviates Piper Liquor, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 88% confident — Both records sit at 5017 E Nevada St, Detroit 48234 with near-identical coordinates (0.038 km), only one business is held at that address, and the names 'PIPER L S' and 'PIPER LIQUOR' share the distinctive 'PIPER' name, indicating one liquor store.
pair 1c748e48abac4e2a96be
mi-lcc PIPER LIQUORvtinfo PIPER L S0.46Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (94% confident; asked as a “near” pair)
Same address and phone, Piper liquor.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records share the same street address, ZIP, and identical phone number (3138915245), with the VIP brand finder name 'PIPER L S' being an abbreviation of the Michigan licence trade name 'PIPER LIQUOR' at one building and no other businesses listed there.
pair 2739a9cd388b7227fecb

Attributes

Channel
off_premise · liquor_store — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BEYY, 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-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
42 within 1 mi · 496 within 3 mi
Off / on premise
13 / 15 within 1 mi · 155 / 215 within 3 mi
Selling alcohol
28 within 1 mi · 253 within 3 mi
Nearest
same channel 0.50 mi · licensed 0.51 mi
Setting
urban (4,534 people per sq mi)
People within 3 mi
128,208 (85,991 adults 21+, 43,593 households) from 46 tract(s), tracts within 3 mi
Income
per capita $19,885 · median household ~$42,435 (weighted mean of tract medians)
Age and education
median age ~33.0 · bachelor's or higher 14%
Ethnicity
Hispanic 2% · White 29% · Black 52% · Asian 12%
Adults per alcohol outlet
339
Alcohol spend within 3 mi
$18,419,494 a year ($9,270,468 at home, $9,139,084 away) · $72,518 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:37insertmi-lcc L-000135156 ↔ vtinfo 5a10299b4d7d453dClaude judge: samemerged17
2026-11-19 20:37insertdoordash 30428600 ↔ snap snap|us|1381701same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000135156 ↔ snap snap|us|1381701same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000135155 ↔ snap snap|us|1381701same address and namemerged17
2026-11-12 17:29insertab-inbev 2540227 ↔ mi-lcc L-000135155Claude judge: samemerged14
2026-11-11 12:56insertab-inbev 2540227 ↔ vtinfo 5a10299b4d7d453dsame address and namemerged12
2026-11-03 13:33backfilldoordash 30428600 ↔ mi-lcc L-000135156same address and namemerged
2026-11-03 13:33backfilldoordash 30428600 ↔ mi-lcc L-000135155same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000135155 ↔ mi-lcc L-000135156one store listed twicemerged