Williams Street Tap

CRYSTAL LAKE, IL 60014 · O164add37e571 · first seen 2026-11-13
3 sourceson premise · baralcohol: alcohol

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
Williams Street Tap
a source's own spelling of the licence name (record_title.py)no other value
Street
80 N WILLIAMS ST
ab-inbevno other value
City
CRYSTAL LAKE
ab-inbevno other value
State
IL
ab-inbevno other value
ZIP
60014
ab-inbevno other value
Pin
42.24319, -88.31728 map
overtureno other value
Phone
8154597408
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4dabc43f68f0; O622011c00535

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-inbevWILLIAMS STREET TAP
60134
80 N WILLIAMS ST, CRYSTAL LAKE, IL, 6001442.24297, -88.317472026-11-132026-11-13
overtureWilliams Street Tap
ca0ddde0-f5fc-4cb0-9edc-e3e91310adcc
80 N Williams St, Crystal Lake, IL, 60014815459740842.24319, -88.317282026-11-132026-11-13
vtinfoWILLIAMS STREET TAP
2c0641008ae27a57
80 N WILLIAMS ST, CRYSTAL LAKE, IL, 60014815459740842.24327, -88.317382026-11-172026-11-18

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 WILLIAMS STREET TAPoverture Williams Street Tap1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
ab-inbev WILLIAMS STREET TAPvtinfo WILLIAMS STREET TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
overture Williams Street Tapvtinfo WILLIAMS STREET TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
alcohol — channel bar
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
34 within 1 mi · 206 within 3 mi
Off / on premise
5 / 21 within 1 mi · 61 / 112 within 3 mi
Selling alcohol
19 within 1 mi · 100 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.51 mi
Setting
suburban (1,486 people per sq mi)
People within 3 mi
42,016 (30,393 adults 21+, 15,572 households) from 9 tract(s), tracts within 3 mi
Income
per capita $44,075 · median household ~$100,032 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 40%
Ethnicity
Hispanic 16% · White 79% · Black 1% · Asian 3%
Adults per alcohol outlet
301
Alcohol spend within 3 mi
$11,774,069 a year ($5,309,076 at home, $6,459,558 away) · $116,575 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-17 17:19insertab-inbev 60134 ↔ vtinfo 2c0641008ae27a57same address and namemerged15
2026-11-17 17:19insertoverture ca0ddde0-f5fc-4cb0-9edc-e3e91310adcc ↔ vtinfo 2c0641008ae27a57same address and namemerged15
2026-11-13 14:10insertab-inbev 60134 ↔ overture ca0ddde0-f5fc-4cb0-9edc-e3e91310adccsame address and namemerged15