Redcoat Tavern

Royal Oak, MI 48073 · O16c04c961bde · first seen 2026-10-08
6 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
Redcoat Tavern 2 other
a source's own spelling of the licence name (record_title.py)
RED COAT TAVERN ab-inbevvtinfo ×2
red coat tavern royal oak doordash
Street
31542 Woodward Ave 1 other
mi-lcc
31542 Woodward Avenue doordash
City
Royal Oak
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48073
mi-lccno other value
Pin
42.52238, -83.18996 map
doordashno other value
Phone
2485490300
vtinfono other value
Licences
mi-lcc L-000005842 · mi-lcc L-000434239
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odf8a5f43aacf; Oc028d2f300bc; O3ad46a2af6eb; Oe7c6dd8f943a; O1af90708d671; Oed8516c38204

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-inbevRED COAT TAVERN
2537596
31542 WOODWARD AVE, ROYAL OAK, MI, 4807342.52227, -83.190162026-11-112026-11-11
doordashred coat tavern royal oak
204171
31542 Woodward Avenue, Royal Oak, MI, 4807342.52238, -83.189962026-10-082026-11-11
inspectionsREDCOAT TAVERN
inspections|mi|SFE-4063-021059
31542 WOODWARD AVE, Royal Oak, MI, 4807342.52201, -83.189872026-11-202026-11-20
mi-lccREDCOAT TAVERN
L-000005842
31542 Woodward Ave, Royal Oak, MI, 48073248549030042.52211, -83.190022026-11-032026-11-12
mi-lccREDCOAT TAVERN
L-000434239
31542 Woodward Ave, Royal Oak, MI, 48073248549030042.52211, -83.190022026-11-032026-11-12
overtureRedcoat Tavern
7d23ff6b-d9b0-402a-bd05-f146d8057fc2
31542 Woodward Ave, Royal Oak, MI, 48073248549030042.52235, -83.189962026-11-062026-11-12
vtinfoRED COAT TAVERN
e79af726babfe866
31542 WOODWARD AVE, ROYAL OAK, MI, 48073248549030042.52233, -83.189762026-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 RED COAT TAVERNdoordash red coat tavern royal oak1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ab-inbev RED COAT TAVERNvtinfo RED COAT TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 33 m apart · name similarity 1.00
doordash red coat tavern royal oakvtinfo RED COAT TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
inspections REDCOAT TAVERNmi-lcc REDCOAT TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
inspections REDCOAT TAVERNmi-lcc REDCOAT TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
inspections REDCOAT TAVERNoverture Redcoat Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
mi-lcc REDCOAT TAVERNmi-lcc REDCOAT TAVERN1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc REDCOAT TAVERNoverture Redcoat Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 · phone: equal
mi-lcc REDCOAT TAVERNoverture Redcoat Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 · phone: equal
ab-inbev RED COAT TAVERNinspections REDCOAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 37 m apart · name similarity 0.50
ab-inbev RED COAT TAVERNmi-lcc REDCOAT TAVERN0.50Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Red Coat vs Redcoat Tavern, same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 31542 Woodward Ave, Royal Oak, MI 48073 within about 20 m, and the names 'RED COAT TAVERN' and 'REDCOAT TAVERN' are the same tavern written with and without a space, so this is one operation at one premises despite the building holding two businesses.
pair 0b64bb5f22757df04ba1
ab-inbev RED COAT TAVERNmi-lcc REDCOAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 21 m apart · name similarity 0.50
ab-inbev RED COAT TAVERNoverture Redcoat Tavern0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 18 m apart · name similarity 0.50
doordash red coat tavern royal oakinspections REDCOAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 42 m apart · name similarity 0.50
doordash red coat tavern royal oakmi-lcc REDCOAT TAVERN0.50Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Redcoat Tavern same address, spelling variant.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — The DoorDash listing 'red coat tavern royal oak' and the Michigan licence 'REDCOAT TAVERN' match on name (only the spacing differs), the street address is the same (31542 Woodward Ave, Royal Oak, 48073), and the coordinates are about 31 m apart; the other business at the address does not change this pair.
pair 1386293d5b2848630cce
doordash red coat tavern royal oakmi-lcc REDCOAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 31 m apart · name similarity 0.50
doordash red coat tavern royal oakoverture Redcoat Tavern0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 4 m apart · name similarity 0.50
inspections REDCOAT TAVERNvtinfo RED COAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 37 m apart · name similarity 0.50
mi-lcc REDCOAT TAVERNvtinfo RED COAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 33 m apart · name similarity 0.50 · phone: equal
mi-lcc REDCOAT TAVERNvtinfo RED COAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 33 m apart · name similarity 0.50 · phone: equal
overture Redcoat Tavernvtinfo RED COAT TAVERN0.50same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.88 · same street + ZIP · pins 17 m apart · name similarity 0.50 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
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": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
75 within 1 mi · 718 within 3 mi
Off / on premise
17 / 45 within 1 mi · 198 / 385 within 3 mi
Selling alcohol
32 within 1 mi · 369 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.06 mi
Setting
urban (4,694 people per sq mi)
People within 3 mi
132,708 (103,323 adults 21+, 59,961 households) from 39 tract(s), tracts within 3 mi
Income
per capita $67,609 · median household ~$113,783 (weighted mean of tract medians)
Age and education
median age ~40.5 · bachelor's or higher 62%
Ethnicity
Hispanic 3% · White 74% · Black 13% · Asian 6%
Adults per alcohol outlet
279
Alcohol spend within 3 mi
$49,194,522 a year ($21,730,808 at home, $27,444,786 away) · $132,958 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 204171 ↔ inspections inspections|mi|SFE-4063-021059same address and namemerged17
2026-11-20 22:08insertab-inbev 2537596 ↔ inspections inspections|mi|SFE-4063-021059same address and namemerged17
2026-11-20 22:08insertdoordash 204171 ↔ mi-lcc L-000434239same address and namemerged17
2026-11-20 22:08insertab-inbev 2537596 ↔ mi-lcc L-000434239same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-021059 ↔ vtinfo e79af726babfe866same address and namemerged17
2026-11-20 22:08insertmi-lcc L-000005842 ↔ vtinfo e79af726babfe866same address and namemerged17
2026-11-20 22:08insertmi-lcc L-000434239 ↔ vtinfo e79af726babfe866same address and namemerged17
2026-11-20 22:08insertdoordash 204171 ↔ overture 7d23ff6b-d9b0-402a-bd05-f146d8057fc2same address and namemerged17
2026-11-20 22:08insertab-inbev 2537596 ↔ overture 7d23ff6b-d9b0-402a-bd05-f146d8057fc2same address and namemerged17
2026-11-20 22:08insertoverture 7d23ff6b-d9b0-402a-bd05-f146d8057fc2 ↔ vtinfo e79af726babfe866same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-021059 ↔ mi-lcc L-000005842same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-021059 ↔ mi-lcc L-000434239same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-021059 ↔ overture 7d23ff6b-d9b0-402a-bd05-f146d8057fc2same address and namemerged17
2026-11-12 17:29insertdoordash 204171 ↔ mi-lcc L-000005842Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2537596 ↔ mi-lcc L-000005842Claude judge: samemerged14
2026-11-12 14:25insertdoordash 204171 ↔ vtinfo e79af726babfe866same address and namemerged12
2026-11-12 14:25insertab-inbev 2537596 ↔ vtinfo e79af726babfe866same address and namemerged12
2026-11-11 12:56insertab-inbev 2537596 ↔ doordash 204171same address and namemerged12
2026-11-06 18:13insertmi-lcc L-000434239 ↔ overture 7d23ff6b-d9b0-402a-bd05-f146d8057fc2same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000005842 ↔ overture 7d23ff6b-d9b0-402a-bd05-f146d8057fc2same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000005842 ↔ mi-lcc L-000434239one store listed twicemerged