CASA REAL

Rotterdam, NY 12303 · O04c589ddc3cd · first seen 2026-11-02
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
CASA REAL 2 other
the most common name a source states
CASA REAL LLC ny-sla
Casa Real Mexican Restaurant overture
Street
1400 ALTAMONT AVE
ny-slano other value
City
ROTTERDAM 1 other
ny-sla
SCHENECTADY vtinfo
State
NY
ny-slano other value
ZIP
12303
ny-slano other value
Pin
42.78363, -73.94446 map 2 other
overture
171 m away ny-sla
254 m away vtinfo
Phone
5183560060 1 other
vtinfo
5188067678 overture
Licences
ny-sla 0340-22-208875
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O2eea787e98c7; O82d14dc84d18

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
ny-slaCASA REAL LLC
0340-22-208875
1400 ALTAMONT AVE, ROTTERDAM, NY, 12303
ZIP lookup: Schenectady, NY
42.78497, -73.943442026-11-022026-11-02
overtureCasa Real Mexican Restaurant
6c2bf9cc-8d87-4900-a474-36818e2dd641
1400 Altamont Ave, Rotterdam, NY, 12303
ZIP lookup: Schenectady, NY
518806767842.78363, -73.944462026-11-132026-11-13
vtinfoCASA REAL
a49c7a41450f3e1b
1400 ALTAMONT AVE, SCHENECTADY, NY, 12303518356006042.78406, -73.941412026-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
ny-sla CASA REAL LLCvtinfo CASA REAL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 194 m apart · name similarity 1.00
ny-sla CASA REAL LLCoverture Casa Real Mexican Restaurant0.49same 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 171 m apart · name similarity 0.49
overture Casa Real Mexican Restaurantvtinfo CASA REAL0.49same 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 254 m apart · name similarity 0.49 · phone: differs

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
CASA REAL LLC — 2 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": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
64 within 1 mi · 477 within 3 mi
Off / on premise
22 / 24 within 1 mi · 133 / 211 within 3 mi
Selling alcohol
44 within 1 mi · 327 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.07 mi
Setting
urban (3,114 people per sq mi)
People within 3 mi
88,050 (65,312 adults 21+, 36,758 households) from 26 tract(s), tracts within 3 mi
Income
per capita $35,479 · median household ~$68,049 (weighted mean of tract medians)
Age and education
median age ~37.7 · bachelor's or higher 27%
Ethnicity
Hispanic 10% · White 58% · Black 15% · Asian 5%
Adults per alcohol outlet
199
Alcohol spend within 3 mi
$21,001,873 a year ($9,931,612 at home, $11,059,191 away) · $64,030 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 6c2bf9cc-8d87-4900-a474-36818e2dd641 ↔ vtinfo a49c7a41450f3e1bsame address and namemerged15
2026-11-14 20:23insertny-sla 0340-22-208875 ↔ vtinfo a49c7a41450f3e1bsame address and namemerged15
2026-11-13 14:10insertny-sla 0340-22-208875 ↔ overture 6c2bf9cc-8d87-4900-a474-36818e2dd641same address and namemerged15