Tops

WATERLOO, NY 13148 · O2bdccb3a99bc · first seen 2026-10-08
4 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
a licence name in capitals, cleaned (derived; record_title.py)
TOPS MARKET #565 ny-sla
tops markets waterloo doordash
TOPS PT LLC ny-sla (legal name)
Tops PT, LLC d/b/a Tops PT 565 snap
Street
1963 KINGDOM PLAZA 1 other
ny-sla
1963 KINGDOM PLZ ab-inbevdoordashsnap ×3
City
WATERLOO
ny-slano other value
State
NY
ny-slano other value
ZIP
13148 1 other
ny-sla
13165 ab-inbevsnap ×2
Pin
42.90407, -76.83538 map 2 other
doordash
801 m away ny-sla
147 m away snap
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; O6b316b83537e

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-20
doordashtops markets waterloo
34105955
1963 Kingdom Plz, Waterloo, NY, 13148
ZIP lookup: Seneca Falls, NY
42.90407, -76.835382026-10-082026-11-20
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-20
snapTops PT, LLC d/b/a Tops PT 565
snap|us|349255
1963 Kingdom Plz, Waterloo, NY, 1316542.90303, -76.834282026-11-192026-11-19

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 TOPSny-sla TOPS MARKET #5650.61same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: market · name Jaro-Winkler 0.43 · same street + city + state · pins 806 m apart · matched through the licence's legal name: TOPS PT LLC · name similarity 0.61
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
ab-inbev TOPSsnap Tops PT, LLC d/b/a Tops PT 5650.27learned pair model: samemergedjudge: None · model: pair-gbm-v1 · p 0.99 · pair_id: cbca8d05d47e338aa061 · person: None · stratum: same-address

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 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

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-20 22:08insertab-inbev 3233312 ↔ snap snap|us|349255learned pair model: samemerged17
2026-11-18 18:58insertab-inbev 3233312 ↔ ny-sla 0081-22-331377same address and namemerged15
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