HAMBURG BREWING COMPANY

HAMBURG, NY 14075 · O051e2a03659d · first seen 2026-11-02
4 sourcesoff premise · liquor_storealcohol: licensed7 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
HAMBURG BREWING COMPANY 1 other
the most common name a source states
HAMBURG BREWING COMPANY, LLC ttb
Street
6553 Boston State Rd 1 other
ny-sla
6553 BOSTON STATE RD RD ttb
City
Hamburg
ny-slano other value
State
NY
ny-slano other value
ZIP
14075
ny-slano other value
Pin
42.71100, -78.80285 map 2 other
overture
75 m away ttb
102 m away vtinfo
Phone
7168122002 1 other
vtinfo
7166493249 overture
Licences
ny-sla 0005-24-305367 · ny-sla 0014-16-304965 · ny-sla 0015-16-307935 · ny-sla 0033-26-337516 · ny-sla 0267-23-337998 · ny-sla 0370-23-329031 · ttb NY-W-21333
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe13de13102f4; O466455ac3205; O98940a546ab0; Ob466f0a5f1c4; Oaad1524cc8fe; Oaf7f28949bcc; O45a8b9a587e5; O8e7348a31acc

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-slaHAMBURG BREWING COMPANY
0005-24-305367
6553 Boston State Rd, Hamburg, NY, 1407542.71124, -78.803102026-11-022026-11-06
ny-slaHAMBURG BREWING COMPANY
0014-16-304965
6553 BOSTON STATE RD, HAMBURG, NY, 1407542.71124, -78.803102026-11-022026-11-06
ny-slaHAMBURG BREWING COMPANY
0015-16-307935
6553 BOSTON STATE RD, HAMBURG, NY, 1407542.71124, -78.803102026-11-022026-11-06
ny-slaHamburg Brewing Company
0033-26-337516
6553 Boston State Rd, Hamburg, NY, 1407542.71124, -78.803102026-11-022026-11-06
ny-slaHAMBURG BREWING COMPANY
0267-23-337998
6553 BOSTON STATE RD, HAMBURG, NY, 1407542.71124, -78.803102026-11-022026-11-06
ny-slaHAMBURG BREWING COMPANY
0370-23-329031
6553 BOSTON STATE RD, HAMBURG, NY, 1407542.71124, -78.803102026-11-022026-11-06
overtureHamburg Brewing Company
497c325a-b8dd-4c6f-b155-1e5a414e2206
6553 Boston State Rd, Hamburg, NY, 14075716649324942.71100, -78.802852026-11-062026-11-06
ttbHAMBURG BREWING COMPANY, LLC
NY-W-21333
6553 BOSTON STATE RD RD, HAMBURG, NY, 1407542.71110, -78.803752026-11-032026-11-06
vtinfoHAMBURG BREWING COMPANY
e0b644df58db30ca
6553 BOSTON STATE RD, HAMBURG, NY, 14075716812200242.71010, -78.802592026-11-152026-11-15

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 [Horseshoe - Additional Bar]overture Hamburg Brewing Company1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · matched through the licence's legal name: HAMBURG BREWING COMPANY, LLC · name similarity 1.00
ny-sla [Horseshoe - Additional Bar]ttb HAMBURG BREWING COMPANY, LLC1.00street written two waysheld same-source-conflictname Jaro-Winkler 1.00 · matched on zip · pins 56 m apart · name similarity 1.00 · street similarity 0.91
ny-sla [Horseshoe - Additional Bar]vtinfo HAMBURG BREWING COMPANY1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · matched through the licence's legal name: HAMBURG BREWING COMPANY, LLC · name similarity 1.00
ny-sla {OUTSIDE} ADD BARoverture Hamburg Brewing Company1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · matched through the licence's legal name: HAMBURG BREWING COMPANY, LLC · name similarity 1.00
ny-sla {OUTSIDE} ADD BARttb HAMBURG BREWING COMPANY, LLC1.00street written two waysheld same-source-conflictname Jaro-Winkler 1.00 · matched on zip · pins 56 m apart · name similarity 1.00 · street similarity 0.91
ny-sla {OUTSIDE} ADD BARvtinfo HAMBURG BREWING COMPANY1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · matched through the licence's legal name: HAMBURG BREWING COMPANY, LLC · name similarity 1.00
ny-sla (PATIO ADD BAR)overture Hamburg Brewing Company1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · matched through the licence's legal name: HAMBURG BREWING COMPANY, LLC · name similarity 1.00
ny-sla (PATIO ADD BAR)ttb HAMBURG BREWING COMPANY, LLC1.00street written two waysheld same-source-conflictname Jaro-Winkler 1.00 · matched on zip · pins 56 m apart · name similarity 1.00 · street similarity 0.91
ny-sla (PATIO ADD BAR)vtinfo HAMBURG BREWING COMPANY1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · matched through the licence's legal name: HAMBURG BREWING COMPANY, LLC · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYny-sla HAMBURG BREWING COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla HAMBURG BREWING COMPANYny-sla HAMBURG BREWING COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla HAMBURG BREWING COMPANYny-sla Hamburg Brewing Company1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla HAMBURG BREWING COMPANYny-sla HAMBURG BREWING COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla HAMBURG BREWING COMPANYny-sla HAMBURG BREWING COMPANY1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla HAMBURG BREWING COMPANYoverture Hamburg Brewing Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ny-sla HAMBURG BREWING COMPANYvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYoverture Hamburg Brewing Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ny-sla HAMBURG BREWING COMPANYvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYoverture Hamburg Brewing Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ny-sla HAMBURG BREWING COMPANYvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · name similarity 1.00
ny-sla Hamburg Brewing Companyoverture Hamburg Brewing Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla Hamburg Brewing Companyttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ny-sla Hamburg Brewing Companyvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYoverture Hamburg Brewing Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ny-sla HAMBURG BREWING COMPANYvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYoverture Hamburg Brewing Company1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla HAMBURG BREWING COMPANYttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · name similarity 1.00 · street similarity 0.91
ny-sla HAMBURG BREWING COMPANYvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 134 m apart · name similarity 1.00
overture Hamburg Brewing Companyttb HAMBURG BREWING COMPANY, LLC1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 75 m apart · name similarity 1.00 · street similarity 0.91
overture Hamburg Brewing Companyvtinfo HAMBURG BREWING COMPANY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 102 m apart · name similarity 1.00 · phone: differs
ttb HAMBURG BREWING COMPANY, LLCvtinfo HAMBURG BREWING COMPANY1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 147 m apart · name similarity 1.00 · street similarity 0.91

Attributes

Channel
off_premise · liquor_store — name
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HAMBURG BREWING COMPANY — 4 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0005; NY 0014; NY 0015; NY 0033; NY 0267; NY 0370
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
5 within 1 mi · 139 within 3 mi
Off / on premise
1 / 0 within 1 mi · 34 / 52 within 3 mi
Selling alcohol
5 within 1 mi · 105 within 3 mi
Nearest
same channel 0.47 mi · licensed 0.02 mi
Setting
suburban (801 people per sq mi)
People within 3 mi
22,639 (17,818 adults 21+, 9,756 households) from 4 tract(s), tracts within 3 mi
Income
per capita $52,959 · median household ~$104,619 (weighted mean of tract medians)
Age and education
median age ~45.5 · bachelor's or higher 51%
Ethnicity
Hispanic 2% · White 93% · Black 1% · Asian 1%
Adults per alcohol outlet
168
Alcohol spend within 3 mi
$7,810,601 a year ($3,499,615 at home, $4,308,190 away) · $73,685 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-15 16:24insertttb NY-W-21333 ↔ vtinfo e0b644df58db30castreet written two waysmerged15
2026-11-15 16:24insertny-sla 0005-24-305367 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-15 16:24insertny-sla 0014-16-304965 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-15 16:24insertoverture 497c325a-b8dd-4c6f-b155-1e5a414e2206 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-15 16:24insertny-sla 0423-23-328915 ↔ vtinfo e0b644df58db30casame address and nameheld: same-source-conflict15
2026-11-15 16:24insertny-sla 0340-23-329031-01 ↔ vtinfo e0b644df58db30casame address and nameheld: same-source-conflict15
2026-11-15 16:24insertny-sla 0370-23-329031 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-15 16:24insertny-sla 0033-26-337516 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-15 16:24insertny-sla 0015-16-307935 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-15 16:24insertny-sla 0423-23-338991 ↔ vtinfo e0b644df58db30casame address and nameheld: same-source-conflict15
2026-11-15 16:24insertny-sla 0267-23-337998 ↔ vtinfo e0b644df58db30casame address and namemerged15
2026-11-06 18:13insertoverture 497c325a-b8dd-4c6f-b155-1e5a414e2206 ↔ ttb NY-W-21333street written two waysmerged11
2026-11-06 18:13insertny-sla 0423-23-338991 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0423-23-328915 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0340-23-329031-01 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0370-23-329031 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and namemerged11
2026-11-06 18:13insertny-sla 0267-23-337998 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and namemerged11
2026-11-06 18:13insertny-sla 0033-26-337516 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and namemerged11
2026-11-06 18:13insertny-sla 0015-16-307935 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and namemerged11
2026-11-06 18:13insertny-sla 0005-24-305367 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and namemerged11
2026-11-06 18:13insertny-sla 0014-16-304965 ↔ overture 497c325a-b8dd-4c6f-b155-1e5a414e2206same address and namemerged11
2026-11-05 16:28backfillny-sla 0340-23-329031-01 ↔ ttb NY-W-21333street written two waysheld: same-source-conflict
2026-11-05 16:28backfillny-sla 0423-23-328915 ↔ ttb NY-W-21333street written two waysheld: same-source-conflict
2026-11-05 16:28backfillny-sla 0423-23-338991 ↔ ttb NY-W-21333street written two waysheld: same-source-conflict
2026-11-03 14:30backfillny-sla 0005-24-305367 ↔ ttb NY-W-21333street written two waysmerged
2026-11-03 14:30backfillny-sla 0014-16-304965 ↔ ttb NY-W-21333street written two waysmerged
2026-11-03 14:30backfillny-sla 0370-23-329031 ↔ ttb NY-W-21333street written two waysmerged
2026-11-03 14:30backfillny-sla 0267-23-337998 ↔ ttb NY-W-21333street written two waysmerged
2026-11-03 14:30backfillny-sla 0015-16-307935 ↔ ttb NY-W-21333street written two waysmerged
2026-11-03 14:30backfillny-sla 0033-26-337516 ↔ ttb NY-W-21333street written two waysmerged
2026-11-03 13:33backfillny-sla 0005-24-305367 ↔ ny-sla 0370-23-329031one store listed twicemerged
2026-11-03 13:33backfillny-sla 0005-24-305367 ↔ ny-sla 0267-23-337998one store listed twicemerged
2026-11-03 13:33backfillny-sla 0005-24-305367 ↔ ny-sla 0033-26-337516one store listed twicemerged
2026-11-03 13:33backfillny-sla 0005-24-305367 ↔ ny-sla 0015-16-307935one store listed twicemerged
2026-11-03 13:33backfillny-sla 0005-24-305367 ↔ ny-sla 0014-16-304965one store listed twicemerged