Royal Oak Brewery

Royal Oak, MI 48067 · O1af0ab9b045a · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed3 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
Royal Oak Brewery 3 other
a source's own spelling of the licence name (record_title.py)
THE ROYAL OAK BREWERY inspectionsmi-lccvtinfo ×5
ROYAL OAK BREWING CO. mi-lcc (legal name) ×3
the royal oak brewery royal oak doordash
Street
215 E 4th St 2 other
mi-lcc
215 E 4TH vtinfo
215 East 4th Street doordash
City
Royal Oak
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48067
mi-lccno other value
Pin
42.48742, -83.14241 map
ubereatsno other value
Phone
2485441141
vtinfono other value
Licences
mi-lcc L-000004440 · mi-lcc L-000093010 · mi-lcc L-000179573
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa2bfacc09101; O9bcbbec0f005; O95e35ceb7a09; Oaa46e68f0a4a; Od6166b25e5ad; Oc80cf63f4b58; O383976050033

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
doordashthe royal oak brewery royal oak
215455
215 East 4th Street, Royal Oak, MI, 4806742.48746, -83.142362026-10-082026-11-03
inspectionsTHE ROYAL OAK BREWERY
inspections|mi|SFE-4063-023815
215 E 4TH ST, Royal Oak, MI, 4806742.48741, -83.142412026-11-202026-11-20
mi-lccTHE ROYAL OAK BREWERY
legal name: ROYAL OAK BREWING CO.
L-000004440
215 E 4th St, Royal Oak, MI, 48067248544114142.48737, -83.142772026-11-032026-11-05
mi-lccTHE ROYAL OAK BREWERY
legal name: ROYAL OAK BREWING CO.
L-000093010
215 E 4th St, Royal Oak, MI, 48067248544114142.48737, -83.142772026-11-032026-11-05
mi-lccTHE ROYAL OAK BREWERY
legal name: ROYAL OAK BREWING CO.
L-000179573
215 E 4th St, Royal Oak, MI, 48067248544114142.48737, -83.142772026-11-032026-11-05
overtureRoyal Oak Brewery
bf585483-f3ee-424c-891e-aa5afb39ca94
215 E 4th St, Royal Oak, MI, 48067248544114142.48741, -83.142352026-11-062026-11-06
ubereatsRoyal Oak Brewery
ZgMbOt4zSnuyYy6Qx3mjiw
215 E 4th St, Royal Oak, MI, 4806742.48742, -83.142412026-10-142026-11-03
vtinfoTHE ROYAL OAK BREWERY
6861fb42005b9f0f
215 E 4TH, ROYAL OAK, MI, 48067248544114142.48752, -83.142312026-11-122026-11-19

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
doordash the royal oak brewery royal oakinspections THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · pins 7 m apart · name similarity 1.00
doordash the royal oak brewery royal oakmi-lcc THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 1.00
doordash the royal oak brewery royal oakmi-lcc THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 1.00
doordash the royal oak brewery royal oakmi-lcc THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · name similarity 1.00
doordash the royal oak brewery royal oakoverture Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · pins 5 m apart · name similarity 1.00
doordash the royal oak brewery royal oakubereats Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
inspections THE ROYAL OAK BREWERYmi-lcc THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
inspections THE ROYAL OAK BREWERYmi-lcc THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
inspections THE ROYAL OAK BREWERYmi-lcc THE ROYAL OAK BREWERY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
inspections THE ROYAL OAK BREWERYoverture Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
inspections THE ROYAL OAK BREWERYubereats Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 1 m apart · name similarity 1.00
mi-lcc THE ROYAL OAK BREWERYmi-lcc THE ROYAL OAK BREWERY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE ROYAL OAK BREWERYmi-lcc THE ROYAL OAK BREWERY1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE ROYAL OAK BREWERYoverture Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00 · phone: equal
mi-lcc THE ROYAL OAK BREWERYubereats Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc THE ROYAL OAK BREWERYvtinfo THE ROYAL OAK BREWERY1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (98% confident; asked as a “proximity” pair)
Same name, address, phone.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records carry the same name 'THE ROYAL OAK BREWERY', the same street address (215 E 4th St), the same ZIP, and an identical phone number, with the only address building at this location and a distance of about 40 meters between coordinates.
pair 1518f6f0ead54c05f4f0
mi-lcc THE ROYAL OAK BREWERYoverture Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00 · phone: equal
mi-lcc THE ROYAL OAK BREWERYubereats Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc THE ROYAL OAK BREWERYoverture Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 35 m apart · name similarity 1.00 · phone: equal
mi-lcc THE ROYAL OAK BREWERYubereats Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc THE ROYAL OAK BREWERYvtinfo THE ROYAL OAK BREWERY1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (97% confident; asked as a “proximity” pair)
Identical name, address, phone
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records carry the same trade name 'THE ROYAL OAK BREWERY', the same street address (215 E 4th St), ZIP, and identical phone number, with only one business at that address and a 0.04 km distance between coordinates.
pair 18aa51ddb73dc1db3715
overture Royal Oak Breweryubereats Royal Oak Brewery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ROYAL OAK BREWING CO. — 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/Brew Pub; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
149 within 1 mi · 774 within 3 mi
Off / on premise
18 / 85 within 1 mi · 196 / 408 within 3 mi
Selling alcohol
87 within 1 mi · 425 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.02 mi
Setting
urban (5,146 people per sq mi)
People within 3 mi
145,496 (119,437 adults 21+, 68,968 households) from 45 tract(s), tracts within 3 mi
Income
per capita $56,848 · median household ~$96,979 (weighted mean of tract medians)
Age and education
median age ~39.2 · bachelor's or higher 52%
Ethnicity
Hispanic 4% · White 76% · Black 12% · Asian 3%
Adults per alcohol outlet
280
Alcohol spend within 3 mi
$50,466,619 a year ($22,784,631 at home, $27,659,793 away) · $118,466 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:08insertdoordash 215455 ↔ inspections inspections|mi|SFE-4063-023815same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023815 ↔ ubereats ZgMbOt4zSnuyYy6Qx3mjiwsame address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023815 ↔ mi-lcc L-000093010same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023815 ↔ mi-lcc L-000004440same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023815 ↔ mi-lcc L-000179573same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-023815 ↔ overture bf585483-f3ee-424c-891e-aa5afb39ca94same address and namemerged17
2026-11-19 20:37insertmi-lcc L-000179573 ↔ vtinfo 6861fb42005b9f0fClaude judge: samemerged17
2026-11-19 20:37insertmi-lcc L-000004440 ↔ vtinfo 6861fb42005b9f0fClaude judge: samemerged17
2026-11-06 18:13insertmi-lcc L-000179573 ↔ overture bf585483-f3ee-424c-891e-aa5afb39ca94same address and namemerged11
2026-11-06 18:13insertdoordash 215455 ↔ overture bf585483-f3ee-424c-891e-aa5afb39ca94same address and namemerged11
2026-11-06 18:13insertoverture bf585483-f3ee-424c-891e-aa5afb39ca94 ↔ ubereats ZgMbOt4zSnuyYy6Qx3mjiwsame address and namemerged11
2026-11-06 18:13insertmi-lcc L-000093010 ↔ overture bf585483-f3ee-424c-891e-aa5afb39ca94same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000004440 ↔ overture bf585483-f3ee-424c-891e-aa5afb39ca94same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000093010 ↔ ubereats ZgMbOt4zSnuyYy6Qx3mjiwsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000004440 ↔ ubereats ZgMbOt4zSnuyYy6Qx3mjiwsame address and namemerged
2026-11-03 13:33backfillmi-lcc L-000179573 ↔ ubereats ZgMbOt4zSnuyYy6Qx3mjiwsame address and namemerged
2026-11-03 13:33backfilldoordash 215455 ↔ mi-lcc L-000093010same address and namemerged
2026-11-03 13:33backfilldoordash 215455 ↔ mi-lcc L-000004440same address and namemerged
2026-11-03 13:33backfilldoordash 215455 ↔ mi-lcc L-000179573same address and namemerged
2026-11-03 13:33backfillmi-lcc L-000004440 ↔ mi-lcc L-000179573one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000004440 ↔ mi-lcc L-000093010one store listed twicemerged
2026-10-14 18:03backfilldoordash 215455 ↔ ubereats ZgMbOt4zSnuyYy6Qx3mjiwsame address and namemerged