Pip's Cafe & Provisions

Greenport, NY 11944 · O20484cd36886 · first seen 2026-10-08
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
Pip's Cafe & Provisions 2 other
the most common name a source states
Main Street Yum LLC ny-sla (legal name)
pips cafe and provisions 218 main st greenport doordash
Street
218 Main Street 1 other
ny-sla
218 Main St doordashoverture ×2
City
Greenport
ny-slano other value
State
NY
ny-slano other value
ZIP
11944
ny-slano other value
Pin
41.10288, -72.35908 map
doordashno other value
Phone
6313180363
overtureno other value
Licences
ny-sla 0267-25-131942
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od23fb84acb1c; Ocd848ec4698d

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
doordashpips cafe and provisions 218 main st greenport
34115845
218 Main St, Greenport, NY, 1194441.10288, -72.359082026-10-082026-11-16
ny-slaPip's Cafe & Provisions
legal name: Main Street Yum LLC
0267-25-131942
218 Main Street, Greenport, NY, 1194441.10301, -72.359012026-11-022026-11-05
overturePip's Cafe & Provisions
f1baf970-3f2a-47c8-8de0-1598554acf0b
218 Main St, Greenport, NY, 11944631318036341.10291, -72.359012026-11-062026-11-06

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 Pip's Cafe & Provisionsoverture Pip's Cafe & Provisions1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00
doordash pips cafe and provisions 218 main st greenportny-sla Pip's Cafe & Provisions0.64one name contains the other, same addressmergedjudge: None · pair_id: 51df3ff404acdd18d99a · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
Main Street Yum LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, wine_on — NY 0267
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
76 within 1 mi · 128 within 3 mi
Off / on premise
12 / 27 within 1 mi · 21 / 35 within 3 mi
Selling alcohol
71 within 1 mi · 121 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.01 mi
Setting
rural (178 people per sq mi)
People within 3 mi
5,037 (4,167 adults 21+, 2,072 households) from 2 tract(s), tracts within 3 mi
Income
per capita $59,631 · median household ~$87,632 (weighted mean of tract medians)
Age and education
median age ~51.2 · bachelor's or higher 43%
Ethnicity
Hispanic 23% · White 68% · Black 4% · Asian 3%
Adults per alcohol outlet
34
Alcohol spend within 3 mi
$1,578,054 a year ($706,749 at home, $870,731 away) · $12,935 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-16 14:56insertdoordash 34115845 ↔ ny-sla 0267-25-131942one name contains the other, same addressmerged15
2026-11-06 18:13insertny-sla 0267-25-131942 ↔ overture f1baf970-3f2a-47c8-8de0-1598554acf0bsame address and namemerged11