McGrath's

Farmingdale, NY 11735 · O1538d0d2c953 · first seen 2026-10-08
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
McGrath's 5 other
a licence name in capitals, cleaned (derived; record_title.py)
MCGRATHS ab-inbevvtinfo ×2
L.I. McGrath’s overture
LI McGraths ny-sla
li mcgraths farmingdale doordash
R & R Massapequa Park Inc ny-sla (legal name)
Street
217 Main St
ny-slano other value
City
Farmingdale
ny-slano other value
State
NY
ny-slano other value
ZIP
11735
ny-slano other value
Pin
40.73390, -73.44582 map
doordashno other value
Phone
5168542040
vtinfono other value
Licences
ny-sla 0340-25-110251
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of6d8bdd46407; O33a504f4639d; O68fb1266de2d; O4cb6d85f34b8

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-inbevMCGRATHS
4791314
217 MAIN ST, FARMINGDALE, NY, 1173540.73386, -73.445962026-11-112026-11-12
doordashli mcgraths farmingdale
32187355
217 Main St, Farmingdale, NY, 1173540.73390, -73.445822026-10-082026-11-16
ny-slaLI McGraths
legal name: R & R Massapequa Park Inc
0340-25-110251
217 Main St, Farmingdale, NY, 1173540.73394, -73.446042026-11-022026-11-16
overtureL.I. McGrath’s
1519ba70-0f2b-4b47-9fbb-8d3a46556be2
217 Main St, Farmingdale, NY, 11735516854204040.73402, -73.445752026-11-062026-11-16
vtinfoMCGRATHS
f01bcc1391bab1d5
217 MAIN ST, FARMINGDALE, NY, 11735516854204040.73396, -73.445862026-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 MCGRATHSvtinfo MCGRATHS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 m apart · name similarity 1.00
doordash li mcgraths farmingdaleny-sla LI McGraths1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ab-inbev MCGRATHSdoordash li mcgraths farmingdale0.67one name contains the other, same addressmergedjudge: None · pair_id: f7784e274bd6afc0b04f · person: None · rule: names contained at one address · stratum: near
ab-inbev MCGRATHSny-sla LI McGraths0.67one name contains the other, same addressmergedjudge: None · pair_id: f83da91c878ea2c3696d · person: None · rule: names contained at one address · stratum: near
doordash li mcgraths farmingdalevtinfo MCGRATHS0.67one name contains the other, same addressmergedjudge: None · pair_id: 09c571813c9e71cdb32e · person: None · rule: names contained at one address · stratum: near
ny-sla LI McGrathsvtinfo MCGRATHS0.67one name contains the other, same addressmergedjudge: None · pair_id: bf880767e903e7a6e01f · person: None · rule: names contained at one address · stratum: near
doordash li mcgraths farmingdaleoverture L.I. McGrath’s0.56same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 14 m apart · name similarity 0.56
ny-sla LI McGrathsoverture L.I. McGrath’s0.56same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 26 m apart · name similarity 0.56

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
R & R Massapequa Park Inc — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
164 within 1 mi · 640 within 3 mi
Off / on premise
26 / 84 within 1 mi · 144 / 321 within 3 mi
Selling alcohol
115 within 1 mi · 396 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.01 mi
Setting
urban (4,042 people per sq mi)
People within 3 mi
114,279 (88,538 adults 21+, 39,104 households) from 24 tract(s), tracts within 3 mi
Income
per capita $60,393 · median household ~$142,830 (weighted mean of tract medians)
Age and education
median age ~43.9 · bachelor's or higher 46%
Ethnicity
Hispanic 15% · White 70% · Black 6% · Asian 9%
Adults per alcohol outlet
223
Alcohol spend within 3 mi
$38,244,065 a year ($16,392,300 at home, $21,838,673 away) · $96,333 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-16 14:56insertab-inbev 4791314 ↔ doordash 32187355one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 32187355 ↔ vtinfo f01bcc1391bab1d5one name contains the other, same addressmerged15
2026-11-16 14:56insertny-sla 0340-25-110251 ↔ vtinfo f01bcc1391bab1d5one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4791314 ↔ ny-sla 0340-25-110251one name contains the other, same addressmerged15
2026-11-14 20:23insertdoordash 32187355 ↔ overture 1519ba70-0f2b-4b47-9fbb-8d3a46556be2same address and namemerged15
2026-11-14 20:23insertdoordash 32187355 ↔ ny-sla 0340-25-110251same address and namemerged15
2026-11-12 14:25insertab-inbev 4791314 ↔ vtinfo f01bcc1391bab1d5same address and namemerged12
2026-11-06 18:13insertny-sla 0340-25-110251 ↔ overture 1519ba70-0f2b-4b47-9fbb-8d3a46556be2same address and namemerged11