Long Lake Grocery

Traverse City, MI 49685 · O70136e56d070 · first seen 2026-11-03
4 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
Long Lake Grocery 2 other
a source's own spelling of the licence name (record_title.py)
LONG LAKE GROCERY IND. mi-lcc ×2
MAFNF, LLC mi-lcc (legal name) ×2
Street
9352 N Long Lake Rd 1 other
mi-lcc
9374 N LONG LAKE RD ab-inbevoverturevtinfo ×3
City
Traverse City
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49685
mi-lccno other value
Pin
44.74783, -85.76363 map 2 other
overture
57 m away mi-lcc ×2
76 m away vtinfo
Phone
2319464249
vtinfono other value
Licences
mi-lcc L-000188057 · mi-lcc L-000488026
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O91f69b974f2f; O75ee2de745e3; Oda7582e663c6; Oc9590d1eb8d8; O88e888313949

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-inbevLONG LAKE GROCERY
2545754
9374 N LONG LAKE RD, TRAVERSE CITY, MI, 4968544.74767, -85.763432026-11-112026-11-12
mi-lccLONG LAKE GROCERY IND.
legal name: MAFNF, LLC
L-000188057
9352 N Long Lake Rd, Traverse City, MI, 49685231946424944.74780, -85.762912026-11-032026-11-05
mi-lccLONG LAKE GROCERY IND.
legal name: MAFNF, LLC
L-000488026
9352 N Long Lake Rd, Traverse City, MI, 49685231946424944.74780, -85.762912026-11-032026-11-05
overtureLong Lake Grocery
3be5f474-357b-4343-9b7f-2d6111b1c294
9374 N Long Lake Rd, Traverse City, MI, 49685231946424944.74783, -85.763632026-11-132026-11-13
vtinfoLONG LAKE GROCERY
bf61ca9fb0b44739
9352 N LONG LAKE RD, TRAVERSE CITY, MI, 49685231946424944.74850, -85.763762026-11-162026-11-19
vtinfoLONG LAKE GROCERY
f988191c66854fce
9374 N LONG LAKE RD, TRAVERSE CITY, MI, 49685231946424944.74796, -85.763592026-11-162026-11-17

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 LONG LAKE GROCERYoverture Long Lake Grocery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ab-inbev LONG LAKE GROCERYvtinfo LONG LAKE GROCERY1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “proximity” pair)
Distinctive name, nearby street numbers, same road
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 70% confident — Both records carry the identical name LONG LAKE GROCERY in the same city and ZIP, with coordinates about 96 m apart and no other business counted at the address; the street numbers differ (9374 vs 9352), which is a modest discrepancy on the same road.
pair 25a2cc977a9a36823fad
ab-inbev LONG LAKE GROCERYvtinfo LONG LAKE GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 m apart · name similarity 1.00
mi-lcc LONG LAKE GROCERY IND.mi-lcc LONG LAKE GROCERY IND.1.00one store listed twicemergedsame street + ZIP · name: identical
overture Long Lake Groceryvtinfo LONG LAKE GROCERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00 · phone: equal
ab-inbev LONG LAKE GROCERYmi-lcc LONG LAKE GROCERY IND.0.82Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (82% confident; asked as a “proximity” pair)
Same distinctive name, adjacent numbers, 44 m apart.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are named Long Lake Grocery on N Long Lake Rd in the same ZIP 49685, about 44 m apart, with no other business at the address; the house numbers differ (9374 vs 9352) and the Michigan record adds 'IND.' and a legal entity, which is plausibly one store.
pair 20367c30a33457fa481b
ab-inbev LONG LAKE GROCERYmi-lcc LONG LAKE GROCERY IND.0.82Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same distinctive name, nearby numbers, 44m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records carry the same name, Long Lake Grocery, on N Long Lake Rd in Traverse City, ZIP 49685, with coordinates about 44 m apart and only one business at that address in the data. The house numbers differ (9374 vs 9352), which keeps this from being certain.
pair 08f6603c91a744019c7d
mi-lcc LONG LAKE GROCERY IND.vtinfo LONG LAKE GROCERY0.82same address and namemerged both outlets held a record of one source, each naming the same businessaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 103 m apart · name similarity 0.82 · phone: equal
mi-lcc LONG LAKE GROCERY IND.vtinfo LONG LAKE GROCERY0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 103 m apart · name similarity 0.82 · phone: equal

Attributes

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

Trade area

Other outlets
1 within 1 mi · 16 within 3 mi
Off / on premise
0 / 0 within 1 mi · 3 / 4 within 3 mi
Selling alcohol
1 within 1 mi · 15 within 3 mi
Nearest
same channel 1.27 mi · licensed 1.27 mi
Setting
rural (147 people per sq mi)
People within 3 mi
4,143 (3,312 adults 21+, 1,599 households) from 1 tract(s), tracts within 3 mi
Income
per capita $52,054 · median household ~$116,935 (weighted mean of tract medians)
Age and education
median age ~50.0 · bachelor's or higher 55%
Ethnicity
Hispanic 1% · White 95% · Black 0% · Asian 1%
Adults per alcohol outlet
207
Alcohol spend within 3 mi
$1,350,597 a year ($597,704 at home, $752,238 away) · $84,412 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:37insertab-inbev 2545754 ↔ vtinfo bf61ca9fb0b44739Claude judge: samemerged17
2026-11-19 20:37updatemi-lcc L-000488026 ↔ vtinfo bf61ca9fb0b44739same address and namemerged17
2026-11-19 20:37updatemi-lcc L-000188057 ↔ vtinfo bf61ca9fb0b44739same address and namemerged17
2026-11-17 17:19updatemi-lcc L-000488026 ↔ vtinfo bf61ca9fb0b44739same address and nameheld: same-source-conflict15
2026-11-17 17:19updatemi-lcc L-000188057 ↔ vtinfo bf61ca9fb0b44739same address and nameheld: same-source-conflict15
2026-11-16 14:56insertmi-lcc L-000488026 ↔ vtinfo bf61ca9fb0b44739same address and nameheld: same-source-conflict15
2026-11-16 14:56insertmi-lcc L-000188057 ↔ vtinfo bf61ca9fb0b44739same address and nameheld: same-source-conflict15
2026-11-16 14:56insertoverture 3be5f474-357b-4343-9b7f-2d6111b1c294 ↔ vtinfo f988191c66854fcesame address and namemerged15
2026-11-16 14:56insertab-inbev 2545754 ↔ vtinfo f988191c66854fcesame address and namemerged15
2026-11-13 14:10insertab-inbev 2545754 ↔ overture 3be5f474-357b-4343-9b7f-2d6111b1c294same address and namemerged15
2026-11-12 17:29insertab-inbev 2545754 ↔ mi-lcc L-000188057Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2545754 ↔ mi-lcc L-000488026Claude judge: samemerged14
2026-11-03 13:33backfillmi-lcc L-000188057 ↔ mi-lcc L-000488026one store listed twicemerged