THE RUSTY NAIL

CLIFTON PARK, NY 12065 · O8b0c39b68513 · first seen 2026-10-08
5 sourceson premise · restaurantalcohol: 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
THE RUSTY NAIL 3 other
the most common name a source states
BENTLEY & BENTLEY INC ny-sla (legal name)
rusty nail clifton park doordash
Rusty Nail Grill and Tavern overture
Street
1781 ROUTE 9 3 other
ny-sla
1784 RTE 9 ab-inbevvtinfo ×2
1781 U.S. 9 doordash
1781 US-9 overture
City
CLIFTON PARK
ny-slano other value
State
NY
ny-slano other value
ZIP
12065
ny-slano other value
Pin
42.87780, -73.77373 map 2 other
doordash
111 m away ab-inbev
160 m away vtinfo
Phone
5183719875
vtinfono other value
Licences
ny-sla 0370-24-237491
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob5164ec67b6f; Od1328b97e8b2; Oad64fde4f4bc; O8e1437cc551c

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-inbevTHE RUSTY NAIL
3077514
1784 RTE 9, CLIFTON PARK, NY, 1206542.87683, -73.774022026-11-112026-11-13
doordashrusty nail clifton park
592347
1781 U.S. 9, Clifton Park, NY, 1206542.87780, -73.773732026-10-082026-11-13
ny-slaTHE RUSTY NAIL
legal name: BENTLEY & BENTLEY INC
0370-24-237491
1781 ROUTE 9, CLIFTON PARK, NY, 1206542.87765, -73.773702026-11-022026-11-13
overtureRusty Nail Grill and Tavern
fa6809fa-3083-4f31-b907-14c18ccf160b
1781 US-9, Clifton Park, NY, 12065518371987542.87781, -73.773752026-11-132026-11-13
vtinfoTHE RUSTY NAIL
3e3b8d0a6ee7eb3e
1784 RTE 9, CLIFTON PARK, NY, 12065518371987542.87861, -73.775352026-11-122026-11-13

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 THE RUSTY NAILdoordash rusty nail clifton park1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (80% confident; asked as a “near” pair)
Distinctive name, near-identical Route 9 address, 111m apart
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records name The Rusty Nail in Clifton Park, NY 12065 on Route 9, with coordinates about 111 m apart and no other businesses at the address; the small house-number difference (1784 vs 1781) is likely the same premises listed under different numbering.
pair 195a19d77bb0c572ba0b
ab-inbev THE RUSTY NAILvtinfo THE RUSTY NAIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 225 m apart · name similarity 1.00
doordash rusty nail clifton parkny-sla THE RUSTY NAIL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
doordash rusty nail clifton parkoverture Rusty Nail Grill and Tavern0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: grill, tavern · name Jaro-Winkler 0.71 · same street + ZIP · pins 2 m apart · name similarity 0.55
ny-sla THE RUSTY NAILoverture Rusty Nail Grill and Tavern0.55same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: grill, tavern · name Jaro-Winkler 0.71 · same street + ZIP · pins 18 m apart · name similarity 0.55

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
BENTLEY & BENTLEY INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0370
Rule version 7, computed 2026-11-16 17:18.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
34 within 1 mi · 200 within 3 mi
Off / on premise
11 / 17 within 1 mi · 58 / 102 within 3 mi
Selling alcohol
21 within 1 mi · 114 within 3 mi
Nearest
same channel 0.41 mi · licensed 0.33 mi
Setting
suburban (1,238 people per sq mi)
People within 3 mi
35,005 (26,119 adults 21+, 14,354 households) from 8 tract(s), tracts within 3 mi
Income
per capita $58,589 · median household ~$116,267 (weighted mean of tract medians)
Age and education
median age ~41.2 · bachelor's or higher 51%
Ethnicity
Hispanic 4% · White 84% · Black 2% · Asian 6%
Adults per alcohol outlet
227
Alcohol spend within 3 mi
$12,045,470 a year ($5,328,119 at home, $6,712,813 away) · $104,743 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-13 14:10insertny-sla 0370-24-237491 ↔ overture fa6809fa-3083-4f31-b907-14c18ccf160bsame address and namemerged15
2026-11-13 14:10insertdoordash 592347 ↔ overture fa6809fa-3083-4f31-b907-14c18ccf160bsame address and namemerged15
2026-11-12 17:29insertab-inbev 3077514 ↔ doordash 592347Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 3077514 ↔ vtinfo 3e3b8d0a6ee7eb3esame address and namemerged12
2026-11-09 16:40insertdoordash 592347 ↔ ny-sla 0370-24-237491same address and namemerged11