THE HOUSE OF SHAMROCKS

Hazel Park, MI 48030 · O1712799f013d · first seen 2026-10-08
5 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 HOUSE OF SHAMROCKS 3 other
the most common name a source states
WILDS CORPORATION mi-lcc (legal name) ×2
House of Shamrocks overture
house of shamrocks hazel park doordash
Street
23420 John R Rd 2 other
mi-lcc
23420 JOHN R ab-inbevvtinfo ×2
23420 John R Road doordash
City
Hazel Park
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48030
mi-lccno other value
Pin
42.46464, -83.10384 map
doordashno other value
Phone
2485438388
vtinfono other value
Licences
mi-lcc L-000108047 · mi-lcc L-000108048
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oced5c0918259; Oba94cd475b03; Ob80912a11726; O813379384209; O583c2116457a

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 HOUSE OF SHAMROCKS
139076
23420 JOHN R, HAZEL PARK, MI, 4803042.46470, -83.104022026-11-112026-11-11
doordashhouse of shamrocks hazel park
228548
23420 John R Road, Hazel Park, MI, 4803042.46464, -83.103842026-10-082026-11-13
mi-lccTHE HOUSE OF SHAMROCKS
legal name: WILDS CORPORATION
L-000108047
23420 John R Rd, Hazel Park, MI, 48030248543838842.46448, -83.104022026-11-032026-11-11
mi-lccTHE HOUSE OF SHAMROCKS
legal name: WILDS CORPORATION
L-000108048
23420 John R Rd, Hazel Park, MI, 48030248543838842.46448, -83.104022026-11-032026-11-11
overtureHouse of Shamrocks
2cccade9-27e6-4a9c-9566-ca513934ea53
23420 John R Rd, Hazel Park, MI, 48030248543838842.46449, -83.103952026-11-062026-11-11
vtinfoTHE HOUSE OF SHAMROCKS
f59f5d59cb049e9c
23420 JOHN R, HAZEL PARK, MI, 48030248543838842.46462, -83.103782026-11-112026-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 HOUSE OF SHAMROCKSdoordash house of shamrocks hazel park1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 16 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev THE HOUSE OF SHAMROCKSmi-lcc THE HOUSE OF SHAMROCKS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 24 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev THE HOUSE OF SHAMROCKSmi-lcc THE HOUSE OF SHAMROCKS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 24 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev THE HOUSE OF SHAMROCKSoverture House of Shamrocks1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 24 m apart · name similarity 1.00 · street similarity 0.80
ab-inbev THE HOUSE OF SHAMROCKSvtinfo THE HOUSE OF SHAMROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00
doordash house of shamrocks hazel parkmi-lcc THE HOUSE OF SHAMROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00
doordash house of shamrocks hazel parkmi-lcc THE HOUSE OF SHAMROCKS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00
doordash house of shamrocks hazel parkoverture House of Shamrocks1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
doordash house of shamrocks hazel parkvtinfo THE HOUSE OF SHAMROCKS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 5 m apart · name similarity 1.00 · street similarity 0.80
mi-lcc THE HOUSE OF SHAMROCKSmi-lcc THE HOUSE OF SHAMROCKS1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc THE HOUSE OF SHAMROCKSoverture House of Shamrocks1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 · phone: equal
mi-lcc THE HOUSE OF SHAMROCKSvtinfo THE HOUSE OF SHAMROCKS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 25 m apart · name similarity 1.00 · street similarity 0.80
mi-lcc THE HOUSE OF SHAMROCKSoverture House of Shamrocks1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 · phone: equal
mi-lcc THE HOUSE OF SHAMROCKSvtinfo THE HOUSE OF SHAMROCKS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 25 m apart · name similarity 1.00 · street similarity 0.80
overture House of Shamrocksvtinfo THE HOUSE OF SHAMROCKS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 20 m apart · name similarity 1.00 · street similarity 0.80

Attributes

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

Trade area

Other outlets
75 within 1 mi · 795 within 3 mi
Off / on premise
17 / 40 within 1 mi · 191 / 420 within 3 mi
Selling alcohol
45 within 1 mi · 421 within 3 mi
Nearest
same channel 0.09 mi · licensed 0.15 mi
Setting
urban (4,601 people per sq mi)
People within 3 mi
130,104 (103,251 adults 21+, 58,396 households) from 43 tract(s), tracts within 3 mi
Income
per capita $43,610 · median household ~$76,678 (weighted mean of tract medians)
Age and education
median age ~37.2 · bachelor's or higher 37%
Ethnicity
Hispanic 4% · White 58% · Black 28% · Asian 7%
Adults per alcohol outlet
245
Alcohol spend within 3 mi
$36,025,912 a year ($16,765,702 at home, $19,242,757 away) · $85,369 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:25insertab-inbev 139076 ↔ doordash 228548street written two waysmerged12
2026-11-12 14:25insertdoordash 228548 ↔ vtinfo f59f5d59cb049e9cstreet written two waysmerged12
2026-11-12 14:25insertdoordash 228548 ↔ mi-lcc L-000108048same address and namemerged12
2026-11-12 14:25insertdoordash 228548 ↔ mi-lcc L-000108047same address and namemerged12
2026-11-12 14:25insertdoordash 228548 ↔ overture 2cccade9-27e6-4a9c-9566-ca513934ea53same address and namemerged12
2026-11-11 12:56insertmi-lcc L-000108048 ↔ vtinfo f59f5d59cb049e9cstreet written two waysmerged12
2026-11-11 12:56insertmi-lcc L-000108047 ↔ vtinfo f59f5d59cb049e9cstreet written two waysmerged12
2026-11-11 12:56insertoverture 2cccade9-27e6-4a9c-9566-ca513934ea53 ↔ vtinfo f59f5d59cb049e9cstreet written two waysmerged12
2026-11-11 12:56insertab-inbev 139076 ↔ mi-lcc L-000108048street written two waysmerged12
2026-11-11 12:56insertab-inbev 139076 ↔ mi-lcc L-000108047street written two waysmerged12
2026-11-11 12:56insertab-inbev 139076 ↔ overture 2cccade9-27e6-4a9c-9566-ca513934ea53street written two waysmerged12
2026-11-11 12:56insertab-inbev 139076 ↔ vtinfo f59f5d59cb049e9csame address and namemerged12
2026-11-06 18:13insertmi-lcc L-000108048 ↔ overture 2cccade9-27e6-4a9c-9566-ca513934ea53same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000108047 ↔ overture 2cccade9-27e6-4a9c-9566-ca513934ea53same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000108047 ↔ mi-lcc L-000108048one store listed twicemerged