Tsunami Panhandle

SAN FRANCISCO, CA 94117 · O4c61b6b5f143 · first seen 2026-10-08
1 sourceon 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
Tsunami Panhandle 1 other
a licence name in capitals, cleaned (derived; record_title.py)
FULTON LOUNGE INC ca-abc (legal name)
Street
1306-08 FULTON ST
ca-abcno other value
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94117
ca-abcno other value
Pin
37.77688, -122.43842 map
ca-abcno other value
Phone
none
no other value
Licences
ca-abc 00480449|47|LIC|0
every licence and permit record in the outlet
Joined by singleton · absorbed ids: none

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-abcTSUNAMI PANHANDLE
legal name: FULTON LOUNGE INC
00480449|47|LIC|0
1306-08 FULTON ST, SAN FRANCISCO, CA, 9411737.77688, -122.438422026-10-082026-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
ca-abc TSUNAMI PANHANDLEdoordash tsunami panhandle san francisco1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “proximity” pair)
The distinctive name 'Tsunami Panhandle' matches, with the DoorDash slug adding only the city. Both records give 1306 Fulton St, 94117, 7 m apart, and our data holds only one business at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 95% confident — Same name and address
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records name Tsunami Panhandle at 1306 Fulton Street, San Francisco 94117 with close coordinates, and the California licence (eating place, restaurant with full bar) is the same business's licence beside its DoorDash listing; no other business is held at that address.
  • Claude Haiku 5.5, prompt v7: same, 93% confident — The California ABC record is an active restaurant licence for TSUNAMI PANHANDLE at 1306-08 Fulton St, and the DoorDash listing 'tsunami panhandle san francisco' matches the same name and ZIP at the same street address, with only one business at that address and coordinates 7 metres apart.
pair 40d937102c21845b691e

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
FULTON LOUNGE INC — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
826 within 1 mi · 6,264 within 3 mi
Off / on premise
154 / 523 within 1 mi · 842 / 3,992 within 3 mi
Selling alcohol
591 within 1 mi · 3,930 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (19,544 people per sq mi)
People within 3 mi
552,587 (476,976 adults 21+, 270,420 households) from 171 tract(s), tracts within 3 mi
Income
per capita $107,007 · median household ~$154,814 (weighted mean of tract medians)
Age and education
median age ~40.2 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 47% · Black 4% · Asian 29%
Adults per alcohol outlet
121
Alcohol spend within 3 mi
$261,484,390 a year ($110,942,096 at home, $150,463,333 away) · $66,519 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-11 12:56insertca-abc 00480449|47|LIC|0 ↔ doordash 976162Claude judge: sameheld: same-source-conflict12