Frida's Mexican Cuisine

PLAINVIEW, NY 11803 · O142ba44d2d3e · first seen 2026-10-08
4 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
Frida's Mexican Cuisine 3 other
a source's own spelling of the licence name (record_title.py)
FRIDAS MEXICAN CUISINE ny-slavtinfo ×2
AAG HOSPITALITY INC ny-sla (legal name)
fridas mexican cuisine plainview doordash
Street
387 S OYSTER BAY RD 1 other
ny-sla
387 South Oyster Bay Road doordash
City
PLAINVIEW 1 other
ny-sla
Oyster Bay overture
State
NY
ny-slano other value
ZIP
11803
ny-slano other value
Pin
40.78473, -73.50189 map
doordashno other value
Phone
5164750075
vtinfono other value
Licences
ny-sla 0340-24-123267
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O72b9fa4e3b67; O321102f2c3cf; O7e6707c2badf

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
doordashfridas mexican cuisine plainview
25886839
387 South Oyster Bay Road, Plainview, NY, 1180340.78473, -73.501892026-10-082026-11-14
ny-slaFRIDAS MEXICAN CUISINE
legal name: AAG HOSPITALITY INC
0340-24-123267
387 S OYSTER BAY RD, PLAINVIEW, NY, 1180340.78469, -73.502032026-11-022026-11-05
overtureFrida's Mexican Cuisine
ee830b42-5289-45a2-8f30-ceaab28c4fd2
387 S Oyster Bay Rd, Oyster Bay, NY, 11803
ZIP lookup: Plainview, NY
516475007540.78475, -73.501772026-11-062026-11-06
vtinfoFRIDAS MEXICAN CUISINE
4d97d5b129ad156a
387 S OYSTER BAY RD, PLAINVIEW, NY, 11803516475007540.78471, -73.501812026-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 fridas mexican cuisine plainviewny-sla FRIDAS MEXICAN CUISINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
doordash fridas mexican cuisine plainviewvtinfo FRIDAS MEXICAN CUISINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ny-sla FRIDAS MEXICAN CUISINEoverture Frida's Mexican Cuisine1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ny-sla FRIDAS MEXICAN CUISINEvtinfo FRIDAS MEXICAN CUISINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
overture Frida's Mexican Cuisinevtinfo FRIDAS MEXICAN CUISINE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 · phone: equal
doordash fridas mexican cuisine plainviewoverture Frida's Mexican Cuisine0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 10 m apart · name similarity 0.78

Attributes

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

Trade area

Other outlets
79 within 1 mi · 731 within 3 mi
Off / on premise
18 / 45 within 1 mi · 158 / 412 within 3 mi
Selling alcohol
31 within 1 mi · 355 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
urban (3,809 people per sq mi)
People within 3 mi
107,693 (79,792 adults 21+, 34,835 households) from 22 tract(s), tracts within 3 mi
Income
per capita $66,561 · median household ~$164,017 (weighted mean of tract medians)
Age and education
median age ~43.8 · bachelor's or higher 58%
Ethnicity
Hispanic 11% · White 55% · Black 2% · Asian 30%
Adults per alcohol outlet
224
Alcohol spend within 3 mi
$36,642,554 a year ($15,457,160 at home, $21,174,005 away) · $102,929 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:23insertdoordash 25886839 ↔ overture ee830b42-5289-45a2-8f30-ceaab28c4fd2same address and namemerged15
2026-11-14 20:23insertdoordash 25886839 ↔ ny-sla 0340-24-123267same address and namemerged15
2026-11-14 20:23insertoverture ee830b42-5289-45a2-8f30-ceaab28c4fd2 ↔ vtinfo 4d97d5b129ad156asame address and namemerged15
2026-11-14 20:23insertdoordash 25886839 ↔ vtinfo 4d97d5b129ad156asame address and namemerged15
2026-11-12 14:25insertny-sla 0340-24-123267 ↔ vtinfo 4d97d5b129ad156asame address and namemerged12
2026-11-06 18:13insertny-sla 0340-24-123267 ↔ overture ee830b42-5289-45a2-8f30-ceaab28c4fd2same address and namemerged11