Ralphs Famous Italian Ices & Ice Cream

Port Jefferson, NY 11777 · Obe9ea9cbcb4d · first seen 2026-10-08
2 sourceson premise · restaurantchain: Ralphsalcohol: alcohol chain

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
Ralphs Famous Italian Ices & Ice Cream 1 other
the most common name a source states
ralph's famous italian ices port jefferson doordash
Street
112 Main Street
ubereatsno other value
City
Port Jefferson
ubereatsno other value
State
NY
ubereatsno other value
ZIP
11777
ubereatsno other value
Pin
40.94612, -73.06889 map
ubereatsno other value
Phone
none
no other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of784b35d4f35

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
doordashralph's famous italian ices port jefferson
27681332
112 Main Street, Port Jefferson, NY, 1177740.94611, -73.068902026-10-082026-11-03
ubereatsRalphs Famous Italian Ices & Ice Cream
k5-871g5QBK4PPbohmCScA
112 Main Street, Port Jefferson, NY, 1177740.94612, -73.068892026-10-282026-10-28

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
doordash ralph's famous italian ices port jeffersonubereats Ralphs Famous Italian Ices & Ice Cream0.60Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records name Ralph's Famous Italian Ices at 112 Main Street, Port Jefferson 11777, and the names agree once DoorDash's appended city is removed, so the shared building does not undermine the matc
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give the same street address, ZIP and near-identical coordinates in Port Jefferson, and the names match (Ralph's Famous Italian Ices), with no suite conflict; the other business at the address does not carry a different name that would contradict this, and the chain is a single storefront here so the listings describe one outlet.
pair e489e403949d3b6238f6

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
Ralphs — name-prefix
Alcohol
alcohol_chain — Ralphs: licensed at 192 of 251 outlets in licence states
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:19.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
55 within 1 mi · 316 within 3 mi
Off / on premise
7 / 30 within 1 mi · 67 / 162 within 3 mi
Selling alcohol
43 within 1 mi · 194 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.00 mi
Setting
suburban (1,351 people per sq mi)
People within 3 mi
38,188 (28,444 adults 21+, 13,885 households) from 11 tract(s), tracts within 3 mi
Income
per capita $63,708 · median household ~$143,509 (weighted mean of tract medians)
Age and education
median age ~41.8 · bachelor's or higher 52%
Ethnicity
Hispanic 18% · White 75% · Black 3% · Asian 6%
Adults per alcohol outlet
146
Alcohol spend within 3 mi
$13,293,957 a year ($5,734,561 at home, $7,554,883 away) · $68,174 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-02 23:02backfilldoordash 27681332 ↔ ubereats k5-871g5QBK4PPbohmCScAClaude judge: samemerged