Saint Joseph River Yacht Club

Saint Joseph, MI 49085 · O02dc75cfce13 · 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
Saint Joseph River Yacht Club 1 other
a licence name in capitals, cleaned (derived; record_title.py)
ST JOSEPH RIVER YACHT CLUB inspectionsmi-lccoverture ×4
Street
1 Lighthouse Ln 1 other
mi-lcc
1 LIGHTHOUSE LA ab-inbevvtinfo ×2
City
Saint Joseph 1 other
mi-lcc
St Joseph overture
State
MI
mi-lccno other value
ZIP
49085
mi-lccno other value
Pin
42.11395, -86.48465 map 1 other
overture
559 m away inspections
Phone
2699836393
vtinfono other value
Licences
mi-lcc L-000004188 · mi-lcc L-000020699
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obc26d7d6ff4e; Oe2b9605295ff; O48d5de104d5f; O78ebf8b54755; Od546debc8805; O1c0841ed221f

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-inbevSAINT JOSEPH RIVER YACHT CLUB
138716
1 LIGHTHOUSE LA, SAINT JOSEPH, MI, 4908542.11428, -86.484812026-11-112026-11-20
inspectionsST JOSEPH RIVER YACHT CLUB
inspections|mi|SFE-1111-040632
1 LIGHTHOUSE LN, Saint Joseph, MI, 4908542.11613, -86.478542026-11-202026-11-20
mi-lccST. JOSEPH RIVER YACHT CLUB
L-000004188
1 Lighthouse Ln, Saint Joseph, MI, 4908526998363932026-11-032026-11-20
mi-lccST. JOSEPH RIVER YACHT CLUB
L-000020699
1 Lighthouse Ln, Saint Joseph, MI, 4908526998363932026-11-032026-11-20
overtureSt Joseph River Yacht Club
e6a53d96-4be4-4790-917b-b6d685c21de2
1 Lighthouse ln, St Joseph, MI, 49085269983639342.11395, -86.484652026-11-062026-11-20
vtinfoSAINT JOSEPH RIVER YACHT CLUB
edad67d53c544e2f
1 LIGHTHOUSE LA, SAINT JOSEPH, MI, 49085269983639342.11412, -86.484632026-11-182026-11-20

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 SAINT JOSEPH RIVER YACHT CLUBvtinfo SAINT JOSEPH RIVER YACHT CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
inspections ST JOSEPH RIVER YACHT CLUBmi-lcc ST. JOSEPH RIVER YACHT CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections ST JOSEPH RIVER YACHT CLUBmi-lcc ST. JOSEPH RIVER YACHT CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections ST JOSEPH RIVER YACHT CLUBoverture St Joseph River Yacht Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 559 m apart · name similarity 1.00
mi-lcc ST. JOSEPH RIVER YACHT CLUBmi-lcc ST. JOSEPH RIVER YACHT CLUB1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc ST. JOSEPH RIVER YACHT CLUBoverture 1d9c06f0-4173-43be-8ade-640d080739b01.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: equal
mi-lcc ST. JOSEPH RIVER YACHT CLUBoverture St Joseph River Yacht Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: equal
mi-lcc ST. JOSEPH RIVER YACHT CLUBoverture 1d9c06f0-4173-43be-8ade-640d080739b01.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: equal
mi-lcc ST. JOSEPH RIVER YACHT CLUBoverture St Joseph River Yacht Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: equal
ab-inbev SAINT JOSEPH RIVER YACHT CLUBinspections ST JOSEPH RIVER YACHT CLUB0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · pins 557 m apart · name similarity 0.81 · street similarity 0.92
ab-inbev SAINT JOSEPH RIVER YACHT CLUBmi-lcc ST. JOSEPH RIVER YACHT CLUB0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · name similarity 0.81 · street similarity 0.92
ab-inbev SAINT JOSEPH RIVER YACHT CLUBmi-lcc ST. JOSEPH RIVER YACHT CLUB0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · name similarity 0.81 · street similarity 0.92
ab-inbev SAINT JOSEPH RIVER YACHT CLUBoverture St Joseph River Yacht Club0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · pins 39 m apart · name similarity 0.81 · street similarity 0.92
inspections ST JOSEPH RIVER YACHT CLUBvtinfo SAINT JOSEPH RIVER YACHT CLUB0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · pins 550 m apart · name similarity 0.81 · street similarity 0.92
mi-lcc ST. JOSEPH RIVER YACHT CLUBvtinfo SAINT JOSEPH RIVER YACHT CLUB0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on city · name similarity 0.81 · street similarity 0.92
mi-lcc ST. JOSEPH RIVER YACHT CLUBvtinfo SAINT JOSEPH RIVER YACHT CLUB0.81street written two waysmergedname Jaro-Winkler 0.96 · matched on city · name similarity 0.81 · street similarity 0.92

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:31.
Every vote behind these (raw)
{
 "votes": []
}

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:08insertab-inbev 138716 ↔ inspections inspections|mi|SFE-1111-040632street written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1111-040632 ↔ vtinfo edad67d53c544e2fstreet written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1111-040632 ↔ overture e6a53d96-4be4-4790-917b-b6d685c21de2same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1111-040632 ↔ mi-lcc L-000004188same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-1111-040632 ↔ mi-lcc L-000020699same address and namemerged17
2026-11-18 18:58insertmi-lcc L-000004188 ↔ vtinfo edad67d53c544e2fstreet written two waysmerged15
2026-11-18 18:58insertmi-lcc L-000020699 ↔ vtinfo edad67d53c544e2fstreet written two waysmerged15
2026-11-18 18:58insertab-inbev 138716 ↔ vtinfo edad67d53c544e2fsame address and namemerged15
2026-11-11 12:56insertab-inbev 138716 ↔ mi-lcc L-000020699street written two waysmerged12
2026-11-11 12:56insertab-inbev 138716 ↔ overture e6a53d96-4be4-4790-917b-b6d685c21de2street written two waysmerged12
2026-11-11 12:56insertab-inbev 138716 ↔ mi-lcc L-000004188street written two waysmerged12
2026-11-09 15:32updatemi-lcc L-000004188 ↔ overture e6a53d96-4be4-4790-917b-b6d685c21de2same address and namemerged11
2026-11-09 15:32updatemi-lcc L-000020699 ↔ overture e6a53d96-4be4-4790-917b-b6d685c21de2same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000004188 ↔ overture e6a53d96-4be4-4790-917b-b6d685c21de2same address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000004188 ↔ overture 1d9c06f0-4173-43be-8ade-640d080739b0same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000020699 ↔ overture e6a53d96-4be4-4790-917b-b6d685c21de2same address and nameheld: same-source-conflict11
2026-11-06 18:13insertmi-lcc L-000020699 ↔ overture 1d9c06f0-4173-43be-8ade-640d080739b0same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000004188 ↔ mi-lcc L-000020699one store listed twicemerged