Aloha Club

OAKLAND, CA 94601 · O72ead24b53ed · first seen 2026-10-08
4 sourceson premise · baralcohol: 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 source's own spelling of the licence name (record_title.py)
HERNANDEZ & WELTIN INC ca-abc (legal name)
Street
952 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.77498, -122.22707 map
overtureno other value
Phone
5105341495
vtinfono other value
Licences
ca-abc 00184907|48|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od6f1df7f3153; O9a4bdcb2272c; Od6c48146aba6

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-inbevALOHA CLUB
2210691
952 FRUITVALE AVE, OAKLAND, CA, 9460137.77512, -122.226992026-11-112026-11-11
ca-abcALOHA CLUB
legal name: HERNANDEZ & WELTIN INC
00184907|48|LIC|0
952 FRUITVALE AVE, OAKLAND, CA, 9460137.77504, -122.227032026-10-082026-11-11
overtureAloha Club
985e68e3-4d96-46e7-a7ce-9550c541db89
952 Fruitvale Ave, Oakland, CA, 94601510534149537.77498, -122.227072026-11-062026-11-11
vtinfoALOHA CLUB
a7f6d6540ad8d680
952 FRUITVALE AVE, OAKLAND, CA, 94601510534149537.77490, -122.227022026-11-122026-11-14

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
ab-inbev ALOHA CLUBca-abc ALOHA CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
ab-inbev ALOHA CLUBoverture Aloha Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev ALOHA CLUBvtinfo ALOHA CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 25 m apart · name similarity 1.00
ca-abc ALOHA CLUBoverture Aloha Club1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ca-abc ALOHA CLUBvtinfo ALOHA CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
overture Aloha Clubvtinfo ALOHA CLUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · bar — 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, spirits_on — CA 48
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "bar"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

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
2026-11-12 14:25insertca-abc 00184907|48|LIC|0 ↔ vtinfo a7f6d6540ad8d680same address and namemerged12
2026-11-12 14:25insertab-inbev 2210691 ↔ vtinfo a7f6d6540ad8d680same address and namemerged12
2026-11-12 14:25insertoverture 985e68e3-4d96-46e7-a7ce-9550c541db89 ↔ vtinfo a7f6d6540ad8d680same address and namemerged12
2026-11-11 12:56insertab-inbev 2210691 ↔ overture 985e68e3-4d96-46e7-a7ce-9550c541db89same address and namemerged12
2026-11-11 12:56insertab-inbev 2210691 ↔ ca-abc 00184907|48|LIC|0same address and namemerged12
2026-11-06 18:13insertca-abc 00184907|48|LIC|0 ↔ overture 985e68e3-4d96-46e7-a7ce-9550c541db89same address and namemerged11