THE LOCKVIEW RESTAURANT

Sault Sainte Marie, MI 49783 · O1cc80eb773e4 · first seen 2026-11-03
3 sourceson premise · restaurantalcohol: 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
THE LOCKVIEW RESTAURANT 2 other
the most common name a source states
FISH & SHIPS, LLC mi-lcc (legal name) ×2
LOCKVIEW RESTAURANT ab-inbevoverture ×2
Street
329 W Portage Ave
mi-lccno other value
City
Sault Sainte Marie 1 other
mi-lcc
Sault Ste Marie overture
State
MI
mi-lccno other value
ZIP
49783
mi-lccno other value
Pin
46.50134, -84.35040 map 1 other
overture
66 m away mi-lcc ×2
Phone
9066322772
overtureno other value
Licences
mi-lcc L-000416130 · mi-lcc L-000416131
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odeb57c3f24c8; O5b35a0c9e8d6; O51982277ac74

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-inbevLOCKVIEW RESTAURANT
3281281
329 W PORTAGE AVE, SAULT SAINTE MARIE, MI, 4978346.50131, -84.350192026-11-122026-11-12
mi-lccTHE LOCKVIEW RESTAURANT
legal name: FISH & SHIPS, LLC
L-000416130
329 W Portage Ave, Sault Sainte Marie, MI, 49783906632277246.50123, -84.349542026-11-032026-11-12
mi-lccTHE LOCKVIEW RESTAURANT
legal name: FISH & SHIPS, LLC
L-000416131
329 W Portage Ave, Sault Sainte Marie, MI, 49783906632277246.50123, -84.349542026-11-032026-11-12
overtureLockview Restaurant
7faf0826-b881-4e7c-aa77-012fa1374561
329 W Portage Ave, Sault Ste Marie, MI, 49783906632277246.50134, -84.350402026-11-062026-11-12

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 LOCKVIEW RESTAURANTmi-lcc THE LOCKVIEW RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev LOCKVIEW RESTAURANTmi-lcc THE LOCKVIEW RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev LOCKVIEW RESTAURANToverture Lockview Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
mi-lcc THE LOCKVIEW RESTAURANTmi-lcc THE LOCKVIEW RESTAURANT1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE LOCKVIEW RESTAURANToverture Lockview Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00 · phone: equal
mi-lcc THE LOCKVIEW RESTAURANToverture Lockview Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 66 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
FISH & SHIPS, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 7, computed 2026-11-16 17:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
41 within 1 mi · 112 within 3 mi
Off / on premise
9 / 13 within 1 mi · 32 / 40 within 3 mi
Selling alcohol
37 within 1 mi · 78 within 3 mi
Nearest
same channel 0.10 mi · licensed 0.06 mi
Setting
rural (472 people per sq mi)
People within 3 mi
13,335 (9,775 adults 21+, 5,860 households) from 4 tract(s), tracts within 3 mi
Income
per capita $29,676 · median household ~$53,268 (weighted mean of tract medians)
Age and education
median age ~34.8 · bachelor's or higher 27%
Ethnicity
Hispanic 2% · White 69% · Black 1% · Asian 1%
Adults per alcohol outlet
124
Alcohol spend within 3 mi
$2,754,754 a year ($1,367,342 at home, $1,386,336 away) · $34,870 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-12 14:25insertab-inbev 3281281 ↔ overture 7faf0826-b881-4e7c-aa77-012fa1374561same address and namemerged12
2026-11-12 14:25insertab-inbev 3281281 ↔ mi-lcc L-000416131same address and namemerged12
2026-11-12 14:25insertab-inbev 3281281 ↔ mi-lcc L-000416130same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000416131 ↔ overture 7faf0826-b881-4e7c-aa77-012fa1374561same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000416130 ↔ overture 7faf0826-b881-4e7c-aa77-012fa1374561same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000416130 ↔ mi-lcc L-000416131one store listed twicemerged