Shell

MIDDLE ISLAND, NY 11953 · O02392b74f0f9 · first seen 2026-11-02
6 sourcesoff premise · conveniencechain: Shellalcohol: 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
Shell 3 other
the most common name a source states
FOOD MART ny-sla
MID ENTERPRISE inspections
MID ENTERPRISE INC ny-sla (legal name)
Street
809 MIDDLE COUNTRY RD 1 other
shell
809 MIDDLE COUNTRY ROAD inspectionsny-sla ×2
City
MIDDLE ISLAND
shellno other value
State
NY
shellno other value
ZIP
11953
shellno other value
Pin
40.88338, -72.94248 map 1 other
shell
57 m away ab-inbev
Phone
6319243933
shellno other value
Licences
ny-sla 0081-22-131358
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc574cd9ae55a; O1873905dd57c; O4452de3458f6; O06645c301005; O979651304405

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-inbevSHELL
2731411
809 MIDDLE COUNTRY RD, MIDDLE ISLAND, NY, 1195340.88328, -72.941812026-11-112026-11-11
inspectionsMID ENTERPRISE
inspections|nys-retail|473077
809 MIDDLE COUNTRY ROAD, Middle Island, NY, 1195340.88331, -72.942332026-11-192026-11-19
ny-slaFOOD MART
legal name: MID ENTERPRISE INC
0081-22-131358
809 MIDDLE COUNTRY ROAD, MIDDLE ISLAND, NY, 1195340.88331, -72.942332026-11-022026-11-18
overtureShell
6573f824-62ce-4c1c-bb83-0da95f66c803
809 Middle Country Rd, Middle Island, NY, 11953631924393340.88334, -72.942332026-11-132026-11-13
shellShell
10000363
809 MIDDLE COUNTRY RD, MIDDLE ISLAND, NY, 11953631924393340.88338, -72.942482026-11-102026-11-10
vtinfoSHELL
1be179973c6e3ef3
809 MIDDLE COUNTRY RD, MIDDLE ISLAND, NY, 11953631924393340.88342, -72.942672026-11-152026-11-15

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 SHELLoverture Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 44 m apart · name similarity 1.00
ab-inbev SHELLshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 57 m apart · name similarity 1.00
ab-inbev SHELLvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 74 m apart · name similarity 1.00
inspections MID ENTERPRISEny-sla FOOD MART1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 0 m apart · matched through the licence's legal name: MID ENTERPRISE INC · name similarity 1.00
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 · phone: equal
overture Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 29 m apart · name similarity 1.00 · phone: equal
shell Shellvtinfo SHELL1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00 · phone: equal
ab-inbev SHELLny-sla FOOD MART0.10Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “same-address” pair)
Shell station food mart at same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: unsure, 50% confident — Both records are at the same street address with coordinates about 44 m apart, but the names differ (SHELL vs FOOD MART, legal name MID ENTERPRISE INC) and the address holds two businesses, so the names must agree for SAME and the data cannot show whether the Shell account is the Food Mart's own fuel side or a separate business.
pair b977147b321e35e82704

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
licensed — a licence or TTB permit on file
Operator
MID ENTERPRISE INC — 1 outlets in the master under this operator
Licence privileges
beer_off — NY 0081
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
34 within 1 mi · 101 within 3 mi
Off / on premise
9 / 18 within 1 mi · 25 / 52 within 3 mi
Selling alcohol
13 within 1 mi · 55 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.01 mi
Setting
suburban (1,050 people per sq mi)
People within 3 mi
29,686 (22,608 adults 21+, 11,567 households) from 8 tract(s), tracts within 3 mi
Income
per capita $44,752 · median household ~$90,040 (weighted mean of tract medians)
Age and education
median age ~42.4 · bachelor's or higher 33%
Ethnicity
Hispanic 16% · White 61% · Black 22% · Asian 1%
Adults per alcohol outlet
404
Alcohol spend within 3 mi
$8,454,754 a year ($3,833,140 at home, $4,617,973 away) · $150,978 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-19 20:37insertinspections inspections|nys-retail|473077 ↔ ny-sla 0081-22-131358same address and namemerged17
2026-11-18 18:58insertab-inbev 2731411 ↔ ny-sla 0081-22-131358Claude judge: samemerged15
2026-11-15 16:24insertab-inbev 2731411 ↔ vtinfo 1be179973c6e3ef3same address and namemerged15
2026-11-15 16:24insertshell 10000363 ↔ vtinfo 1be179973c6e3ef3same address and namemerged15
2026-11-15 16:24insertoverture 6573f824-62ce-4c1c-bb83-0da95f66c803 ↔ vtinfo 1be179973c6e3ef3same address and namemerged15
2026-11-13 14:10insertab-inbev 2731411 ↔ overture 6573f824-62ce-4c1c-bb83-0da95f66c803same address and namemerged15
2026-11-13 14:10insertoverture 6573f824-62ce-4c1c-bb83-0da95f66c803 ↔ shell 10000363same address and namemerged15
2026-11-11 12:56insertab-inbev 2731411 ↔ shell 10000363same address and namemerged12