Stewart's Shop

Albany, NY 12204 · O2a0df11cb3c4 · first seen 2026-11-02
6 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
STEWART'S SHOP #186 ny-sla
Stewart's Shops overture
STEWART'S SHOPS #186 lottery
STEWART'S SHOPS CORP ny-sla (legal name)
STEWARTS SHOP 186 inspections
STEWARTS SHOPS CORP inspections (legal name)
Street
14 BROADWAY
ny-slano other value
City
MENANDS 1 other
ny-sla
ALBANY ab-inbevinspectionslotteryvtinfo ×4
State
NY
ny-slano other value
ZIP
12204
ny-slano other value
Pin
42.67767, -73.73500 map
overtureno other value
Phone
5184656491
vtinfono other value
Licences
ny-sla 0081-21-213304
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob4e0b5c6bfcd; O819233bbc7af; O71b8aaec37d5; O6628589b6ddf; O6d16a87eb9db

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
3279531
14 BROADWAY, ALBANY, NY, 1220442.67762, -73.734762026-11-112026-11-19
inspectionsSTEWARTS SHOP 186
legal name: STEWARTS SHOPS CORP
inspections|nys-retail|010584
14 BROADWAY, Albany, NY, 1220442.67781, -73.735142026-11-192026-11-19
lotterySTEWART'S SHOPS #186
lottery|ny|037220
14 BROADWAY, Albany, NY, 1220442.67784, -73.734542026-11-202026-11-20
ny-slaSTEWART'S SHOP #186
legal name: STEWART'S SHOPS CORP
0081-21-213304
14 BROADWAY, MENANDS, NY, 1220442.67781, -73.735142026-11-022026-11-19
overtureStewart's Shops
5febbf23-1599-48b4-a5f8-e4b72be3975c
14 Broadway, Menands, NY, 12204518465649142.67767, -73.735002026-11-062026-11-19
vtinfoSTEWARTS SHOP
a7157cc56dc8b65c
14 BROADWAY, ALBANY, NY, 12204518465649142.67777, -73.735162026-11-122026-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 1861.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 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 + city + state · pins 37 m apart · name similarity 1.00
inspections STEWARTS SHOP 186ny-sla STEWART'S SHOP #1861.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 186overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · matched through the licence's legal name: STEWARTS SHOPS CORP · name similarity 1.00
inspections STEWARTS SHOP 186vtinfo STEWARTS SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
lottery STEWART'S SHOPS #186overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 41 m apart · name similarity 1.00
ny-sla STEWART'S SHOP #186overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 19 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00
ab-inbev STEWARTS SHOPny-sla STEWART'S SHOP #1860.65one name contains the other, same addressmergedjudge: None · pair_id: c41b199fb9647ae6426c · person: None · rule: names contained at one address · stratum: near
ny-sla STEWART'S SHOP #186vtinfo STEWARTS SHOP0.65one name contains the other, same addressmergedjudge: None · pair_id: ea2ad07a4a85d62dbb85 · person: None · rule: names contained at one address · stratum: near

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:33.
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:08insertinspections inspections|nys-retail|010584 ↔ vtinfo a7157cc56dc8b65csame address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|037220 ↔ overture 5febbf23-1599-48b4-a5f8-e4b72be3975csame address and namemerged17
2026-11-20 22:08insertab-inbev 3279531 ↔ inspections inspections|nys-retail|010584same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|010584 ↔ overture 5febbf23-1599-48b4-a5f8-e4b72be3975csame address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|010584 ↔ ny-sla 0081-21-213304same address and namemerged17
2026-11-16 14:56insertny-sla 0081-21-213304 ↔ vtinfo a7157cc56dc8b65cone name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 3279531 ↔ ny-sla 0081-21-213304one name contains the other, same addressmerged15
2026-11-12 14:25insertab-inbev 3279531 ↔ vtinfo a7157cc56dc8b65csame address and namemerged12
2026-11-06 18:13insertny-sla 0081-21-213304 ↔ overture 5febbf23-1599-48b4-a5f8-e4b72be3975csame address and namemerged11