The Blue Fish

WEST HOLLYWOOD, CA 90069 · O4ba7fe8b94a9 · first seen 2026-10-08
1 sourceunknownalcohol: 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
The Blue Fish 2 other
a licence name in capitals, cleaned (derived; record_title.py)
BLUE FISH ca-abc
MELROSE 8478 LLC ca-abc (legal name)
Street
8478 MELROSE AVE
ca-abcno other value
City
WEST HOLLYWOOD
ca-abcno other value
State
CA
ca-abcno other value
ZIP
90069
ca-abcno other value
Pin
34.08302, -118.37412 map
ca-abcno other value
Phone
none
no other value
Licences
ca-abc 00677677|47|APP|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-abcBLUE FISH
legal name: MELROSE 8478 LLC
00677677|47|APP|0
8478 MELROSE AVE, WEST HOLLYWOOD, CA, 9006934.08302, -118.374122026-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.

No links: this outlet is a single record, so nothing was joined or declined.

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MELROSE 8478 LLC — 1 outlets in the master under this operator
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
784 within 1 mi · 2,813 within 3 mi
Off / on premise
92 / 495 within 1 mi · 406 / 1,709 within 3 mi
Selling alcohol
465 within 1 mi · 1,555 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.00 mi
Setting
urban (9,601 people per sq mi)
People within 3 mi
271,474 (234,227 adults 21+, 142,474 households) from 85 tract(s), tracts within 3 mi
Income
per capita $85,814 · median household ~$107,445 (weighted mean of tract medians)
Age and education
median age ~40.2 · bachelor's or higher 64%
Ethnicity
Hispanic 17% · White 60% · Black 8% · Asian 11%
Adults per alcohol outlet
151
Alcohol spend within 3 mi
$114,131,756 a year ($50,050,482 at home, $64,038,596 away) · $73,349 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.