Joe Kool's

Troy, MI 48083 · Ob8003bfabe5b · first seen 2026-10-08
5 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 4 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
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 3 other
doordash
83 m away ab-inbev
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

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-11
doordashjoe kool's troy
712403
1835 East Big Beaver Road, Troy, MI, 4808342.56443, -83.111512026-10-082026-11-09
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-09
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-13
vtinfoJOE KOOLS
8b6343cbdb856aa4
1835 E BIG BEAVER RD, TROY, MI, 48083248526566542.56502, -83.111032026-11-122026-11-14

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 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
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
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

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 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
61 within 1 mi · 608 within 3 mi
Off / on premise
13 / 40 within 1 mi · 149 / 362 within 3 mi
Selling alcohol
24 within 1 mi · 284 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.05 mi
Setting
urban (3,320 people per sq mi)
People within 3 mi
93,868 (73,318 adults 21+, 37,282 households) from 24 tract(s), tracts within 3 mi
Income
per capita $43,863 · median household ~$90,297 (weighted mean of tract medians)
Age and education
median age ~40.5 · bachelor's or higher 45%
Ethnicity
Hispanic 3% · White 69% · Black 6% · Asian 17%
Adults per alcohol outlet
257
Alcohol spend within 3 mi
$26,327,170 a year ($11,988,559 at home, $14,326,271 away) · $92,376 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-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