The Rock on 3rd

Royal Oak, MI 48067 · O20499bea7e90 · 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 Rock on 3rd 1 other
a source's own spelling of the licence name (record_title.py)
TWO C'S, INC. mi-lcc (legal name) ×2
Street
114 E 3rd St 1 other
mi-lcc
112 E 3RD ST ab-inbevoverturevtinfo ×3
City
Royal Oak
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48067
mi-lccno other value
Pin
42.48806, -83.14349 map
overtureno other value
Phone
2485427625
vtinfono other value
Licences
mi-lcc L-000002381 · mi-lcc L-000008824
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od411510c7777; O52e173fb4dd9; O77e79c58c7fd; Oed594084a201

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 ROCK ON 3RD
2506200
112 E 3RD ST, ROYAL OAK, MI, 4806742.48822, -83.143782026-11-112026-11-12
mi-lccTHE ROCK ON 3RD
legal name: TWO C'S, INC.
L-000002381
114 E 3rd St, Royal Oak, MI, 48067248542762542.48807, -83.144002026-11-032026-11-12
mi-lccTHE ROCK ON 3RD
legal name: TWO C'S, INC.
L-000008824
114 E 3rd St, Royal Oak, MI, 48067248542762542.48807, -83.144002026-11-032026-11-12
overtureThe Rock on 3rd
e9ede2d5-48ea-4f38-ace3-f177e85ecd8d
112 E 3rd St, Royal Oak, MI, 48067248542762542.48806, -83.143492026-11-132026-11-13
vtinfoTHE ROCK ON 3RD
ad9d4e97fe73c755
112 E 3RD ST, ROYAL OAK, MI, 48067248542762542.48797, -83.143452026-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 ROCK ON 3RDmi-lcc THE ROCK ON 3RD1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “proximity” pair)
Identical name, adjacent street numbers.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records carry the identical name 'THE ROCK ON 3RD' in Royal Oak, MI 48067, with coordinates about 24 m apart and only one business at the address; the 112 vs 114 house-number gap is a small discrepancy that likely reflects the same building.
pair 40c00f611b612f4d817f
ab-inbev THE ROCK ON 3RDoverture The Rock on 3rd1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
ab-inbev THE ROCK ON 3RDvtinfo THE ROCK ON 3RD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 39 m apart · name similarity 1.00
mi-lcc THE ROCK ON 3RDmi-lcc THE ROCK ON 3RD1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE ROCK ON 3RDvtinfo THE ROCK ON 3RD1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “proximity” pair)
Same name and phone, adjacent street number
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records have the identical name THE ROCK ON 3RD and the same phone number, with coordinates about 46 m apart on the same street and ZIP; the 112 vs 114 house number difference is most likely a numbering variance for one building, and no other business is listed at the address.
pair 353c4628ff151de1bb63
mi-lcc THE ROCK ON 3RDvtinfo THE ROCK ON 3RD1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair)
Same name and phone, adjacent street numbers.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records carry the same trade name 'THE ROCK ON 3RD' and an identical phone number in the same ZIP, with coordinates about 46 m apart; the 112 vs 114 house-number difference is most likely a data-entry discrepancy for one building, and only one business is held at the address.
pair 3642cc34d1e18ce8726f
overture The Rock on 3rdvtinfo THE ROCK ON 3RD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TWO C'S, INC. — 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:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
149 within 1 mi · 768 within 3 mi
Off / on premise
17 / 86 within 1 mi · 189 / 411 within 3 mi
Selling alcohol
86 within 1 mi · 422 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
urban (5,335 people per sq mi)
People within 3 mi
150,831 (123,834 adults 21+, 71,824 households) from 47 tract(s), tracts within 3 mi
Income
per capita $56,893 · median household ~$96,922 (weighted mean of tract medians)
Age and education
median age ~39.2 · bachelor's or higher 53%
Ethnicity
Hispanic 4% · White 76% · Black 12% · Asian 3%
Adults per alcohol outlet
293
Alcohol spend within 3 mi
$52,525,637 a year ($23,718,209 at home, $28,784,140 away) · $124,174 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-19 20:37insertmi-lcc L-000008824 ↔ vtinfo ad9d4e97fe73c755Claude judge: samemerged17
2026-11-19 20:37insertmi-lcc L-000002381 ↔ vtinfo ad9d4e97fe73c755Claude judge: samemerged17
2026-11-13 14:10insertoverture e9ede2d5-48ea-4f38-ace3-f177e85ecd8d ↔ vtinfo ad9d4e97fe73c755same address and namemerged15
2026-11-13 14:10insertab-inbev 2506200 ↔ overture e9ede2d5-48ea-4f38-ace3-f177e85ecd8dsame address and namemerged15
2026-11-12 17:29insertab-inbev 2506200 ↔ mi-lcc L-000008824Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2506200 ↔ vtinfo ad9d4e97fe73c755same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000002381 ↔ mi-lcc L-000008824one store listed twicemerged