SGT Peppers

Ann Arbor, MI 48104 · O0de023ec270c · first seen 2026-10-08
5 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
SGT Peppers 3 other
a licence name in capitals, cleaned (derived; record_title.py)
MELODY'S NEST INC mi-lcc (legal name) ×2
Sergeant Pepper's General overture
sergeant pepper's general liquor ann arbor doordash
Street
1028 E University Ave 1 other
mi-lcc
1028 E UNIVERSITY ab-inbevvtinfo ×2
City
Ann Arbor
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48104
mi-lccno other value
Pin
42.26879, -83.73594 map 1 other
doordash
72 m away mi-lcc ×2
Phone
7346620202
vtinfono other value
Licences
mi-lcc L-000483872 · mi-lcc L-000483873
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O148b83c61359; O364a99e070ac; O8259034f287f; O1053675fff22; O84ab12c7c3c8

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-inbevSGT PEPPERS
2763296
1028 E UNIVERSITY, ANN ARBOR, MI, 4810442.26853, -83.736122026-11-112026-11-12
doordashsergeant pepper's general liquor ann arbor
40029253
1028 E University Ave, Ann Arbor, MI, 4810442.26879, -83.735942026-10-082026-11-03
mi-lccSGT. PEPPERS
legal name: MELODY'S NEST INC
L-000483872
1028 E University Ave, Ann Arbor, MI, 48104734662020242.26942, -83.735742026-11-032026-11-12
mi-lccSGT. PEPPERS
legal name: MELODY'S NEST INC
L-000483873
1028 E University Ave, Ann Arbor, MI, 48104734662020242.26942, -83.735742026-11-032026-11-12
overtureSergeant Pepper's General
7af5a99a-c77c-4b03-900d-71ce181448cc
1028 E University Ave, Ann Arbor, MI, 48104734662020242.26893, -83.735812026-11-062026-11-06
vtinfoSGT PEPPERS
7a2b6b9e7dd56531
1028 E UNIVERSITY, ANN ARBOR, MI, 48104734662020242.26879, -83.735942026-11-132026-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 SGT PEPPERSmi-lcc SGT. PEPPERS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 104 m apart · name similarity 1.00 · street similarity 0.86
ab-inbev SGT PEPPERSmi-lcc SGT. PEPPERS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 104 m apart · name similarity 1.00 · street similarity 0.86
ab-inbev SGT PEPPERSvtinfo SGT PEPPERS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
mi-lcc SGT. PEPPERSmi-lcc SGT. PEPPERS1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc SGT. PEPPERSvtinfo SGT PEPPERS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 72 m apart · name similarity 1.00 · street similarity 0.86
mi-lcc SGT. PEPPERSvtinfo SGT PEPPERS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 72 m apart · name similarity 1.00 · street similarity 0.86
doordash sergeant pepper's general liquor ann arboroverture Sergeant Pepper's General0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 18 m apart · name similarity 0.81
mi-lcc SGT. PEPPERSoverture Sergeant Pepper's General0.44same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: general · name Jaro-Winkler 0.64 · same street + ZIP · pins 55 m apart · name similarity 0.44 · phone: equal
mi-lcc SGT. PEPPERSoverture Sergeant Pepper's General0.44same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: general · name Jaro-Winkler 0.64 · same street + ZIP · pins 55 m apart · name similarity 0.44 · phone: equal
doordash sergeant pepper's general liquor ann arbormi-lcc SGT. PEPPERS0.36same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: general, liquor · name Jaro-Winkler 0.49 · same street + ZIP · pins 72 m apart · name similarity 0.36
doordash sergeant pepper's general liquor ann arbormi-lcc SGT. PEPPERS0.36same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: general, liquor · name Jaro-Winkler 0.49 · same street + ZIP · pins 72 m apart · name similarity 0.36

Attributes

Channel
off_premise · convenience — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MELODY'S NEST 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
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
249 within 1 mi · 698 within 3 mi
Off / on premise
25 / 141 within 1 mi · 152 / 374 within 3 mi
Selling alcohol
134 within 1 mi · 364 within 3 mi
Nearest
same channel 0.27 mi · licensed 0.21 mi
Setting
urban (3,912 people per sq mi)
People within 3 mi
110,623 (79,366 adults 21+, 45,599 households) from 32 tract(s), tracts within 3 mi
Income
per capita $55,225 · median household ~$93,067 (weighted mean of tract medians)
Age and education
median age ~32.4 · bachelor's or higher 78%
Ethnicity
Hispanic 6% · White 70% · Black 7% · Asian 14%
Adults per alcohol outlet
217
Alcohol spend within 3 mi
$32,921,612 a year ($14,771,431 at home, $18,136,049 away) · $90,196 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-13 14:10insertmi-lcc L-000483873 ↔ vtinfo 7a2b6b9e7dd56531street written two waysmerged15
2026-11-13 14:10insertmi-lcc L-000483872 ↔ vtinfo 7a2b6b9e7dd56531street written two waysmerged15
2026-11-13 14:10insertab-inbev 2763296 ↔ vtinfo 7a2b6b9e7dd56531same address and namemerged15
2026-11-12 17:29insertdoordash 40029253 ↔ mi-lcc L-000483872same address and namemerged14
2026-11-12 17:29insertdoordash 40029253 ↔ mi-lcc L-000483873same address and namemerged14
2026-11-12 17:29insertmi-lcc L-000483872 ↔ overture 7af5a99a-c77c-4b03-900d-71ce181448ccsame address and namemerged14
2026-11-12 17:29insertmi-lcc L-000483873 ↔ overture 7af5a99a-c77c-4b03-900d-71ce181448ccsame address and namemerged14
2026-11-11 12:56insertab-inbev 2763296 ↔ mi-lcc L-000483872street written two waysmerged12
2026-11-11 12:56insertab-inbev 2763296 ↔ mi-lcc L-000483873street written two waysmerged12
2026-11-06 18:13insertdoordash 40029253 ↔ overture 7af5a99a-c77c-4b03-900d-71ce181448ccsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000483872 ↔ mi-lcc L-000483873one store listed twicemerged