The Rensselaer

Troy, NY 12180 · O493089ba0c39 · first seen 2026-11-02
4 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 Rensselaer 1 other
a licence name in capitals, cleaned (derived; record_title.py)
Hoosick Banquet Llc overtureinspections (legal name)ny-sla (legal name) ×3
Street
227 HOOSICK STREET 1 other
ny-sla
227 Hoosick St overturevtinfo ×2
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.73873, -73.67171 map 2 other
overture
71 m away inspections
77 m away ny-sla
Phone
5182721700 1 other
vtinfo
5186406407 overture
Licences
ny-sla 0346-23-226938
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O4dfc6cb069ab; Odf0d85cafcae; O95502b421397

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
inspectionsTHE RENSSELAER
legal name: Hoosick Banquet LLC
inspections|nys|707825
227 Hoosick STREET, Troy, NY, 1218042.73867, -73.672582026-11-192026-11-19
ny-slaTHE RENSSELAER
legal name: HOOSICK BANQUET LLC
0346-23-226938
227 HOOSICK STREET, TROY, NY, 1218042.73865, -73.672652026-11-022026-11-05
overtureHoosick Banquet Llc
cb4dfcbd-4046-4206-a6de-206d1243a0a3
227 Hoosick St, Troy, NY, 12180518640640742.73873, -73.671712026-11-062026-11-06
vtinfoTHE RENSSELAER
03051a0af4f6ad58
227 HOOSICK ST, TROY, NY, 12180518272170042.73872, -73.671712026-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
inspections THE RENSSELAERny-sla THE RENSSELAER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
inspections THE RENSSELAERoverture Hoosick Banquet Llc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · matched through the licence's legal name: Hoosick Banquet LLC · name similarity 1.00
inspections THE RENSSELAERvtinfo THE RENSSELAER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 71 m apart · name similarity 1.00
ny-sla THE RENSSELAERoverture Hoosick Banquet Llc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 77 m apart · matched through the licence's legal name: HOOSICK BANQUET LLC · name similarity 1.00
ny-sla THE RENSSELAERvtinfo THE RENSSELAER1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 77 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HOOSICK BANQUET LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0346
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
124 within 1 mi · 420 within 3 mi
Off / on premise
21 / 62 within 1 mi · 89 / 184 within 3 mi
Selling alcohol
75 within 1 mi · 283 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
suburban (2,709 people per sq mi)
People within 3 mi
76,602 (56,118 adults 21+, 33,750 households) from 23 tract(s), tracts within 3 mi
Income
per capita $38,309 · median household ~$65,516 (weighted mean of tract medians)
Age and education
median age ~35.2 · bachelor's or higher 35%
Ethnicity
Hispanic 9% · White 69% · Black 13% · Asian 4%
Adults per alcohol outlet
198
Alcohol spend within 3 mi
$19,392,732 a year ($9,139,373 at home, $10,244,331 away) · $68,284 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|707825 ↔ ny-sla 0346-23-226938same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|707825 ↔ overture cb4dfcbd-4046-4206-a6de-206d1243a0a3same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|707825 ↔ vtinfo 03051a0af4f6ad58same address and namemerged17
2026-11-12 14:25insertny-sla 0346-23-226938 ↔ vtinfo 03051a0af4f6ad58same address and namemerged12
2026-11-06 18:13insertny-sla 0346-23-226938 ↔ overture cb4dfcbd-4046-4206-a6de-206d1243a0a3same address and namemerged11