Smiley's Deli

Utica, NY 13501 · O02e9d23680c1 · first seen 2026-10-08
7 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
Smiley's Deli 5 other
a source's own spelling of the licence name (record_title.py)
SMILEYS DELI ab-inbevinspectionsvtinfo ×3
Smileys Deli Corporation snapinspections (legal name) ×2
SMILEY'S DELI CORPORATION ny-sla
smileys deli utica doordash
Smiley’s Deli overture
Street
819 SOUTH ST 1ST FL 1 other
ny-sla
819 SOUTH ST ab-inbevdoordashinspectionsoverturesnapvtinfo ×6
City
UTICA
ny-slano other value
State
NY
ny-slano other value
ZIP
13501
ny-slano other value
Pin
43.09081, -75.21606 map
doordashno other value
Phone
3155205621 1 other
vtinfo
3158788885 overture
Licences
ny-sla 0081-23-210151
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odbb32282bc18; Off6037cd1b70; O5d4625194ed7; O9a59984a7f80; Ofea697368d0f; O05dd77e903a1

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-inbevSMILEYS DELI
4612539
819 SOUTH ST, UTICA, NY, 1350143.09092, -75.216642026-11-112026-11-15
doordashsmileys deli utica
36095931
819 South St, Utica, NY, 1350143.09081, -75.216062026-10-082026-11-15
inspectionsSMILEYS DELI
legal name: SMILEYS DELI CORPORATION
inspections|nys-retail|757709
819 SOUTH ST, Utica, NY, 1350143.09069, -75.216122026-11-192026-11-19
ny-slaSMILEY'S DELI CORPORATION
0081-23-210151
819 SOUTH ST 1ST FL, UTICA, NY, 1350143.09069, -75.216122026-11-022026-11-18
overtureSmiley’s Deli
07b3d168-c746-4f0c-af58-e0f6a7c2bb6d
819 South St, Utica, NY, 13501315878888543.09092, -75.216022026-11-062026-11-15
snapSmileys Deli Corporation
snap|us|1528295
819 South St, Utica, NY, 1350143.09093, -75.216012026-11-192026-11-19
vtinfoSMILEYS DELI
ab730300cdb9c044
819 SOUTH ST, UTICA, NY, 13501315520562143.09092, -75.215992026-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 SMILEYS DELIdoordash smileys deli utica1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 48 m apart · name similarity 1.00
ab-inbev SMILEYS DELIinspections SMILEYS DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 49 m apart · name similarity 1.00
ab-inbev SMILEYS DELIoverture Smiley’s Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00
ab-inbev SMILEYS DELIvtinfo SMILEYS DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 53 m apart · name similarity 1.00
doordash smileys deli uticainspections SMILEYS DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
doordash smileys deli uticaoverture Smiley’s Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
doordash smileys deli uticavtinfo SMILEYS DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
inspections SMILEYS DELIny-sla SMILEY'S DELI CORPORATION1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 0 m apart · name similarity 1.00 · street similarity 0.80
inspections SMILEYS DELIoverture Smiley’s Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 27 m apart · name similarity 1.00
inspections SMILEYS DELIsnap Smileys Deli Corporation1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · matched through the licence's legal name: SMILEYS DELI CORPORATION · name similarity 1.00
inspections SMILEYS DELIvtinfo SMILEYS DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 28 m apart · name similarity 1.00
ny-sla SMILEY'S DELI CORPORATIONsnap Smileys Deli Corporation1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 28 m apart · name similarity 1.00 · street similarity 0.80
overture Smiley’s Delivtinfo SMILEYS DELI1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 3 m apart · name similarity 1.00 · phone: differs
ab-inbev SMILEYS DELIny-sla SMILEY'S DELI CORPORATION0.67Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (94% confident; asked as a “near” pair)
Smiley's Deli same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 819 South St, Utica NY 13501 about 50 m apart, and the names 'SMILEYS DELI' and 'SMILEY'S DELI CORPORATION' match as a trade name and its corporate entity; only one business is at the address and the suite note '1ST FL' does not conflict with a single deli.
pair 8aa58ec819aa3fd47318
doordash smileys deli uticany-sla SMILEY'S DELI CORPORATION0.67Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Smiley's Deli same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 819 South St, Utica NY 13501 about 14 m apart, and the DoorDash listing 'smileys deli utica' matches the NY SLA licensee 'SMILEY'S DELI CORPORATION' (the legal entity behind the deli), with no other business at that address.
pair b7d7481b8b08727ebbbc
ny-sla SMILEY'S DELI CORPORATIONvtinfo SMILEYS DELI0.67Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Smiley's Deli same name and address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 819 South St, Utica NY 13501 with coordinates about 28 m apart, and the names 'SMILEY'S DELI CORPORATION' (ny-sla legal entity behind the trade name) and 'SMILEYS DELI' (vtinfo) clearly refer to the same deli, with no other business at that address and no chain involved.
pair e096ab1a87cf1738cd8c

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SMILEY'S DELI CORPORATION — 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": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
100 within 1 mi · 308 within 3 mi
Off / on premise
14 / 54 within 1 mi · 53 / 161 within 3 mi
Selling alcohol
57 within 1 mi · 186 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.01 mi
Setting
suburban (2,151 people per sq mi)
People within 3 mi
60,810 (42,014 adults 21+, 23,899 households) from 25 tract(s), tracts within 3 mi
Income
per capita $26,768 · median household ~$54,089 (weighted mean of tract medians)
Age and education
median age ~35.8 · bachelor's or higher 20%
Ethnicity
Hispanic 14% · White 54% · Black 17% · Asian 12%
Adults per alcohol outlet
225
Alcohol spend within 3 mi
$11,548,632 a year ($5,635,284 at home, $5,906,503 away) · $61,757 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|757709 ↔ ny-sla 0081-23-210151street written two waysmerged17
2026-11-19 20:37insertny-sla 0081-23-210151 ↔ snap snap|us|1528295street written two waysmerged17
2026-11-19 20:37insertinspections inspections|nys-retail|757709 ↔ overture 07b3d168-c746-4f0c-af58-e0f6a7c2bb6dsame address and namemerged17
2026-11-19 20:37insertdoordash 36095931 ↔ inspections inspections|nys-retail|757709same address and namemerged17
2026-11-19 20:37insertab-inbev 4612539 ↔ inspections inspections|nys-retail|757709same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|757709 ↔ vtinfo ab730300cdb9c044same address and namemerged17
2026-11-19 20:37insertinspections inspections|nys-retail|757709 ↔ snap snap|us|1528295same address and namemerged17
2026-11-18 18:58insertny-sla 0081-23-210151 ↔ vtinfo ab730300cdb9c044Claude judge: samemerged15
2026-11-18 18:58insertdoordash 36095931 ↔ ny-sla 0081-23-210151Claude judge: samemerged15
2026-11-18 18:58insertab-inbev 4612539 ↔ ny-sla 0081-23-210151Claude judge: samemerged15
2026-11-15 16:24insertoverture 07b3d168-c746-4f0c-af58-e0f6a7c2bb6d ↔ vtinfo ab730300cdb9c044same address and namemerged15
2026-11-15 16:24insertdoordash 36095931 ↔ vtinfo ab730300cdb9c044same address and namemerged15
2026-11-15 16:24insertab-inbev 4612539 ↔ vtinfo ab730300cdb9c044same address and namemerged15
2026-11-11 12:56insertab-inbev 4612539 ↔ overture 07b3d168-c746-4f0c-af58-e0f6a7c2bb6dsame address and namemerged12
2026-11-11 12:56insertab-inbev 4612539 ↔ doordash 36095931same address and namemerged12
2026-11-06 18:13insertdoordash 36095931 ↔ overture 07b3d168-c746-4f0c-af58-e0f6a7c2bb6dsame address and namemerged11