Outlets /
STEWARTS SHOP
MECHANICVILLE, NY 12118 · O78d8e3160e05 · first seen 2026-11-02
4 sourcesoff premise · conveniencealcohol: 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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | STEWARTS SHOP 3 other | the most common name a source states | STEWART'S SHOP #315 ny-sla Stewart's Shops overture STEWART'S SHOPS CORP ny-sla (legal name) |
| Street | 51 LUTHER FOREST BLVD | ny-sla | no other value |
| City | MECHANICVILLE | ny-sla | no other value |
| State | NY | ny-sla | no other value |
| ZIP | 12118 | ny-sla | no other value |
| Pin | 42.94747, -73.78535 map | overture | no other value |
| Phone | 5188991530 | vtinfo | no other value |
| Licences | ny-sla 0081-21-210244 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O935da4a750f8; Oc65c988a157a; Of2b176000287; O9095ce54eeb0
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | STEWARTS SHOP 4009230 | 51 LUTHER FOREST BLVD, MECHANICVILLE, NY, 12118 | 42.94761, -73.78538 | 2026-11-11 | 2026-11-16 | |
| ny-sla | STEWART'S SHOP #315 legal name: STEWART'S SHOPS CORP 0081-21-210244 | 51 LUTHER FOREST BLVD, MECHANICVILLE, NY, 12118 | 42.94767, -73.78540 | 2026-11-02 | 2026-11-06 | |
| overture | Stewart's Shops 7813d0d3-314f-43c1-8276-464323497dfc | 51 Luther Forest Blvd, Mechanicville, NY, 12118 | 5188991530 | 42.94747, -73.78535 | 2026-11-06 | 2026-11-09 |
| vtinfo | STEWARTS SHOP 15fdbae9935eb97c | 51 LUTHER FOREST BLVD, MECHANICVILLE, NY, 12118 | 5188991530 | 42.94790, -73.78527 | 2026-11-15 | 2026-11-16 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ny-sla STEWART'S SHOP #315 | overture ddb2c94f-3f6d-4fa0-a176-315367ec5652 | 1.00 | same address and name | held same-source-conflict | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4470 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00 |
| ab-inbev STEWARTS SHOP | vtinfo STEWARTS SHOP | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ny-sla STEWART'S SHOP #315 | overture Stewart's Shops | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00 |
| ny-sla STEWART'S SHOP #315 | overture ae616224-0951-4135-9bef-1a70d99e9692 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 619 m apart · matched through the licence's legal name: STEWART'S SHOPS CORP · name similarity 1.00 |
| ab-inbev STEWARTS SHOP | ny-sla STEWART'S SHOP #315 | 0.65 | one name contains the other, same address | merged | judge: None · pair_id: 86b5d53705732544e229 · person: None · rule: names contained at one address · stratum: near |
| ny-sla STEWART'S SHOP #315 | vtinfo STEWARTS SHOP | 0.65 | one name contains the other, same address | merged | judge: None · pair_id: 21023323a23c427add3d · person: None · rule: names contained at one address · stratum: near |
Attributes
- Channel
- off_premise · convenience — overture-category
- 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 9, computed 2026-11-17 18:23.
Every vote behind these (raw)
{
"votes": [
[
"overture-category",
"off_premise",
"convenience"
]
]
}Trade area
- Other outlets
- 2 within 1 mi · 60 within 3 mi
- Off / on premise
- 0 / 2 within 1 mi · 22 / 27 within 3 mi
- Selling alcohol
- 1 within 1 mi · 35 within 3 mi
- Nearest
- same channel 1.22 mi · licensed 0.81 mi
- Setting
- rural (481 people per sq mi)
- People within 3 mi
- 13,603 (10,594 adults 21+, 5,880 households) from 3 tract(s), tracts within 3 mi
- Income
- per capita $66,936 · median household ~$122,637 (weighted mean of tract medians)
- Age and education
- median age ~41.2 · bachelor's or higher 57%
- Ethnicity
- Hispanic 4% · White 89% · Black 2% · Asian 4%
- Adults per alcohol outlet
- 294
- Alcohol spend within 3 mi
- $5,248,693 a year ($2,302,782 at home, $2,943,865 away) · $145,797 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-16 14:56 | insert | ab-inbev 4009230 ↔ ny-sla 0081-21-210244 | one name contains the other, same address | merged | 15 |
| 2026-11-16 14:56 | insert | ny-sla 0081-21-210244 ↔ vtinfo 15fdbae9935eb97c | one name contains the other, same address | merged | 15 |
| 2026-11-15 16:24 | insert | ab-inbev 4009230 ↔ vtinfo 15fdbae9935eb97c | same address and name | merged | 15 |
| 2026-11-09 15:32 | update | ny-sla 0081-21-210244 ↔ overture 7813d0d3-314f-43c1-8276-464323497dfc | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ny-sla 0081-21-210244 ↔ overture 7813d0d3-314f-43c1-8276-464323497dfc | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ny-sla 0081-21-210244 ↔ overture ddb2c94f-3f6d-4fa0-a176-315367ec5652 | same address and name | held: same-source-conflict | 11 |
| 2026-11-06 18:13 | insert | ny-sla 0081-21-210244 ↔ overture ae616224-0951-4135-9bef-1a70d99e9692 | same address and name | merged | 11 |