5th Avenue Liquor

Detroit, MI 48227 · O0367034860e4 · first seen 2026-11-03
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
5th Avenue Liquor 2 other
a licence name in capitals, cleaned (derived; record_title.py)
FIFTH AVENUE LIQUOR SPOT mi-lccoverturesnap ×4
HIBA ONE, INC. mi-lcc (legal name) ×2
Street
17734 Fenkell St 1 other
mi-lcc
17734 FENKELL ab-inbevvtinfo ×2
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48227
mi-lccno other value
Pin
42.40137, -83.21693 map 1 other
overture
53 m away ab-inbev
Phone
3138370040 1 other
vtinfo
3136515955 mi-lccoverture ×3
Licences
mi-lcc L-000259095 · mi-lcc L-000259096
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9f38a3d8fa26; O9c2209b75908; O705c75d28910; O5a5faf3af1c8; Od86933b09f84

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-inbev5TH AVENUE LIQUOR
2549296
17734 FENKELL, DETROIT, MI, 4822742.40147, -83.217562026-11-112026-11-12
mi-lccFIFTH AVENUE LIQUOR SPOT
legal name: HIBA ONE, INC.
L-000259095
17734 Fenkell St, Detroit, MI, 48227313651595542.40121, -83.216402026-11-032026-11-05
mi-lccFIFTH AVENUE LIQUOR SPOT
legal name: HIBA ONE, INC.
L-000259096
17734 Fenkell St, Detroit, MI, 48227313651595542.40121, -83.216402026-11-032026-11-05
overtureFifth Avenue Liquor Spot
11d9fe01-b3c8-4114-a286-8ee99877c106
17734 Fenkell St, Detroit, MI, 48227313651595542.40137, -83.216932026-11-062026-11-06
snapFifth Avenue Liquor Spot
snap|us|1477344
17734 Fenkell St, Detroit, MI, 4822742.40142, -83.217012026-11-192026-11-19
vtinfo5TH AVENUE LIQUOR
0b2c1f0135788501
17734 FENKELL, DETROIT, MI, 48227313837004042.40142, -83.217012026-11-122026-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 5TH AVENUE LIQUORvtinfo 5TH AVENUE LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 45 m apart · name similarity 1.00
mi-lcc FIFTH AVENUE LIQUOR SPOTmi-lcc FIFTH AVENUE LIQUOR SPOT1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc FIFTH AVENUE LIQUOR SPOToverture Fifth Avenue Liquor Spot1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00 · phone: equal
mi-lcc FIFTH AVENUE LIQUOR SPOTsnap Fifth Avenue Liquor Spot1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00
mi-lcc FIFTH AVENUE LIQUOR SPOToverture Fifth Avenue Liquor Spot1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00 · phone: equal
mi-lcc FIFTH AVENUE LIQUOR SPOTsnap Fifth Avenue Liquor Spot1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 55 m apart · name similarity 1.00
overture Fifth Avenue Liquor Spotsnap Fifth Avenue Liquor Spot1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ab-inbev 5TH AVENUE LIQUORmi-lcc FIFTH AVENUE LIQUOR SPOT0.52Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “near” pair)
Fifth Avenue Liquor at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 17734 Fenkell, Detroit 48227 with no other business at that address, and the names 5TH AVENUE LIQUOR and FIFTH AVENUE LIQUOR SPOT are the same trade name written two ways (5th = Fifth), with the Michigan licence entity HIBA ONE, INC. behind the second.
pair 39d1ee07f2776ecccc47
mi-lcc FIFTH AVENUE LIQUOR SPOTvtinfo 5TH AVENUE LIQUOR0.52Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Fifth/5th Avenue Liquor at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 17734 Fenkell in Detroit 48227 (about 56 m apart) with only one business at that address, and '5TH AVENUE LIQUOR' is a near-identical spelling of 'FIFTH AVENUE LIQUOR SPOT'; the differing phone numbers are the main counter-evidence.
pair 153c930108644a1370f7

Attributes

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

Trade area

Other outlets
59 within 1 mi · 491 within 3 mi
Off / on premise
19 / 29 within 1 mi · 175 / 218 within 3 mi
Selling alcohol
30 within 1 mi · 260 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.38 mi
Setting
urban (5,109 people per sq mi)
People within 3 mi
144,446 (102,667 adults 21+, 56,659 households) from 55 tract(s), tracts within 3 mi
Income
per capita $22,689 · median household ~$42,569 (weighted mean of tract medians)
Age and education
median age ~37.4 · bachelor's or higher 15%
Ethnicity
Hispanic 2% · White 3% · Black 92% · Asian 0%
Adults per alcohol outlet
393
Alcohol spend within 3 mi
$23,741,475 a year ($11,913,320 at home, $11,813,677 away) · $90,964 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-000259096 ↔ vtinfo 0b2c1f0135788501Claude judge: samemerged17
2026-11-19 20:37insertoverture 11d9fe01-b3c8-4114-a286-8ee99877c106 ↔ snap snap|us|1477344same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000259095 ↔ snap snap|us|1477344same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000259096 ↔ snap snap|us|1477344same address and namemerged17
2026-11-12 17:29insertab-inbev 2549296 ↔ mi-lcc L-000259095Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2549296 ↔ vtinfo 0b2c1f0135788501same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000259095 ↔ overture 11d9fe01-b3c8-4114-a286-8ee99877c106same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000259096 ↔ overture 11d9fe01-b3c8-4114-a286-8ee99877c106same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000259095 ↔ mi-lcc L-000259096one store listed twicemerged