Dirty Dog Cafe

Grosse Pointe Farms, MI 48236 · O2dc302207a06 · first seen 2026-11-03
4 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
Dirty Dog Cafe 2 other
a licence name in capitals, cleaned (derived; record_title.py)
DIRTY DOG JAZZ CAFE ab-inbevinspectionsoverture ×3
DIRTY DOG JAZZ CAFE, L.L.C. mi-lcc (legal name) ×2
Street
93-97 Kercheval Ave 1 other
mi-lcc
97 KERCHEVAL AVE ab-inbevinspectionsoverture ×3
City
Grosse Pointe Farms 1 other
mi-lcc
GROSSE POINTE ab-inbev
State
MI
mi-lccno other value
ZIP
48236
mi-lccno other value
Pin
42.39547, -82.90330 map
overtureno other value
Phone
3138825299 1 other
overture
5865528777 mi-lcc ×2
Licences
mi-lcc L-000166074 · mi-lcc L-000233558
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O5a88909b31c7; O473bfb4bf0e0; Ofb9941a7c7c6; O84f1ada996a4

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-inbevDIRTY DOG JAZZ CAFE
2905446
97 KERCHEVAL AVE, GROSSE POINTE, MI, 4823642.39534, -82.903002026-11-112026-11-11
inspectionsDIRTY DOG JAZZ CAFE
inspections|mi|SFE-4882-060857
97 KERCHEVAL AVE, Grosse Pointe Farms, MI, 4823642.39540, -82.903002026-11-202026-11-20
mi-lccDIRTY DOG CAFE
legal name: DIRTY DOG JAZZ CAFE, L.L.C.
L-000166074
93-97 Kercheval Ave, Grosse Pointe Farms, MI, 48236586552877742.39544, -82.902872026-11-032026-11-12
mi-lccDIRTY DOG CAFE
legal name: DIRTY DOG JAZZ CAFE, L.L.C.
L-000233558
93-97 Kercheval Ave, Grosse Pointe Farms, MI, 48236586552877742.39544, -82.902872026-11-032026-11-12
overtureDirty Dog Jazz Cafe
49600534-831d-4ac8-8076-8f95a7986828
97 Kercheval Ave, Grosse Pointe Farms, MI, 48236313882529942.39547, -82.903302026-11-132026-11-13

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 DIRTY DOG JAZZ CAFEinspections DIRTY DOG JAZZ CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ab-inbev DIRTY DOG JAZZ CAFEoverture Dirty Dog Jazz Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00
inspections DIRTY DOG JAZZ CAFEoverture Dirty Dog Jazz Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
mi-lcc DIRTY DOG CAFEmi-lcc DIRTY DOG CAFE1.00one store listed twicemergedsame street + ZIP · name: identical
ab-inbev DIRTY DOG JAZZ CAFEmi-lcc DIRTY DOG CAFE0.80Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Dirty Dog Jazz Cafe same address range and legal name.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are at Kercheval Ave in Grosse Pointe (97 vs 93-97 with matching ZIP 48236, about 16 m apart), and the Michigan record's legal name 'DIRTY DOG JAZZ CAFE, L.L.C.' matches the AB InBev venue name 'DIRTY DOG JAZZ CAFE', with no other business at that address in the data.
pair 07c0689467e09b271977

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DIRTY DOG JAZZ CAFE, L.L.C. — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
54 within 1 mi · 264 within 3 mi
Off / on premise
11 / 30 within 1 mi · 70 / 137 within 3 mi
Selling alcohol
30 within 1 mi · 158 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
urban (3,004 people per sq mi)
People within 3 mi
84,946 (60,363 adults 21+, 32,321 households) from 27 tract(s), tracts within 3 mi
Income
per capita $50,050 · median household ~$95,922 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 45%
Ethnicity
Hispanic 2% · White 46% · Black 47% · Asian 1%
Adults per alcohol outlet
380
Alcohol spend within 3 mi
$23,396,464 a year ($10,500,701 at home, $12,885,953 away) · $147,148 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 2905446 ↔ inspections inspections|mi|SFE-4882-060857same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4882-060857 ↔ overture 49600534-831d-4ac8-8076-8f95a7986828same address and namemerged17
2026-11-13 14:10insertab-inbev 2905446 ↔ overture 49600534-831d-4ac8-8076-8f95a7986828same address and namemerged15
2026-11-12 17:29insertab-inbev 2905446 ↔ mi-lcc L-000166074Claude judge: samemerged14
2026-11-03 13:33backfillmi-lcc L-000166074 ↔ mi-lcc L-000233558one store listed twicemerged