Outlets /
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.
| Field | Master value | Taken from | What 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-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 95451 | ca-abc | no other value |
| Pin | 38.97840, -122.83927 map | ubereats | no other value |
| Phone | 7072792440 | overture | no 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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | JOHNS MARKET 535490 | 3860 MAIN ST, KELSEYVILLE, CA, 95451 | 38.97810, -122.83933 | 2026-11-11 | 2026-11-11 | |
| ca-abc | JOHN'S MARKET & DELI legal name: BATIKH BASEL 00630716|20|LIC|0 | 3860 MAIN ST, KELSEYVILLE, CA, 95451 | 38.97810, -122.83926 | 2026-10-08 | 2026-11-05 | |
| ca-abc | JOHN'S MARKET & DELI 00683921|20|APP|0 | 3860 MAIN ST, KELSEYVILLE, CA, 95451 | 38.97810, -122.83926 | 2026-10-30 | 2026-11-04 | |
| doordash | john's market kelseyville 38526133 | 3860 Main St, Kelseyville, CA, 95451 | 38.97825, -122.83939 | 2026-10-08 | 2026-11-06 | |
| overture | John's Market and Deli 8801930c-39da-4eae-b8b5-a9284c3ee561 | 3860 Main St, Kelseyville, CA, 95451 | 7072792440 | 38.97811, -122.83947 | 2026-11-06 | 2026-11-06 |
| ubereats | Johns Market and Deli EyBSzvxDWWKI-J6ui6vTMA | 3860 Main Street, Kelseyville, CA, 95451 | 38.97840, -122.83927 | 2026-10-22 | 2026-11-05 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev JOHNS MARKET | doordash john's market kelseyville | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00 |
| ca-abc JOHN'S MARKET & DELI | ca-abc JOHN'S MARKET & DELI | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| ca-abc JOHN'S MARKET & DELI | overture John's Market and Deli | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00 |
| ca-abc JOHN'S MARKET & DELI | overture John's Market and Deli | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 18 m apart · name similarity 1.00 |
| ca-abc JOHN'S MARKET & DELI | ubereats Johns Market and Deli | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 34 m apart · name similarity 1.00 |
| overture John's Market and Deli | ubereats Johns Market and Deli | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 36 m apart · name similarity 1.00 |
| ab-inbev JOHNS MARKET | ca-abc JOHN'S MARKET & DELI | 0.75 | same address and name | merged | address 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 MARKET | ca-abc JOHN'S MARKET & DELI | 0.75 | same address and name | merged | address 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 MARKET | overture John's Market and Deli | 0.75 | same address and name | merged | address 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 MARKET | ubereats Johns Market and Deli | 0.75 | same address and name | merged | address 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 & DELI | doordash john's market kelseyville | 0.75 | Claude judge: same | merged | 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:
pair 593878db0719382404c5 |
| ca-abc JOHN'S MARKET & DELI | doordash john's market kelseyville | 0.75 | Claude judge: same | merged | 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:
pair 0f368a4b542453de8e64 |
| doordash john's market kelseyville | overture John's Market and Deli | 0.75 | same address and name | merged | address 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 kelseyville | ubereats Johns Market and Deli | 0.75 | Claude judge: same | merged | 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:
pair c28affbfe00a74488697 |
| ca-abc JOHN'S MARKET & DELI | ubereats Johns Market and Deli | 0.66 | Claude judge: same | merged | 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:
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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-12 17:29 | insert | ab-inbev 535490 ↔ ca-abc 00630716|20|LIC|0 | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 535490 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMA | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 535490 ↔ ca-abc 00683921|20|APP|0 | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 535490 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561 | same address and name | merged | 14 |
| 2026-11-12 17:29 | insert | doordash 38526133 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561 | same address and name | merged | 14 |
| 2026-11-11 12:56 | insert | ca-abc 00630716|20|LIC|0 ↔ doordash 38526133 | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00683921|20|APP|0 ↔ doordash 38526133 | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 535490 ↔ doordash 38526133 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 38526133 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMA | Claude judge: same | merged | 11 |
| 2026-11-06 18:13 | insert | overture 8801930c-39da-4eae-b8b5-a9284c3ee561 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMA | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00683921|20|APP|0 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00630716|20|LIC|0 ↔ overture 8801930c-39da-4eae-b8b5-a9284c3ee561 | same address and name | merged | 11 |
| 2026-11-05 17:26 | backfill | ca-abc 00630716|20|LIC|0 ↔ ca-abc 00683921|20|APP|0 | one store listed twice | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00683921|20|APP|0 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMA | same address and name | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00630716|20|LIC|0 ↔ ubereats EyBSzvxDWWKI-J6ui6vTMA | Claude judge: same | merged |