Tequila Casa Azul Mexican Restaurant

Amsterdam, NY 12010 · O14fdbf4497db · first seen 2026-11-07
2 sourceson premise · restaurantalcohol: unknown

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
Tequila Casa Azul Mexican Restaurant 1 other
the most common name a source states
tequila casa azul amsterdam doordash
Street
4879 State Highway 30
doordashno other value
City
Amsterdam
doordashno other value
State
NY
doordashno other value
ZIP
12010
doordashno other value
Pin
42.97016, -74.18684 map 1 other
doordash
195 m away overture
Phone
5182122339
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O923c51ced4dc

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
doordashtequila casa azul amsterdam
52501171
4879 State Highway 30, Amsterdam, NY, 1201042.97016, -74.186842026-11-072026-11-13
overtureTequila Casa Azul Mexican Restaurant
4cc03ae4-ea27-4311-9349-20fa133b4127
4879 State Highway 30, Amsterdam, NY, 12010518212233942.96902, -74.185012026-11-132026-11-13

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 tequila casa azul amsterdamoverture Tequila Casa Azul Mexican Restaurant0.62same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.83 · same street + ZIP · pins 195 m apart · name similarity 0.62

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
66 within 1 mi · 150 within 3 mi
Off / on premise
27 / 30 within 1 mi · 50 / 62 within 3 mi
Selling alcohol
32 within 1 mi · 100 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.03 mi
Setting
suburban (965 people per sq mi)
People within 3 mi
27,285 (20,304 adults 21+, 11,136 households) from 10 tract(s), tracts within 3 mi
Income
per capita $35,195 · median household ~$69,722 (weighted mean of tract medians)
Age and education
median age ~41.6 · bachelor's or higher 25%
Ethnicity
Hispanic 25% · White 71% · Black 5% · Asian 1%
Adults per alcohol outlet
203
Alcohol spend within 3 mi
$6,378,005 a year ($3,017,919 at home, $3,357,396 away) · $63,780 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-13 14:10insertdoordash 52501171 ↔ overture 4cc03ae4-ea27-4311-9349-20fa133b4127same address and namemerged15