Frank's Wine & Spirits

HERMOSA BEACH, CA 90254 · O043a50a09e9c · first seen 2026-10-08
5 sourcesoff premise · liquor_storechain: Oceanviewalcohol: 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
Frank's Wine & Spirits 4 other
a source's own spelling of the licence name (record_title.py)
FRANKS WINE & SPIRITS ab-inbevvtinfo ×2
FRANK'S WINE & SPIRTS inspections
FRANKS HB INC ca-abc
Frank’s Wine & Spirits ubereats
Street
3232 MANHATTAN AVE 1 other
ca-abc
3232 Manhattan Avenue ubereats
City
HERMOSA BEACH
ca-abcno other value
State
CA
ca-abcno other value
ZIP
90254
ca-abcno other value
Pin
33.87623, -118.40631 map
ubereatsno other value
Phone
3107983331
vtinfono other value
Licences
ca-abc 00666686|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O90100435e5a8; O574f1700020d; Oc1392961e633; Oafa5878d32db

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-inbevFRANKS WINE & SPIRITS
4881611
3232 MANHATTAN AVE, HERMOSA BEACH, CA, 9025433.87624, -118.406332026-11-112026-11-11
ca-abcFRANKS HB INC
00666686|21|LIC|0
3232 MANHATTAN AVE, HERMOSA BEACH, CA, 9025433.87615, -118.406262026-10-082026-11-04
inspectionsFRANK'S WINE & SPIRTS
inspections|la|FA0399101|PR0365728
3232 MANHATTAN AVE, Hermosa Beach, CA, 9025433.87615, -118.406262026-11-192026-11-20
ubereatsFrank’s Wine & Spirits
5SO-p-H4To64SEVb4HsxsA
3232 Manhattan Avenue, Hermosa Beach, CA, 9025433.87623, -118.406312026-11-092026-11-11
vtinfoFRANKS WINE & SPIRITS
ba051f12bf64eb37
3232 MANHATTAN AVE, HERMOSA BEACH, CA, 90254310798333133.87627, -118.406232026-11-122026-11-13

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 FRANKS WINE & SPIRITSubereats Frank’s Wine & Spirits1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 2 m apart · name similarity 1.00
ab-inbev FRANKS WINE & SPIRITSvtinfo FRANKS WINE & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 10 m apart · name similarity 1.00
ubereats Frank’s Wine & Spiritsvtinfo FRANKS WINE & SPIRITS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
ab-inbev FRANKS WINE & SPIRITSinspections FRANK'S WINE & SPIRTS0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · name similarity 0.74
inspections FRANK'S WINE & SPIRTSubereats Frank’s Wine & Spirits0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · name similarity 0.74
inspections FRANK'S WINE & SPIRTSvtinfo FRANKS WINE & SPIRITS0.74same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.96 · same street + ZIP · name similarity 0.74
ab-inbev FRANKS WINE & SPIRITSca-abc FRANKS HB INC0.38Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Franks HB Inc is entity behind Franks Wine & Spirits
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at the same street address and ZIP (about 12 m apart), and the California licence is an off-sale liquor store licence whose legal entity FRANKS HB INC matches the trade name FRANKS WINE & SPIRITS, so they read as one store.
pair 3cee594c224db76b146a
ca-abc FRANKS HB INCubereats Frank’s Wine & Spirits0.38Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “same-address” pair)
The legal entity 'FRANKS HB INC' holds an active off-sale general (liquor store) licence at 3232 Manhattan Ave, and 'Frank's Wine & Spirits' is listed at that same address (0.01 km apart), so the name
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Franks HB Inc matches Frank's Wine & Spirits, same address
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Same address (coordinates within 0.01 km) and the CA ABC off-sale general licence for FRANKS HB INC matches the Uber Eats alcohol listing 'Frank's Wine & Spirits' at 3232 Manhattan Avenue, Hermosa Beach; the Uber Eats listing is the alcohol department/storefront of the same operation, and the name fits the legal-entity-to-trade-name pattern, though the shared building (2 businesses) leaves some doubt.
  • Claude Haiku 5.5, prompt v7: same, 75% confident — The ABC off-sale general licence held by FRANKS HB INC and the Uber Eats listing 'Frank's Wine & Spirits' match on name and sit at the same street address (0.01 km apart), and the state rule treats a chain's alcohol listing at its own address as the same store; the shared building (2 businesses) and the Oceanview chain tag keep confidence below high.
pair 1621c91c83b109c6ff23

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
Oceanview — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
FRANKS HB INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ]
 ]
}

Trade area

Other outlets
162 within 1 mi · 961 within 3 mi
Off / on premise
21 / 110 within 1 mi · 176 / 575 within 3 mi
Selling alcohol
120 within 1 mi · 586 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.04 mi
Setting
urban (4,320 people per sq mi)
People within 3 mi
122,156 (90,802 adults 21+, 48,577 households) from 29 tract(s), tracts within 3 mi
Income
per capita $92,070 · median household ~$170,188 (weighted mean of tract medians)
Age and education
median age ~41.3 · bachelor's or higher 68%
Ethnicity
Hispanic 16% · White 60% · Black 2% · Asian 16%
Adults per alcohol outlet
155
Alcohol spend within 3 mi
$50,819,028 a year ($21,442,467 at home, $29,362,510 away) · $86,574 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-19 20:37insertinspections inspections|la|FA0399101|PR0365728 ↔ ubereats 5SO-p-H4To64SEVb4HsxsAsame address and namemerged17
2026-11-19 20:37insertab-inbev 4881611 ↔ inspections inspections|la|FA0399101|PR0365728same address and namemerged17
2026-11-19 20:37insertinspections inspections|la|FA0399101|PR0365728 ↔ vtinfo ba051f12bf64eb37same address and namemerged17
2026-11-12 17:29insertab-inbev 4881611 ↔ ca-abc 00666686|21|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertubereats 5SO-p-H4To64SEVb4HsxsA ↔ vtinfo ba051f12bf64eb37same address and namemerged12
2026-11-12 14:25insertab-inbev 4881611 ↔ vtinfo ba051f12bf64eb37same address and namemerged12
2026-11-11 12:56insertca-abc 00666686|21|LIC|0 ↔ ubereats 5SO-p-H4To64SEVb4HsxsAClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 4881611 ↔ ubereats 5SO-p-H4To64SEVb4HsxsAsame address and namemerged12