Walnut Creek Country Club

South Lyon, MI 48178 · O18778f1d1fbf · 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
Walnut Creek Country Club 1 other
a source's own spelling of the licence name (record_title.py)
WALNUT CREEK COUNTRY CLUB MAIN inspections
Street
25501 Johns Rd 1 other
mi-lcc
25501 JOHNS ab-inbevvtinfo ×2
City
South Lyon
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48178
mi-lccno other value
Pin
42.47377, -83.56804 map 4 other
overture
323 m away mi-lcc ×2
335 m away ab-inbev
345 m away inspections
103 m away vtinfo
Phone
2484377337
vtinfono other value
Licences
mi-lcc L-000020723 · mi-lcc L-000117518
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O79f7533af6bf; O78a32c1cf845; Oef695db340c0; O29a5a2d157d7; O34ffe80154e4

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-inbevWALNUT CREEK COUNTRY CLUB
139380
25501 JOHNS, SOUTH LYON, MI, 4817842.47302, -83.564082026-11-112026-11-13
inspectionsWALNUT CREEK COUNTRY CLUB MAIN
inspections|mi|SFE-4063-023156
25501 JOHNS RD, South Lyon, MI, 4817842.47329, -83.563882026-11-202026-11-20
mi-lccWALNUT CREEK COUNTRY CLUB
L-000020723
25501 Johns Rd, South Lyon, MI, 48178248437733742.47397, -83.564122026-11-032026-11-13
mi-lccWALNUT CREEK COUNTRY CLUB
L-000117518
25501 Johns Rd, South Lyon, MI, 48178248437733742.47397, -83.564122026-11-032026-11-13
overtureWalnut Creek Country Club
73589b93-58e9-4174-aeed-a0c20c2381c9
25501 Johns Rd, South Lyon, MI, 48178248437733742.47377, -83.568042026-11-062026-11-13
vtinfoWALNUT CREEK COUNTRY CLUB
d6c293200e05fc65
25501 JOHNS, SOUTH LYON, MI, 48178248437733742.47364, -83.566792026-11-132026-11-19

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 WALNUT CREEK COUNTRY CLUBmi-lcc WALNUT CREEK COUNTRY CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 106 m apart · name similarity 1.00 · street similarity 0.77
ab-inbev WALNUT CREEK COUNTRY CLUBmi-lcc WALNUT CREEK COUNTRY CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 106 m apart · name similarity 1.00 · street similarity 0.77
ab-inbev WALNUT CREEK COUNTRY CLUBoverture Walnut Creek Country Club1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 335 m apart · name similarity 1.00 · street similarity 0.77
ab-inbev WALNUT CREEK COUNTRY CLUBvtinfo WALNUT CREEK COUNTRY CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 233 m apart · name similarity 1.00
mi-lcc WALNUT CREEK COUNTRY CLUBmi-lcc WALNUT CREEK COUNTRY CLUB1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc WALNUT CREEK COUNTRY CLUBoverture Walnut Creek Country Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 323 m apart · name similarity 1.00 · phone: equal
mi-lcc WALNUT CREEK COUNTRY CLUBvtinfo WALNUT CREEK COUNTRY CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 223 m apart · name similarity 1.00 · street similarity 0.77
mi-lcc WALNUT CREEK COUNTRY CLUBoverture Walnut Creek Country Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 323 m apart · name similarity 1.00 · phone: equal
mi-lcc WALNUT CREEK COUNTRY CLUBvtinfo WALNUT CREEK COUNTRY CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 223 m apart · name similarity 1.00 · street similarity 0.77
overture Walnut Creek Country Clubvtinfo WALNUT CREEK COUNTRY CLUB1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 103 m apart · name similarity 1.00 · street similarity 0.77
inspections WALNUT CREEK COUNTRY CLUB MAINmi-lcc WALNUT CREEK COUNTRY CLUB0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 78 m apart · name similarity 0.85
inspections WALNUT CREEK COUNTRY CLUB MAINmi-lcc WALNUT CREEK COUNTRY CLUB0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 78 m apart · name similarity 0.85
inspections WALNUT CREEK COUNTRY CLUB MAINoverture Walnut Creek Country Club0.85same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 345 m apart · name similarity 0.85
ab-inbev WALNUT CREEK COUNTRY CLUBinspections WALNUT CREEK COUNTRY CLUB MAIN0.85street written two waysmergedname Jaro-Winkler 0.95 · matched on zip · pins 34 m apart · name similarity 0.85 · street similarity 0.77
inspections WALNUT CREEK COUNTRY CLUB MAINvtinfo WALNUT CREEK COUNTRY CLUB0.85street written two waysmergedname Jaro-Winkler 0.95 · matched on zip · pins 242 m apart · name similarity 0.85 · street similarity 0.77

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

Trade area

Other outlets
3 within 1 mi · 78 within 3 mi
Off / on premise
1 / 1 within 1 mi · 23 / 43 within 3 mi
Selling alcohol
2 within 1 mi · 38 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.86 mi
Setting
suburban (760 people per sq mi)
People within 3 mi
21,494 (15,273 adults 21+, 7,616 households) from 4 tract(s), tracts within 3 mi
Income
per capita $67,874 · median household ~$158,091 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 61%
Ethnicity
Hispanic 4% · White 65% · Black 6% · Asian 22%
Adults per alcohol outlet
392
Alcohol spend within 3 mi
$7,558,199 a year ($3,230,700 at home, $4,325,467 away) · $193,800 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:08insertab-inbev 139380 ↔ inspections inspections|mi|SFE-4063-023156street written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023156 ↔ vtinfo d6c293200e05fc65street written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023156 ↔ mi-lcc L-000117518same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023156 ↔ mi-lcc L-000020723same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023156 ↔ overture 73589b93-58e9-4174-aeed-a0c20c2381c9same address and namemerged17
2026-11-13 14:10insertmi-lcc L-000117518 ↔ vtinfo d6c293200e05fc65street written two waysmerged15
2026-11-13 14:10insertoverture 73589b93-58e9-4174-aeed-a0c20c2381c9 ↔ vtinfo d6c293200e05fc65street written two waysmerged15
2026-11-13 14:10insertmi-lcc L-000020723 ↔ vtinfo d6c293200e05fc65street written two waysmerged15
2026-11-13 14:10insertab-inbev 139380 ↔ vtinfo d6c293200e05fc65same address and namemerged15
2026-11-11 12:56insertab-inbev 139380 ↔ mi-lcc L-000117518street written two waysmerged12
2026-11-11 12:56insertab-inbev 139380 ↔ overture 73589b93-58e9-4174-aeed-a0c20c2381c9street written two waysmerged12
2026-11-11 12:56insertab-inbev 139380 ↔ mi-lcc L-000020723street written two waysmerged12
2026-11-06 18:13insertmi-lcc L-000020723 ↔ overture 73589b93-58e9-4174-aeed-a0c20c2381c9same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000117518 ↔ overture 73589b93-58e9-4174-aeed-a0c20c2381c9same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000020723 ↔ mi-lcc L-000117518one store listed twicemerged