CASA VALLARTA

LAKE KATRINE, NY 12449 · O00da240b591c · 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
CASA VALLARTA 4 other
the most common name a source states
CASA VALLARTA II INC ny-sla (legal name)
Casa Vallarta Mexican Restaurant overture
MI RANCHO ALEGRE ny-sla
mi rancho alegre lake katrine doordash
Street
1571 ULSTER AVE SUITE 104 3 other
ny-sla
1571 ULSTER AV STE 3 ab-inbevvtinfo ×2
1571 Ulster Ave Unit 4 overture
1571 Ulster Avenue doordash
City
LAKE KATRINE 1 other
ny-sla
Ulster overture
State
NY
ny-slano other value
ZIP
12449
ny-slano other value
Pin
41.97749, -73.98980 map
doordashno other value
Phone
8454815318
vtinfono other value
Licences
ny-sla 0340-22-208453
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oef4392a689b4; Ode6337402c7b; O8413712374cf; O195e9f88cb1f; O7438a92fcf14

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-inbevCASA VALLARTA
4401462
1571 ULSTER AV STE 3, LAKE KATRINE, NY, 1244941.97755, -73.989882026-11-112026-11-13
doordashmi rancho alegre lake katrine
1280659
1571 Ulster Avenue, Lake Katrine, NY, 1244941.97749, -73.989802026-10-082026-11-13
ny-slaMI RANCHO ALEGRE
legal name: CASA VALLARTA II INC
0340-22-208453
1571 ULSTER AVE SUITE 104, LAKE KATRINE, NY, 1244941.97762, -73.989882026-11-022026-11-13
overtureCasa Vallarta Mexican Restaurant
c7715820-0a2c-4625-8bcb-124a9aec5382
1571 Ulster Ave Unit 4, Ulster, NY, 12449845481531841.97740, -73.989732026-11-132026-11-13
vtinfoCASA VALLARTA
8c9329d787b3a5a1
1571 ULSTER AV STE 3, LAKE KATRINE, NY, 12449845481531841.97732, -73.989932026-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 CASA VALLARTAvtinfo CASA VALLARTA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 26 m apart · name similarity 1.00
doordash mi rancho alegre lake katrineny-sla MI RANCHO ALEGRE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
doordash mi rancho alegre lake katrineoverture c6aa6f1b-1a72-4d0c-8a66-63c2e64019c00.89same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.97 · same street + ZIP · pins 20 m apart · name similarity 0.89
ab-inbev CASA VALLARTAny-sla MI RANCHO ALEGRE0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 8 m apart · matched through the licence's legal name: CASA VALLARTA II INC · name similarity 0.78
ny-sla MI RANCHO ALEGREvtinfo CASA VALLARTA0.78same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · pins 34 m apart · matched through the licence's legal name: CASA VALLARTA II INC · name similarity 0.78
ab-inbev CASA VALLARTAoverture Casa Vallarta Mexican Restaurant0.54same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.79 · same street + ZIP · pins 21 m apart · name similarity 0.54
overture Casa Vallarta Mexican Restaurantvtinfo CASA VALLARTA0.54same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: mexican, restaurant · name Jaro-Winkler 0.79 · same street + ZIP · pins 19 m apart · name similarity 0.54 · phone: equal

Attributes

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

Trade area

Other outlets
71 within 1 mi · 137 within 3 mi
Off / on premise
25 / 28 within 1 mi · 47 / 51 within 3 mi
Selling alcohol
41 within 1 mi · 86 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.19 mi
Setting
suburban (715 people per sq mi)
People within 3 mi
20,228 (16,207 adults 21+, 9,090 households) from 6 tract(s), tracts within 3 mi
Income
per capita $41,781 · median household ~$68,402 (weighted mean of tract medians)
Age and education
median age ~42.1 · bachelor's or higher 27%
Ethnicity
Hispanic 10% · White 74% · Black 8% · Asian 2%
Adults per alcohol outlet
186
Alcohol spend within 3 mi
$5,584,933 a year ($2,587,005 at home, $2,994,908 away) · $64,195 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:23insertoverture c7715820-0a2c-4625-8bcb-124a9aec5382 ↔ vtinfo 8c9329d787b3a5a1same address and namemerged15
2026-11-14 20:23insertny-sla 0340-22-208453 ↔ vtinfo 8c9329d787b3a5a1same address and namemerged15
2026-11-14 20:23insertab-inbev 4401462 ↔ vtinfo 8c9329d787b3a5a1same address and namemerged15
2026-11-13 14:10insertab-inbev 4401462 ↔ overture c7715820-0a2c-4625-8bcb-124a9aec5382same address and namemerged15
2026-11-11 12:56insertab-inbev 4401462 ↔ ny-sla 0340-22-208453same address and namemerged12
2026-11-09 15:32insertdoordash 1280659 ↔ overture c6aa6f1b-1a72-4d0c-8a66-63c2e64019c0same address and namemerged11
2026-11-09 15:32insertdoordash 1280659 ↔ ny-sla 0340-22-208453same address and namemerged11