Shamrocks Bar & Grill

Merrick, NY 11566 · O2f1618b6e768 · first seen 2026-11-02
3 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
Shamrocks Bar & Grill 2 other
the most common name a source states
SHAMROCKS SPORTS PUB & GRILL ny-sla
T & D RESTAURANT CORP ny-sla (legal name)
Street
708 MERRICK AVE
ny-slano other value
City
NORTH MERRICK 1 other
ny-sla
Merrick overturevtinfo ×2
State
NY
ny-slano other value
ZIP
11566
ny-slano other value
Pin
40.68673, -73.56142 map
overtureno other value
Phone
5169921818
vtinfono other value
Licences
ny-sla 0370-23-115932
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9e8e0e23537b; Oe7e75014db62

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
ny-slaSHAMROCKS SPORTS PUB & GRILL
legal name: T & D RESTAURANT CORP
0370-23-115932
708 MERRICK AVE, NORTH MERRICK, NY, 11566
ZIP lookup: Merrick, NY
40.68671, -73.561602026-11-022026-11-13
overtureShamrocks Bar & Grill
8ced5ef1-d4ce-4d4a-bd93-1a4b3dc226a5
708 Merrick Ave, Merrick, NY, 11566516992181840.68673, -73.561422026-11-132026-11-13
vtinfoSHAMROCKS BAR & GRILL
8f1a31efbbeecb72
708 MERRICK AVE, MERRICK, NY, 11566516992181840.68674, -73.561352026-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
overture Shamrocks Bar & Grillvtinfo SHAMROCKS BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: equal
ny-sla SHAMROCKS SPORTS PUB & GRILLoverture Shamrocks Bar & Grill0.53same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, pub, sports · name Jaro-Winkler 0.71 · same street + ZIP · pins 15 m apart · name similarity 0.53
ny-sla SHAMROCKS SPORTS PUB & GRILLvtinfo SHAMROCKS BAR & GRILL0.53same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill, pub, sports · name Jaro-Winkler 0.71 · same street + ZIP · pins 21 m apart · name similarity 0.53

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
T & D RESTAURANT CORP — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
54 within 1 mi · 1,113 within 3 mi
Off / on premise
14 / 27 within 1 mi · 240 / 592 within 3 mi
Selling alcohol
33 within 1 mi · 631 within 3 mi
Nearest
same channel 0.40 mi · licensed 0.01 mi
Setting
urban (7,735 people per sq mi)
People within 3 mi
218,706 (163,218 adults 21+, 65,037 households) from 40 tract(s), tracts within 3 mi
Income
per capita $50,961 · median household ~$140,881 (weighted mean of tract medians)
Age and education
median age ~40.1 · bachelor's or higher 40%
Ethnicity
Hispanic 27% · White 42% · Black 25% · Asian 6%
Adults per alcohol outlet
258
Alcohol spend within 3 mi
$63,000,066 a year ($27,153,846 at home, $35,823,118 away) · $99,684 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-14 20:23insertny-sla 0370-23-115932 ↔ vtinfo 8f1a31efbbeecb72same address and namemerged15
2026-11-13 14:10insertny-sla 0370-23-115932 ↔ overture 8ced5ef1-d4ce-4d4a-bd93-1a4b3dc226a5same address and namemerged15
2026-11-13 14:10insertoverture 8ced5ef1-d4ce-4d4a-bd93-1a4b3dc226a5 ↔ vtinfo 8f1a31efbbeecb72same address and namemerged15