The Rocks Bar & Grill

Detroit, MI 48210 · O5a4f50ebf0fc · first seen 2026-11-03
4 sourceson premise · restaurantalcohol: 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
The Rocks Bar & Grill 2 other
a source's own spelling of the licence name (record_title.py)
THE ROCKS BAR AND GRILL ab-inbevvtinfo ×2
THE ROCKS BAR AND GRILL, LLC mi-lcc ×2
Street
3511 Clippert St
mi-lccno other value
City
Detroit
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48210
mi-lccno other value
Pin
42.32589, -83.12165 map
overtureno other value
Phone
9567849124
vtinfono other value
Licences
mi-lcc L-000439342 · mi-lcc L-000439343
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocb05e210a1b6; Oa7fec842c069; Oeb8c0381af1b; O9d4239b0555c

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-inbevTHE ROCKS BAR AND GRILL
4489768
3511 CLIPPERT ST, DETROIT, MI, 4821042.32567, -83.121452026-11-112026-11-12
mi-lccTHE ROCKS BAR AND GRILL, LLC
L-000439342
3511 Clippert St, Detroit, MI, 48210956784912442.32601, -83.121652026-11-032026-11-12
mi-lccTHE ROCKS BAR AND GRILL, LLC
L-000439343
3511 Clippert St, Detroit, MI, 48210956784912442.32601, -83.121652026-11-032026-11-12
overtureThe Rocks Bar & Grill
03300c37-6841-4fb0-975a-369eb82d4fc7
3511 Clippert St, Detroit, MI, 4821042.32589, -83.121652026-11-062026-11-12
vtinfoTHE ROCKS BAR AND GRILL
926b739ae51bd703
3511 CLIPPERT ST, DETROIT, MI, 48210956784912442.32588, -83.121772026-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 THE ROCKS BAR AND GRILLmi-lcc THE ROCKS BAR AND GRILL, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ab-inbev THE ROCKS BAR AND GRILLmi-lcc THE ROCKS BAR AND GRILL, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ab-inbev THE ROCKS BAR AND GRILLoverture The Rocks Bar & Grill1.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 THE ROCKS BAR AND GRILLvtinfo THE ROCKS BAR AND GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 36 m apart · name similarity 1.00
mi-lcc THE ROCKS BAR AND GRILL, LLCmi-lcc THE ROCKS BAR AND GRILL, LLC1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE ROCKS BAR AND GRILL, LLCoverture The Rocks Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
mi-lcc THE ROCKS BAR AND GRILL, LLCvtinfo THE ROCKS BAR AND GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00 · phone: equal
mi-lcc THE ROCKS BAR AND GRILL, LLCoverture The Rocks Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
mi-lcc THE ROCKS BAR AND GRILL, LLCvtinfo THE ROCKS BAR AND GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00 · phone: equal
overture The Rocks Bar & Grillvtinfo THE ROCKS BAR AND GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
THE ROCKS BAR AND GRILL, LLC — 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 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
107 within 1 mi · 539 within 3 mi
Off / on premise
25 / 60 within 1 mi · 111 / 298 within 3 mi
Selling alcohol
57 within 1 mi · 294 within 3 mi
Nearest
same channel 0.16 mi · licensed 0.13 mi
Setting
urban (3,945 people per sq mi)
People within 3 mi
111,546 (73,016 adults 21+, 39,084 households) from 47 tract(s), tracts within 3 mi
Income
per capita $21,199 · median household ~$39,982 (weighted mean of tract medians)
Age and education
median age ~32.8 · bachelor's or higher 16%
Ethnicity
Hispanic 35% · White 41% · Black 21% · Asian 1%
Adults per alcohol outlet
248
Alcohol spend within 3 mi
$16,745,833 a year ($8,321,220 at home, $8,415,904 away) · $56,766 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-12 14:25insertmi-lcc L-000439342 ↔ vtinfo 926b739ae51bd703same address and namemerged12
2026-11-12 14:25insertab-inbev 4489768 ↔ vtinfo 926b739ae51bd703same address and namemerged12
2026-11-12 14:25insertoverture 03300c37-6841-4fb0-975a-369eb82d4fc7 ↔ vtinfo 926b739ae51bd703same address and namemerged12
2026-11-12 14:25insertmi-lcc L-000439343 ↔ vtinfo 926b739ae51bd703same address and namemerged12
2026-11-11 12:56insertab-inbev 4489768 ↔ overture 03300c37-6841-4fb0-975a-369eb82d4fc7same address and namemerged12
2026-11-11 12:56insertab-inbev 4489768 ↔ mi-lcc L-000439343same address and namemerged12
2026-11-11 12:56insertab-inbev 4489768 ↔ mi-lcc L-000439342same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000439343 ↔ overture 03300c37-6841-4fb0-975a-369eb82d4fc7same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000439342 ↔ overture 03300c37-6841-4fb0-975a-369eb82d4fc7same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000439342 ↔ mi-lcc L-000439343one store listed twicemerged