Outlets /
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.
| Field | Master value | Taken from | What 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-sla | no other value |
| City | FRANKFORT | ny-sla | no other value |
| State | NY | ny-sla | no other value |
| ZIP | 13340 | ny-sla | no other value |
| Pin | 43.03738, -75.06924 map 1 other | overture | 260 m away ab-inbev |
| Phone | 3158949087 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | STEWARTS SHOP 2630833 | 200 E MAIN ST, FRANKFORT, NY, 13340 | 43.03566, -75.06706 | 2026-11-12 | 2026-11-16 | |
| inspections | STEWARTS SHOP 427 legal name: STEWARTS SHOPS CORP inspections|nys-retail|215273 | 200 E MAIN ST, Frankfort, NY, 13340 | 43.03743, -75.06898 | 2026-11-19 | 2026-11-19 | |
| lottery | STEWART'S SHOPS #427 lottery|ny|039700 | 200 E MAIN ST, Frankfort, NY, 13340 | 43.03752, -75.06904 | 2026-11-20 | 2026-11-20 | |
| ny-sla | STEWART'S SHOP #427 legal name: STEWART'S SHOPS CORP 0081-21-209323 | 200 E MAIN ST, FRANKFORT, NY, 13340 | 43.03743, -75.06898 | 2026-11-02 | 2026-11-05 | |
| overture | Stewart's Shops ea7add2b-d509-4e65-8fa3-48073c06e659 | 200 E Main St, Frankfort, NY, 13340 | 3158949087 | 43.03738, -75.06924 | 2026-11-06 | 2026-11-06 |
| snap | STEWART'S SHOP 427 snap|us|551204 | 200 E Main St, Frankfort, NY, 13340 | 43.03743, -75.06902 | 2026-11-19 | 2026-11-19 |
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 |
|---|---|---|---|---|---|
| ab-inbev STEWARTS SHOP | inspections STEWARTS SHOP 427 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 251 m apart · name similarity 1.00 |
| ab-inbev STEWARTS SHOP | snap STEWART'S SHOP 427 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 253 m apart · name similarity 1.00 |
| inspections STEWARTS SHOP 427 | ny-sla STEWART'S SHOP #427 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · name similarity 1.00 |
| inspections STEWARTS SHOP 427 | overture Stewart's Shops | 1.00 | same address and name | merged | address 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 427 | snap STEWART'S SHOP 427 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00 |
| lottery STEWART'S SHOPS #427 | 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 · name similarity 1.00 |
| ny-sla STEWART'S SHOP #427 | overture Stewart's Shops | 1.00 | same address and name | merged | address 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 #427 | snap STEWART'S SHOP 427 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00 |
| ab-inbev STEWARTS SHOP | ny-sla STEWART'S SHOP #427 | 0.65 | one name contains the other, same address | merged | judge: 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-20 22:08 | insert | ab-inbev 2630833 ↔ inspections inspections|nys-retail|215273 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | ab-inbev 2630833 ↔ snap snap|us|551204 | same address and name | merged | 17 |
| 2026-11-20 22:08 | insert | lottery lottery|ny|039700 ↔ overture ea7add2b-d509-4e65-8fa3-48073c06e659 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|215273 ↔ snap snap|us|551204 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|215273 ↔ ny-sla 0081-21-209323 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | ny-sla 0081-21-209323 ↔ snap snap|us|551204 | same address and name | merged | 17 |
| 2026-11-19 20:37 | insert | inspections inspections|nys-retail|215273 ↔ overture ea7add2b-d509-4e65-8fa3-48073c06e659 | same address and name | merged | 17 |
| 2026-11-16 14:56 | insert | ab-inbev 2630833 ↔ ny-sla 0081-21-209323 | one name contains the other, same address | merged | 15 |
| 2026-11-06 18:13 | insert | ny-sla 0081-21-209323 ↔ overture ea7add2b-d509-4e65-8fa3-48073c06e659 | same address and name | merged | 11 |