John's Market and Deli

KELSEYVILLE, CA 95451 · O2a1fb387ba9f · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: Johns Market and Delialcohol: licensed2 licences

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 Market and Deli 5 other
a source's own spelling of the licence name (record_title.py)
JOHN'S MARKET & DELI ca-abc ×2
BATIKH BASEL ca-abc (legal name)
john's market kelseyville doordash
JOHNS MARKET ab-inbev
Johns Market and Deli ubereats
Street
3860 MAIN ST 1 other
ca-abc
3860 Main Street ubereats
City
KELSEYVILLE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95451
ca-abcno other value
Pin
38.97840, -122.83927 map
ubereatsno other value
Phone
7072792440
overtureno other value
Licences
ca-abc 00630716|20|LIC|0 · ca-abc 00683921|20|APP|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oda6abdf40544; O9dbe913aa04d; Obac40ea7bd47; O82550b251095; Oc8f22834a01e

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-inbevJOHNS MARKET
535490
3860 MAIN ST, KELSEYVILLE, CA, 9545138.97810, -122.839332026-11-112026-11-11
ca-abcJOHN'S MARKET & DELI
legal name: BATIKH BASEL
00630716|20|LIC|0
3860 MAIN ST, KELSEYVILLE, CA, 9545138.97810, -122.839262026-10-082026-11-05
ca-abcJOHN'S MARKET & DELI
00683921|20|APP|0
3860 MAIN ST, KELSEYVILLE, CA, 9545138.97810, -122.839262026-10-302026-11-04
doordashjohn's market kelseyville
38526133
3860 Main St, Kelseyville, CA, 9545138.97825, -122.839392026-10-082026-11-06
overtureJohn's Market and Deli
8801930c-39da-4eae-b8b5-a9284c3ee561
3860 Main St, Kelseyville, CA, 95451707279244038.97811, -122.839472026-11-062026-11-06
ubereatsJohns Market and Deli
EyBSzvxDWWKI-J6ui6vTMA
3860 Main Street, Kelseyville, CA, 9545138.97840, -122.839272026-10-222026-11-05

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 JOHNS MARKETdoordash john's market kelseyville1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ca-abc JOHN'S MARKET & DELIca-abc JOHN'S MARKET & DELI1.00one store listed twicemergedsame street + ZIP · name: identical
ca-abc JOHN'S MARKET & DELIoverture John's Market and Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
ca-abc JOHN'S MARKET & DELIoverture John's Market and Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00
ca-abc JOHN'S MARKET & DELIubereats Johns Market and Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00
overture John's Market and Deliubereats Johns Market and Deli1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00
ab-inbev JOHNS MARKETca-abc JOHN'S MARKET & DELI0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, market · name Jaro-Winkler 0.82 · same street + ZIP · pins 6 m apart · name similarity 0.75
ab-inbev JOHNS MARKETca-abc JOHN'S MARKET & DELI0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, market · name Jaro-Winkler 0.82 · same street + ZIP · pins 6 m apart · name similarity 0.75
ab-inbev JOHNS MARKEToverture John's Market and Deli0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, market · name Jaro-Winkler 0.82 · same street + ZIP · pins 12 m apart · name similarity 0.75
ab-inbev JOHNS MARKETubereats Johns Market and Deli0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, market · name Jaro-Winkler 0.82 · same street + ZIP · pins 34 m apart · name similarity 0.75
ca-abc JOHN'S MARKET & DELIdoordash john's market kelseyville0.75Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The DoorDash slug 'john's market kelseyville' is the name 'John's Market' with the city appended, and it matches the licensed off-sale store JOHN'S MARKET & DELI at the same street address and ZIP, wh
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give 3860 Main St, Kelseyville CA 95451 with coordinates 0.02 km apart, and the DoorDash slug 'john's market kelseyville' matches the CA-ABC DBA 'JOHN'S MARKET & DELI' with an active off-sale licence, though two businesses share the address so the name match carries the decision.
  • Claude Haiku 5.5, prompt v4: same, 72% confident — The DoorDash slug 'john's market kelseyville' matches the CA-ABC DBA 'JOHN'S MARKET & DELI' in the same city and state, and it looks like a single independent store rather than a chain, though the building holds three businesses and the DoorDash record has no street address to confirm the premises.
pair 593878db0719382404c5
ca-abc JOHN'S MARKET & DELIdoordash john's market kelseyville0.75Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records name John's Market at 3860 Main St, Kelseyville, about 20 m apart; the names agree despite the shared building, and the pending licence is under the same name, so it does not point to a s
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — The CA ABC record 'JOHN'S MARKET & DELI' and the DoorDash slug 'john's market kelseyville' share the same name and city, at the same street address and ZIP, with coordinates about 0.02 km apart; the pending application is under the same name, so it is not a predecessor listing.
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records give 3860 Main St, Kelseyville, CA 95451 with coordinates about 20 m apart, and the names agree on 'John's Market' (the DoorDash slug adds the city). The ABC record's only licence is a pending off-sale application under the same name, so it is not a predecessor listed under another name. The building has two businesses, but the matching names support one outlet.
  • Claude Haiku 5.5, prompt v4: unsure, 50% confident — The DoorDash record gives only a slug and city, with no street address, so it cannot be tied to 3860 Main St, which is shared by three businesses; the names roughly agree (John's Market, Kelseyville), but a generic name with no address match is not enough to confirm one premises.
pair 0f368a4b542453de8e64
doordash john's market kelseyvilleoverture John's Market and Deli0.75same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: deli, market · name Jaro-Winkler 0.82 · same street + ZIP · pins 16 m apart · name similarity 0.75
doordash john's market kelseyvilleubereats Johns Market and Deli0.75Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
Both records name John's Market at the same street address, 3860 Main St, Kelseyville, 0.02 km apart, and the DoorDash slug simply appends the city to the name, so the names agree despite the shared-b
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 3860 Main Street, Kelseyville CA 95451 with coordinates about 20 m apart, and the names match (John's Market Kelseyville vs Johns Market and Deli); the only other business at the address is not a competing name, so the address and name agree.
pair c28affbfe00a74488697
ca-abc JOHN'S MARKET & DELIubereats Johns Market and Deli0.66Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records carry the same distinctive name, John's Market & Deli, at 3860 Main St, Kelseyville 95451, and the off-sale store licence matches a market; the shared building does not matter because the
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Same street address, ZIP and city in California, and the names match ('JOHN'S MARKET & DELI' vs 'Johns Market and Deli'); the ABC record is an active off-sale licence for a store, consistent with the Uber Eats market, and the building has three businesses but the names agree.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — The names match closely (JOHN'S MARKET & DELI vs Johns Market and Deli), the street address, city and ZIP are identical, and the off-sale licence fits a market; the building has 3 businesses, but the matching names are what decide it.
pair 62538e1a7bd5b4c101e1

Attributes

Channel
off_premise · convenience — ca-licence
Chain
Johns Market and Deli — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_off, wine_off — CA 20
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
19 within 1 mi · 35 within 3 mi
Off / on premise
3 / 10 within 1 mi · 5 / 12 within 3 mi
Selling alcohol
16 within 1 mi · 32 within 3 mi
Nearest
same channel 0.08 mi · licensed 0.02 mi
Setting
rural (225 people per sq mi)
People within 3 mi
6,355 (4,433 adults 21+, 2,368 households) from 1 tract(s), tracts within 3 mi
Income
per capita $33,824 · median household ~$56,667 (weighted mean of tract medians)
Age and education
median age ~36.6 · bachelor's or higher 13%
Ethnicity
Hispanic 47% · White 51% · Black 5% · Asian 1%
Adults per alcohol outlet
134
Alcohol spend within 3 mi
$1,410,494 a year ($669,135 at home, $741,013 away) · $42,742 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:29insertab-inbev 535490 ↔ ca-abc 00630716|20|LIC|0same address and namemerged14
2026-11-12 17:29insertab-inbev 535490 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMAsame address and namemerged14
2026-11-12 17:29insertab-inbev 535490 ↔ ca-abc 00683921|20|APP|0same address and namemerged14
2026-11-12 17:29insertab-inbev 535490 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561same address and namemerged14
2026-11-12 17:29insertdoordash 38526133 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561same address and namemerged14
2026-11-11 12:56insertca-abc 00630716|20|LIC|0 ↔ doordash 38526133Claude judge: samemerged12
2026-11-11 12:56insertca-abc 00683921|20|APP|0 ↔ doordash 38526133Claude judge: samemerged12
2026-11-11 12:56insertab-inbev 535490 ↔ doordash 38526133same address and namemerged12
2026-11-06 18:13insertdoordash 38526133 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMAClaude judge: samemerged11
2026-11-06 18:13insertoverture 8801930c-39da-4eae-b8b5-a9284c3ee561 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMAsame address and namemerged11
2026-11-06 18:13insertca-abc 00683921|20|APP|0 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561same address and namemerged11
2026-11-06 18:13insertca-abc 00630716|20|LIC|0 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561same address and namemerged11
2026-11-05 17:26backfillca-abc 00630716|20|LIC|0 ↔ ca-abc 00683921|20|APP|0one store listed twicemerged
2026-11-02 23:02backfillca-abc 00683921|20|APP|0 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMAsame address and namemerged
2026-11-02 23:02backfillca-abc 00630716|20|LIC|0 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMAClaude judge: samemerged