Hill Street Cafe

ALBANY, NY 12202 · O0f9435a58c47 · 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
Hill Street Cafe 1 other
a source's own spelling of the licence name (record_title.py)
HILL STREET CAFE INC ny-sla
Street
178 180 MADISON AVENUE 2 other
ny-sla
180 MADISON AVE ab-inbevoverturevtinfo ×3
180 MADISON AVENUE inspections
City
ALBANY
ny-slano other value
State
NY
ny-slano other value
ZIP
12202
ny-slano other value
Pin
42.64669, -73.75809 map 1 other
overture
58 m away ab-inbev
Phone
5184623544
vtinfono other value
Licences
ny-sla 0340-23-227481
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O773f0c8a4c3b; Odcf22f6f0684; O83882bc1d7e3; Of28fe0cbcfb8

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-inbevHILL STREET CAFE
2626769
180 MADISON AVE, ALBANY, NY, 1220242.64651, -73.757422026-11-112026-11-11
inspectionsHILL STREET CAFE
inspections|nys|251122
180 MADISON AVENUE, Albany, NY, 1220242.64681, -73.757972026-11-192026-11-19
ny-slaHILL STREET CAFE INC
0340-23-227481
178 180 MADISON AVENUE, ALBANY, NY, 1220242.64680, -73.757832026-11-022026-11-18
overtureHill Street Cafe
d0b2d3f9-0ac2-4ddc-a969-d9f11853c765
180 Madison Ave, Albany, NY, 12202518462354442.64669, -73.758092026-11-132026-11-13
vtinfoHILL STREET CAFE
da4b1e55b30aa448
180 MADISON AVE, ALBANY, NY, 12202518462354442.64662, -73.758092026-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 HILL STREET CAFEinspections HILL STREET CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 56 m apart · name similarity 1.00
ab-inbev HILL STREET CAFEny-sla HILL STREET CAFE INC1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Same name and address range.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name Hill Street Cafe (NY-SLA's entity name adds INC) at the same Madison Avenue address in Albany ZIP 12202, only about 47 m apart, and no other business is listed at that address, so they describe one restaurant's premises.
pair 79bf123a0031c4133edb
ab-inbev HILL STREET CAFEoverture Hill Street Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ab-inbev HILL STREET CAFEvtinfo HILL STREET CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 56 m apart · name similarity 1.00
inspections HILL STREET CAFEoverture Hill Street Cafe1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
inspections HILL STREET CAFEvtinfo HILL STREET CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ny-sla HILL STREET CAFE INCvtinfo HILL STREET CAFE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “proximity” pair)
Same name Hill Street Cafe, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name HILL STREET CAFE at 178-180 / 180 Madison Ave in Albany, NY with a distance of 0.029 km, and no other business is listed at that address, so the names and address agree on one outlet.
pair 308a59ab48e0e54920c2
overture Hill Street Cafevtinfo HILL STREET CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 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
HILL STREET CAFE INC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0340
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
278 within 1 mi · 621 within 3 mi
Off / on premise
59 / 125 within 1 mi · 154 / 289 within 3 mi
Selling alcohol
188 within 1 mi · 408 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.01 mi
Setting
urban (3,411 people per sq mi)
People within 3 mi
96,434 (75,562 adults 21+, 44,863 households) from 29 tract(s), tracts within 3 mi
Income
per capita $38,371 · median household ~$62,774 (weighted mean of tract medians)
Age and education
median age ~34.4 · bachelor's or higher 41%
Ethnicity
Hispanic 11% · White 51% · Black 25% · Asian 9%
Adults per alcohol outlet
185
Alcohol spend within 3 mi
$25,337,791 a year ($11,998,760 at home, $13,324,578 away) · $61,951 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:37insertab-inbev 2626769 ↔ inspections inspections|nys|251122same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|251122 ↔ vtinfo da4b1e55b30aa448same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys|251122 ↔ overture d0b2d3f9-0ac2-4ddc-a969-d9f11853c765same address and namemerged17
2026-11-18 18:58insertab-inbev 2626769 ↔ ny-sla 0340-23-227481Claude judge: samemerged15
2026-11-18 18:58insertny-sla 0340-23-227481 ↔ vtinfo da4b1e55b30aa448Claude judge: samemerged15
2026-11-13 14:10insertoverture d0b2d3f9-0ac2-4ddc-a969-d9f11853c765 ↔ vtinfo da4b1e55b30aa448same address and namemerged15
2026-11-13 14:10insertab-inbev 2626769 ↔ overture d0b2d3f9-0ac2-4ddc-a969-d9f11853c765same address and namemerged15
2026-11-12 14:25insertab-inbev 2626769 ↔ vtinfo da4b1e55b30aa448same address and namemerged12