THE WITCHES BREW

CLARENCE, NY 14031 · O035dcf3d2168 · first seen 2026-11-02
3 sourceson premise · predictedalcohol: 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
THE WITCHES BREW 2 other
the most common name a source states
GREAT PUMPKIN FARM ab-inbevoverture ×2
GREAT PUMPKIN FARM LLC ny-sla (legal name) ×2
Street
11199 MAIN ST
ny-slano other value
City
CLARENCE
ny-slano other value
State
NY
ny-slano other value
ZIP
14031
ny-slano other value
Pin
42.98495, -78.56828 map 1 other
overture
247 m away ab-inbev
Phone
7167591929
overtureno other value
Licences
ny-sla 0370-24-323530 · ny-sla 0370-24-323530-01
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O82c779f809d4; O3f6e2e5281f5; Od5bd77d3469a

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
ab-inbevGREAT PUMPKIN FARM
3926325
11199 MAIN ST, CLARENCE, NY, 1403142.98420, -78.571142026-11-112026-11-11
ny-slaTHE WITCHES BREW
legal name: GREAT PUMPKIN FARM LLC
0370-24-323530
11199 MAIN ST, CLARENCE, NY, 1403142.98506, -78.568282026-11-022026-11-05
ny-slaTHE WITCHES BREW
legal name: GREAT PUMPKIN FARM LLC
0370-24-323530-01
11199 MAIN ST, CLARENCE, NY, 1403142.98506, -78.568282026-11-022026-11-05
overtureGreat Pumpkin Farm
413c1d7d-8a50-40af-a72d-ac292b42f4e4
11199 Main St, Clarence, NY, 14031716759192942.98495, -78.568282026-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
ab-inbev GREAT PUMPKIN FARMny-sla THE WITCHES BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 252 m apart · matched through the licence's legal name: GREAT PUMPKIN FARM LLC · name similarity 1.00
ab-inbev GREAT PUMPKIN FARMny-sla THE WITCHES BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 252 m apart · matched through the licence's legal name: GREAT PUMPKIN FARM LLC · name similarity 1.00
ab-inbev GREAT PUMPKIN FARMoverture Great Pumpkin Farm1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 247 m apart · name similarity 1.00
ny-sla THE WITCHES BREWny-sla THE WITCHES BREW1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla THE WITCHES BREWoverture Great Pumpkin Farm1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · matched through the licence's legal name: GREAT PUMPKIN FARM LLC · name similarity 1.00
ny-sla THE WITCHES BREWoverture Great Pumpkin Farm1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · matched through the licence's legal name: GREAT PUMPKIN FARM LLC · name similarity 1.00

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
GREAT PUMPKIN FARM LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370; NY 0423 (add-on: follows the base licence)
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
0 within 1 mi · 41 within 3 mi
Off / on premise
0 / 0 within 1 mi · 9 / 16 within 3 mi
Selling alcohol
0 within 1 mi · 34 within 3 mi
Nearest
same channel none within 3 mi · licensed 1.01 mi
Setting
rural (455 people per sq mi)
People within 3 mi
12,868 (10,037 adults 21+, 5,416 households) from 3 tract(s), tracts within 3 mi
Income
per capita $61,799 · median household ~$99,339 (weighted mean of tract medians)
Age and education
median age ~52.6 · bachelor's or higher 44%
Ethnicity
Hispanic 3% · White 90% · Black 0% · Asian 0%
Adults per alcohol outlet
287
Alcohol spend within 3 mi
$4,191,001 a year ($1,873,101 at home, $2,316,097 away) · $119,743 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-11 12:56insertab-inbev 3926325 ↔ ny-sla 0370-24-323530-01same address and namemerged12
2026-11-11 12:56insertab-inbev 3926325 ↔ ny-sla 0370-24-323530same address and namemerged12
2026-11-11 12:56insertab-inbev 3926325 ↔ overture 413c1d7d-8a50-40af-a72d-ac292b42f4e4same address and namemerged12
2026-11-06 18:13insertny-sla 0370-24-323530-01 ↔ overture 413c1d7d-8a50-40af-a72d-ac292b42f4e4same address and namemerged11
2026-11-06 18:13insertny-sla 0370-24-323530 ↔ overture 413c1d7d-8a50-40af-a72d-ac292b42f4e4same address and namemerged11
2026-11-03 13:33backfillny-sla 0370-24-323530 ↔ ny-sla 0370-24-323530-01one store listed twicemerged