Turtle Bay Tavern

New York, NY 10022 · O05e6cc3898ac · first seen 2026-11-02
6 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
Turtle Bay Tavern 1 other
the most common name a source states
LMF NY LLC ny-sla (legal name)
Street
975 2nd Ave 2 other
ny-sla
975 2 AVENUE inspections
975 2nd Avenue toast
City
New York 1 other
ny-sla
New York City overture
State
NY
ny-slano other value
ZIP
10022
ny-slano other value
Pin
40.75596, -73.96795 map
ubereatsno other value
Phone
9173065374 2 other
toast
6463988791 overture
9175432948 inspections
Licences
ny-sla 0340-24-122851
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofc475aa0d768; Ocf6969fd9165; Oe23456a5285e; Of81bfe24e8a1; O313a33580ba9

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-inbevTURTLE BAY TAVERN
4740079
975 2ND AVE, NEW YORK, NY, 1002240.75592, -73.967852026-11-192026-11-19
inspectionsTURTLE BAY TAVERN
inspections|nyc|50149083
975 2 AVENUE, New York, NY, 10022917543294840.75589, -73.967792026-11-192026-11-19
ny-slaTurtle Bay Tavern
legal name: LMF NY LLC
0340-24-122851
975 2nd Ave, New York, NY, 1002240.75589, -73.967792026-11-022026-11-05
overtureTurtle Bay Tavern
b3b5e320-a887-4b36-a582-262888d7e2eb
975 2nd Ave, New York City, NY, 10022
ZIP lookup: New York, NY
646398879140.75602, -73.968062026-11-062026-11-06
toastTurtle Bay Tavern
cc75a5a9-da6f-47c2-aebd-05a6a65489b9
975 2nd Avenue, New York, NY, 10022917306537440.75597, -73.968062026-11-062026-11-14
ubereatsTurtle Bay Tavern
3PJtbGAEVt2swLV9buGeFQ
975 2nd Ave, New York, NY, 1002240.75596, -73.967952026-11-142026-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 TURTLE BAY TAVERNinspections TURTLE BAY TAVERN1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ab-inbev TURTLE BAY TAVERNny-sla Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
ab-inbev TURTLE BAY TAVERNoverture Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 21 m apart · name similarity 1.00
ab-inbev TURTLE BAY TAVERNtoast Turtle Bay Tavern1.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 TURTLE BAY TAVERNubereats Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
inspections TURTLE BAY TAVERNny-sla Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
inspections TURTLE BAY TAVERNoverture Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00 · phone: differs
inspections TURTLE BAY TAVERNtoast Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 24 m apart · name similarity 1.00 · phone: differs
inspections TURTLE BAY TAVERNubereats Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ny-sla Turtle Bay Tavernoverture Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ny-sla Turtle Bay Taverntoast Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
ny-sla Turtle Bay Tavernubereats Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
overture Turtle Bay Taverntoast Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00 · phone: differs
overture Turtle Bay Tavernubereats Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
toast Turtle Bay Tavernubereats Turtle Bay Tavern1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
LMF NY LLC — 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:31.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
3,037 within 1 mi · 16,053 within 3 mi
Off / on premise
278 / 1,551 within 1 mi · 1,755 / 8,714 within 3 mi
Selling alcohol
1,903 within 1 mi · 9,924 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (44,683 people per sq mi)
People within 3 mi
1,263,379 (1,069,470 adults 21+, 648,799 households) from 292 tract(s), tracts within 3 mi
Income
per capita $111,406 · median household ~$138,042 (weighted mean of tract medians)
Age and education
median age ~39.6 · bachelor's or higher 73%
Ethnicity
Hispanic 17% · White 59% · Black 7% · Asian 15%
Adults per alcohol outlet
108
Alcohol spend within 3 mi
$599,621,689 a year ($256,817,495 at home, $342,606,747 away) · $60,415 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-19 20:37insertinspections inspections|nyc|50149083 ↔ overture b3b5e320-a887-4b36-a582-262888d7e2ebsame address and namemerged17
2026-11-19 20:37insertinspections inspections|nyc|50149083 ↔ ny-sla 0340-24-122851same address and namemerged17
2026-11-19 20:37insertinspections inspections|nyc|50149083 ↔ toast cc75a5a9-da6f-47c2-aebd-05a6a65489b9same address and namemerged17
2026-11-19 20:37insertab-inbev 4740079 ↔ inspections inspections|nyc|50149083same address and namemerged17
2026-11-19 20:37insertab-inbev 4740079 ↔ overture b3b5e320-a887-4b36-a582-262888d7e2ebsame address and namemerged17
2026-11-19 20:37insertab-inbev 4740079 ↔ ny-sla 0340-24-122851same address and namemerged17
2026-11-19 20:37insertab-inbev 4740079 ↔ toast cc75a5a9-da6f-47c2-aebd-05a6a65489b9same address and namemerged17
2026-11-19 20:37insertinspections inspections|nyc|50149083 ↔ ubereats 3PJtbGAEVt2swLV9buGeFQsame address and namemerged17
2026-11-19 20:37insertab-inbev 4740079 ↔ ubereats 3PJtbGAEVt2swLV9buGeFQsame address and namemerged17
2026-11-14 20:23insertoverture b3b5e320-a887-4b36-a582-262888d7e2eb ↔ toast cc75a5a9-da6f-47c2-aebd-05a6a65489b9same address and namemerged15
2026-11-14 20:23insertoverture b3b5e320-a887-4b36-a582-262888d7e2eb ↔ ubereats 3PJtbGAEVt2swLV9buGeFQsame address and namemerged15
2026-11-14 20:23insertny-sla 0340-24-122851 ↔ ubereats 3PJtbGAEVt2swLV9buGeFQsame address and namemerged15
2026-11-14 20:23inserttoast cc75a5a9-da6f-47c2-aebd-05a6a65489b9 ↔ ubereats 3PJtbGAEVt2swLV9buGeFQsame address and namemerged15
2026-11-06 18:13insertny-sla 0340-24-122851 ↔ toast cc75a5a9-da6f-47c2-aebd-05a6a65489b9same address and namemerged11
2026-11-06 18:13insertny-sla 0340-24-122851 ↔ overture b3b5e320-a887-4b36-a582-262888d7e2ebsame address and namemerged11