Stewart's Shop

Schenectady, NY 12302 · O1eec2926ff8a · first seen 2026-11-02
7 sourcesoff premise · conveniencechain: Stewart's Shopsalcohol: 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 7 other
a licence name in capitals, cleaned (derived; record_title.py)
STEWARTS SHOP ab-inbevvtinfo ×2
STEWARTS SHOP 275 inspectionssnap ×2
STEWART'S SHOP #275 ny-sla
Stewart's Shops overture
STEWART'S SHOPS #275 lottery
STEWART'S SHOPS CORP ny-sla (legal name)
STEWARTS SHOPS CORP inspections (legal name)
Street
50 FREEMAN'S BRIDGE RD 1 other
ny-sla
50 FREEMANS BRIDGE RD ab-inbevinspectionslotteryoverturesnapvtinfo ×6
City
GLENVILLE 1 other
ny-sla
SCHENECTADY ab-inbevlotteryoverturesnapvtinfo ×5
State
NY
ny-slano other value
ZIP
12302
ny-slano other value
Pin
42.83603, -73.93269 map 1 other
overture
391 m away ab-inbev
Phone
5183829654
vtinfono other value
Licences
ny-sla 0081-21-210410
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaf0b4374a3f4; O53dded62cb2d; Oe8e715971d88; Oea79a812c786; O3c81cc32e46c; O4449d31eea01; O318a9f3134f8

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
182563
50 FREEMANS BRIDGE RD, SCHENECTADY, NY, 1230242.83835, -73.936302026-11-112026-11-19
inspectionsSTEWARTS SHOP 275
legal name: STEWARTS SHOPS CORP
inspections|nys-retail|425374
50 FREEMANS BRIDGE RD, Glenville, NY, 1230242.83611, -73.932922026-11-192026-11-19
lotterySTEWART'S SHOPS #275
lottery|ny|030926
50 FREEMANS BRIDGE RD, Schenectady, NY, 1230242.83579, -73.932902026-11-202026-11-20
ny-slaSTEWART'S SHOP #275
legal name: STEWART'S SHOPS CORP
0081-21-210410
50 FREEMAN'S BRIDGE RD, GLENVILLE, NY, 1230242.83611, -73.932922026-11-022026-11-19
overtureStewart's Shops
ea87dfad-26f9-4c2b-9041-b548f6807d67
50 Freemans Bridge Rd, Schenectady, NY, 12302518382965442.83603, -73.932692026-11-062026-11-19
snapStewarts Shop 275
snap|us|1003677
50 Freemans Bridge Rd, Schenectady, NY, 1230242.83587, -73.932962026-11-192026-11-19
vtinfoSTEWARTS SHOP
845fb84324f8d7ac
50 FREEMANS BRIDGE RD, SCHENECTADY, NY, 12302518382965442.83622, -73.932572026-11-152026-11-19

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 SHOPinspections STEWARTS SHOP 2751.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 371 m apart · name similarity 1.00
ab-inbev STEWARTS SHOPsnap Stewarts Shop 2751.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 388 m apart · name similarity 1.00
ab-inbev STEWARTS SHOPvtinfo STEWARTS SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 385 m apart · name similarity 1.00
inspections STEWARTS SHOP 275ny-sla STEWART'S SHOP #2751.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00
inspections STEWARTS SHOP 275overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · matched through the licence's legal name: STEWARTS SHOPS CORP · name similarity 1.00
inspections STEWARTS SHOP 275snap Stewarts Shop 2751.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
inspections STEWARTS SHOP 275vtinfo STEWARTS SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
lottery STEWART'S SHOPS #275overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 32 m apart · name similarity 1.00
ny-sla STEWART'S SHOP #275overture 280002d9-47bf-4885-bee2-60c0656c51301.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 609 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00
ny-sla STEWART'S SHOP #275overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 20 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00
ny-sla STEWART'S SHOP #275snap Stewarts Shop 2751.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ny-sla STEWART'S SHOP #275vtinfo STEWARTS SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
snap Stewarts Shop 275vtinfo STEWARTS SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev STEWARTS SHOPny-sla STEWART'S SHOP #2750.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Stewart's Shop same address, Glenville is in Schenectady ZIP.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name Stewart's Shop at the same street address (50 Freeman's Bridge Rd, ZIP 12302) with only one business at that address, and the NY-SLA legal name STEWART'S SHOPS CORP matches the chain banner, so this is one store under spelling variants (the city difference is a postal-versus-municipal naming quirk for the same ZIP).
pair 4c033a7c41227e91faea

Attributes

Channel
off_premise · convenience — overture-category
Chain
Stewart's Shops — overture-brand
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 11, computed 2026-11-20 23:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

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-20 22:08insertab-inbev 182563 ↔ inspections inspections|nys-retail|425374same address and namemerged17
2026-11-20 22:08insertab-inbev 182563 ↔ snap snap|us|1003677same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|030926 ↔ overture ea87dfad-26f9-4c2b-9041-b548f6807d67same address and namemerged17
2026-11-20 22:08insertinspections inspections|nys-retail|425374 ↔ vtinfo 845fb84324f8d7acsame address and namemerged17
2026-11-20 22:08insertsnap snap|us|1003677 ↔ vtinfo 845fb84324f8d7acsame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|425374 ↔ snap snap|us|1003677same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|425374 ↔ overture ea87dfad-26f9-4c2b-9041-b548f6807d67same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|425374 ↔ ny-sla 0081-21-210410same address and namemerged17
2026-11-19 20:37insertny-sla 0081-21-210410 ↔ snap snap|us|1003677same address and namemerged17
2026-11-18 18:58insertny-sla 0081-21-210410 ↔ vtinfo 845fb84324f8d7acsame address and namemerged15
2026-11-15 16:24insertab-inbev 182563 ↔ vtinfo 845fb84324f8d7acsame address and namemerged15
2026-11-12 17:29insertab-inbev 182563 ↔ ny-sla 0081-21-210410Claude judge: samemerged14
2026-11-09 15:32updateny-sla 0081-21-210410 ↔ overture ea87dfad-26f9-4c2b-9041-b548f6807d67same address and namemerged11
2026-11-06 18:13insertny-sla 0081-21-210410 ↔ overture ea87dfad-26f9-4c2b-9041-b548f6807d67same address and nameheld: same-source-conflict11
2026-11-06 18:13insertny-sla 0081-21-210410 ↔ overture 280002d9-47bf-4885-bee2-60c0656c5130same address and namemerged11