ON TAP

LATHAM, NY 12110 · Oa341f710702c · first seen 2026-11-02
4 sourceson premise · baralcohol: licensed2 licences

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
ON TAP 1 other
the most common name a source states
BULLOCK BOYS LLC ny-sla (legal name) ×2
Street
400 OLD LOUDON ROAD 1 other
ny-sla
400 OLD LOUDON RD ab-inbevoverturevtinfo ×3
City
LATHAM 1 other
ny-sla
Colonie overture
State
NY
ny-slano other value
ZIP
12110
ny-slano other value
Pin
42.76191, -73.75461 map 2 other
overture
75 m away ny-sla ×2
70 m away ab-inbev
Phone
5187836161
vtinfono other value
Licences
ny-sla 0343-23-202583 · ny-sla 0423-23-237430
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of4648cb684ef; Oae88077e1afc; Ob3e0b5574a54; Oe1a4eae3edf3

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-inbevON TAP
3279312
400 OLD LOUDON RD, LATHAM, NY, 1211042.76232, -73.753972026-11-112026-11-11
ny-slaON TAP
legal name: BULLOCK BOYS LLC
0343-23-202583
400 OLD LOUDON ROAD, LATHAM, NY, 1211042.76124, -73.754502026-11-022026-11-05
ny-slaON TAP
legal name: BULLOCK BOYS LLC
0423-23-237430
400 OLD LOUDON ROAD, LATHAM, NY, 1211042.76124, -73.754502026-11-022026-11-05
overtureOn Tap
30ff7afe-3b3d-455e-8626-98b5b3e32db3
400 Old Loudon Rd, Colonie, NY, 12110
ZIP lookup: Latham, NY
518783616142.76191, -73.754612026-11-062026-11-06
vtinfoON TAP
a43ea785f9022e07
400 OLD LOUDON RD, LATHAM, NY, 12110518783616142.76176, -73.754512026-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 ON TAPny-sla ON TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 128 m apart · name similarity 1.00
ab-inbev ON TAPny-sla ON TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 128 m apart · name similarity 1.00
ab-inbev ON TAPoverture On Tap1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 70 m apart · name similarity 1.00
ab-inbev ON TAPvtinfo ON TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 76 m apart · name similarity 1.00
ny-sla ON TAPny-sla ON TAP1.00one store listed twicemergedsame street + ZIP · name: identical
ny-sla ON TAPoverture On Tap1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
ny-sla ON TAPvtinfo ON TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00
ny-sla ON TAPoverture On Tap1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 75 m apart · name similarity 1.00
ny-sla ON TAPvtinfo ON TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 58 m apart · name similarity 1.00
overture On Tapvtinfo ON TAP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 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
BULLOCK BOYS LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on, spirits_on — NY 0343; NY 0423 (add-on: follows the base licence)
Rule version 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
67 within 1 mi · 249 within 3 mi
Off / on premise
25 / 27 within 1 mi · 74 / 120 within 3 mi
Selling alcohol
36 within 1 mi · 146 within 3 mi
Nearest
same channel 0.10 mi · licensed 0.08 mi
Setting
suburban (1,686 people per sq mi)
People within 3 mi
47,680 (33,590 adults 21+, 19,026 households) from 11 tract(s), tracts within 3 mi
Income
per capita $46,298 · median household ~$90,973 (weighted mean of tract medians)
Age and education
median age ~37.1 · bachelor's or higher 41%
Ethnicity
Hispanic 6% · White 72% · Black 9% · Asian 10%
Adults per alcohol outlet
229
Alcohol spend within 3 mi
$13,442,651 a year ($6,122,106 at home, $7,314,347 away) · $91,447 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 30ff7afe-3b3d-455e-8626-98b5b3e32db3 ↔ vtinfo a43ea785f9022e07same address and namemerged15
2026-11-12 14:25insertny-sla 0423-23-237430 ↔ vtinfo a43ea785f9022e07same address and namemerged12
2026-11-12 14:25insertny-sla 0343-23-202583 ↔ vtinfo a43ea785f9022e07same address and namemerged12
2026-11-12 14:25insertab-inbev 3279312 ↔ vtinfo a43ea785f9022e07same address and namemerged12
2026-11-11 12:56insertab-inbev 3279312 ↔ ny-sla 0423-23-237430same address and namemerged12
2026-11-11 12:56insertab-inbev 3279312 ↔ ny-sla 0343-23-202583same address and namemerged12
2026-11-11 12:56insertab-inbev 3279312 ↔ overture 30ff7afe-3b3d-455e-8626-98b5b3e32db3same address and namemerged12
2026-11-06 18:13insertny-sla 0423-23-237430 ↔ overture 30ff7afe-3b3d-455e-8626-98b5b3e32db3same address and namemerged11
2026-11-06 18:13insertny-sla 0343-23-202583 ↔ overture 30ff7afe-3b3d-455e-8626-98b5b3e32db3same address and namemerged11
2026-11-03 13:33backfillny-sla 0343-23-202583 ↔ ny-sla 0423-23-237430one store listed twicemerged