Stewart's Shop

BALLSTON LAKE, NY 12019 · O1ca17ea02014 · first seen 2026-11-02
3 sourcesunknownalcohol: 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
Stewart's Shop 3 other
a licence name in capitals, cleaned (derived; record_title.py)
STEWARTS SHOP ab-inbevvtinfo ×2
STEWART'S SHOP #365 ny-sla
STEWART'S SHOPS CORP ny-sla (legal name)
Street
21 LONGKILL ROAD 1 other
ny-sla
13 LONGKILL RD ab-inbevvtinfo ×2
City
BALLSTON LAKE
ny-slano other value
State
NY
ny-slano other value
ZIP
12019
ny-slano other value
Pin
42.91140, -73.82232 map 1 other
ny-sla
98 m away ab-inbev
Phone
5188778537
vtinfono other value
Licences
ny-sla 0081-21-210714
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe1d9ef4736e3; O6da538307108

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-inbevSTEWARTS SHOP
2911304
13 LONGKILL RD, BALLSTON LAKE, NY, 1201942.91223, -73.821932026-11-112026-11-15
ny-slaSTEWART'S SHOP #365
legal name: STEWART'S SHOPS CORP
0081-21-210714
21 LONGKILL ROAD, BALLSTON LAKE, NY, 1201942.91140, -73.822322026-11-022026-11-18
vtinfoSTEWARTS SHOP
943929787ea0dfb5
13 LONGKILL RD, BALLSTON LAKE, NY, 12019518877853742.91117, -73.822422026-11-152026-11-15

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 STEWARTS SHOPvtinfo STEWARTS SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 124 m apart · name similarity 1.00
ny-sla STEWART'S SHOP #365vtinfo STEWARTS SHOP0.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
Stewart's Shop on Longkill Rd, 27m apart; numbering variance.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 82% confident — Record A is Stewart's Shops #365 with legal entity Stewart's Shops Corp at 21 Longkill Road, Ballston Lake, and record B is Stewart's Shop at 13 Longkill Rd in the same ZIP about 27 m apart; the street number differs but the name and coordinates point to the same single-occupant store, so I judge it the same outlet with moderate confidence.
pair f0bb57d6e954c10ef778

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
STEWART'S SHOPS CORP — 358 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
5 within 1 mi · 48 within 3 mi
Off / on premise
0 / 3 within 1 mi · 15 / 11 within 3 mi
Selling alcohol
4 within 1 mi · 41 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.06 mi
Setting
suburban (541 people per sq mi)
People within 3 mi
15,310 (11,420 adults 21+, 6,403 households) from 4 tract(s), tracts within 3 mi
Income
per capita $70,692 · median household ~$134,518 (weighted mean of tract medians)
Age and education
median age ~43.3 · bachelor's or higher 59%
Ethnicity
Hispanic 1% · White 91% · Black 1% · Asian 4%
Adults per alcohol outlet
272
Alcohol spend within 3 mi
$5,982,471 a year ($2,592,947 at home, $3,387,338 away) · $142,440 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-18 18:58insertny-sla 0081-21-210714 ↔ vtinfo 943929787ea0dfb5Claude judge: samemerged15
2026-11-15 16:24insertab-inbev 2911304 ↔ vtinfo 943929787ea0dfb5same address and namemerged15