Stewart's Shop #427

Frankfort, NY 13340 · O57446a2862d2 · 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 #427 7 other
a licence name in capitals, cleaned (derived; record_title.py)
STEWART'S SHOP 427 snap
Stewart's Shops overture
STEWART'S SHOPS #427 lottery
STEWART'S SHOPS CORP ny-sla (legal name)
STEWARTS SHOP ab-inbev
STEWARTS SHOP 427 inspections
STEWARTS SHOPS CORP inspections (legal name)
Street
200 E MAIN ST
ny-slano other value
City
FRANKFORT
ny-slano other value
State
NY
ny-slano other value
ZIP
13340
ny-slano other value
Pin
43.03738, -75.06924 map 1 other
overture
260 m away ab-inbev
Phone
3158949087
overtureno other value
Licences
ny-sla 0081-21-209323
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9c452f494f3b; O61f1e68f9a13; Of98d351bebc6; Occ025307a1ac; O63d349b0fd12

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
2630833
200 E MAIN ST, FRANKFORT, NY, 1334043.03566, -75.067062026-11-122026-11-16
inspectionsSTEWARTS SHOP 427
legal name: STEWARTS SHOPS CORP
inspections|nys-retail|215273
200 E MAIN ST, Frankfort, NY, 1334043.03743, -75.068982026-11-192026-11-19
lotterySTEWART'S SHOPS #427
lottery|ny|039700
200 E MAIN ST, Frankfort, NY, 1334043.03752, -75.069042026-11-202026-11-20
ny-slaSTEWART'S SHOP #427
legal name: STEWART'S SHOPS CORP
0081-21-209323
200 E MAIN ST, FRANKFORT, NY, 1334043.03743, -75.068982026-11-022026-11-05
overtureStewart's Shops
ea7add2b-d509-4e65-8fa3-48073c06e659
200 E Main St, Frankfort, NY, 13340315894908743.03738, -75.069242026-11-062026-11-06
snapSTEWART'S SHOP 427
snap|us|551204
200 E Main St, Frankfort, NY, 1334043.03743, -75.069022026-11-192026-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 4271.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 251 m apart · name similarity 1.00
ab-inbev STEWARTS SHOPsnap STEWART'S SHOP 4271.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 253 m apart · name similarity 1.00
inspections STEWARTS SHOP 427ny-sla STEWART'S SHOP #4271.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 427overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · matched through the licence's legal name: STEWARTS SHOPS CORP · name similarity 1.00
inspections STEWARTS SHOP 427snap STEWART'S SHOP 4271.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
lottery STEWART'S SHOPS #427overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
ny-sla STEWART'S SHOP #427overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00
ny-sla STEWART'S SHOP #427snap STEWART'S SHOP 4271.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00
ab-inbev STEWARTS SHOPny-sla STEWART'S SHOP #4270.65one name contains the other, same addressmergedjudge: None · pair_id: f51c52a3d620b9654aa9 · 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:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
18 within 1 mi · 52 within 3 mi
Off / on premise
5 / 8 within 1 mi · 16 / 18 within 3 mi
Selling alcohol
12 within 1 mi · 37 within 3 mi
Nearest
same channel 0.28 mi · licensed 0.02 mi
Setting
suburban (528 people per sq mi)
People within 3 mi
14,929 (11,244 adults 21+, 6,515 households) from 3 tract(s), tracts within 3 mi
Income
per capita $35,140 · median household ~$66,015 (weighted mean of tract medians)
Age and education
median age ~42.6 · bachelor's or higher 22%
Ethnicity
Hispanic 4% · White 91% · Black 1% · Asian 1%
Adults per alcohol outlet
296
Alcohol spend within 3 mi
$3,470,185 a year ($1,663,267 at home, $1,805,586 away) · $91,321 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-20 22:08insertab-inbev 2630833 ↔ inspections inspections|nys-retail|215273same address and namemerged17
2026-11-20 22:08insertab-inbev 2630833 ↔ snap snap|us|551204same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|039700 ↔ overture ea7add2b-d509-4e65-8fa3-48073c06e659same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|215273 ↔ snap snap|us|551204same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|215273 ↔ ny-sla 0081-21-209323same address and namemerged17
2026-11-19 20:37insertny-sla 0081-21-209323 ↔ snap snap|us|551204same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|215273 ↔ overture ea7add2b-d509-4e65-8fa3-48073c06e659same address and namemerged17
2026-11-16 14:56insertab-inbev 2630833 ↔ ny-sla 0081-21-209323one name contains the other, same addressmerged15
2026-11-06 18:13insertny-sla 0081-21-209323 ↔ overture ea7add2b-d509-4e65-8fa3-48073c06e659same address and namemerged11