John's Coffee Shop

New York, NY 10017 · O05e7e7c99f48 · first seen 2026-10-26
3 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
John's Coffee Shop 2 other
the most common name a source states
John's Coffee Shop - Murray Hill ubereats
P R CREPE LTD ny-sla (legal name)
Street
823 2ND AVE
ny-slano other value
City
NEW YORK
ny-slano other value
State
NY
ny-slano other value
ZIP
10017
ny-slano other value
Pin
40.75114, -73.97149 map
ubereatsno other value
Phone
2128674955
overtureno other value
Licences
ny-sla 0240-22-102179
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9cbaac35874c; O5473c607c2d2

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
ny-slaJOHN'S COFFEE SHOP
legal name: P R CREPE LTD
0240-22-102179
823 2ND AVE, NEW YORK, NY, 1001740.75104, -73.971352026-11-022026-11-12
overtureJohn's Coffee Shop
311c63de-3389-4372-8ccc-35ebfe472841
823 2nd Ave, New York, NY, 10017212867495540.75108, -73.971512026-11-062026-11-12
ubereatsJohn's Coffee Shop - Murray Hill
Mv5rYW0jQ4ukiV68f3xGHQ
823 2nd Ave, New York, NY, 1001740.75114, -73.971492026-10-262026-11-03

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
ny-sla JOHN'S COFFEE SHOPoverture John's Coffee Shop1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ny-sla JOHN'S COFFEE SHOPubereats John's Coffee Shop - Murray Hill0.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
John's Coffee Shop at same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are at 823 2nd Ave, New York 10017 with coordinates about 16 m apart, the Uber Eats name 'John's Coffee Shop - Murray Hill' matches the NY SLA trade name 'JOHN'S COFFEE SHOP', and only one business is held at that address, so this is one outlet's licence beside its delivery listing.
pair 3cfe312d8539d7880b63

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
P R CREPE LTD — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on — NY 0240
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
3,584 within 1 mi · 16,391 within 3 mi
Off / on premise
334 / 1,840 within 1 mi · 1,736 / 8,937 within 3 mi
Selling alcohol
2,292 within 1 mi · 10,206 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (44,511 people per sq mi)
People within 3 mi
1,258,513 (1,063,106 adults 21+, 644,936 households) from 290 tract(s), tracts within 3 mi
Income
per capita $112,197 · median household ~$139,135 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 73%
Ethnicity
Hispanic 16% · White 60% · Black 6% · Asian 16%
Adults per alcohol outlet
104
Alcohol spend within 3 mi
$598,317,847 a year ($256,151,580 at home, $341,971,217 away) · $58,618 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 17:29insertny-sla 0240-22-102179 ↔ ubereats Mv5rYW0jQ4ukiV68f3xGHQClaude judge: samemerged14
2026-11-06 18:13insertny-sla 0240-22-102179 ↔ overture 311c63de-3389-4372-8ccc-35ebfe472841same address and namemerged11