Haggy's Hatchet House

Frewsburg, NY 14738 · O12c3049541e7 · first seen 2026-11-02
2 sourceson premise · baralcohol: 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
Haggy's Hatchet House 1 other
the most common name a source states
Haggy's Hatchet House, LLC ny-sla
Street
84 W Main St
ny-slano other value
City
Frewsburg
ny-slano other value
State
NY
ny-slano other value
ZIP
14738
ny-slano other value
Pin
42.05289, -79.16368 map
overtureno other value
Phone
7169224096
overtureno other value
Licences
ny-sla 0267-25-315299
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O337cb2a0c80f

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-slaHaggy's Hatchet House, LLC
0267-25-315299
84 W Main St, Frewsburg, NY, 1473842.05267, -79.163682026-11-022026-11-06
overtureHaggy's Hatchet House
92528cd1-7a69-4b7b-a16f-40b41e73bdf2
84 W Main St, Frewsburg, NY, 14738716922409642.05289, -79.163682026-11-062026-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
ny-sla Haggy's Hatchet House, LLCoverture Haggy's Hatchet House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
Haggy's Hatchet House, LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on — NY 0267
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
12 within 1 mi · 14 within 3 mi
Off / on premise
3 / 2 within 1 mi · 3 / 3 within 3 mi
Selling alcohol
9 within 1 mi · 11 within 3 mi
Nearest
same channel 0.19 mi · licensed 0.12 mi
Setting
rural (187 people per sq mi)
People within 3 mi
5,282 (3,951 adults 21+, 2,024 households) from 1 tract(s), tracts within 3 mi
Income
per capita $34,880 · median household ~$80,000 (weighted mean of tract medians)
Age and education
median age ~42.7 · bachelor's or higher 21%
Ethnicity
Hispanic 2% · White 97% · Black 0% · Asian 0%
Adults per alcohol outlet
329
Alcohol spend within 3 mi
$1,174,308 a year ($553,239 at home, $620,665 away) · $97,859 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-06 18:13insertny-sla 0267-25-315299 ↔ overture 92528cd1-7a69-4b7b-a16f-40b41e73bdf2same address and namemerged11