Duggans

Royal Oak, MI 48073 · O2875b042c407 · 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
Duggans 3 other
a licence name in capitals, cleaned (derived; record_title.py)
DUGGANS IRISH PUB ab-inbevoverturevtinfo ×3
TKJH HOSPITALITY, INC. mi-lcc (legal name) ×2
duggan's irish pub royal oak doordash
Street
31501 Woodward Ave
mi-lccno other value
City
Royal Oak
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48073
mi-lccno other value
Pin
42.52166, -83.19050 map
doordashno other value
Phone
2485493659
vtinfono other value
Licences
mi-lcc L-000263925 · mi-lcc L-000263927
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oce035dd3e431; Od35e6f5443dc; Oe5f130ea36a9; Of47e44308547; Oad8fdb193841; O4d54fb63886e

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-inbevDUGGANS IRISH PUB
2763402
31501 WOODWARD AVE, ROYAL OAK, MI, 4807342.52167, -83.190602026-11-112026-11-20
doordashduggan's irish pub royal oak
44796955
31501 Woodward Ave, Royal Oak, MI, 4807342.52166, -83.190502026-10-082026-11-20
inspectionsDUGGANS
inspections|mi|SFE-4063-203064
31501 WOODWARD AVE, Royal Oak, MI, 4807342.52157, -83.190132026-11-202026-11-20
mi-lccDUGGANS
legal name: TKJH HOSPITALITY, INC.
L-000263925
31501 Woodward Ave, Royal Oak, MI, 48073248549365942.52168, -83.190182026-11-032026-11-20
mi-lccDUGGANS
legal name: TKJH HOSPITALITY, INC.
L-000263927
31501 Woodward Ave, Royal Oak, MI, 48073248549365942.52168, -83.190182026-11-032026-11-20
overtureDuggans Irish Pub
7ce53218-77ff-4d3c-a4d2-b08d5ad35781
31501 Woodward Ave, Royal Oak, MI, 48073248549365942.52169, -83.190562026-11-092026-11-20
vtinfoDUGGANS IRISH PUB
030700971a2046ea
31501 WOODWARD AVE, ROYAL OAK, MI, 48073248549365942.52167, -83.190602026-11-122026-11-20

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 DUGGANS IRISH PUBdoordash duggan's irish pub royal oak1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00
ab-inbev DUGGANS IRISH PUBoverture Duggans Irish Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00
ab-inbev DUGGANS IRISH PUBvtinfo DUGGANS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 0 m apart · name similarity 1.00
doordash duggan's irish pub royal oakoverture Duggans Irish Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00
doordash duggan's irish pub royal oakvtinfo DUGGANS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
inspections DUGGANSmi-lcc DUGGANS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
inspections DUGGANSmi-lcc DUGGANS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
mi-lcc DUGGANSmi-lcc DUGGANS1.00one store listed twicemergedsame street + ZIP · name: identical
overture Duggans Irish Pubvtinfo DUGGANS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00 · phone: equal
doordash duggan's irish pub royal oakmi-lcc DUGGANS0.46Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Duggan's same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at the same street address and ZIP in Royal Oak, and the DoorDash slug 'duggan's irish pub' matches the Michigan licence trade name 'DUGGANS' (filed by legal entity TKJH Hospitality), with only one business at the address and coordinates about 26 m apart.
pair 43f7ca34f4aaaa6d988b

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
TKJH HOSPITALITY, 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:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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:08insertinspections inspections|mi|SFE-4063-203064 ↔ mi-lcc L-000263927same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4063-203064 ↔ mi-lcc L-000263925same address and namemerged17
2026-11-12 17:29insertdoordash 44796955 ↔ mi-lcc L-000263927Claude judge: samemerged14
2026-11-12 14:25insertdoordash 44796955 ↔ vtinfo 030700971a2046easame address and namemerged12
2026-11-12 14:25insertab-inbev 2763402 ↔ vtinfo 030700971a2046easame address and namemerged12
2026-11-12 14:25insertoverture 7ce53218-77ff-4d3c-a4d2-b08d5ad35781 ↔ vtinfo 030700971a2046easame address and namemerged12
2026-11-11 12:56insertab-inbev 2763402 ↔ overture 7ce53218-77ff-4d3c-a4d2-b08d5ad35781same address and namemerged12
2026-11-11 12:56insertab-inbev 2763402 ↔ doordash 44796955same address and namemerged12
2026-11-09 15:32insertdoordash 44796955 ↔ overture 7ce53218-77ff-4d3c-a4d2-b08d5ad35781same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000263925 ↔ mi-lcc L-000263927one store listed twicemerged