Finestra

New York, NY 10021 · O34cfb723523d · 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
Finestra 3 other
a licence name in capitals, cleaned (derived; record_title.py)
Finestra Restaurant overturevtinfo ×2
DERO RESTAURANT CORP ny-sla (legal name)
finestra restaurant new york doordash
Street
1370 YORK AVE 1 other
ny-sla
1370 York Avenue doordashinspections ×2
City
NEW YORK
ny-slano other value
State
NY
ny-slano other value
ZIP
10021
ny-slano other value
Pin
40.76752, -73.95320 map
doordashno other value
Phone
2127178594 1 other
vtinfo
2127178595 inspectionsoverture ×2
Licences
ny-sla 0340-21-116305
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe03af4f04fcb; Od9b94bee371c; Od10704cdc151; O63e7efd981be; O75e09c76d51c

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
doordashfinestra restaurant new york
221795
1370 York Avenue, New York, NY, 1002140.76752, -73.953202026-10-082026-11-14
inspectionsFINESTRA
inspections|nyc|40869272
1370 YORK AVENUE, New York, NY, 10021212717859540.76762, -73.953172026-11-192026-11-19
ny-slaFINESTRA
legal name: DERO RESTAURANT CORP
0340-21-116305
1370 YORK AVE, NEW YORK, NY, 1002140.76764, -73.953172026-11-022026-11-13
overtureFinestra Restaurant
7e00f53c-a36c-429c-ab4a-82d4b9e7fb0b
1370 York Ave, New York, NY, 10021212717859540.76753, -73.953072026-11-132026-11-13
vtinfoFINESTRA RESTAURANT
c2fc84035e69c4da
1370 YORK AVE, NEW YORK, NY, 10021212717859440.76750, -73.952802026-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
doordash finestra restaurant new yorkoverture Finestra Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
doordash finestra restaurant new yorkvtinfo FINESTRA RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 34 m apart · name similarity 1.00
inspections FINESTRAny-sla FINESTRA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00
ny-sla FINESTRAoverture 55ab03a6-c425-4512-bfb4-a39ec16da4e51.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · matched through the licence's legal name: DERO RESTAURANT CORP · name similarity 1.00
overture Finestra Restaurantvtinfo FINESTRA RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 · phone: differs
doordash finestra restaurant new yorkny-sla FINESTRA0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.88 · same street + city + state · pins 13 m apart · matched through the licence's legal name: DERO RESTAURANT CORP · name similarity 0.55
ny-sla FINESTRAoverture Finestra Restaurant0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.88 · same street + ZIP · pins 15 m apart · matched through the licence's legal name: DERO RESTAURANT CORP · name similarity 0.55
ny-sla FINESTRAvtinfo FINESTRA RESTAURANT0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.88 · same street + city + state · pins 35 m apart · matched through the licence's legal name: DERO RESTAURANT CORP · name similarity 0.55
doordash finestra restaurant new yorkinspections FINESTRA0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.88 · same street + ZIP · pins 11 m apart · name similarity 0.55
inspections FINESTRAoverture Finestra Restaurant0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.88 · same street + ZIP · pins 13 m apart · name similarity 0.55 · phone: equal
inspections FINESTRAvtinfo FINESTRA RESTAURANT0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.88 · same street + ZIP · pins 34 m apart · name similarity 0.55 · phone: differs

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
DERO RESTAURANT CORP — 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:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1,350 within 1 mi · 12,787 within 3 mi
Off / on premise
171 / 783 within 1 mi · 1,521 / 6,816 within 3 mi
Selling alcohol
817 within 1 mi · 7,754 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
urban (43,367 people per sq mi)
People within 3 mi
1,226,168 (1,026,376 adults 21+, 610,336 households) from 287 tract(s), tracts within 3 mi
Income
per capita $101,279 · median household ~$128,506 (weighted mean of tract medians)
Age and education
median age ~39.9 · bachelor's or higher 69%
Ethnicity
Hispanic 19% · White 55% · Black 10% · Asian 14%
Adults per alcohol outlet
132
Alcohol spend within 3 mi
$542,018,272 a year ($233,685,544 at home, $308,145,364 away) · $69,893 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|40869272 ↔ vtinfo c2fc84035e69c4dasame address and namemerged17
2026-11-19 20:37insertdoordash 221795 ↔ inspections inspections|nyc|40869272same address and namemerged17
2026-11-19 20:37insertinspections inspections|nyc|40869272 ↔ overture 7e00f53c-a36c-429c-ab4a-82d4b9e7fb0bsame address and namemerged17
2026-11-19 20:37insertinspections inspections|nyc|40869272 ↔ ny-sla 0340-21-116305same address and namemerged17
2026-11-13 17:47insertdoordash 221795 ↔ ny-sla 0340-21-116305same address and namemerged15
2026-11-13 17:47insertdoordash 221795 ↔ vtinfo c2fc84035e69c4dasame address and namemerged15
2026-11-13 17:47insertdoordash 221795 ↔ overture 7e00f53c-a36c-429c-ab4a-82d4b9e7fb0bsame address and namemerged15
2026-11-13 14:10insertny-sla 0340-21-116305 ↔ overture 7e00f53c-a36c-429c-ab4a-82d4b9e7fb0bsame address and namemerged15
2026-11-13 14:10insertoverture 7e00f53c-a36c-429c-ab4a-82d4b9e7fb0b ↔ vtinfo c2fc84035e69c4dasame address and namemerged15
2026-11-12 17:29insertny-sla 0340-21-116305 ↔ vtinfo c2fc84035e69c4dasame address and namemerged14
2026-11-06 18:13insertny-sla 0340-21-116305 ↔ overture 55ab03a6-c425-4512-bfb4-a39ec16da4e5same address and namemerged11