Liquor Hub

CASTRO VALLEY, CA 94546 · O12feaf7c94a0 · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Liquor Hubalcohol: 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
Liquor Hub 3 other
a source's own spelling of the licence name (record_title.py)
Liquor Hub 2 ubereats
liquor hub 2 castro valley doordash
P & G INVESTMENTS CORP ca-abc (legal name)
Street
20388 LAKE CHABOT RD 1 other
ca-abc
20388 Lake Chabot Road ubereats
City
CASTRO VALLEY
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94546
ca-abcno other value
Pin
37.69701, -122.08665 map 1 other
ubereats
391 m away ca-abc
Phone
5105821416
vtinfono other value
Licences
ca-abc 00641056|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oec901930afe3; O1b9dd2eb6bce; Ofe3ff98ccf79; O38583141f19d; Ob4bbe1490833

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-inbevLIQUOR HUB
4601007
20388 LAKE CHABOT RD, CASTRO VALLEY, CA, 9454637.69702, -122.086872026-11-112026-11-11
ca-abcLIQUOR HUB
legal name: P & G INVESTMENTS CORP
00641056|21|LIC|0
20388 LAKE CHABOT RD, CASTRO VALLEY, CA, 9454637.70042, -122.087742026-10-082026-11-05
doordashliquor hub 2 castro valley
24667413
20388 Lake Chabot Rd, Castro Valley, CA, 9454637.69700, -122.086632026-10-082026-11-02
snapLiquor Hub
snap|us|1530594
20388 Lake Chabot Rd, Castro Valley, CA, 9454637.69696, -122.086502026-11-192026-11-19
ubereatsLiquor Hub 2
mJlxXW1kWHSJFAMhC8pqHw
20388 Lake Chabot Road, Castro Valley, CA, 9454637.69701, -122.086652026-10-082026-11-02
vtinfoLIQUOR HUB
d2b5e5513733a439
20388 LAKE CHABOT RD, CASTRO VALLEY, CA, 94546510582141637.69707, -122.086512026-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 LIQUOR HUBca-abc LIQUOR HUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 386 m apart · name similarity 1.00
ab-inbev LIQUOR HUBsnap Liquor Hub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00
ab-inbev LIQUOR HUBvtinfo LIQUOR HUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 32 m apart · name similarity 1.00
ca-abc LIQUOR HUBsnap Liquor Hub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 400 m apart · name similarity 1.00
ca-abc LIQUOR HUBvtinfo LIQUOR HUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 388 m apart · name similarity 1.00
doordash liquor hub 2 castro valleyubereats Liquor Hub 21.00same address and namemergedaddress similarity 1.00 · same street + city + state · pins 2 m apart · name similarity 1.00
snap Liquor Hubvtinfo LIQUOR HUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
ca-abc LIQUOR HUBdoordash liquor hub 2 castro valley0.79Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
The street address, city and ZIP are identical, the names match ('liquor hub' plus the city appended to the DoorDash slug, where '2' is likely a branch number), and only one business is recorded at th
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 70% confident — Both records name LIQUOR HUB at the same street address and ZIP in Castro Valley, and the DoorDash listing is just the slug with the city appended, so the names agree; the stray '2' is the main doubt, since it could mean a separate branch.
pair c00c0f52ad2a4412d54c
ca-abc LIQUOR HUBubereats Liquor Hub 20.79Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “near” pair)
Both records place a liquor store named Liquor Hub at the identical street address and ZIP, and our data holds only one business there, so the '2' on the Uber Eats listing is likely a store label rath
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 80% confident — Liquor Hub at same address; '2' likely listing suffix.
  • Claude Haiku 5.5, prompt v9: same, 60% confident — Both records sit at 20388 Lake Chabot Rd, Castro Valley 94546, and the Uber Eats listing's chain is 'Liquor Hub', matching the CA licence's trade name, so this is likely one store's delivery listing; the trailing '2' in 'Liquor Hub 2' leaves some doubt about a second branch or separate operation.
  • Claude Haiku 5.5, prompt v7: same, 60% confident — Both records name Liquor Hub at the identical street address, city and ZIP, and the ABC off-sale licence fits a liquor store, but the trailing '2' in the Uber Eats name and the two businesses listed at this address leave some doubt that it is a second premises.
  • Claude Haiku 5.5, prompt v4: same, 82% confident — Both records give the same street address, city and ZIP, and no other business is held at that address; the ubereats name 'Liquor Hub 2' differs from the ca-abc 'LIQUOR HUB' only by a trailing number, which reads as a store or listing suffix on one off-sale liquor operation.
pair 2772567f0a2a57e53a02

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
Liquor Hub — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
P & G INVESTMENTS CORP — 2 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "ubereats-type",
   "off_premise",
   "liquor_store"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
138 within 1 mi · 691 within 3 mi
Off / on premise
26 / 101 within 1 mi · 184 / 439 within 3 mi
Selling alcohol
68 within 1 mi · 353 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.02 mi
Setting
urban (6,349 people per sq mi)
People within 3 mi
179,502 (136,795 adults 21+, 59,591 households) from 38 tract(s), tracts within 3 mi
Income
per capita $46,824 · median household ~$114,138 (weighted mean of tract medians)
Age and education
median age ~40.0 · bachelor's or higher 32%
Ethnicity
Hispanic 37% · White 25% · Black 11% · Asian 25%
Adults per alcohol outlet
386
Alcohol spend within 3 mi
$49,422,153 a year ($21,758,253 at home, $27,644,484 away) · $139,611 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:37insertca-abc 00641056|21|LIC|0 ↔ snap snap|us|1530594same address and namemerged17
2026-11-19 20:37insertab-inbev 4601007 ↔ snap snap|us|1530594same address and namemerged17
2026-11-19 20:37insertsnap snap|us|1530594 ↔ vtinfo d2b5e5513733a439same address and namemerged17
2026-11-12 14:25insertca-abc 00641056|21|LIC|0 ↔ vtinfo d2b5e5513733a439same address and namemerged12
2026-11-12 14:25insertab-inbev 4601007 ↔ vtinfo d2b5e5513733a439same address and namemerged12
2026-11-11 12:56insertab-inbev 4601007 ↔ ca-abc 00641056|21|LIC|0same address and namemerged12
2026-11-02 23:02backfillca-abc 00641056|21|LIC|0 ↔ doordash 24667413Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00641056|21|LIC|0 ↔ ubereats mJlxXW1kWHSJFAMhC8pqHwClaude judge: samemerged
2026-10-09 13:59backfilldoordash 24667413 ↔ ubereats mJlxXW1kWHSJFAMhC8pqHwsame address and namemerged