ADD BAR-2ND FLOOR OF PREMISE

Brentwood, NY 11717 · O0edd88d800ce · first seen 2026-10-08
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
ADD BAR-2ND FLOOR OF PREMISE 3 other
the most common name a source states
LA ESPIGUITA HALL overture
la espiguita hall brentwood doordash
LA ESPIGUITA SOCCER LLC ny-sla (legal name)
Street
1795 BRENTWOOD RD
ny-slano other value
City
BRENTWOOD
ny-slano other value
State
NY
ny-slano other value
ZIP
11717
ny-slano other value
Pin
40.77871, -73.24406 map
doordashno other value
Phone
6316449885
overtureno other value
Licences
ny-sla 0423-22-113376
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc4d9f2da9e27; O2fba7e502648

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
doordashla espiguita hall brentwood
40135667
1795 Brentwood Rd, Brentwood, NY, 1171740.77871, -73.244062026-10-082026-11-12
ny-slaADD BAR-2ND FLOOR OF PREMISE
legal name: LA ESPIGUITA SOCCER LLC
0423-22-113376
1795 BRENTWOOD RD, BRENTWOOD, NY, 1171740.77890, -73.244062026-11-022026-11-05
overtureLA ESPIGUITA HALL
c39eebaa-57e0-4126-91a1-5564f5a064ae
1795 Brentwood Rd, Brentwood, NY, 11717631644988540.77868, -73.244422026-11-062026-11-12

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 la espiguita hall brentwoodoverture LA ESPIGUITA HALL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 30 m apart · name similarity 1.00
doordash la espiguita hall brentwoodny-sla ADD BAR-2ND FLOOR OF PREMISE0.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
La Espiguita legal name matches hall at address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — The DoorDash listing 'la espiguita hall brentwood' matches the NY SLA licence's legal entity 'LA ESPIGUITA SOCCER LLC' at the same street address and near-identical coordinates, and the licence is an additional bar on the 2nd floor of that same premises, so it reads as one operation's licence rather than a separate business, though the second business at the address leaves some doubt.
pair 0ff1626be888a0bf9795

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
LA ESPIGUITA SOCCER LLC — 1 outlets in the master under this operator
Licence privileges
none — NY 0423 (add-on; no base licence on file)
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
79 within 1 mi · 520 within 3 mi
Off / on premise
19 / 36 within 1 mi · 152 / 224 within 3 mi
Selling alcohol
56 within 1 mi · 339 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.01 mi
Setting
suburban (2,733 people per sq mi)
People within 3 mi
77,270 (55,177 adults 21+, 20,008 households) from 30 tract(s), tracts within 3 mi
Income
per capita $38,009 · median household ~$119,935 (weighted mean of tract medians)
Age and education
median age ~36.1 · bachelor's or higher 24%
Ethnicity
Hispanic 51% · White 31% · Black 14% · Asian 7%
Adults per alcohol outlet
162
Alcohol spend within 3 mi
$17,476,247 a year ($7,670,910 at home, $9,797,380 away) · $51,401 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-12 17:29insertdoordash 40135667 ↔ ny-sla 0423-22-113376Claude judge: samemerged14
2026-11-06 18:13insertdoordash 40135667 ↔ overture c39eebaa-57e0-4126-91a1-5564f5a064aesame address and namemerged11