Aloha Club

OAKLAND, CA 94601 · Oc940b4eead94 · 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
Aloha Club 1 other
a licence name in capitals, cleaned (derived; record_title.py)
HERNANDEZ & WELTIN INC ca-abc (legal name)
Street
954 FRUITVALE AVE
ca-abcno other value
City
OAKLAND
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94601
ca-abcno other value
Pin
37.77504, -122.22702 map
ca-abcno other value
Phone
none
no other value
Licences
ca-abc 00616388|41|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-abcALOHA CLUB
legal name: HERNANDEZ & WELTIN INC
00616388|41|LIC|0
954 FRUITVALE AVE, OAKLAND, CA, 9460137.77504, -122.227022026-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
ab-inbev ALOHA CLUBca-abc ALOHA CLUB1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same distinctive name, adjacent street numbers, 9 m apart.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 65% confident — Both records carry the identical name ALOHA CLUB in Oakland 94601, and their coordinates are about 9 m apart, which suggests one building despite the 952 versus 954 house-number mismatch; the 2-business count at the address adds some uncertainty, so confidence is moderate.
pair 8efc967e75dccac216e9
ca-abc ALOHA CLUBvtinfo ALOHA CLUB1.00Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “proximity” pair)
Same name, adjacent street numbers, same building
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 60% confident — Both records carry the identical name ALOHA CLUB in the same city and ZIP, with coordinates 16 m apart, so they likely describe one operation; the 952 vs 954 street-number mismatch in a building shared by two businesses keeps this from being certain.
pair fcc6a7851e399d2514c5

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HERNANDEZ & WELTIN INC — 2 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:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
282 within 1 mi · 1,237 within 3 mi
Off / on premise
57 / 137 within 1 mi · 270 / 706 within 3 mi
Selling alcohol
122 within 1 mi · 716 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (9,897 people per sq mi)
People within 3 mi
279,841 (214,607 adults 21+, 106,977 households) from 66 tract(s), tracts within 3 mi
Income
per capita $56,192 · median household ~$104,487 (weighted mean of tract medians)
Age and education
median age ~39.0 · bachelor's or higher 46%
Ethnicity
Hispanic 30% · White 29% · Black 15% · Asian 21%
Adults per alcohol outlet
299
Alcohol spend within 3 mi
$85,451,055 a year ($37,649,713 at home, $47,768,830 away) · $119,179 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 00616388|41|LIC|0 ↔ vtinfo a7f6d6540ad8d680Claude judge: sameheld: same-source-conflict15
2026-11-18 18:58insertab-inbev 2210691 ↔ ca-abc 00616388|41|LIC|0Claude judge: sameheld: same-source-conflict15