Ale House

Troy, NY 12180 · O2f4254c72239 · first seen 2026-11-02
4 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
Ale House 3 other
a source's own spelling of the licence name (record_title.py)
THE ALE HOUSE inspectionsny-slavtinfo ×3
BRINO INCORPORATED ny-sla (legal name)
BRINO, INC inspections (legal name)
Street
680 682 RIVER STREET 2 other
ny-sla
680 River St overturevtinfo ×2
680 RIVER STREET inspections
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.74519, -73.68390 map
overtureno other value
Phone
5182729740
vtinfono other value
Licences
ny-sla 0340-23-231895
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O43a039c1664a; O47f3d81d2a53; O4150be67dfc7

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 ALE HOUSE
legal name: BRINO, INC
inspections|nys|301125
680 RIVER STREET, Troy, NY, 1218042.74518, -73.683992026-11-192026-11-19
ny-slaTHE ALE HOUSE
legal name: BRINO INCORPORATED
0340-23-231895
680 682 RIVER STREET, TROY, NY, 1218042.74546, -73.683952026-11-022026-11-12
overtureAle House
ba3622a8-71a2-4755-bfb9-09cda5652696
680 River St, Troy, NY, 12180518272974042.74519, -73.683902026-11-132026-11-13
vtinfoTHE ALE HOUSE
9183928b397c341c
680 RIVER ST, TROY, NY, 12180518272974042.74508, -73.683982026-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 ALE HOUSEny-sla THE ALE HOUSE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 31 m apart · name similarity 1.00 · street similarity 0.80
inspections THE ALE HOUSEoverture Ale House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
inspections THE ALE HOUSEvtinfo THE ALE HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ny-sla THE ALE HOUSEoverture Ale House1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 31 m apart · name similarity 1.00 · street similarity 0.80
ny-sla THE ALE HOUSEvtinfo THE ALE HOUSE1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 43 m apart · name similarity 1.00 · street similarity 0.80
overture Ale Housevtinfo THE ALE HOUSE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 14 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
BRINO INCORPORATED — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
121 within 1 mi · 453 within 3 mi
Off / on premise
19 / 63 within 1 mi · 98 / 191 within 3 mi
Selling alcohol
73 within 1 mi · 310 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.03 mi
Setting
suburban (2,772 people per sq mi)
People within 3 mi
78,382 (57,269 adults 21+, 34,315 households) from 23 tract(s), tracts within 3 mi
Income
per capita $35,975 · median household ~$59,355 (weighted mean of tract medians)
Age and education
median age ~35.5 · bachelor's or higher 33%
Ethnicity
Hispanic 10% · White 68% · Black 14% · Asian 4%
Adults per alcohol outlet
184
Alcohol spend within 3 mi
$18,868,063 a year ($8,985,417 at home, $9,873,967 away) · $60,669 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|301125 ↔ ny-sla 0340-23-231895street written two waysmerged17
2026-11-19 20:37insertinspections inspections|nys|301125 ↔ vtinfo 9183928b397c341csame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|301125 ↔ overture ba3622a8-71a2-4755-bfb9-09cda5652696same address and namemerged17
2026-11-13 14:10insertny-sla 0340-23-231895 ↔ overture ba3622a8-71a2-4755-bfb9-09cda5652696street written two waysmerged15
2026-11-13 14:10insertoverture ba3622a8-71a2-4755-bfb9-09cda5652696 ↔ vtinfo 9183928b397c341csame address and namemerged15
2026-11-12 14:25insertny-sla 0340-23-231895 ↔ vtinfo 9183928b397c341cstreet written two waysmerged12