TOPS

WATERLOO, NY 13148 · O6b316b83537e · first seen 2026-10-08
3 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 3 other
the most common name a source states
TOPS MARKET #565 ny-sla
tops markets waterloo doordash
TOPS PT LLC ny-sla (legal name)
Street
1963 KINGDOM PLAZA 1 other
ny-sla
1963 KINGDOM PLZ ab-inbevdoordash ×2
City
WATERLOO
ny-slano other value
State
NY
ny-slano other value
ZIP
13148 1 other
ny-sla
13165 ab-inbev
Pin
42.90407, -76.83538 map 1 other
doordash
801 m away ny-sla
Phone
none
no other value
Licences
ny-sla 0081-22-331377
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob688fafa56c5; O6f28c438f3e0

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
3233312
1963 KINGDOM PLZ, WATERLOO, NY, 1316542.90429, -76.835452026-11-112026-11-12
doordashtops markets waterloo
34105955
1963 Kingdom Plz, Waterloo, NY, 13148
ZIP lookup: Seneca Falls, NY
42.90407, -76.835382026-10-082026-11-12
ny-slaTOPS MARKET #565
legal name: TOPS PT LLC
0081-22-331377
1963 KINGDOM PLAZA, WATERLOO, NY, 13148
ZIP lookup: Seneca Falls, NY
42.90417, -76.825552026-11-022026-11-05

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 waterloony-sla TOPS MARKET #5650.53Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Tops at same Kingdom Plaza address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records give the same street address (1963 Kingdom Plaza, Waterloo NY 13148) with no other business listed there, and both names are the Tops Markets banner (DoorDash 'tops markets waterloo' vs SLA licence 'TOPS MARKET #565' filed by TOPS PT LLC), so this is one store and its listing; the 0.8 km coordinate gap is only geocoding noise.
pair 1730febd94160c75da20
ab-inbev TOPSdoordash tops markets waterloo0.50same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: markets · name Jaro-Winkler 0.60 · same street + city + state · pins 24 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 PT LLC — 31 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 9, computed 2026-11-17 18:22.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
32 within 1 mi · 87 within 3 mi
Off / on premise
12 / 10 within 1 mi · 21 / 33 within 3 mi
Selling alcohol
19 within 1 mi · 63 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.11 mi
Setting
rural (226 people per sq mi)
People within 3 mi
6,387 (5,154 adults 21+, 2,998 households) from 2 tract(s), tracts within 3 mi
Income
per capita $32,399 · median household ~$53,832 (weighted mean of tract medians)
Age and education
median age ~47.3 · bachelor's or higher 23%
Ethnicity
Hispanic 6% · White 85% · Black 2% · Asian 1%
Adults per alcohol outlet
81
Alcohol spend within 3 mi
$1,449,453 a year ($711,921 at home, $736,883 away) · $22,648 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-12 17:29insertdoordash 34105955 ↔ ny-sla 0081-22-331377Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 3233312 ↔ doordash 34105955same address and namemerged14