The Whistling Kettle

Troy, NY 12180 · O103b4833574b · first seen 2026-10-08
5 sourceson premise · restaurantchain: Whistling Kettlealcohol: 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 Whistling Kettle 3 other
a source's own spelling of the licence name (record_title.py)
The Whistling Kettle - Troy ubereats
the whistling kettle troy doordash
WHISTLING KETTLE TROY LLC ny-sla (legal name)
Street
254 BROADWAY
ny-slano other value
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.73133, -73.69077 map
ubereatsno other value
Phone
5182654451 1 other
vtinfo
5188741938 overture
Licences
ny-sla 0240-22-202587
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O230bff575cff; O72226fd412ca; O48cfb43934d9; O82c38445ca4f

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
doordashthe whistling kettle troy
592380
254 Broadway, Troy, NY, 1218042.73145, -73.690652026-10-082026-10-18
ny-slaTHE WHISTLING KETTLE
legal name: WHISTLING KETTLE TROY LLC
0240-22-202587
254 BROADWAY, TROY, NY, 1218042.73137, -73.690722026-11-022026-11-05
overtureThe Whistling Kettle
fd0137ab-ddd4-41e0-bc1e-b138f13a35e1
254 Broadway, Troy, NY, 12180518874193842.73141, -73.690702026-11-062026-11-06
ubereatsThe Whistling Kettle - Troy
eKOGhw-PW6WvwuZrd7SbJw
254 Broadway, Troy, NY, 1218042.73133, -73.690772026-11-052026-11-05
vtinfoTHE WHISTLING KETTLE
78fc7a1e79a80a92
254 BROADWAY, TROY, NY, 12180518265445142.73147, -73.690702026-11-122026-11-14

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 the whistling kettle troyny-sla THE WHISTLING KETTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
doordash the whistling kettle troyoverture The Whistling Kettle1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
doordash the whistling kettle troyubereats The Whistling Kettle - Troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
doordash the whistling kettle troyvtinfo THE WHISTLING KETTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00
ny-sla THE WHISTLING KETTLEoverture The Whistling Kettle1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ny-sla THE WHISTLING KETTLEubereats The Whistling Kettle - Troy1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · matched through the licence's legal name: WHISTLING KETTLE TROY LLC · name similarity 1.00
ny-sla THE WHISTLING KETTLEvtinfo THE WHISTLING KETTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 11 m apart · name similarity 1.00
overture The Whistling Kettlevtinfo THE WHISTLING KETTLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: differs
overture The Whistling Kettleubereats The Whistling Kettle - Troy0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 11 m apart · name similarity 0.77
ubereats The Whistling Kettle - Troyvtinfo THE WHISTLING KETTLE0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 16 m apart · name similarity 0.77

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Whistling Kettle — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
WHISTLING KETTLE TROY LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on — NY 0240
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
206 within 1 mi · 434 within 3 mi
Off / on premise
28 / 106 within 1 mi · 88 / 197 within 3 mi
Selling alcohol
128 within 1 mi · 286 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (2,971 people per sq mi)
People within 3 mi
84,015 (60,289 adults 21+, 35,803 households) from 25 tract(s), tracts within 3 mi
Income
per capita $39,012 · median household ~$67,471 (weighted mean of tract medians)
Age and education
median age ~34.2 · bachelor's or higher 36%
Ethnicity
Hispanic 9% · White 68% · Black 13% · Asian 6%
Adults per alcohol outlet
210
Alcohol spend within 3 mi
$20,913,185 a year ($9,820,820 at home, $11,082,937 away) · $72,868 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 14:25insertubereats eKOGhw-PW6WvwuZrd7SbJw ↔ vtinfo 78fc7a1e79a80a92same address and namemerged12
2026-11-12 14:25insertdoordash 592380 ↔ vtinfo 78fc7a1e79a80a92same address and namemerged12
2026-11-12 14:25insertoverture fd0137ab-ddd4-41e0-bc1e-b138f13a35e1 ↔ vtinfo 78fc7a1e79a80a92same address and namemerged12
2026-11-12 14:25insertny-sla 0240-22-202587 ↔ vtinfo 78fc7a1e79a80a92same address and namemerged12
2026-11-06 18:13insertoverture fd0137ab-ddd4-41e0-bc1e-b138f13a35e1 ↔ ubereats eKOGhw-PW6WvwuZrd7SbJwsame address and namemerged11
2026-11-06 18:13insertny-sla 0240-22-202587 ↔ overture fd0137ab-ddd4-41e0-bc1e-b138f13a35e1same address and namemerged11
2026-11-06 18:13insertdoordash 592380 ↔ overture fd0137ab-ddd4-41e0-bc1e-b138f13a35e1same address and namemerged11
2026-11-05 16:28backfillny-sla 0240-22-202587 ↔ ubereats eKOGhw-PW6WvwuZrd7SbJwsame address and namemerged
2026-11-05 16:28backfilldoordash 592380 ↔ ubereats eKOGhw-PW6WvwuZrd7SbJwsame address and namemerged
2026-11-03 13:33backfilldoordash 592380 ↔ ny-sla 0240-22-202587same address and namemerged