Stewart's Shop

Middle Grove, NY 12850 · O2f4eba69eb1a · 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 8 other
a licence name in capitals, cleaned (derived; record_title.py)
STEWARTS SHOP ab-inbevvtinfo ×2
STEWART'S SHOP #360 ny-sla
STEWART'S SHOP 360 snap
Stewart's Shops overture
STEWART'S SHOPS #360 lottery
STEWART'S SHOPS CORP ny-sla (legal name)
STEWARTS SHOP 360 inspections
STEWARTS SHOPS CORP inspections (legal name)
Street
465 MIDDLE GROVE ROAD 2 other
ny-sla
465 MIDDLE GROVE RD inspectionsoverturesnap ×3
465 MIDDLEGROVE RD ab-inbevvtinfo ×2
City
MIDDLE GROVE
ny-slano other value
State
NY
ny-slano other value
ZIP
12850
ny-slano other value
Pin
43.08700, -73.92100 map 1 other
overture
54 m away ab-inbev
Phone
5185830070
vtinfono other value
Licences
ny-sla 0081-21-208142
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa8592bd28cab; O9d51f5e59ed8; Odcd0ed562135; O85e3bf73d2be; Od873d96a1148; O63aa9f583bf5

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
2731026
465 MIDDLEGROVE RD, MIDDLE GROVE, NY, 1285043.08660, -73.921372026-11-112026-11-11
inspectionsSTEWARTS SHOP 360
legal name: STEWARTS SHOPS CORP
inspections|nys-retail|410002
465 MIDDLE GROVE RD, Middle Grove, NY, 1285043.08707, -73.921092026-11-192026-11-19
lotterySTEWART'S SHOPS #360
lottery|ny|033399
465 MIDDLE GROVE ROAD, Middle Grove, NY, 1285043.08713, -73.920622026-11-202026-11-20
ny-slaSTEWART'S SHOP #360
legal name: STEWART'S SHOPS CORP
0081-21-208142
465 MIDDLE GROVE ROAD, MIDDLE GROVE, NY, 1285043.08707, -73.921092026-11-022026-11-12
overtureStewart's Shops
3d02aec8-9b47-4427-acca-e7e42fb9c378
465 Middle Grove Rd, Middle Grove, NY, 12850518583007043.08700, -73.921002026-11-062026-11-12
snapSTEWART'S SHOP 360
snap|us|374639
465 Middle Grove Rd, Middle Grove, NY, 1285043.08724, -73.921332026-11-192026-11-19
vtinfoSTEWARTS SHOP
1fe8098e1c1fb6f9
465 MIDDLEGROVE RD, MIDDLE GROVE, NY, 12850518583007043.08706, -73.921042026-11-202026-11-22

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 + city + state · pins 58 m apart · name similarity 1.00
inspections STEWARTS SHOP 360ny-sla STEWART'S SHOP #3601.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 360overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · matched through the licence's legal name: STEWARTS SHOPS CORP · name similarity 1.00
inspections STEWARTS SHOP 360snap STEWART'S SHOP 3601.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
lottery STEWART'S SHOPS #360overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
ny-sla STEWART'S SHOP #360overture Stewart's Shops1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00
ny-sla STEWART'S SHOP #360snap STEWART'S SHOP 3601.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
ab-inbev STEWARTS SHOPny-sla STEWART'S SHOP #3600.65Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (94% confident; asked as a “near” pair)
Stewart's Shop same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 465 Middle Grove Road in Middle Grove NY 12850, with coordinates about 57 m apart, and the names agree as Stewart's Shop (store #360 under the legal entity Stewart's Shops Corp); no other business is at that address.
pair 095d3ec6da09275710e8

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"
  ]
 ]
}

Trade area

Other outlets
0 within 1 mi · 1 within 3 mi
Off / on premise
0 / 0 within 1 mi · 0 / 0 within 3 mi
Selling alcohol
0 within 1 mi · 1 within 3 mi
Nearest
same channel none within 3 mi · licensed 1.45 mi
Setting
rural (163 people per sq mi)
People within 3 mi
4,599 (3,326 adults 21+, 1,747 households) from 1 tract(s), tracts within 3 mi
Income
per capita $34,588 · median household ~$79,141 (weighted mean of tract medians)
Age and education
median age ~37.9 · bachelor's or higher 18%
Ethnicity
Hispanic 2% · White 91% · Black 3% · Asian 0%
Adults per alcohol outlet
1,663
Alcohol spend within 3 mi
$1,081,486 a year ($502,217 at home, $578,876 away) · $540,743 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 2731026 ↔ vtinfo 1fe8098e1c1fb6f9same address and namemerged17
2026-11-20 22:08insertlottery lottery|ny|033399 ↔ overture 3d02aec8-9b47-4427-acca-e7e42fb9c378same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|410002 ↔ snap snap|us|374639same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|410002 ↔ overture 3d02aec8-9b47-4427-acca-e7e42fb9c378same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|410002 ↔ ny-sla 0081-21-208142same address and namemerged17
2026-11-19 20:37insertny-sla 0081-21-208142 ↔ snap snap|us|374639same address and namemerged17
2026-11-12 17:29insertab-inbev 2731026 ↔ ny-sla 0081-21-208142Claude judge: samemerged14
2026-11-06 18:13insertny-sla 0081-21-208142 ↔ overture 3d02aec8-9b47-4427-acca-e7e42fb9c378same address and namemerged11