TOPS

HAMBURG, NY 14075 · O15f9a9e82acc · first seen 2026-10-08
5 sourcesoff premisealcohol: 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 4 other
the most common name a source states
TOPS #215 ny-sla
TOPS MARKETS #215 overture
tops markets hamburg doordash
Tops Markets LLC ny-sla (legal name)
Street
4250 MCKINLEY PARKWAY 1 other
ny-sla
4250 MCKINLEY PKWY ab-inbevdoordashoverturevtinfo ×4
City
HAMBURG
ny-slano other value
State
NY
ny-slano other value
ZIP
14075
ny-slano other value
Pin
42.76823, -78.81353 map 4 other
doordash
125 m away ab-inbev
126 m away ny-sla
156 m away overture
125 m away vtinfo
Phone
7165153230
vtinfono other value
Licences
ny-sla 0081-21-308654
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oef40294e2fce; Oa61d05aa21ec; O418a0633a520; O2797b68c62c7

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
2632817
4250 MCKINLEY PKWY, HAMBURG, NY, 1407542.76834, -78.812012026-11-112026-11-12
doordashtops markets hamburg
34105737
4250 Mckinley Pkwy, Hamburg, NY, 1407542.76823, -78.813532026-10-082026-11-04
ny-slaTOPS #215
legal name: Tops Markets LLC
0081-21-308654
4250 MCKINLEY PARKWAY, HAMBURG, NY, 1407542.76841, -78.812012026-11-022026-11-05
overtureTOPS MARKETS #215
b86f1797-690f-4f76-b339-8584a42e0fe2
4250 Mckinley Pkwy, Hamburg, NY, 1407542.76819, -78.811612026-11-132026-11-13
vtinfoTOPS
5c894c28d38dc28e
4250 MCKINLEY PKWY, HAMBURG, NY, 14075716515323042.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 TOPSvtinfo TOPS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 121 m apart · name similarity 1.00
doordash tops markets hamburgny-sla TOPS #2151.00same address and namemergedaddress 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
ny-sla TOPS #215overture TOPS MARKETS #2150.76same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: markets · name Jaro-Winkler 0.82 · same street + ZIP · pins 40 m apart · matched through the licence's legal name: Tops Markets LLC · name similarity 0.76
ab-inbev TOPSdoordash tops markets hamburg0.50same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: markets · name Jaro-Winkler 0.56 · same street + ZIP · pins 125 m apart · name similarity 0.50
doordash tops markets hamburgvtinfo TOPS0.50same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: markets · name Jaro-Winkler 0.56 · same street + ZIP · pins 125 m apart · name similarity 0.50

Attributes

Channel
off_premise — doordash-url
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:15.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
28 within 1 mi · 273 within 3 mi
Off / on premise
6 / 13 within 1 mi · 68 / 123 within 3 mi
Selling alcohol
17 within 1 mi · 170 within 3 mi
Nearest
same channel 0.28 mi · licensed 0.08 mi
Setting
suburban (1,038 people per sq mi)
People within 3 mi
29,338 (23,473 adults 21+, 13,666 households) from 7 tract(s), tracts within 3 mi
Income
per capita $45,005 · median household ~$79,939 (weighted mean of tract medians)
Age and education
median age ~46.1 · bachelor's or higher 29%
Ethnicity
Hispanic 4% · White 89% · Black 2% · Asian 1%
Adults per alcohol outlet
137
Alcohol spend within 3 mi
$8,573,230 a year ($3,993,448 at home, $4,575,233 away) · $50,136 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-15 16:24insertdoordash 34105737 ↔ vtinfo 5c894c28d38dc28esame address and namemerged15
2026-11-15 16:24updatedoordash 34105737 ↔ ny-sla 0081-21-312146same address and nameheld: same-source-conflict15
2026-11-15 16:24insertab-inbev 2632817 ↔ vtinfo 5c894c28d38dc28esame address and namemerged15
2026-11-14 20:23updatedoordash 34105737 ↔ ny-sla 0081-21-312146same address and nameheld: same-source-conflict15
2026-11-13 14:10insertny-sla 0081-21-308654 ↔ overture b86f1797-690f-4f76-b339-8584a42e0fe2same address and namemerged15
2026-11-12 17:29insertab-inbev 4024514 ↔ doordash 34105737Claude judge: sameheld: same-source-conflict14
2026-11-12 17:29insertab-inbev 2632817 ↔ doordash 34105737same address and namemerged14
2026-11-05 16:28backfilldoordash 34105737 ↔ ny-sla 0081-21-308654same address and namemerged
2026-11-05 16:28backfilldoordash 34105737 ↔ ny-sla 0081-21-312146same address and nameheld: same-source-conflict