Lake Roots Cafe

Crystal Lake, IL 60014 · O2c9ad375abcd · first seen 2026-11-06
4 sourceson premise · restaurantalcohol: 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
Lake Roots Cafe 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Lake Roots overturetoast (legal name) ×2
Lake Roots 475 West Virginia Street toast
Street
475 West Virginia Street 1 other
toast
475 W VIRGINIA ST ab-inbevoverturevtinfo ×3
City
Crystal Lake
toastno other value
State
IL
toastno other value
ZIP
60014
toastno other value
Pin
42.23588, -88.33889 map
toastno other value
Phone
7799944170 1 other
vtinfo
8158936240 overturetoast ×2
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob6a010cb99fc; Od7fc3da9ec9a; O8cb932d82f31

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-inbevLAKE ROOTS CAFE
4895115
475 W VIRGINIA ST, CRYSTAL LAKE, IL, 6001442.23608, -88.339062026-11-132026-11-17
overtureLake Roots
08a83fa8-c9eb-4485-b333-f1a71ff5cc64
475 W Virginia St, Crystal Lake, IL, 60014815893624042.23584, -88.338972026-11-132026-11-17
toastLake Roots 475 West Virginia Street
legal name: Lake Roots
3477ef2e-ca38-4b67-a8d3-b0ad50fce024
475 West Virginia Street, Crystal Lake, IL, 60014815893624042.23588, -88.338892026-11-062026-11-17
vtinfoLAKE ROOTS CAFE
d9a9c9db8135fbac
475 W VIRGINIA ST, CRYSTAL LAKE, IL, 60014779994417042.23586, -88.338852026-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 LAKE ROOTS CAFEvtinfo LAKE ROOTS CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 29 m apart · name similarity 1.00
overture Lake Rootstoast Lake Roots 475 West Virginia Street1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · matched through the licence's legal name: Lake Roots · name similarity 1.00 · phone: equal
ab-inbev LAKE ROOTS CAFEoverture Lake Roots0.73same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.81 · same street + ZIP · pins 28 m apart · name similarity 0.73
overture Lake Rootsvtinfo LAKE ROOTS CAFE0.73same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: cafe · name Jaro-Winkler 0.81 · same street + city + state · pins 10 m apart · name similarity 0.73 · phone: differs

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Michelob Ultra (AB InBev), Proximo Spirits (Jose Cuervo) +3 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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:19insertoverture 08a83fa8-c9eb-4485-b333-f1a71ff5cc64 ↔ vtinfo d9a9c9db8135fbacsame address and namemerged15
2026-11-17 17:19insertab-inbev 4895115 ↔ vtinfo d9a9c9db8135fbacsame address and namemerged15
2026-11-13 14:10insertab-inbev 4895115 ↔ overture 08a83fa8-c9eb-4485-b333-f1a71ff5cc64same address and namemerged15
2026-11-13 14:10insertoverture 08a83fa8-c9eb-4485-b333-f1a71ff5cc64 ↔ toast 3477ef2e-ca38-4b67-a8d3-b0ad50fce024same address and namemerged15