Pop Top Liquor

Hazel Park, MI 48030 · O157e11c9a481 · first seen 2026-11-03
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
Pop Top Liquor
a source's own spelling of the licence name (record_title.py)no other value
Street
931 E 9 Mile Rd 1 other
mi-lcc
931 9 MILE ab-inbevvtinfo ×2
City
Hazel Park
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48030
mi-lccno other value
Pin
42.46178, -83.09616 map
overtureno other value
Phone
2485473809
vtinfono other value
Licences
mi-lcc L-000146563 · mi-lcc L-000146564
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocf2bf2b51a26; O21343107b9f8; O52f0852885eb; O20d1c9b3b74c; O17ccf4c2ffa7

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-inbevPOP TOP LIQUOR
2922210
931 9 MILE, HAZEL PARK, MI, 4803042.46184, -83.096192026-11-112026-11-11
mi-lccPOP TOP LIQUOR
L-000146563
931 E 9 Mile Rd, Hazel Park, MI, 48030248547380942.46162, -83.096382026-11-032026-11-19
mi-lccPOP TOP LIQUOR
L-000146564
931 E 9 Mile Rd, Hazel Park, MI, 48030248547380942.46162, -83.096382026-11-032026-11-19
overturePop Top Liquor
ec9b9e39-8709-485a-b0fb-bf981ce8e7bf
931 E 9 Mile Rd, Hazel Park, MI, 48030248547380942.46178, -83.096162026-11-062026-11-19
snapPop Top Liquor
snap|us|798667
931 E 9 Mile Rd, Hazel Park, MI, 4803042.46194, -83.096152026-11-192026-11-19
vtinfoPOP TOP LIQUOR
b70d41de6d104008
931 9 MILE, HAZEL PARK, MI, 48030248547380942.46193, -83.096132026-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 POP TOP LIQUORvtinfo POP TOP LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
mi-lcc POP TOP LIQUORmi-lcc POP TOP LIQUOR1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc POP TOP LIQUORoverture Pop Top Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 · phone: equal
mi-lcc POP TOP LIQUORsnap Pop Top Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
mi-lcc POP TOP LIQUORvtinfo POP TOP LIQUOR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (97% confident; asked as a “proximity” pair)
Same name, phone, address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records name POP TOP LIQUOR at 931 9 Mile Rd in Hazel Park, MI 48030 with an identical phone number, the coordinates are about 40 m apart, and it is the only business at that address.
pair 0a4c662cb2faf6a59401
mi-lcc POP TOP LIQUORoverture Pop Top Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00 · phone: equal
mi-lcc POP TOP LIQUORsnap Pop Top Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
overture Pop Top Liquorsnap Pop Top Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00

Attributes

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

Trade area

Other outlets
71 within 1 mi · 673 within 3 mi
Off / on premise
20 / 38 within 1 mi · 170 / 342 within 3 mi
Selling alcohol
40 within 1 mi · 364 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (4,577 people per sq mi)
People within 3 mi
129,402 (101,937 adults 21+, 57,064 households) from 43 tract(s), tracts within 3 mi
Income
per capita $41,828 · median household ~$74,421 (weighted mean of tract medians)
Age and education
median age ~37.5 · bachelor's or higher 35%
Ethnicity
Hispanic 4% · White 55% · Black 31% · Asian 6%
Adults per alcohol outlet
279
Alcohol spend within 3 mi
$34,535,018 a year ($16,135,172 at home, $18,382,706 away) · $94,616 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-000146563 ↔ vtinfo b70d41de6d104008Claude judge: samemerged17
2026-11-19 20:37insertmi-lcc L-000146564 ↔ snap snap|us|798667same address and namemerged17
2026-11-19 20:37insertoverture ec9b9e39-8709-485a-b0fb-bf981ce8e7bf ↔ snap snap|us|798667same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000146563 ↔ snap snap|us|798667same address and namemerged17
2026-11-11 12:56insertab-inbev 2922210 ↔ vtinfo b70d41de6d104008same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000146563 ↔ overture ec9b9e39-8709-485a-b0fb-bf981ce8e7bfsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000146564 ↔ overture ec9b9e39-8709-485a-b0fb-bf981ce8e7bfsame address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000146563 ↔ mi-lcc L-000146564one store listed twicemerged