Shamrock Wine and Liquor

HIGHLAND, NY 12528 · O3f12de5b9482 · first seen 2026-11-02
3 sourcesoff premise · liquor_storealcohol: 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
Shamrock Wine and Liquor 2 other
the most common name a source states
SHAMROCK WINE & LIQUOR vtinfo
SHAMROCK WINE & LIQUOR LLC ny-sla
Street
3565 ROUTE 9W 2 other
ny-sla
3565 US Highway 9W overture
3565 US HWY 9W vtinfo
City
HIGHLAND
ny-slano other value
State
NY
ny-slano other value
ZIP
12528
ny-slano other value
Pin
41.71412, -73.96408 map 1 other
overture
52 m away vtinfo
Phone
8456919195
vtinfono other value
Licences
ny-sla 0100-22-216250
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oab01dae45db2; O96bdf8447eb2

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-slaSHAMROCK WINE & LIQUOR LLC
0100-22-216250
3565 ROUTE 9W, HIGHLAND, NY, 1252841.71446, -73.964102026-11-022026-11-18
overtureShamrock Wine and Liquor
d86376d1-4f93-419e-922c-c53ea9699222
3565 US Highway 9W, Highland, NY, 12528845691919541.71412, -73.964082026-11-132026-11-13
vtinfoSHAMROCK WINE & LIQUOR
252fe61ceec489f4
3565 US HWY 9W, HIGHLAND, NY, 12528845691919541.71451, -73.964422026-11-132026-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 SHAMROCK WINE & LIQUOR LLCvtinfo SHAMROCK WINE & LIQUOR1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (97% confident; asked as a “proximity” pair)
Same name and address, Route 9W equals US Hwy 9W.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records are Shamrock Wine & Liquor at the same Highland, NY 12528 address (3565 Route 9W is US Hwy 9W), with near-identical coordinates 27 m apart, the name matching the legal entity SHAMROCK WINE & LIQUOR LLC, and only one business at that address.
pair d774fab276486feb0336
overture Shamrock Wine and Liquorvtinfo SHAMROCK WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 52 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SHAMROCK WINE & LIQUOR LLC — 1 outlets in the master under this operator
Licence privileges
wine_off, spirits_off — NY 0100
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
45 within 1 mi · 293 within 3 mi
Off / on premise
15 / 16 within 1 mi · 53 / 139 within 3 mi
Selling alcohol
33 within 1 mi · 189 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (1,653 people per sq mi)
People within 3 mi
46,742 (34,916 adults 21+, 18,360 households) from 11 tract(s), tracts within 3 mi
Income
per capita $42,364 · median household ~$67,623 (weighted mean of tract medians)
Age and education
median age ~36.1 · bachelor's or higher 33%
Ethnicity
Hispanic 21% · White 48% · Black 25% · Asian 3%
Adults per alcohol outlet
184
Alcohol spend within 3 mi
$11,286,860 a year ($5,247,587 at home, $6,034,277 away) · $59,405 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:58insertny-sla 0100-22-216250 ↔ vtinfo 252fe61ceec489f4Claude judge: samemerged15
2026-11-13 14:10insertoverture d86376d1-4f93-419e-922c-c53ea9699222 ↔ vtinfo 252fe61ceec489f4same address and namemerged15