CASA REAL

Guilderland, NY 12303 · O0c0cad2a5834 · 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
CASA REAL 3 other
the most common name a source states
CASA REAL LLC ny-sla
Casa Real Mexican Restaurant overture
casa real mexican restaurant schenectady doordash
Street
3770 CARMAN RD 1 other
ny-sla
3770 Carman Road doordash
City
GUILDERLAND 1 other
ny-sla
Schenectady doordashvtinfo ×2
State
NY
ny-slano other value
ZIP
12303
ny-slano other value
Pin
42.72273, -73.93612 map
doordashno other value
Phone
5183578475 1 other
vtinfo
5188067718 overture
Licences
ny-sla 0340-23-237609
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of8689eadc9f9; Od014f328c7a4; O4838d7ea7db4

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
doordashcasa real mexican restaurant schenectady
28108833
3770 Carman Road, Schenectady, NY, 1230342.72273, -73.936122026-10-082026-11-12
ny-slaCASA REAL LLC
0340-23-237609
3770 CARMAN RD, GUILDERLAND, NY, 12303
ZIP lookup: Schenectady, NY
42.72287, -73.936082026-11-022026-11-12
overtureCasa Real Mexican Restaurant
5c04d877-a059-4912-ad71-ace556a176e5
3770 Carman Rd, Guilderland, NY, 12303
ZIP lookup: Schenectady, NY
518806771842.72269, -73.936062026-11-132026-11-13
vtinfoCASA REAL
3221deb82eaf4422
3770 CARMAN RD, SCHENECTADY, NY, 12303518357847542.72264, -73.936072026-11-122026-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
ny-sla CASA REAL LLCvtinfo CASA REAL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
doordash casa real mexican restaurant schenectadyoverture Casa Real Mexican Restaurant0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 8 m apart · name similarity 0.81
doordash casa real mexican restaurant schenectadyvtinfo 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 11 m apart · name similarity 0.49
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 20 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 5 m apart · name similarity 0.49 · phone: differs
doordash casa real mexican restaurant schenectadyny-sla CASA REAL LLC0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (90% confident; asked as a “same-address” pair)
Casa Real name and address match.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 3770 Carman Road, ZIP 12303, about 16 m apart, with no other businesses at the address; the DoorDash listing 'Casa Real Mexican Restaurant' plausibly matches the NY SLA licensee 'CASA REAL LLC' operating a restaurant there, though the city differs (Schenectady vs Guilderland, which share the 12303 ZIP).
pair 343495a2b7e415b2a747

Attributes

Channel
on_premise · restaurant — doordash-url
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": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
22 within 1 mi · 66 within 3 mi
Off / on premise
9 / 7 within 1 mi · 24 / 20 within 3 mi
Selling alcohol
18 within 1 mi · 50 within 3 mi
Nearest
same channel 0.14 mi · licensed 0.14 mi
Setting
suburban (632 people per sq mi)
People within 3 mi
17,863 (13,353 adults 21+, 6,889 households) from 5 tract(s), tracts within 3 mi
Income
per capita $63,490 · median household ~$126,071 (weighted mean of tract medians)
Age and education
median age ~40.3 · bachelor's or higher 61%
Ethnicity
Hispanic 5% · White 75% · Black 4% · Asian 13%
Adults per alcohol outlet
262
Alcohol spend within 3 mi
$6,125,239 a year ($2,681,956 at home, $3,440,433 away) · $120,103 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:10insertoverture 5c04d877-a059-4912-ad71-ace556a176e5 ↔ vtinfo 3221deb82eaf4422same address and namemerged15
2026-11-13 14:10insertny-sla 0340-23-237609 ↔ overture 5c04d877-a059-4912-ad71-ace556a176e5same address and namemerged15
2026-11-13 14:10insertdoordash 28108833 ↔ overture 5c04d877-a059-4912-ad71-ace556a176e5same address and namemerged15
2026-11-12 17:29insertdoordash 28108833 ↔ ny-sla 0340-23-237609Claude judge: samemerged14
2026-11-12 17:29insertdoordash 28108833 ↔ vtinfo 3221deb82eaf4422same address and namemerged14
2026-11-12 14:25insertny-sla 0340-23-237609 ↔ vtinfo 3221deb82eaf4422same address and namemerged12