Ernie's Liquor

PALO ALTO, CA 94306 · O168890d7d833 · first seen 2026-10-08
5 sourcesoff premise · liquor_storechain: Ernie's Wine &alcohol: licensed2 licences

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
Ernie's Liquor 5 other
a licence name in capitals, cleaned (derived; record_title.py)
ERNIES LIQUOR ca-abc ×2
ERNIES WINE & LIQUOR ab-inbevvtinfo ×2
EZHARAT LLC ca-abc (legal name) ×2
Ernie's Wine & Liquor ubereats
Ernie's Wines & Liquors overture
Street
3870 EL CAMINO REAL
ca-abcno other value
City
PALO ALTO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94306
ca-abcno other value
Pin
37.41701, -122.13080 map
ubereatsno other value
Phone
6504934743 1 other
vtinfo
6504933300 overture
Licences
ca-abc 00623850|21|APP|0 · ca-abc 00623850|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ocbc7bc5983b5; Ofd9d8b5ce9b5; O81fc8a53b9a2; O572860ab7472; Od3fd436d9d95

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-inbevERNIES WINE & LIQUOR
1342663
3870 EL CAMINO REAL, PALO ALTO, CA, 9430637.41689, -122.130482026-11-112026-11-11
ca-abcERNIES LIQUOR
legal name: EZHARAT LLC
00623850|21|APP|0
3870 EL CAMINO REAL, PALO ALTO, CA, 9430637.41707, -122.130872026-10-082026-11-11
ca-abcERNIES LIQUOR
legal name: EZHARAT LLC
00623850|21|LIC|0
3870 EL CAMINO REAL, PALO ALTO, CA, 9430637.41707, -122.130872026-10-082026-11-11
overtureErnie's Wines & Liquors
27d6497f-6bf6-452e-bb12-b865c623f60f
3870 El Camino Real, Palo Alto, CA, 94306650493330037.41693, -122.130842026-11-062026-11-11
ubereatsErnie's Wine & Liquor
6OocPT5wR6CQ5AN8FdEBVw
3870 El Camino Real, Palo Alto, CA, 9430637.41701, -122.130802026-10-082026-11-11
vtinfoERNIES WINE & LIQUOR
c2ac6e9df2a4db81
3870 EL CAMINO REAL, PALO ALTO, CA, 94306650493474337.41685, -122.130872026-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 ERNIES WINE & LIQUORubereats Ernie's Wine & Liquor1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev ERNIES WINE & LIQUORvtinfo ERNIES WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 35 m apart · name similarity 1.00
ca-abc ERNIES LIQUORca-abc ERNIES LIQUOR1.00one licence filemergedfile: 00623850 · same_address
ubereats Ernie's Wine & Liquorvtinfo ERNIES WINE & LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00
ab-inbev ERNIES WINE & LIQUORca-abc ERNIES LIQUOR0.75same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 40 m apart · name similarity 0.75
ab-inbev ERNIES WINE & LIQUORca-abc ERNIES LIQUOR0.75same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + ZIP · pins 40 m apart · name similarity 0.75
ca-abc ERNIES LIQUORvtinfo ERNIES WINE & LIQUOR0.75same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 24 m apart · name similarity 0.75
ca-abc ERNIES LIQUORvtinfo ERNIES WINE & LIQUOR0.75same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.94 · same street + city + state · pins 24 m apart · name similarity 0.75
ab-inbev ERNIES WINE & LIQUORoverture Ernie's Wines & Liquors0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 33 m apart · name similarity 0.57
overture Ernie's Wines & Liquorsubereats Ernie's Wine & Liquor0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 10 m apart · name similarity 0.57
overture Ernie's Wines & Liquorsvtinfo ERNIES WINE & LIQUOR0.57same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 9 m apart · name similarity 0.57 · phone: differs
ca-abc ERNIES LIQUORoverture Ernie's Wines & Liquors0.52same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 16 m apart · name similarity 0.52
ca-abc ERNIES LIQUORoverture Ernie's Wines & Liquors0.52same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 16 m apart · name similarity 0.52
ca-abc ERNIES LIQUORubereats Ernie's Wine & Liquor0.47Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
Both records name Ernie's liquor store at 3870 El Camino Real, Palo Alto 94306, and the active off-sale general licence matches a liquor store, so the name variants describe one outlet.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give 3870 El Camino Real, Palo Alto 94306, and the names match (ERNIES LIQUOR is the ABC licensee for Ernie's Wine & Liquor), with the Uber Eats listing being the liquor store's alcohol department and the ABC record holding an active off-sale general licence there. The building is shared with one other business, but the names agree, so the match holds.
pair 8049d53eb148aaca0732
ca-abc ERNIES LIQUORubereats Ernie's Wine & Liquor0.47Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
The names agree ('ERNIES LIQUOR' and 'Ernie's Wine & Liquor') and both records give the same street address and ZIP, and the off-sale general liquor-store licence fits a liquor store, so one outlet; t
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records sit at 3870 El Camino Real, Palo Alto, 94306, and the names agree closely (ERNIES LIQUOR vs Ernie's Wine & Liquor) with an active off-sale liquor licence matching a liquor store listing; the shared building with two businesses is offset by the matching name.
pair d0bdfbc4fe2765b8d587

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
Ernie's Wine & — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
EZHARAT LLC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ca-licence",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
102 within 1 mi · 808 within 3 mi
Off / on premise
8 / 68 within 1 mi · 131 / 542 within 3 mi
Selling alcohol
55 within 1 mi · 468 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
urban (4,955 people per sq mi)
People within 3 mi
140,096 (103,766 adults 21+, 52,345 households) from 31 tract(s), tracts within 3 mi
Income
per capita $111,825 · median household ~$198,115 (weighted mean of tract medians)
Age and education
median age ~39.4 · bachelor's or higher 80%
Ethnicity
Hispanic 12% · White 44% · Black 2% · Asian 36%
Adults per alcohol outlet
221
Alcohol spend within 3 mi
$58,044,182 a year ($24,122,199 at home, $33,909,833 away) · $123,762 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-12 14:25insertoverture 27d6497f-6bf6-452e-bb12-b865c623f60f ↔ vtinfo c2ac6e9df2a4db81same address and namemerged12
2026-11-12 14:25insertca-abc 00623850|21|LIC|0 ↔ vtinfo c2ac6e9df2a4db81same address and namemerged12
2026-11-12 14:25insertca-abc 00623850|21|APP|0 ↔ vtinfo c2ac6e9df2a4db81same address and namemerged12
2026-11-12 14:25insertubereats 6OocPT5wR6CQ5AN8FdEBVw ↔ vtinfo c2ac6e9df2a4db81same address and namemerged12
2026-11-12 14:25insertab-inbev 1342663 ↔ vtinfo c2ac6e9df2a4db81same address and namemerged12
2026-11-11 12:56insertab-inbev 1342663 ↔ overture 27d6497f-6bf6-452e-bb12-b865c623f60fsame address and namemerged12
2026-11-11 12:56insertab-inbev 1342663 ↔ ca-abc 00623850|21|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 1342663 ↔ ca-abc 00623850|21|APP|0same address and namemerged12
2026-11-11 12:56insertab-inbev 1342663 ↔ ubereats 6OocPT5wR6CQ5AN8FdEBVwsame address and namemerged12
2026-11-06 18:13insertca-abc 00623850|21|LIC|0 ↔ overture 27d6497f-6bf6-452e-bb12-b865c623f60fsame address and namemerged11
2026-11-06 18:13insertca-abc 00623850|21|APP|0 ↔ overture 27d6497f-6bf6-452e-bb12-b865c623f60fsame address and namemerged11
2026-11-06 18:13insertoverture 27d6497f-6bf6-452e-bb12-b865c623f60f ↔ ubereats 6OocPT5wR6CQ5AN8FdEBVwsame address and namemerged11
2026-11-02 23:02backfillca-abc 00623850|21|LIC|0 ↔ ubereats 6OocPT5wR6CQ5AN8FdEBVwClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00623850|21|APP|0 ↔ ubereats 6OocPT5wR6CQ5AN8FdEBVwClaude judge: samemerged
2026-10-09 13:59backfillca-abc 00623850|21|APP|0 ↔ ca-abc 00623850|21|LIC|0one licence filemerged