Pied Piper

Detroit, MI 48221 · O58cbad044666 · first seen 2026-10-08
6 sourcesoff premise · conveniencealcohol: 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
Pied Piper 4 other
a licence name in capitals, cleaned (derived; record_title.py)
PIED PIPER MARKET mi-lccoverture ×3
PIED PIPER FOODS, LLC mi-lcc (legal name) ×2
Pied Piper Foods snap
pied piper market detroit doordash
Street
16215 Livernois Ave 1 other
mi-lcc
16215 LIVERNOIS ab-inbevdoordashoverturevtinfo ×4
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48221
mi-lccno other value
Pin
42.41152, -83.14087 map 1 other
doordash
64 m away mi-lcc ×2
Phone
3133415976 1 other
vtinfo
3133416976 mi-lcc ×2
Licences
mi-lcc L-000259411 · mi-lcc L-000259412
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oede68c832cb8; Oba46edae8a6c; Of37fa3a572b5; Ob1754489a9f8; O8d4c053b5d4c; O6e83ec918986

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
2548943
16215 LIVERNOIS, DETROIT, MI, 4822142.41126, -83.140802026-11-112026-11-19
doordashpied piper market detroit
27478107
16215 Livernois, Detroit, MI, 4822142.41152, -83.140872026-10-082026-11-19
mi-lccPIED PIPER MARKET
legal name: PIED PIPER FOODS, LLC
L-000259411
16215 Livernois Ave, Detroit, MI, 48221313341697642.41096, -83.140662026-11-032026-11-19
mi-lccPIED PIPER MARKET
legal name: PIED PIPER FOODS, LLC
L-000259412
16215 Livernois Ave, Detroit, MI, 48221313341697642.41096, -83.140662026-11-032026-11-19
overturePied Piper Market
c74c8b92-5f6d-472e-bdd5-029ecf6d6d1f
16215 Livernois, Detroit, MI, 48221313341597642.41156, -83.140752026-11-062026-11-19
snapPied Piper Foods
snap|us|1246255
16215 Livernois Ave, Detroit, MI, 4822142.41112, -83.140722026-11-192026-11-19
vtinfoPIED PIPER
a437b59b141dc1b4
16215 LIVERNOIS, DETROIT, MI, 48221313341597642.41161, -83.140962026-11-112026-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 PIPERvtinfo PIED PIPER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 41 m apart · name similarity 1.00
doordash pied piper market detroitmi-lcc PIED PIPER MARKET1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.82
doordash pied piper market detroitmi-lcc PIED PIPER MARKET1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.82
doordash pied piper market detroitoverture Pied Piper Market1.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 PIED PIPER MARKETmi-lcc PIED PIPER MARKET1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc PIED PIPER MARKEToverture Pied Piper Market1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 67 m apart · name similarity 1.00 · street similarity 0.82
mi-lcc PIED PIPER MARKETsnap Pied Piper Foods1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · matched through the licence's legal name: PIED PIPER FOODS, LLC · name similarity 1.00
mi-lcc PIED PIPER MARKEToverture Pied Piper Market1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 67 m apart · name similarity 1.00 · street similarity 0.82
mi-lcc PIED PIPER MARKETsnap Pied Piper Foods1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · matched through the licence's legal name: PIED PIPER FOODS, LLC · name similarity 1.00
ab-inbev PIED PIPERdoordash pied piper market detroit0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.71 · same street + ZIP · pins 30 m apart · name similarity 0.70
ab-inbev PIED PIPERoverture Pied Piper Market0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.71 · same street + ZIP · pins 34 m apart · name similarity 0.70
doordash pied piper market detroitvtinfo PIED PIPER0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.71 · same street + ZIP · pins 12 m apart · name similarity 0.70
overture Pied Piper Marketvtinfo PIED PIPER0.70same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.71 · same street + ZIP · pins 17 m apart · name similarity 0.70 · phone: equal

Attributes

Channel
off_premise · convenience — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PIED PIPER FOODS, LLC — 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:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-000259411 ↔ snap snap|us|1246255same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000259412 ↔ snap snap|us|1246255same address and namemerged17
2026-11-12 17:29insertab-inbev 2548943 ↔ doordash 27478107same address and namemerged14
2026-11-12 17:29insertdoordash 27478107 ↔ vtinfo a437b59b141dc1b4same address and namemerged14
2026-11-12 17:29insertab-inbev 2548943 ↔ overture c74c8b92-5f6d-472e-bdd5-029ecf6d6d1fsame address and namemerged14
2026-11-12 17:29insertoverture c74c8b92-5f6d-472e-bdd5-029ecf6d6d1f ↔ vtinfo a437b59b141dc1b4same address and namemerged14
2026-11-11 12:56insertab-inbev 2548943 ↔ vtinfo a437b59b141dc1b4same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000259411 ↔ overture c74c8b92-5f6d-472e-bdd5-029ecf6d6d1fstreet written two waysmerged11
2026-11-06 18:13insertmi-lcc L-000259412 ↔ overture c74c8b92-5f6d-472e-bdd5-029ecf6d6d1fstreet written two waysmerged11
2026-11-06 18:13insertdoordash 27478107 ↔ overture c74c8b92-5f6d-472e-bdd5-029ecf6d6d1fsame address and namemerged11
2026-11-03 14:30backfilldoordash 27478107 ↔ mi-lcc L-000259411street written two waysmerged
2026-11-03 14:30backfilldoordash 27478107 ↔ mi-lcc L-000259412street written two waysmerged
2026-11-03 13:33backfillmi-lcc L-000259411 ↔ mi-lcc L-000259412one store listed twicemerged