Kanpai Sushi

PISMO BEACH, CA 93449 · O14e4e167487a · first seen 2026-10-08
2 sourceson premise · restaurantalcohol: 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
Kanpai Sushi 1 other
a source's own spelling of the licence name (record_title.py)
SPYGLASS SUSHI LLC ca-abc (legal name) ×2
Street
2665 SHELL BEACH RD M 1 other
ca-abc
2665 Shell Beach Rd overture
City
PISMO BEACH
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93449
ca-abcno other value
Pin
35.16298, -120.68650 map 1 other
overture
54 m away ca-abc ×2
Phone
8052956636
overtureno other value
Licences
ca-abc 00536666|41|APP|0 · ca-abc 00536666|41|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od5affd7b5758; O8eac1b623d8e

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
ca-abcKANPAI SUSHI
legal name: SPYGLASS SUSHI LLC
00536666|41|APP|0
2665 SHELL BEACH RD M, PISMO BEACH, CA, 9344935.16322, -120.687022026-10-082026-11-05
ca-abcKANPAI SUSHI
legal name: SPYGLASS SUSHI LLC
00536666|41|LIC|0
2665 SHELL BEACH RD M, PISMO BEACH, CA, 9344935.16322, -120.687022026-10-082026-11-05
overtureKanpai Sushi
8b4ef013-ca22-4947-9ca8-b321e511ecdc
2665 Shell Beach Rd, Pismo Beach, CA, 93449805295663635.16298, -120.686502026-11-182026-11-18

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
ca-abc KANPAI SUSHIca-abc KANPAI SUSHI1.00one licence filemergedfile: 00536666 · same_address
ca-abc KANPAI SUSHIoverture Kanpai Sushi1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 54 m apart · name similarity 1.00 · street similarity 0.92
ca-abc KANPAI SUSHIoverture Kanpai Sushi1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 54 m apart · name similarity 1.00 · street similarity 0.92

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
SPYGLASS SUSHI LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — CA 41
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
14 within 1 mi · 97 within 3 mi
Off / on premise
4 / 7 within 1 mi · 17 / 52 within 3 mi
Selling alcohol
12 within 1 mi · 89 within 3 mi
Nearest
same channel 0.07 mi · licensed 0.02 mi
Setting
rural (225 people per sq mi)
People within 3 mi
6,354 (5,458 adults 21+, 3,147 households) from 2 tract(s), tracts within 3 mi
Income
per capita $81,488 · median household ~$123,350 (weighted mean of tract medians)
Age and education
median age ~53.5 · bachelor's or higher 57%
Ethnicity
Hispanic 13% · White 79% · Black 1% · Asian 3%
Adults per alcohol outlet
61
Alcohol spend within 3 mi
$2,868,032 a year ($1,245,905 at home, $1,621,046 away) · $31,867 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-18 18:58insertca-abc 00536666|41|LIC|0 ↔ overture 8b4ef013-ca22-4947-9ca8-b321e511ecdcstreet written two waysmerged15
2026-11-18 18:58insertca-abc 00536666|41|APP|0 ↔ overture 8b4ef013-ca22-4947-9ca8-b321e511ecdcstreet written two waysmerged15
2026-10-09 13:59backfillca-abc 00536666|41|APP|0 ↔ ca-abc 00536666|41|LIC|0one licence filemerged