Hampshire Counrty Club

MAMARONECK, NY 10543 · O137a5e842260 · first seen 2026-11-02
3 sourceson premise · predictedalcohol: 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
Hampshire Counrty Club 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Hampshire Country Club overturevtinfo ×2
ORIENTA OPERATING COMPANY LLC ny-sla (legal name)
Street
1107 DELANCEY COVE RD 1 other
ny-sla
1025 Cove Rd overturevtinfo ×2
City
MAMARONECK
ny-slano other value
State
NY
ny-slano other value
ZIP
10543
ny-slano other value
Pin
40.93378, -73.73573 map 2 other
overture
88 m away ny-sla
160 m away vtinfo
Phone
9146984610
vtinfono other value
Licences
ny-sla 0340-23-134401
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O6862ed119417; O7319e5028789

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-slaHAMPSHIRE COUNRTY CLUB
legal name: ORIENTA OPERATING COMPANY LLC
0340-23-134401
1107 DELANCEY COVE RD, MAMARONECK, NY, 1054340.93328, -73.734922026-11-022026-11-18
overtureHampshire Country Club
9c3c5a76-0451-4eb1-b7db-8196fa47d0a1
1025 Cove Rd, Mamaroneck, NY, 10543914698461040.93378, -73.735732026-11-132026-11-13
vtinfoHAMPSHIRE COUNTRY CLUB
e30106071deb6198
1025 COVE RD, MAMARONECK, NY, 10543914698461040.93412, -73.733892026-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
overture Hampshire Country Clubvtinfo HAMPSHIRE COUNTRY CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 160 m apart · name similarity 1.00 · phone: equal
ny-sla HAMPSHIRE COUNRTY CLUBvtinfo HAMPSHIRE COUNTRY CLUB0.73Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “near” pair)
Same country club name, nearby, distinctive
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name the same single-site business, Hampshire Country Club, in Mamaroneck 10543, with coordinates about 128 m apart and no other business at the address; the street numbers differ (1107 Delancey Cove Rd vs 1025 Cove Rd), which keeps confidence below certainty.
pair 99fc15e1f33c5f8340e1

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ORIENTA OPERATING COMPANY LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
93 within 1 mi · 569 within 3 mi
Off / on premise
14 / 53 within 1 mi · 97 / 304 within 3 mi
Selling alcohol
46 within 1 mi · 348 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.05 mi
Setting
urban (3,238 people per sq mi)
People within 3 mi
91,558 (66,054 adults 21+, 33,684 households) from 18 tract(s), tracts within 3 mi
Income
per capita $101,757 · median household ~$171,799 (weighted mean of tract medians)
Age and education
median age ~41.1 · bachelor's or higher 66%
Ethnicity
Hispanic 17% · White 63% · Black 10% · Asian 6%
Adults per alcohol outlet
189
Alcohol spend within 3 mi
$33,790,109 a year ($14,270,104 at home, $19,511,426 away) · $96,820 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 0340-23-134401 ↔ vtinfo e30106071deb6198Claude judge: samemerged15
2026-11-13 14:10insertoverture 9c3c5a76-0451-4eb1-b7db-8196fa47d0a1 ↔ vtinfo e30106071deb6198same address and namemerged15