Outlets /
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.
| Field | Master value | Taken from | What 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-sla | no other value |
| State | NY | ny-sla | no other value |
| ZIP | 11758 | ny-sla | no other value |
| Pin | 40.66703, -73.48002 map | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | R T MCGRATHS PUB 2624791 | 4145 MERRICK RD, MASSAPEQUA, NY, 11758 | 40.66689, -73.47986 | 2026-11-11 | 2026-11-13 | |
| inspections | R T MCGRATH'S legal name: R T MCGRATH'S PUB INC inspections|nys|577169 | 4145 MERRICK ROAD, Massapequa, NY, 11758 | 40.66686, -73.47994 | 2026-11-19 | 2026-11-19 | |
| lottery | R T MCGRATH'S PUB lottery|ny|065100 | 4145 MERRICK ROAD, Massapequa, NY, 11758 | 40.66680, -73.47996 | 2026-11-20 | 2026-11-20 | |
| ny-sla | R T MC GRATHS PUB 0370-24-138592 | 4145 MERRICK ROAD, MASSAPEQUA, NY, 11758 | 40.66696, -73.47991 | 2026-11-02 | 2026-11-13 | |
| overture | McGraths Pub 09f8ca31-fc05-4b09-bf93-d247a17d0f9d | 4145 Merrick Rd, Massapequa, NY, 11758 | 5168096505 | 40.66703, -73.48002 | 2026-11-13 | 2026-11-13 |
| vtinfo | R T MCGRATHS PUB eb6a6483d0f50cd9 | 4145 MERRICK RD, MASSAPEQUA, NY, 11758 | 5167989138 | 40.66710, -73.47991 | 2026-11-12 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev R T MCGRATHS PUB | inspections R T MCGRATH'S | 1.00 | same address and name | merged | address 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 PUB | lottery R T MCGRATH'S PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 |
| ab-inbev R T MCGRATHS PUB | vtinfo R T MCGRATHS PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 24 m apart · name similarity 1.00 |
| inspections R T MCGRATH'S | lottery R T MCGRATH'S PUB | 1.00 | same address and name | merged | address 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'S | vtinfo R T MCGRATHS PUB | 1.00 | same address and name | merged | address 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 PUB | vtinfo R T MCGRATHS PUB | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ab-inbev R T MCGRATHS PUB | overture McGraths Pub | 0.68 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 21 m apart · name similarity 0.68 |
| inspections R T MCGRATH'S | overture McGraths Pub | 0.68 | same address and name | merged | address 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 PUB | overture McGraths Pub | 0.68 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 26 m apart · name similarity 0.68 |
| overture McGraths Pub | vtinfo R T MCGRATHS PUB | 0.68 | same address and name | merged | address 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 PUB | ny-sla R T MC GRATHS PUB | 0.67 | Claude judge: same | merged | 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:
pair 22ecd29ade1da967a77b |
| lottery R T MCGRATH'S PUB | ny-sla R T MC GRATHS PUB | 0.67 | same address and name | merged | address 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 PUB | vtinfo R T MCGRATHS PUB | 0.67 | same address and name | merged | address 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | lottery lottery|ny|065100 ↔ ny-sla 0370-24-138592 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | ny-sla 0370-24-138592 ↔ vtinfo eb6a6483d0f50cd9 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | lottery lottery|ny|065100 ↔ overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9d | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | inspections inspections|nys|577169 ↔ lottery lottery|ny|065100 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | lottery lottery|ny|065100 ↔ vtinfo eb6a6483d0f50cd9 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | ab-inbev 2624791 ↔ lottery lottery|ny|065100 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys|577169 ↔ overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9d | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys|577169 ↔ vtinfo eb6a6483d0f50cd9 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ab-inbev 2624791 ↔ inspections inspections|nys|577169 | same address and name | merged | 17 |
| 2026-11-13 14:10 | insert | overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9d ↔ vtinfo eb6a6483d0f50cd9 | same address and name | merged | 15 |
| 2026-11-13 14:10 | insert | ab-inbev 2624791 ↔ overture 09f8ca31-fc05-4b09-bf93-d247a17d0f9d | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | ab-inbev 2624791 ↔ ny-sla 0370-24-138592 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | ab-inbev 2624791 ↔ vtinfo eb6a6483d0f50cd9 | same address and name | merged | 12 |