Casa Stellina

Farmingdale, NY 11735 · O58c37b20993c · 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 Stellina 1 other
the most common name a source states
casa stellina ristorante farmingdale doordash
Street
300 302 Main St 2 other
ny-sla
300 Main St overturevtinfo ×2
302 Main Street doordash
City
Farmingdale
ny-slano other value
State
NY
ny-slano other value
ZIP
11735
ny-slano other value
Pin
40.73232, -73.44599 map
doordashno other value
Phone
5169439111
vtinfono other value
Licences
ny-sla 0340-25-111008
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oecbff2f3aa01; O991ea17082fe; O8f095cfb5e1e

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 stellina ristorante farmingdale
27838985
302 Main Street, Farmingdale, NY, 1173540.73232, -73.445992026-10-082026-11-05
ny-slaCasa Stellina
0340-25-111008
300 302 Main St, Farmingdale, NY, 1173540.73224, -73.445792026-11-022026-11-18
overtureCasa Stellina
e2c05b1e-6be0-48fa-abae-08cc362bc991
300 Main St, Farmingdale, NY, 11735516943911140.73227, -73.446002026-11-132026-11-18
vtinfoCASA STELLINA
dba1a5250ce96ad8
300 MAIN ST, FARMINGDALE, NY, 11735516943911140.73221, -73.446162026-11-122026-11-18

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 Stellinaoverture Casa Stellina1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 18 m apart · name similarity 1.00 · street similarity 0.78
ny-sla Casa Stellinavtinfo CASA STELLINA1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 32 m apart · name similarity 1.00 · street similarity 0.78
overture Casa Stellinavtinfo CASA STELLINA1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 15 m apart · name similarity 1.00 · phone: equal
doordash casa stellina ristorante farmingdaleny-sla Casa Stellina0.69Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Same restaurant name at 300-302 Main St.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records name Casa Stellina in Farmingdale NY at 302 Main Street (B lists it as 300 302 Main St), the ZIP matches, coordinates are about 19 m apart, and no other business is at the address, so the DoorDash restaurant listing and the NY liquor licence are one operation.
pair d78d8db8524a8fd9b7aa
doordash casa stellina ristorante farmingdalevtinfo CASA STELLINA0.69Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Same distinctive restaurant name, adjacent street numbers, 19 m apart.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records are named Casa Stellina in Farmingdale, NY 11735, and their coordinates are about 19 m apart. The street numbers differ (302 vs 300 Main St), but the name match, the close coordinates and the single business at the address support one outlet.
pair 62c88f8aa2a1f8643e7e

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
172 within 1 mi · 643 within 3 mi
Off / on premise
29 / 87 within 1 mi · 148 / 321 within 3 mi
Selling alcohol
122 within 1 mi · 401 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (4,344 people per sq mi)
People within 3 mi
122,834 (95,262 adults 21+, 41,723 households) from 26 tract(s), tracts within 3 mi
Income
per capita $59,995 · median household ~$144,791 (weighted mean of tract medians)
Age and education
median age ~43.5 · bachelor's or higher 46%
Ethnicity
Hispanic 14% · White 71% · Black 6% · Asian 8%
Adults per alcohol outlet
238
Alcohol spend within 3 mi
$41,047,236 a year ($17,586,858 at home, $23,446,498 away) · $102,362 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-18 18:58insertdoordash 27838985 ↔ ny-sla 0340-25-111008Claude judge: samemerged15
2026-11-18 18:58insertdoordash 27838985 ↔ vtinfo dba1a5250ce96ad8Claude judge: samemerged15
2026-11-13 14:10insertny-sla 0340-25-111008 ↔ overture e2c05b1e-6be0-48fa-abae-08cc362bc991street written two waysmerged15
2026-11-13 14:10insertoverture e2c05b1e-6be0-48fa-abae-08cc362bc991 ↔ vtinfo dba1a5250ce96ad8same address and namemerged15
2026-11-12 14:25insertny-sla 0340-25-111008 ↔ vtinfo dba1a5250ce96ad8street written two waysmerged12