Joe Kool's

Troy, MI 48083 · O3d91b2055c02 · first seen 2026-10-08
6 sourceson premise · restaurantchain: Joe Kool's Troy Bar & Grillalcohol: licensed1 licence

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
Joe Kool's 5 other
a licence name in capitals, cleaned (derived; record_title.py)
JOE KOOLS ab-inbevvtinfo ×2
Joe Kool's Of Troy Bar and Grill overture
JOE KOOL'S OF TROY, LLC mi-lcc (legal name)
joe kool's troy doordash
JOE KOOLS OF TROY LLC inspections
Street
1835 E Big Beaver Rd 1 other
mi-lcc
1835 East Big Beaver Road doordash
City
Troy
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48083
mi-lccno other value
Pin
42.56443, -83.11151 map 4 other
doordash
83 m away ab-inbev
85 m away inspections
85 m away mi-lcc
77 m away vtinfo
Phone
2485265665
vtinfono other value
Licences
mi-lcc L-000269633
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of6a5b8d75a75; Od2bc0e633b34; Od6fac402b69a; Oc055b644578f; Ob8003bfabe5b

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-inbevJOE KOOLS
2763439
1835 E BIG BEAVER RD, TROY, MI, 4808342.56368, -83.111412026-11-112026-11-20
doordashjoe kool's troy
712403
1835 East Big Beaver Road, Troy, MI, 4808342.56443, -83.111512026-10-082026-11-20
inspectionsJOE KOOLS OF TROY LLC
inspections|mi|SFE-3963-210793
1835 E BIG BEAVER RD, Troy, MI, 4808342.56370, -83.111202026-11-202026-11-20
mi-lccJOE KOOL'S
legal name: JOE KOOL'S OF TROY, LLC
L-000269633
1835 E Big Beaver Rd, Troy, MI, 48083248526566542.56366, -83.111562026-11-032026-11-20
overtureJoe Kool's Of Troy Bar and Grill
7c58e01f-be97-4c09-a83c-51ff3f313c1d
1835 E Big Beaver Rd, Troy, MI, 48083248526566542.56441, -83.111502026-11-132026-11-20
vtinfoJOE KOOLS
8b6343cbdb856aa4
1835 E BIG BEAVER RD, TROY, MI, 48083248526566542.56502, -83.111032026-11-122026-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 JOE KOOLSdoordash joe kool's troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 83 m apart · name similarity 1.00
ab-inbev JOE KOOLSmi-lcc JOE KOOL'S1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev JOE KOOLSvtinfo JOE KOOLS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 152 m apart · name similarity 1.00
doordash joe kool's troyinspections JOE KOOLS OF TROY LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 85 m apart · name similarity 1.00
doordash joe kool's troymi-lcc JOE KOOL'S1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 85 m apart · name similarity 1.00
doordash joe kool's troyvtinfo JOE KOOLS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 77 m apart · name similarity 1.00
inspections JOE KOOLS OF TROY LLCmi-lcc JOE KOOL'S1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · matched through the licence's legal name: JOE KOOL'S OF TROY, LLC · name similarity 1.00
mi-lcc JOE KOOL'Svtinfo JOE KOOLS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 157 m apart · name similarity 1.00 · phone: equal
ab-inbev JOE KOOLSinspections JOE KOOLS OF TROY LLC0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 17 m apart · name similarity 0.72
inspections JOE KOOLS OF TROY LLCvtinfo JOE KOOLS0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 147 m apart · name similarity 0.72
doordash joe kool's troyoverture Joe Kool's Of Troy Bar and Grill0.67same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.74 · same street + ZIP · pins 1 m apart · name similarity 0.67
inspections JOE KOOLS OF TROY LLCoverture Joe Kool's Of Troy Bar and Grill0.67same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.74 · same street + ZIP · pins 83 m apart · name similarity 0.67

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
Joe Kool's Troy Bar & Grill — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
JOE KOOL'S OF TROY, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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|mi|SFE-3963-210793 ↔ overture 7c58e01f-be97-4c09-a83c-51ff3f313c1dsame address and namemerged17
2026-11-20 22:08insertab-inbev 2763439 ↔ inspections inspections|mi|SFE-3963-210793same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-210793 ↔ vtinfo 8b6343cbdb856aa4same address and namemerged17
2026-11-20 22:08insertdoordash 712403 ↔ inspections inspections|mi|SFE-3963-210793same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-3963-210793 ↔ mi-lcc L-000269633same address and namemerged17
2026-11-13 14:10insertdoordash 712403 ↔ overture 7c58e01f-be97-4c09-a83c-51ff3f313c1dsame address and namemerged15
2026-11-12 14:25insertdoordash 712403 ↔ vtinfo 8b6343cbdb856aa4same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000269633 ↔ vtinfo 8b6343cbdb856aa4same address and namemerged12
2026-11-12 14:25insertab-inbev 2763439 ↔ vtinfo 8b6343cbdb856aa4same address and namemerged12
2026-11-11 12:56insertab-inbev 2763439 ↔ doordash 712403same address and namemerged12
2026-11-11 12:56insertab-inbev 2763439 ↔ mi-lcc L-000269633same address and namemerged12
2026-11-09 01:04insertdoordash 712403 ↔ mi-lcc L-000269633same address and namemerged11