NEW YORK PICKLE DELI

ROCKY HILL, CT 06067 · O06bd5a2a79f5 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: 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
NEW YORK PICKLE DELI 2 other
the most common name a source states
A & S RESTAURANT INC ct-dcp (legal name)
new york pickle deli rocky hill doordash
Street
397 CROMWELL AVE UNIT H 1 other
ct-dcp
397 Cromwell Ave doordashoverturevtinfo ×3
City
ROCKY HILL
ct-dcpno other value
State
CT
ct-dcpno other value
ZIP
06067
ct-dcpno other value
Pin
41.65896, -72.67901 map 1 other
doordash
227 m away ct-dcp
Phone
8602579465
vtinfono other value
Licences
ct-dcp CT|LIR.0021589
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8c65c6ef6e68; Obca2e3b78449; Oc2b7a25efdbb

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
ct-dcpNEW YORK PICKLE DELI
legal name: A & S RESTAURANT INC
CT|LIR.0021589
397 CROMWELL AVE UNIT H, ROCKY HILL, CT, 0606741.65692, -72.679032026-11-032026-11-06
doordashnew york pickle deli rocky hill
34077227
397 Cromwell Ave, Rocky Hill, CT, 0606741.65896, -72.679012026-10-082026-11-11
overtureNew York Pickle Deli
e1aa792c-93a4-4b28-ab07-74e2feb28e93
397 Cromwell Ave, Rocky Hill, CT, 06067860257946541.65897, -72.679002026-11-062026-11-06
vtinfoNEW YORK PICKLE DELI
cea5fed9cad74bbc
397 CROMWELL AVE, ROCKY HILL, CT, 06067860257946541.65882, -72.678592026-11-122026-11-14

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
ct-dcp NEW YORK PICKLE DELIdoordash new york pickle deli rocky hill1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 227 m apart · name similarity 1.00
ct-dcp NEW YORK PICKLE DELIoverture New York Pickle Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 227 m apart · name similarity 1.00
ct-dcp NEW YORK PICKLE DELIvtinfo NEW YORK PICKLE DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 214 m apart · name similarity 1.00
doordash new york pickle deli rocky hilloverture New York Pickle Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 1 m apart · name similarity 1.00
doordash new york pickle deli rocky hillvtinfo NEW YORK PICKLE DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 38 m apart · name similarity 1.00
overture New York Pickle Delivtinfo NEW YORK PICKLE DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 38 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
A & S RESTAURANT INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — CT LIR
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
52 within 1 mi · 293 within 3 mi
Off / on premise
9 / 32 within 1 mi · 66 / 163 within 3 mi
Selling alcohol
30 within 1 mi · 146 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
suburban (1,608 people per sq mi)
People within 3 mi
45,451 (36,496 adults 21+, 19,881 households) from 9 tract(s), tracts within 3 mi
Income
per capita $58,693 · median household ~$107,344 (weighted mean of tract medians)
Age and education
median age ~43.8 · bachelor's or higher 48%
Ethnicity
Hispanic 10% · White 74% · Black 5% · Asian 9%
Adults per alcohol outlet
248
Alcohol spend within 3 mi
$16,362,235 a year ($7,261,935 at home, $9,093,624 away) · $111,308 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-12 14:25insertdoordash 34077227 ↔ vtinfo cea5fed9cad74bbcsame address and namemerged12
2026-11-12 14:25insertoverture e1aa792c-93a4-4b28-ab07-74e2feb28e93 ↔ vtinfo cea5fed9cad74bbcsame address and namemerged12
2026-11-12 14:25insertct-dcp CT|LIR.0021589 ↔ vtinfo cea5fed9cad74bbcsame address and namemerged12
2026-11-10 17:05insertdoordash 34077227 ↔ overture e1aa792c-93a4-4b28-ab07-74e2feb28e93same address and namemerged12
2026-11-10 17:05insertct-dcp CT|LIR.0021589 ↔ doordash 34077227same address and namemerged12
2026-11-06 18:13insertct-dcp CT|LIR.0021589 ↔ overture e1aa792c-93a4-4b28-ab07-74e2feb28e93same address and namemerged11