Ryan's Wake

TROY, NY 12180 · O3cb9816c424e · first seen 2026-11-02
5 sourceson premise · baralcohol: 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
Ryan's Wake 3 other
a source's own spelling of the licence name (record_title.py)
RYANS WAKE ab-inbevvtinfo ×2
RYAN'S WAKE INC. inspections (legal name)
RYAN'S WAKE PUB inspections
Street
403-407 RIVER STREET 3 other
ny-sla
403 RIVER ST ab-inbevvtinfo ×2
403 River St #1 overture
403 RIVER STREET inspections
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.73528, -73.68775 map
overtureno other value
Phone
5182709253
vtinfono other value
Licences
ny-sla 0370-23-232413
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of6108ba24990; Obd9efcfe5df0; Ob3c66d95b656; Off39e54e9a6f

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-inbevRYANS WAKE
2765835
403 RIVER ST, TROY, NY, 1218042.73530, -73.687982026-11-112026-11-18
inspectionsRYAN'S WAKE PUB
legal name: RYAN'S WAKE INC.
inspections|nys|515960
403 RIVER STREET, Troy, NY, 1218042.73535, -73.687712026-11-192026-11-19
ny-slaRYAN'S WAKE
0370-23-232413
403-407 RIVER STREET, TROY, NY, 1218042.73524, -73.688022026-11-022026-11-03
overtureRyan's Wake
d7c8dd3b-a091-4722-b643-7babdd14d464
403 River St #1, Troy, NY, 12180518270925342.73528, -73.687752026-11-132026-11-18
vtinfoRYANS WAKE
b952cc70a2585ef5
403 RIVER ST, TROY, NY, 12180518270925342.73532, -73.687812026-11-122026-11-18

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 RYANS WAKEinspections RYAN'S WAKE PUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · matched through the licence's legal name: RYAN'S WAKE INC. · name similarity 1.00
ab-inbev RYANS WAKEny-sla RYAN'S WAKE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same name Ryan's Wake, address range includes 403
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 87% confident — The names match once punctuation is removed (RYANS WAKE vs RYAN'S WAKE), the street addresses agree (403 River St within 403-407 River Street), and the coordinates are about 7 m apart, so this is one bar at one premises despite the shared building.
pair 54a1599a7c976dff9ed0
ab-inbev RYANS WAKEoverture Ryan's Wake1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · name similarity 1.00
ab-inbev RYANS WAKEvtinfo RYANS WAKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 m apart · name similarity 1.00
inspections RYAN'S WAKE PUBoverture Ryan's Wake1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · matched through the licence's legal name: RYAN'S WAKE INC. · name similarity 1.00
inspections RYAN'S WAKE PUBvtinfo RYANS WAKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · matched through the licence's legal name: RYAN'S WAKE INC. · name similarity 1.00
ny-sla RYAN'S WAKEvtinfo RYANS WAKE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Ryan's Wake same name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 403 River Street, Troy NY 12180 with near-identical names (RYAN'S WAKE vs RYANS WAKE) and coordinates 19 m apart, so the NY licence and the brand-finder account describe the same bar/restaurant; the shared building count of 2 is outweighed by the matching name.
pair 47e456d3cb86a9ec93a9
overture Ryan's Wakevtinfo RYANS WAKE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
223 within 1 mi · 442 within 3 mi
Off / on premise
32 / 114 within 1 mi · 92 / 199 within 3 mi
Selling alcohol
142 within 1 mi · 294 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.00 mi
Setting
suburban (2,860 people per sq mi)
People within 3 mi
80,867 (57,912 adults 21+, 34,454 households) from 24 tract(s), tracts within 3 mi
Income
per capita $38,355 · median household ~$66,360 (weighted mean of tract medians)
Age and education
median age ~33.9 · bachelor's or higher 35%
Ethnicity
Hispanic 9% · White 68% · Black 13% · Asian 5%
Adults per alcohol outlet
196
Alcohol spend within 3 mi
$19,876,125 a year ($9,358,198 at home, $10,508,787 away) · $67,377 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-19 20:37insertinspections inspections|nys|515960 ↔ vtinfo b952cc70a2585ef5same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|515960 ↔ overture d7c8dd3b-a091-4722-b643-7babdd14d464same address and namemerged17
2026-11-19 20:37insertab-inbev 2765835 ↔ inspections inspections|nys|515960same address and namemerged17
2026-11-18 18:58insertab-inbev 2765835 ↔ ny-sla 0370-23-232413Claude judge: samemerged15
2026-11-18 18:58insertny-sla 0370-23-232413 ↔ vtinfo b952cc70a2585ef5Claude judge: samemerged15
2026-11-13 14:10insertoverture d7c8dd3b-a091-4722-b643-7babdd14d464 ↔ vtinfo b952cc70a2585ef5same address and namemerged15
2026-11-13 14:10insertab-inbev 2765835 ↔ overture d7c8dd3b-a091-4722-b643-7babdd14d464same address and namemerged15
2026-11-12 14:25insertab-inbev 2765835 ↔ vtinfo b952cc70a2585ef5same address and namemerged12