R P MC Murphy's

Wyandotte, MI 48192 · O327aad44c594 · first seen 2026-11-03
5 sourceson premise · restaurantalcohol: licensed1 licence

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
R P MC Murphy's 4 other
a licence name in capitals, cleaned (derived; record_title.py)
R P MC MURPHYS ab-inbevvtinfo ×2
R P MCMURPHYS inspections
R.P. MC MURPHY'S mi-lcc
R.P. McMurphy's overture
Street
2922 Biddle Ave 1 other
mi-lcc
2922 BIDDLE ab-inbevvtinfo ×2
City
Wyandotte
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48192
mi-lccno other value
Pin
42.20395, -83.14919 map
overtureno other value
Phone
7342854885
vtinfono other value
Licences
mi-lcc L-000208251
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od6869d3531cc; Ofa0ca48d09b2; O8472874da435; Oe0b08d439eb0

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-inbevR P MC MURPHYS
138607
2922 BIDDLE, WYANDOTTE, MI, 4819242.20358, -83.149192026-11-112026-11-11
inspectionsR P MCMURPHYS
inspections|mi|SFE-4882-031593
2922 BIDDLE AVE, Wyandotte, MI, 4819242.20375, -83.149192026-11-202026-11-20
mi-lccR.P. MC MURPHY'S
L-000208251
2922 Biddle Ave, Wyandotte, MI, 48192734285488542.20401, -83.149032026-11-032026-11-06
overtureR.P. McMurphy's
61677121-1ea1-44d5-b12a-568886f22d13
2922 Biddle Ave, Wyandotte, MI, 48192734285488542.20395, -83.149192026-11-062026-11-06
vtinfoR P MC MURPHYS
e4c24c5d30294d7a
2922 BIDDLE, WYANDOTTE, MI, 48192734285488542.20400, -83.149372026-11-122026-11-17

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 R P MC MURPHYSmi-lcc R.P. MC MURPHY'S1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 50 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev R P MC MURPHYSvtinfo R P MC MURPHYS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 48 m apart · name similarity 1.00
inspections R P MCMURPHYSoverture R.P. McMurphy's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
mi-lcc R.P. MC MURPHY'Svtinfo R P MC MURPHYS1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 28 m apart · name similarity 1.00 · street similarity 0.75
ab-inbev R P MC MURPHYSinspections R P MCMURPHYS0.68street written two waysmergedname Jaro-Winkler 0.98 · matched on zip · pins 19 m apart · name similarity 0.68 · street similarity 0.75
ab-inbev R P MC MURPHYSoverture R.P. McMurphy's0.68street written two waysmergedname Jaro-Winkler 0.98 · matched on zip · pins 41 m apart · name similarity 0.68 · street similarity 0.75
inspections R P MCMURPHYSvtinfo R P MC MURPHYS0.68street written two waysmergedname Jaro-Winkler 0.98 · matched on zip · pins 31 m apart · name similarity 0.68 · street similarity 0.75
overture R.P. McMurphy'svtinfo R P MC MURPHYS0.68street written two waysmergedname Jaro-Winkler 0.98 · matched on city · pins 16 m apart · name similarity 0.68 · street similarity 0.75
inspections R P MCMURPHYSmi-lcc R.P. MC MURPHY'S0.68same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 32 m apart · name similarity 0.68
mi-lcc R.P. MC MURPHY'Soverture R.P. McMurphy's0.68same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 15 m apart · name similarity 0.68 · phone: equal

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
103 within 1 mi · 357 within 3 mi
Off / on premise
11 / 48 within 1 mi · 77 / 175 within 3 mi
Selling alcohol
78 within 1 mi · 227 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
suburban (2,566 people per sq mi)
People within 3 mi
72,559 (55,112 adults 21+, 30,133 households) from 24 tract(s), tracts within 3 mi
Income
per capita $35,268 · median household ~$67,451 (weighted mean of tract medians)
Age and education
median age ~38.8 · bachelor's or higher 19%
Ethnicity
Hispanic 12% · White 79% · Black 6% · Asian 1%
Adults per alcohol outlet
242
Alcohol spend within 3 mi
$17,029,952 a year ($8,082,058 at home, $8,940,367 away) · $74,693 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:08insertinspections inspections|mi|SFE-4882-031593 ↔ mi-lcc L-000208251same address and namemerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4882-031593 ↔ vtinfo e4c24c5d30294d7astreet written two waysmerged17
2026-11-20 22:08insertab-inbev 138607 ↔ inspections inspections|mi|SFE-4882-031593street written two waysmerged17
2026-11-20 22:08insertinspections inspections|mi|SFE-4882-031593 ↔ overture 61677121-1ea1-44d5-b12a-568886f22d13same address and namemerged17
2026-11-12 14:25insertoverture 61677121-1ea1-44d5-b12a-568886f22d13 ↔ vtinfo e4c24c5d30294d7astreet written two waysmerged12
2026-11-12 14:25insertmi-lcc L-000208251 ↔ vtinfo e4c24c5d30294d7astreet written two waysmerged12
2026-11-12 14:25insertab-inbev 138607 ↔ vtinfo e4c24c5d30294d7asame address and namemerged12
2026-11-11 12:56insertab-inbev 138607 ↔ overture 61677121-1ea1-44d5-b12a-568886f22d13street written two waysmerged12
2026-11-11 12:56insertab-inbev 138607 ↔ mi-lcc L-000208251street written two waysmerged12
2026-11-06 18:13insertmi-lcc L-000208251 ↔ overture 61677121-1ea1-44d5-b12a-568886f22d13same address and namemerged11