Apple Barrel Orchards

Penn Yan, NY 14527 · O71978f788711 · first seen 2026-11-02
4 sourcesoff premisealcohol: licensed2 licences

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
Apple Barrel Orchards 1 other
the most common name a source states
A AND M HILLER LLC inspections (legal name)ny-sla (legal name)ttb (legal name) ×3
Street
2673 SAND HILL RD
ny-slano other value
City
PENN YAN
ny-slano other value
State
NY
ny-slano other value
ZIP
14527
ny-slano other value
Pin
42.65963, -77.08489 map 3 other
overture
62 m away inspections
62 m away ny-sla
130 m away ttb
Phone
3155362744
overtureno other value
Licences
ny-sla 0032-23-339644 · ttb NY-W-21416
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe96f4782cb02; Oc5b1563e1a95; Odd20670b975c

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
inspectionsAPPLE BARREL ORCHARDS
legal name: A AND M HILLER LLC
inspections|nys-retail|758959
2673 SAND HILL RD, Penn Yan, NY, 1452742.66015, -77.084612026-11-192026-11-19
ny-slaAPPLE BARREL ORCHARDS
legal name: A AND M HILLER LLC
0032-23-339644
2673 SAND HILL RD, PENN YAN, NY, 1452742.66015, -77.084612026-11-022026-11-06
overtureApple Barrel Orchards
36b4e3a9-8ee6-4890-96c7-cbc57d59ff73
2673 Sand Hill Rd, Penn Yan, NY, 14527315536274442.65963, -77.084892026-11-062026-11-06
ttbApple Barrel Orchards
legal name: A AND M HILLER LLC
NY-W-21416
2673 SAND HILL RD, PENN YAN, NY, 1452742.65911, -77.083472026-11-032026-11-06

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
inspections APPLE BARREL ORCHARDSny-sla APPLE BARREL ORCHARDS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
inspections APPLE BARREL ORCHARDSoverture Apple Barrel Orchards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00
inspections APPLE BARREL ORCHARDSttb Apple Barrel Orchards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 148 m apart · name similarity 1.00
ny-sla APPLE BARREL ORCHARDSoverture Apple Barrel Orchards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 62 m apart · name similarity 1.00
ny-sla APPLE BARREL ORCHARDSttb Apple Barrel Orchards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Apple Barrel Orchardsttb Apple Barrel Orchards1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 130 m apart · name similarity 1.00

Attributes

Channel
off_premise — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
A AND M HILLER LLC — 1 outlets in the master under this operator
Licence privileges
none — NY 0032
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
5 within 1 mi · 78 within 3 mi
Off / on premise
0 / 2 within 1 mi · 22 / 21 within 3 mi
Selling alcohol
3 within 1 mi · 61 within 3 mi
Nearest
same channel 1.37 mi · licensed 0.69 mi
Setting
rural (75 people per sq mi)
People within 3 mi
2,132 (1,587 adults 21+, 977 households) from 1 tract(s), tracts within 3 mi
Income
per capita $36,033 · median household ~$65,925 (weighted mean of tract medians)
Age and education
median age ~43.8 · bachelor's or higher 20%
Ethnicity
Hispanic 12% · White 88% · Black 0% · Asian 0%
Adults per alcohol outlet
26
Alcohol spend within 3 mi
$530,937 a year ($255,707 at home, $275,024 away) · $8,563 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-19 20:37insertinspections inspections|nys-retail|758959 ↔ ny-sla 0032-23-339644same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|758959 ↔ ttb NY-W-21416same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|758959 ↔ overture 36b4e3a9-8ee6-4890-96c7-cbc57d59ff73same address and namemerged17
2026-11-06 18:13insertny-sla 0032-23-339644 ↔ overture 36b4e3a9-8ee6-4890-96c7-cbc57d59ff73same address and namemerged11
2026-11-06 18:13insertoverture 36b4e3a9-8ee6-4890-96c7-cbc57d59ff73 ↔ ttb NY-W-21416same address and namemerged11
2026-11-03 13:33backfillny-sla 0032-23-339644 ↔ ttb NY-W-21416same address and namemerged