PJ's Motel & River Rat Cafe

CLAYTON, NY 13624 · O5e06cad26060 · first seen 2026-11-02
2 sourceson 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
PJ's Motel & River Rat Cafe 1 other
a licence name in capitals, cleaned (derived; record_title.py)
PJS RIVER RAT CAFE ab-inbev
Street
41867 NYS ROUTE 12 & ROUTE 180 1 other
ny-sla
41867 ST RTE 180 ab-inbev
City
CLAYTON
ny-slano other value
State
NY
ny-slano other value
ZIP
13624
ny-slano other value
Pin
44.27343, -75.99972 map 1 other
ny-sla
605 m away ab-inbev
Phone
none
no other value
Licences
ny-sla 0343-22-230971
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8d6ae9482ee7

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-inbevPJS RIVER RAT CAFE
2599514
41867 ST RTE 180, CLAYTON, NY, 1362444.27013, -75.993682026-11-132026-11-18
ny-slaPJ'S MOTEL & RIVER RAT CAFE
0343-22-230971
41867 NYS ROUTE 12 & ROUTE 180, CLAYTON, NY, 1362444.27343, -75.999722026-11-022026-11-03

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 PJS RIVER RAT CAFEny-sla PJ'S MOTEL & RIVER RAT CAFE0.83Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
PJ's River Rat Cafe same street number.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records are at street number 41867 in Clayton NY 13624 with only one business at that address, and the names share the distinctive 'River Rat Cafe' with 'PJS' and 'PJ's' matching, so the ab-inbev listing and the NY licence describe the same operation; the motel in the licence name is an extra descriptor of the same site.
pair ecfedc0b80ea1188f1d0

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0343
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
2 within 1 mi · 21 within 3 mi
Off / on premise
0 / 1 within 1 mi · 8 / 2 within 3 mi
Selling alcohol
1 within 1 mi · 19 within 3 mi
Nearest
same channel none within 3 mi · licensed 1.51 mi
Setting
rural (none people per sq mi)
People within 3 mi
2,223 (1,956 adults 21+, 1,064 households) from 1 tract(s), the nearest tract
Income
per capita $61,903 · median household ~$99,500 (weighted mean of tract medians)
Age and education
median age ~58.1 · bachelor's or higher 49%
Ethnicity
Hispanic 1% · White 97% · Black 1% · Asian 0%
Adults per alcohol outlet
none
Alcohol spend within 3 mi
$827,492 a year ($371,691 at home, $455,402 away) · none 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-18 18:58insertab-inbev 2599514 ↔ ny-sla 0343-22-230971Claude judge: samemerged15