STEEL PUB CITY

BUFFALO, NY 14218 · O604ac83ed94b · first seen 2026-11-02
4 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
STEEL PUB CITY 2 other
the most common name a source states
STEEL CITY PUB ny-slaoverture ×2
SAMANTHAJOHN LLC ny-sla (legal name)
Street
1449 ABBOTT RD
ny-slano other value
City
LACKAWANNA 1 other
ny-sla
BUFFALO ab-inbevvtinfo ×2
State
NY
ny-slano other value
ZIP
14218
ny-slano other value
Pin
42.82546, -78.80371 map
overtureno other value
Phone
7167682536
vtinfono other value
Licences
ny-sla 0370-23-328433
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obb71c42997fb; O804ccda331b3; Oc853b32488a2

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-inbevSTEEL PUB CITY
3578674
1449 ABBOTT RD, BUFFALO, NY, 14218
ZIP lookup: Lackawanna, NY
42.82552, -78.803582026-11-112026-11-11
ny-slaSTEEL CITY PUB
legal name: SAMANTHAJOHN LLC
0370-23-328433
1449 ABBOTT RD, LACKAWANNA, NY, 1421842.82549, -78.803502026-11-022026-11-05
overtureSteel City Pub
6266dade-f2f9-40c9-ab12-690629f5bcd5
1449 Abbott Rd, Lackawanna, NY, 14218716768253642.82546, -78.803712026-11-062026-11-06
vtinfoSTEEL PUB CITY
04508bd64ac28975
1449 ABBOTT RD, BUFFALO, NY, 14218
ZIP lookup: Lackawanna, NY
716768253642.82544, -78.803832026-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
ab-inbev STEEL PUB CITYny-sla STEEL CITY PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ab-inbev STEEL PUB CITYoverture Steel City Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ab-inbev STEEL PUB CITYvtinfo STEEL PUB CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ny-sla STEEL CITY PUBoverture Steel City Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ny-sla STEEL CITY PUBvtinfo STEEL PUB CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
overture Steel City Pubvtinfo STEEL PUB CITY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SAMANTHAJOHN LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 7, computed 2026-11-16 17:17.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
52 within 1 mi · 415 within 3 mi
Off / on premise
14 / 25 within 1 mi · 111 / 192 within 3 mi
Selling alcohol
33 within 1 mi · 260 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.07 mi
Setting
suburban (2,980 people per sq mi)
People within 3 mi
84,246 (64,647 adults 21+, 37,587 households) from 24 tract(s), tracts within 3 mi
Income
per capita $35,385 · median household ~$66,475 (weighted mean of tract medians)
Age and education
median age ~40.6 · bachelor's or higher 26%
Ethnicity
Hispanic 9% · White 80% · Black 8% · Asian 1%
Adults per alcohol outlet
248
Alcohol spend within 3 mi
$20,720,134 a year ($9,917,032 at home, $10,793,656 away) · $79,387 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:24insertoverture 6266dade-f2f9-40c9-ab12-690629f5bcd5 ↔ vtinfo 04508bd64ac28975same address and namemerged15
2026-11-15 16:24insertab-inbev 3578674 ↔ vtinfo 04508bd64ac28975same address and namemerged15
2026-11-15 16:24insertny-sla 0370-23-328433 ↔ vtinfo 04508bd64ac28975same address and namemerged15
2026-11-11 12:56insertab-inbev 3578674 ↔ ny-sla 0370-23-328433same address and namemerged12
2026-11-11 12:56insertab-inbev 3578674 ↔ overture 6266dade-f2f9-40c9-ab12-690629f5bcd5same address and namemerged12
2026-11-06 18:13insertny-sla 0370-23-328433 ↔ overture 6266dade-f2f9-40c9-ab12-690629f5bcd5same address and namemerged11