TOPS XPRESS

HAMBURG, NY 14075 · Oa3e907c25b16 · first seen 2026-11-02
3 sourcesoff premise · predictedalcohol: 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
TOPS XPRESS 2 other
the most common name a source states
Tops Markets LLC ny-sla (legal name)
TOPS XPRESS #215 ny-sla
Street
4250 MCKINLEY PARKWAY 1 other
ny-sla
4250 MCKINLEY PKWY ab-inbevvtinfo ×2
City
HAMBURG
ny-slano other value
State
NY
ny-slano other value
ZIP
14075
ny-slano other value
Pin
42.76841, -78.81201 map 1 other
ny-sla
115 m away vtinfo
Phone
7165153225
vtinfono other value
Licences
ny-sla 0081-21-312146
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oad5b50b2b655; Oab14292fd5ba

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-inbevTOPS XPRESS
4024514
4250 MCKINLEY PKWY, HAMBURG, NY, 1407542.76834, -78.812012026-11-112026-11-15
ny-slaTOPS XPRESS #215
legal name: Tops Markets LLC
0081-21-312146
4250 MCKINLEY PARKWAY, HAMBURG, NY, 1407542.76841, -78.812012026-11-022026-11-16
vtinfoTOPS XPRESS
d0a6baec847c1393
4250 MCKINLEY PKWY, HAMBURG, NY, 14075716515322542.76924, -78.812852026-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
doordash tops markets hamburgny-sla TOPS XPRESS #2151.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 126 m apart · matched through the licence's legal name: Tops Markets LLC · name similarity 1.00
ab-inbev TOPSvtinfo TOPS XPRESS0.52one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 264f4886084f1d2ca729 · person: None · rule: names contained at one address · stratum: near
ab-inbev TOPS XPRESSvtinfo TOPS0.52one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: b8c7257c28b9f6f8a340 · person: None · rule: names contained at one address · stratum: near
ab-inbev TOPSny-sla TOPS XPRESS #2150.50one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: fa3b088cd16743317dc7 · person: None · rule: names contained at one address · stratum: near
ny-sla TOPS XPRESS #215vtinfo TOPS0.50one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 2fde771c257a6511ab8f · person: None · rule: names contained at one address · stratum: near
ab-inbev TOPS XPRESSny-sla TOPS #2150.38one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: d8a474fb6ac31fd975a8 · person: None · rule: names contained at one address · stratum: same-address
ny-sla TOPS #215vtinfo TOPS XPRESS0.38one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: b5d433df338611141f40 · person: None · rule: names contained at one address · stratum: same-address
ab-inbev TOPS XPRESSdoordash tops markets hamburg0.34Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Same address; Tops Xpress and Tops Markets same banner.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at 4250 McKinley Pkwy, Hamburg NY 14075 with coordinates about 125 m apart, and the only business at that address is a Tops store; 'Tops Xpress' and 'tops markets hamburg' are the same chain outlet listed under different names (a Tops Markets location and its Xpress/alternate listing), with no competing business at the address.
pair 23822aaf860fb94d751c
ab-inbev TOPS XPRESSvtinfo TOPS XPRESS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 121 m apart · name similarity 1.00
ab-inbev TOPS XPRESSny-sla TOPS XPRESS #2150.76one name contains the other, same addressmergedjudge: None · pair_id: c3ea690d07b60415e61d · person: None · rule: names contained at one address · stratum: near
ny-sla TOPS XPRESS #215vtinfo TOPS XPRESS0.76one name contains the other, same addressmergedjudge: None · pair_id: af1ccb42f18696d91e68 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
Tops Markets LLC — 105 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 7, computed 2026-11-16 17:19.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
28 within 1 mi · 272 within 3 mi
Off / on premise
7 / 13 within 1 mi · 70 / 122 within 3 mi
Selling alcohol
17 within 1 mi · 169 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.08 mi
Setting
suburban (1,127 people per sq mi)
People within 3 mi
31,858 (25,264 adults 21+, 14,592 households) from 8 tract(s), tracts within 3 mi
Income
per capita $43,794 · median household ~$79,314 (weighted mean of tract medians)
Age and education
median age ~45.3 · bachelor's or higher 29%
Ethnicity
Hispanic 5% · White 89% · Black 2% · Asian 1%
Adults per alcohol outlet
149
Alcohol spend within 3 mi
$9,096,039 a year ($4,243,163 at home, $4,848,089 away) · $53,506 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:56insertab-inbev 4024514 ↔ ny-sla 0081-21-308654one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertny-sla 0081-21-308654 ↔ vtinfo d0a6baec847c1393one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 2632817 ↔ ny-sla 0081-21-312146one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertny-sla 0081-21-312146 ↔ vtinfo 5c894c28d38dc28eone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 2632817 ↔ vtinfo d0a6baec847c1393one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4024514 ↔ vtinfo 5c894c28d38dc28eone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4024514 ↔ ny-sla 0081-21-312146one name contains the other, same addressmerged15
2026-11-16 14:56insertny-sla 0081-21-312146 ↔ vtinfo d0a6baec847c1393one name contains the other, same addressmerged15
2026-11-15 16:24updatedoordash 34105737 ↔ ny-sla 0081-21-312146same address and nameheld: same-source-conflict15
2026-11-15 16:24insertab-inbev 4024514 ↔ vtinfo d0a6baec847c1393same address and namemerged15
2026-11-14 20:23updatedoordash 34105737 ↔ ny-sla 0081-21-312146same address and nameheld: same-source-conflict15
2026-11-12 17:29insertab-inbev 4024514 ↔ doordash 34105737Claude judge: sameheld: same-source-conflict14
2026-11-05 16:28backfilldoordash 34105737 ↔ ny-sla 0081-21-312146same address and nameheld: same-source-conflict