Pied Piper Liquor

Detroit, MI 48235 · O985c57852ddd · first seen 2026-11-11
3 sourcesoff premise · liquor_storealcohol: alcohol

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
Pied Piper Liquor
the most common name a source statesno other value
Street
18225 SCHAEFER HWY
ab-inbevno other value
City
DETROIT
ab-inbevno other value
State
MI
ab-inbevno other value
ZIP
48235
ab-inbevno other value
Pin
42.42440, -83.18015 map
overtureno other value
Phone
3138637676
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe121b97ea8e3; Of9806a187d85

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-inbevPIED PIPER LIQUOR
4692500
18225 SCHAEFER HWY, DETROIT, MI, 4823542.42451, -83.180232026-11-112026-11-11
overturePied Piper Liquor
6393c75f-4501-4ad1-83a5-f9a67a3765e0
18225 Schaefer Hwy, Detroit, MI, 48235313863767642.42440, -83.180152026-11-132026-11-13
snapPied Piper Liquor
snap|us|1549756
18225 Schaefer Hwy, Detroit, MI, 4823542.42434, -83.180602026-11-192026-11-19

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 PIED PIPER LIQUORoverture Pied Piper Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ab-inbev PIED PIPER LIQUORsnap Pied Piper Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
overture Pied Piper Liquorsnap Pied Piper Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 37 m apart · name similarity 1.00

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
alcohol — channel liquor_store
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:35.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
94 within 1 mi · 591 within 3 mi
Off / on premise
28 / 49 within 1 mi · 202 / 290 within 3 mi
Selling alcohol
37 within 1 mi · 283 within 3 mi
Nearest
same channel 0.12 mi · licensed 0.02 mi
Setting
urban (6,213 people per sq mi)
People within 3 mi
175,681 (130,359 adults 21+, 71,109 households) from 60 tract(s), tracts within 3 mi
Income
per capita $29,113 · median household ~$54,776 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 24%
Ethnicity
Hispanic 2% · White 10% · Black 84% · Asian 1%
Adults per alcohol outlet
459
Alcohol spend within 3 mi
$35,110,450 a year ($17,069,565 at home, $18,022,144 away) · $123,628 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:37insertab-inbev 4692500 ↔ snap snap|us|1549756same address and namemerged17
2026-11-19 20:37insertoverture 6393c75f-4501-4ad1-83a5-f9a67a3765e0 ↔ snap snap|us|1549756same address and namemerged17
2026-11-13 14:10insertab-inbev 4692500 ↔ overture 6393c75f-4501-4ad1-83a5-f9a67a3765e0same address and namemerged15