Deli & Brew

TROY, NY 12180 · O477463262f55 · first seen 2026-11-02
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
Deli & Brew 1 other
a source's own spelling of the licence name (record_title.py)
JOKER INC ny-sla (legal name)
Street
64 VANDENBURGH AVE 1 other
ny-sla
64 Vandenburgh Ave #6030 ubereats
City
TROY
ny-slano other value
State
NY
ny-slano other value
ZIP
12180
ny-slano other value
Pin
42.69960, -73.68857 map 1 other
ubereats
235 m away ab-inbev
Phone
5182749525
vtinfono other value
Licences
ny-sla 0081-23-220110
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of036fe3200a5; Oef6b9999fd81; O9438b9c60a79; O57fbbb0bf0eb

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-inbevDELI & BREW
2626646
64 VANDENBURGH AVE, TROY, NY, 1218042.70171, -73.688482026-11-112026-11-14
ny-slaDELI & BREW
legal name: JOKER INC
0081-23-220110
64 VANDENBURGH AVE, TROY, NY, 1218042.69969, -73.688582026-11-022026-11-14
overtureDeli & Brew
5504483f-51dd-47d5-9c01-fb4f4b8c35b9
64 Vandenburgh Ave, Troy, NY, 12180518274952542.69959, -73.688462026-11-062026-11-14
ubereatsDeli & Brew
eSpI36cAXgSLpY1CbdQMdw
64 Vandenburgh Ave #6030, Troy, NY, 1218042.69960, -73.688572026-11-142026-11-14
vtinfoDELI & BREW
89e806ac909d7a98
64 VANDENBURGH AVE, TROY, NY, 12180518274952542.69954, -73.688502026-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
ab-inbev DELI & BREWny-sla DELI & BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 225 m apart · name similarity 1.00
ab-inbev DELI & BREWoverture Deli & Brew1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 236 m apart · name similarity 1.00
ab-inbev DELI & BREWubereats Deli & Brew1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 235 m apart · name similarity 1.00
ab-inbev DELI & BREWvtinfo DELI & BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 241 m apart · name similarity 1.00
ny-sla DELI & BREWoverture Deli & Brew1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ny-sla DELI & BREWubereats Deli & Brew1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
ny-sla DELI & BREWvtinfo DELI & BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
overture Deli & Brewubereats Deli & Brew1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
overture Deli & Brewvtinfo DELI & BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7 m apart · name similarity 1.00 · phone: equal
ubereats Deli & Brewvtinfo DELI & BREW1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
JOKER INC — 1 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
39 within 1 mi · 359 within 3 mi
Off / on premise
10 / 19 within 1 mi · 73 / 169 within 3 mi
Selling alcohol
22 within 1 mi · 232 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
suburban (2,269 people per sq mi)
People within 3 mi
64,153 (45,702 adults 21+, 26,085 households) from 18 tract(s), tracts within 3 mi
Income
per capita $41,234 · median household ~$77,695 (weighted mean of tract medians)
Age and education
median age ~34.2 · bachelor's or higher 39%
Ethnicity
Hispanic 8% · White 71% · Black 12% · Asian 6%
Adults per alcohol outlet
196
Alcohol spend within 3 mi
$16,425,329 a year ($7,647,340 at home, $8,770,598 away) · $70,495 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-14 20:23insertoverture 5504483f-51dd-47d5-9c01-fb4f4b8c35b9 ↔ ubereats eSpI36cAXgSLpY1CbdQMdwsame address and namemerged15
2026-11-14 20:23insertab-inbev 2626646 ↔ ubereats eSpI36cAXgSLpY1CbdQMdwsame address and namemerged15
2026-11-14 20:23insertny-sla 0081-23-220110 ↔ ubereats eSpI36cAXgSLpY1CbdQMdwsame address and namemerged15
2026-11-14 20:23insertubereats eSpI36cAXgSLpY1CbdQMdw ↔ vtinfo 89e806ac909d7a98same address and namemerged15
2026-11-12 14:25insertoverture 5504483f-51dd-47d5-9c01-fb4f4b8c35b9 ↔ vtinfo 89e806ac909d7a98same address and namemerged12
2026-11-12 14:25insertab-inbev 2626646 ↔ vtinfo 89e806ac909d7a98same address and namemerged12
2026-11-12 14:25insertny-sla 0081-23-220110 ↔ vtinfo 89e806ac909d7a98same address and namemerged12
2026-11-11 12:56insertab-inbev 2626646 ↔ ny-sla 0081-23-220110same address and namemerged12
2026-11-11 12:56insertab-inbev 2626646 ↔ overture 5504483f-51dd-47d5-9c01-fb4f4b8c35b9same address and namemerged12
2026-11-06 18:13insertny-sla 0081-23-220110 ↔ overture 5504483f-51dd-47d5-9c01-fb4f4b8c35b9same address and namemerged11