Hamlet Food Market

Northville, MI 48167 · O0cdb54feca26 · first seen 2026-11-03
4 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
Hamlet Food Market 2 other
a licence name in capitals, cleaned (derived; record_title.py)
HAMLET LIQUOR & WINE BASKET mi-lccoverture ×3
HAMLET INVESTMENTS, INC. mi-lcc (legal name) ×2
Street
1051 Novi Rd
mi-lccno other value
City
Northville
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48167
mi-lccno other value
Pin
42.44350, -83.47474 map 1 other
overture
76 m away ab-inbev
Phone
2483490255
vtinfono other value
Licences
mi-lcc L-000234093 · mi-lcc L-000234094
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obc65d2c18f9e; O63d553f18a48; Od95394025e01; Oee65ea79accf

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-inbevHAMLET FOOD MARKET
2525113
1051 NOVI RD, NORTHVILLE, MI, 4816742.44363, -83.473832026-11-112026-11-12
mi-lccHAMLET LIQUOR & WINE BASKET
legal name: HAMLET INVESTMENTS, INC.
L-000234093
1051 Novi Rd, Northville, MI, 4816724834902552026-11-032026-11-06
mi-lccHAMLET LIQUOR & WINE BASKET
legal name: HAMLET INVESTMENTS, INC.
L-000234094
1051 Novi Rd, Northville, MI, 4816724834902552026-11-032026-11-06
overtureHamlet Liquor & Wine Basket
ba0c47cc-7519-4b43-a3db-38121344f927
1051 Novi Rd, Northville, MI, 48167248349025542.44350, -83.474742026-11-062026-11-06
vtinfoHAMLET FOOD MARKET
47b1c46eaa7a0c1d
1051 NOVI RD, NORTHVILLE, MI, 48167248349025542.44371, -83.474552026-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 HAMLET FOOD MARKETvtinfo HAMLET FOOD MARKET1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 60 m apart · name similarity 1.00
mi-lcc HAMLET LIQUOR & WINE BASKETmi-lcc HAMLET LIQUOR & WINE BASKET1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc HAMLET LIQUOR & WINE BASKEToverture Hamlet Liquor & Wine Basket1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: equal
mi-lcc HAMLET LIQUOR & WINE BASKEToverture Hamlet Liquor & Wine Basket1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: equal
ab-inbev HAMLET FOOD MARKETmi-lcc HAMLET LIQUOR & WINE BASKET0.40Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (82% confident; asked as a “same-address” pair)
Hamlet name and same address; market and liquor one store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 82% confident — Both records sit at 1051 Novi Rd, Northville MI 48167, the only business at that address in the data, and both carry the distinctive Hamlet name (a food market and a liquor and wine basket run by Hamlet Investments, Inc.), so they most likely describe one store under two trade names.
pair 131dc8d4573359737429

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HAMLET INVESTMENTS, 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 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
41 within 1 mi · 291 within 3 mi
Off / on premise
9 / 19 within 1 mi · 60 / 174 within 3 mi
Selling alcohol
34 within 1 mi · 163 within 3 mi
Nearest
same channel 0.41 mi · licensed 0.14 mi
Setting
suburban (2,398 people per sq mi)
People within 3 mi
67,791 (51,187 adults 21+, 27,277 households) from 17 tract(s), tracts within 3 mi
Income
per capita $73,785 · median household ~$140,005 (weighted mean of tract medians)
Age and education
median age ~44.1 · bachelor's or higher 68%
Ethnicity
Hispanic 4% · White 66% · Black 5% · Asian 21%
Adults per alcohol outlet
312
Alcohol spend within 3 mi
$25,842,198 a year ($11,131,432 at home, $14,702,070 away) · $157,574 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:10insertab-inbev 2525113 ↔ vtinfo 47b1c46eaa7a0c1dsame address and namemerged15
2026-11-12 17:29insertab-inbev 2525113 ↔ mi-lcc L-000234093Claude judge: samemerged14
2026-11-06 18:13insertmi-lcc L-000234093 ↔ overture ba0c47cc-7519-4b43-a3db-38121344f927same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000234094 ↔ overture ba0c47cc-7519-4b43-a3db-38121344f927same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000234093 ↔ mi-lcc L-000234094one store listed twicemerged