R T McGrath's Pub

Massapequa, NY 11758 · O25a9bc4699a9 · first seen 2026-11-02
6 sourceson premise · barchain: McGrath's Pubalcohol: 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 T McGrath's Pub 5 other
a licence name in capitals, cleaned (derived; record_title.py)
R T MCGRATHS PUB ab-inbevvtinfo ×2
McGraths Pub overture
R T MC GRATHS PUB ny-sla
R T MCGRATH'S inspections
R T MCGRATH'S PUB INC inspections (legal name)
Street
4145 MERRICK ROAD 1 other
ny-sla
4145 MERRICK RD ab-inbevoverturevtinfo ×3
City
MASSAPEQUA
ny-slano other value
State
NY
ny-slano other value
ZIP
11758
ny-slano other value
Pin
40.66703, -73.48002 map
overtureno other value
Phone
5167989138 1 other
vtinfo
5168096505 overture
Licences
ny-sla 0370-24-138592
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of34967ebbe2d; Oe733c32faa81; O33b7df27d6b2; O33721ead0802; O7c4c69db0ee9

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 T MCGRATHS PUB
2624791
4145 MERRICK RD, MASSAPEQUA, NY, 1175840.66689, -73.479862026-11-112026-11-13
inspectionsR T MCGRATH'S
legal name: R T MCGRATH'S PUB INC
inspections|nys|577169
4145 MERRICK ROAD, Massapequa, NY, 1175840.66686, -73.479942026-11-192026-11-19
lotteryR T MCGRATH'S PUB
lottery|ny|065100
4145 MERRICK ROAD, Massapequa, NY, 1175840.66680, -73.479962026-11-202026-11-20
ny-slaR T MC GRATHS PUB
0370-24-138592
4145 MERRICK ROAD, MASSAPEQUA, NY, 1175840.66696, -73.479912026-11-022026-11-13
overtureMcGraths Pub
09f8ca31-fc05-4b09-bf93-d247a17d0f9d
4145 Merrick Rd, Massapequa, NY, 11758516809650540.66703, -73.480022026-11-132026-11-13
vtinfoR T MCGRATHS PUB
eb6a6483d0f50cd9
4145 MERRICK RD, MASSAPEQUA, NY, 11758516798913840.66710, -73.479912026-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 R T MCGRATHS PUBinspections R T MCGRATH'S1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · matched through the licence's legal name: R T MCGRATH'S PUB INC · name similarity 1.00
ab-inbev R T MCGRATHS PUBlottery R T MCGRATH'S PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ab-inbev R T MCGRATHS PUBvtinfo R T MCGRATHS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00
inspections R T MCGRATH'Slottery R T MCGRATH'S PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · matched through the licence's legal name: R T MCGRATH'S PUB INC · name similarity 1.00
inspections R T MCGRATH'Svtinfo R T MCGRATHS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · matched through the licence's legal name: R T MCGRATH'S PUB INC · name similarity 1.00
lottery R T MCGRATH'S PUBvtinfo R T MCGRATHS PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ab-inbev R T MCGRATHS PUBoverture McGraths Pub0.68same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 21 m apart · name similarity 0.68
inspections R T MCGRATH'Soverture McGraths Pub0.68same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 20 m apart · matched through the licence's legal name: R T MCGRATH'S PUB INC · name similarity 0.68
lottery R T MCGRATH'S PUBoverture McGraths Pub0.68same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 26 m apart · name similarity 0.68
overture McGraths Pubvtinfo R T MCGRATHS PUB0.68same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 12 m apart · name similarity 0.68 · phone: differs
ab-inbev R T MCGRATHS PUBny-sla R T MC GRATHS PUB0.67Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (97% confident; asked as a “near” pair)
Same pub name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 95% confident — Both records name the same pub (R T McGrath's Pub, with only a spacing difference in 'MC GRATHS') at 4145 Merrick Road, Massapequa, NY 11758, with coordinates under 10 m apart and no other businesses at the address.
pair 22ecd29ade1da967a77b
lottery R T MCGRATH'S PUBny-sla R T MC GRATHS PUB0.67same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.82 · same street + ZIP · pins 18 m apart · name similarity 0.67
ny-sla R T MC GRATHS PUBvtinfo R T MCGRATHS PUB0.67same address and namemergedaddress similarity 1.00 · compact · name Jaro-Winkler 0.82 · same street + ZIP · pins 16 m apart · name similarity 0.67

Attributes

Channel
on_premise · bar — overture-category
Chain
McGrath's Pub — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
102 within 1 mi · 616 within 3 mi
Off / on premise
28 / 47 within 1 mi · 139 / 323 within 3 mi
Selling alcohol
70 within 1 mi · 370 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (4,687 people per sq mi)
People within 3 mi
132,530 (101,011 adults 21+, 44,814 households) from 28 tract(s), tracts within 3 mi
Income
per capita $66,234 · median household ~$164,620 (weighted mean of tract medians)
Age and education
median age ~42.9 · bachelor's or higher 51%
Ethnicity
Hispanic 9% · White 85% · Black 3% · Asian 3%
Adults per alcohol outlet
272
Alcohol spend within 3 mi
$47,920,553 a year ($20,260,051 at home, $27,644,110 away) · $129,166 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:08insertlottery lottery|ny|065100 ↔ ny-sla 0370-24-138592same address and namemerged17
2026-11-20 22:08insertny-sla 0370-24-138592 ↔ vtinfo eb6a6483d0f50cd9same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|065100 ↔ overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9dsame address and namemerged17
2026-11-20 22:08insertinspections inspections|nys|577169 ↔ lottery lottery|ny|065100same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|065100 ↔ vtinfo eb6a6483d0f50cd9same address and namemerged17
2026-11-20 22:08insertab-inbev 2624791 ↔ lottery lottery|ny|065100same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|577169 ↔ overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9dsame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|577169 ↔ vtinfo eb6a6483d0f50cd9same address and namemerged17
2026-11-19 20:37insertab-inbev 2624791 ↔ inspections inspections|nys|577169same address and namemerged17
2026-11-13 14:10insertoverture 09f8ca31-fc05-4b09-bf93-d247a17d0f9d ↔ vtinfo eb6a6483d0f50cd9same address and namemerged15
2026-11-13 14:10insertab-inbev 2624791 ↔ overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9dsame address and namemerged15
2026-11-12 17:29insertab-inbev 2624791 ↔ ny-sla 0370-24-138592Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2624791 ↔ vtinfo eb6a6483d0f50cd9same address and namemerged12