KENNEDY'S IRISH PUB

Waterford, MI 48328 · O197af549b281 · first seen 2026-11-03
4 sourceson premise · baralcohol: 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
KENNEDY'S IRISH PUB 1 other
the most common name a source states
KENNEDYS IRISH PUB ab-inbevvtinfo ×2
Street
1057 W Huron St 2 other
mi-lcc
1055 W HURON ST STE 1057 ab-inbevvtinfo ×2
1055 W Huron St overture
City
Waterford
mi-lccno other value
State
MI
mi-lccno other value
ZIP
48328
mi-lccno other value
Pin
42.63481, -83.33157 map 1 other
overture
72 m away ab-inbev
Phone
2486811050 1 other
vtinfo
2484310458 mi-lcc ×2
Licences
mi-lcc L-000003144 · mi-lcc L-000011052
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O54d985ec454c; Oe5074ab59735; O2e7e52da3142; O411b93fe6cd6

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-inbevKENNEDYS IRISH PUB
2525139
1055 W HURON ST STE 1057, WATERFORD, MI, 4832842.63499, -83.330722026-11-112026-11-12
mi-lccKENNEDY'S IRISH PUB
L-000003144
1057 W Huron St, Waterford, MI, 48328248431045842.63495, -83.331672026-11-032026-11-12
mi-lccKENNEDY'S IRISH PUB
L-000011052
1057 W Huron St, Waterford, MI, 48328248431045842.63495, -83.331672026-11-032026-11-12
overtureKennedy's Irish Pub
9d1acb20-bae2-4289-ba8e-8f6cd6d78cc2
1055 W Huron St, MI, 48328
ZIP lookup: Waterford, MI
248681105042.63481, -83.331572026-11-132026-11-13
vtinfoKENNEDYS IRISH PUB
edb1de728b218184
1055 W HURON ST STE 1057, WATERFORD, MI, 48328248681105042.63476, -83.331662026-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 KENNEDYS IRISH PUBmi-lcc KENNEDY'S IRISH PUB1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “proximity” pair)
Same pub name, suite 1057 matches street number
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name the same Irish pub (KENNEDYS vs KENNEDY'S IRISH PUB) at the same Waterford, MI address (1055 W Huron Ste 1057 and 1057 W Huron St, about 80 m apart), with no other business at that address and no chain involved.
pair 139fef09b56885ae9cc2
ab-inbev KENNEDYS IRISH PUBoverture Kennedy's Irish Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 72 m apart · name similarity 1.00
ab-inbev KENNEDYS IRISH PUBvtinfo KENNEDYS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 81 m apart · name similarity 1.00
mi-lcc KENNEDY'S IRISH PUBmi-lcc KENNEDY'S IRISH PUB1.00one store listed twicemergedsame street + ZIP · name: identical
overture Kennedy's Irish Pubvtinfo KENNEDYS IRISH PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
54 within 1 mi · 331 within 3 mi
Off / on premise
15 / 32 within 1 mi · 97 / 155 within 3 mi
Selling alcohol
22 within 1 mi · 197 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.03 mi
Setting
suburban (2,745 people per sq mi)
People within 3 mi
77,604 (60,190 adults 21+, 33,270 households) from 24 tract(s), tracts within 3 mi
Income
per capita $38,833 · median household ~$62,555 (weighted mean of tract medians)
Age and education
median age ~40.4 · bachelor's or higher 26%
Ethnicity
Hispanic 13% · White 51% · Black 28% · Asian 4%
Adults per alcohol outlet
304
Alcohol spend within 3 mi
$18,915,782 a year ($8,909,260 at home, $9,998,493 away) · $95,534 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-13 14:10insertoverture 9d1acb20-bae2-4289-ba8e-8f6cd6d78cc2 ↔ vtinfo edb1de728b218184same address and namemerged15
2026-11-13 14:10insertab-inbev 2525139 ↔ overture 9d1acb20-bae2-4289-ba8e-8f6cd6d78cc2same address and namemerged15
2026-11-12 17:29insertab-inbev 2525139 ↔ mi-lcc L-000011052Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2525139 ↔ vtinfo edb1de728b218184same address and namemerged12
2026-11-03 13:33backfillmi-lcc L-000003144 ↔ mi-lcc L-000011052one store listed twicemerged