Pierce Ave Bar & Grill

Hamburg, NY 14075 · O36bc7de7f6f3 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: 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
Pierce Ave Bar & Grill 3 other
the most common name a source states
Pierce Ave Bar Grill toast (legal name)
Pierce Ave Bar Grill 14 Pierce Avenue toast
pierce avenue bar and grille hamburg doordash
Street
14 Pierce Avenue 1 other
ny-sla
14 PIERCE AVE ab-inbevdoordashoverturevtinfo ×4
City
Hamburg
ny-slano other value
State
NY
ny-slano other value
ZIP
14075
ny-slano other value
Pin
42.71613, -78.83947 map
toastno other value
Phone
7162021402
vtinfono other value
Licences
ny-sla 0340-26-336733
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe2647981ede5; Ob857c5c91588; Oaf83e2af48fd; Ocd5e974455b4; O9ac801aefcfd

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-inbevPIERCE AVE BAR & GRILL
4875523
14 PIERCE AVE, HAMBURG, NY, 1407542.71626, -78.839982026-11-112026-11-16
doordashpierce avenue bar and grille hamburg
35684609
14 Pierce Ave, Hamburg, NY, 1407542.71598, -78.839652026-10-082026-11-14
ny-slaPierce Ave Bar & Grill
0340-26-336733
14 Pierce Avenue, Hamburg, NY, 1407542.71609, -78.839452026-11-022026-11-16
overturePierce Ave Bar & Grill
cbdd39f8-f7eb-4c4a-b2a4-f6585a738701
14 Pierce Ave, Hamburg, NY, 14075716202140242.71599, -78.839582026-11-062026-11-16
toastPierce Ave Bar Grill 14 Pierce Avenue
legal name: Pierce Ave Bar Grill
214da5e1-d728-4e6b-acbc-77a631d8b624
14 Pierce Avenue, Hamburg, NY, 14075716202140242.71613, -78.839472026-11-062026-11-16
vtinfoPIERCE AVE BAR & GRILL
dd761c2788fc9ba5
14 PIERCE AVE, HAMBURG, NY, 14075716202140242.71613, -78.839472026-11-152026-11-16

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 PIERCE AVE BAR & GRILLny-sla Pierce Ave Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 47 m apart · name similarity 1.00
ab-inbev PIERCE AVE BAR & GRILLoverture Pierce Ave Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev PIERCE AVE BAR & GRILLtoast Pierce Ave Bar Grill 14 Pierce Avenue1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · matched through the licence's legal name: Pierce Ave Bar Grill · name similarity 1.00
ab-inbev PIERCE AVE BAR & GRILLvtinfo PIERCE AVE BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ny-sla Pierce Ave Bar & Grilloverture Pierce Ave Bar & Grill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ny-sla Pierce Ave Bar & Grilltoast Pierce Ave Bar Grill 14 Pierce Avenue1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · matched through the licence's legal name: Pierce Ave Bar Grill · name similarity 1.00
ny-sla Pierce Ave Bar & Grillvtinfo PIERCE AVE BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
overture Pierce Ave Bar & Grilltoast Pierce Ave Bar Grill 14 Pierce Avenue1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · matched through the licence's legal name: Pierce Ave Bar Grill · name similarity 1.00 · phone: equal
overture Pierce Ave Bar & Grillvtinfo PIERCE AVE BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00 · phone: equal
toast Pierce Ave Bar Grill 14 Pierce Avenuevtinfo PIERCE AVE BAR & GRILL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · matched through the licence's legal name: Pierce Ave Bar Grill · name similarity 1.00 · phone: equal
ab-inbev PIERCE AVE BAR & GRILLdoordash pierce avenue bar and grille hamburg0.62one name contains the other, same addressmergedjudge: None · pair_id: a7a0b2d2fb4eab9f7927 · person: None · rule: names contained at one address · stratum: near
doordash pierce avenue bar and grille hamburgny-sla Pierce Ave Bar & Grill0.62one name contains the other, same addressmergedjudge: None · pair_id: 485fec5dced76c473dd7 · person: None · rule: names contained at one address · stratum: near
doordash pierce avenue bar and grille hamburgvtinfo PIERCE AVE BAR & GRILL0.62one name contains the other, same addressmergedjudge: None · pair_id: 7a5c4f1e73a9ccdd9540 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
71 within 1 mi · 165 within 3 mi
Off / on premise
13 / 28 within 1 mi · 34 / 69 within 3 mi
Selling alcohol
55 within 1 mi · 118 within 3 mi
Nearest
same channel 0.13 mi · licensed 0.01 mi
Setting
suburban (785 people per sq mi)
People within 3 mi
22,182 (17,087 adults 21+, 9,548 households) from 4 tract(s), tracts within 3 mi
Income
per capita $50,663 · median household ~$101,600 (weighted mean of tract medians)
Age and education
median age ~45.6 · bachelor's or higher 47%
Ethnicity
Hispanic 2% · White 94% · Black 2% · Asian 1%
Adults per alcohol outlet
144
Alcohol spend within 3 mi
$7,373,484 a year ($3,328,399 at home, $4,042,226 away) · $61,962 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-16 14:56insertdoordash 35684609 ↔ ny-sla 0340-26-336733one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4875523 ↔ doordash 35684609one name contains the other, same addressmerged15
2026-11-16 14:56insertdoordash 35684609 ↔ vtinfo dd761c2788fc9ba5one name contains the other, same addressmerged15
2026-11-15 16:24inserttoast 214da5e1-d728-4e6b-acbc-77a631d8b624 ↔ vtinfo dd761c2788fc9ba5same address and namemerged15
2026-11-15 16:24insertny-sla 0340-26-336733 ↔ vtinfo dd761c2788fc9ba5same address and namemerged15
2026-11-15 16:24insertab-inbev 4875523 ↔ vtinfo dd761c2788fc9ba5same address and namemerged15
2026-11-15 16:24insertoverture cbdd39f8-f7eb-4c4a-b2a4-f6585a738701 ↔ vtinfo dd761c2788fc9ba5same address and namemerged15
2026-11-12 14:25insertab-inbev 4875523 ↔ toast 214da5e1-d728-4e6b-acbc-77a631d8b624same address and namemerged12
2026-11-12 14:25insertoverture cbdd39f8-f7eb-4c4a-b2a4-f6585a738701 ↔ toast 214da5e1-d728-4e6b-acbc-77a631d8b624same address and namemerged12
2026-11-12 14:25insertny-sla 0340-26-336733 ↔ toast 214da5e1-d728-4e6b-acbc-77a631d8b624same address and namemerged12
2026-11-11 12:56insertab-inbev 4875523 ↔ overture cbdd39f8-f7eb-4c4a-b2a4-f6585a738701same address and namemerged12
2026-11-11 12:56insertab-inbev 4875523 ↔ ny-sla 0340-26-336733same address and namemerged12
2026-11-06 18:13insertny-sla 0340-26-336733 ↔ overture cbdd39f8-f7eb-4c4a-b2a4-f6585a738701same address and namemerged11