Bayview Yacht Club

Detroit, MI 48215 · O5ab4364dfa3e · first seen 2026-11-03
5 sourceson premise · predictedalcohol: 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
Bayview Yacht Club
a source's own spelling of the licence name (record_title.py)no other value
Street
100 Clairpointe St 1 other
mi-lcc
100 CLAIRPOINTE ab-inbevvtinfo ×2
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48215
mi-lccno other value
Pin
42.35520, -82.95192 map 3 other
overture
475 m away mi-lcc ×2
1170 m away ab-inbev
92 m away vtinfo
Phone
3138221853
vtinfono other value
Licences
mi-lcc L-000000402 · mi-lcc L-000020058
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9fccdb69e0be; Ofde8c6df779b; Of781c4e52d70; O683836c0264e; O9004b6a7905e

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-inbevBAYVIEW YACHT CLUB
136588
100 CLAIRPOINTE, DETROIT, MI, 4821542.36481, -82.957712026-11-112026-11-11
inspectionsBayview Yacht Club
inspections|detroit|51623223
100 CLAIRPOINTE ST, Detroit, MI, 4821542.35518, -82.951902026-11-202026-11-20
mi-lccBAYVIEW YACHT CLUB
L-000000402
100 Clairpointe St, Detroit, MI, 48215313822185342.35941, -82.952892026-11-032026-11-05
mi-lccBAYVIEW YACHT CLUB
L-000020058
100 Clairpointe St, Detroit, MI, 48215313822185342.35941, -82.952892026-11-032026-11-05
overtureBayview Yacht Club
5dc0789a-4372-4e1c-a323-9fc965ed0272
100 Clairpointe St, Detroit, MI, 48215313822185342.35520, -82.951922026-11-062026-11-06
vtinfoBAYVIEW YACHT CLUB
c883e9e942c89a40
100 CLAIRPOINTE, DETROIT, MI, 48215313822185342.35597, -82.952322026-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 BAYVIEW YACHT CLUBmi-lcc BAYVIEW YACHT CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 719 m apart · name similarity 1.00 · street similarity 0.88
ab-inbev BAYVIEW YACHT CLUBmi-lcc BAYVIEW YACHT CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 719 m apart · name similarity 1.00 · street similarity 0.88
ab-inbev BAYVIEW YACHT CLUBvtinfo BAYVIEW YACHT CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1078 m apart · name similarity 1.00
inspections Bayview Yacht Clubmi-lcc BAYVIEW YACHT CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 477 m apart · name similarity 1.00
inspections Bayview Yacht Clubmi-lcc BAYVIEW YACHT CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 477 m apart · name similarity 1.00
inspections Bayview Yacht Cluboverture Bayview Yacht Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
inspections Bayview Yacht Clubvtinfo BAYVIEW YACHT CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 94 m apart · name similarity 1.00 · street similarity 0.88
mi-lcc BAYVIEW YACHT CLUBmi-lcc BAYVIEW YACHT CLUB1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc BAYVIEW YACHT CLUBoverture Bayview Yacht Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 475 m apart · name similarity 1.00 · phone: equal
mi-lcc BAYVIEW YACHT CLUBvtinfo BAYVIEW YACHT CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 385 m apart · name similarity 1.00 · street similarity 0.88
mi-lcc BAYVIEW YACHT CLUBoverture Bayview Yacht Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 475 m apart · name similarity 1.00 · phone: equal
mi-lcc BAYVIEW YACHT CLUBvtinfo BAYVIEW YACHT CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 385 m apart · name similarity 1.00 · street similarity 0.88
overture Bayview Yacht Clubvtinfo BAYVIEW YACHT CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 92 m apart · name similarity 1.00 · street similarity 0.88

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Non-Profit/Club; MI Retail - Off Premises/Specially Designated Merchant
Rule version 11, computed 2026-11-20 23:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
3 within 1 mi · 200 within 3 mi
Off / on premise
0 / 1 within 1 mi · 61 / 84 within 3 mi
Selling alcohol
2 within 1 mi · 126 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.82 mi
Setting
suburban (1,622 people per sq mi)
People within 3 mi
45,868 (34,426 adults 21+, 21,140 households) from 22 tract(s), tracts within 3 mi
Income
per capita $42,969 · median household ~$61,837 (weighted mean of tract medians)
Age and education
median age ~41.8 · bachelor's or higher 39%
Ethnicity
Hispanic 2% · White 33% · Black 60% · Asian 1%
Adults per alcohol outlet
271
Alcohol spend within 3 mi
$12,152,155 a year ($5,644,570 at home, $6,500,647 away) · $95,686 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-20 22:08insertinspections inspections|detroit|51623223 ↔ vtinfo c883e9e942c89a40street written two waysmerged17
2026-11-20 22:08insertinspections inspections|detroit|51623223 ↔ mi-lcc L-000020058same address and namemerged17
2026-11-20 22:08insertinspections inspections|detroit|51623223 ↔ mi-lcc L-000000402same address and namemerged17
2026-11-20 22:08insertinspections inspections|detroit|51623223 ↔ overture 5dc0789a-4372-4e1c-a323-9fc965ed0272same address and namemerged17
2026-11-11 12:56insertmi-lcc L-000020058 ↔ vtinfo c883e9e942c89a40street written two waysmerged12
2026-11-11 12:56insertoverture 5dc0789a-4372-4e1c-a323-9fc965ed0272 ↔ vtinfo c883e9e942c89a40street written two waysmerged12
2026-11-11 12:56insertmi-lcc L-000000402 ↔ vtinfo c883e9e942c89a40street written two waysmerged12
2026-11-11 12:56insertab-inbev 136588 ↔ mi-lcc L-000020058street written two waysmerged12
2026-11-11 12:56insertab-inbev 136588 ↔ mi-lcc L-000000402street written two waysmerged12
2026-11-11 12:56insertab-inbev 136588 ↔ vtinfo c883e9e942c89a40same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000000402 ↔ overture 5dc0789a-4372-4e1c-a323-9fc965ed0272same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000020058 ↔ overture 5dc0789a-4372-4e1c-a323-9fc965ed0272same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000000402 ↔ mi-lcc L-000020058one store listed twicemerged