PICKWICK WINES & SPIRIT

COVINA, CA 91723 · O01b1ab2b4847 · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Pickwick Liquor Wines & Spiritsalcohol: 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
PICKWICK WINES & SPIRIT 5 other
the most common name a source states
HIAM INC ca-abc (legal name)
PICK WICK WINES & SPIRITS ca-abc
pickwick liquor covina doordash
Pickwick Liquor Wines & Spirits ubereats
Pickwick Wines & Spirits overture
Street
454 E ROWLAND ST 2 other
ca-abc
454 E ROWLAND AVE ab-inbevvtinfo ×2
454 East Rowland Street doordash
City
COVINA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91723
ca-abcno other value
Pin
34.07857, -117.88209 map 1 other
ubereats
52 m away vtinfo
Phone
6269667401
vtinfono other value
Licences
ca-abc 00437858|21|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of613804d4f0c; Oa6449b2a4b30; O179d3ab43c7b; O05f869a354b1; O533636229608

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-inbevPICKWICK WINES & SPIRIT
2766857
454 E ROWLAND AVE, COVINA, CA, 9172334.07881, -117.882262026-11-112026-11-11
ca-abcPICK WICK WINES & SPIRITS
legal name: HIAM INC
00437858|21|LIC|0
454 E ROWLAND ST, COVINA, CA, 9172334.07887, -117.882162026-10-082026-11-11
doordashpickwick liquor covina
429591
454 East Rowland Street, Covina, CA, 9172334.07856, -117.882162026-10-082026-11-11
overturePickwick Wines & Spirits
953351b7-4d0a-47f8-86e5-ac49fca44a96
454 E Rowland St, Covina, CA, 91723626966740134.07852, -117.882082026-11-062026-11-11
ubereatsPickwick Liquor Wines & Spirits
y-VDi2YgQxiSXRwcSc0_vw
454 E Rowland St, Covina, CA, 9172334.07857, -117.882092026-10-142026-11-11
vtinfoPICKWICK WINES & SPIRIT
b81c1b793e39be38
454 E ROWLAND AVE, COVINA, CA, 91723626966740134.07880, -117.882582026-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 PICKWICK WINES & SPIRITvtinfo PICKWICK WINES & SPIRIT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 30 m apart · name similarity 1.00
overture Pickwick Wines & Spiritsubereats Pickwick Liquor Wines & Spirits0.81same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.78 · same street + ZIP · pins 6 m apart · name similarity 0.81
ab-inbev PICKWICK WINES & SPIRIToverture Pickwick Wines & Spirits0.74street written two waysmergedname Jaro-Winkler 0.96 · matched on zip · pins 36 m apart · name similarity 0.74 · street similarity 0.80
overture Pickwick Wines & Spiritsvtinfo PICKWICK WINES & SPIRIT0.74street written two waysmergedname Jaro-Winkler 0.96 · matched on city · pins 56 m apart · name similarity 0.74 · street similarity 0.80
ca-abc PICK WICK WINES & SPIRITSoverture Pickwick Wines & Spirits0.60same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 40 m apart · name similarity 0.60
doordash pickwick liquor covinaubereats Pickwick Liquor Wines & Spirits0.59Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
The DoorDash slug 'pickwick liquor covina' is Pickwick Liquor with the city appended, and it matches 454 E Rowland St, Covina 91723 and the coordinates (6 m apart); the names agree, so the shared-buil
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 93% confident — Both records name Pickwick Liquor at 454 E Rowland St, Covina, CA 91723 with coordinates about 6 m apart; the DoorDash slug 'pickwick liquor covina' matches the Uber Eats trade name, and the address match is the same single independent store despite the building holding two businesses, since the names agree.
pair f3060153056bd7565149
ca-abc PICK WICK WINES & SPIRITSubereats Pickwick Liquor Wines & Spirits0.51Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair)
Same street address and ZIP, and the names 'Pick Wick Wines & Spirits' and 'Pickwick Liquor Wines & Spirits' agree; the off-sale general licence fits a liquor store.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 82% confident — Both records sit at 454 E Rowland St, Covina 91723 (34 m apart), and the names are essentially the same (Pick Wick Wines & Spirits vs Pickwick Liquor Wines & Spirits), with the CA licence being an off-sale liquor store; the shared building (2 businesses) is offset by the strong name agreement.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give the same street address, city and ZIP, and the names match closely (Pick Wick Wines & Spirits vs Pickwick Liquor Wines & Spirits, a spacing variant plus the word Liquor), with an active off-sale liquor licence supporting a retail store, so the name agreement settles the shared-building question.
pair 5bfc2e377ce3ca7fab26
ab-inbev PICKWICK WINES & SPIRITca-abc PICK WICK WINES & SPIRITS0.47Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Pickwick Wines same number, Ave/St typo
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 454 E Rowland in Covina, 91723, about 12 m apart, and the names are near-identical (PICKWICK WINES & SPIRIT vs PICK WICK WINES & SPIRITS), with the AVE/ST suffix difference being a minor address variant; the other business counted at this address does not change the match because this name agrees closely.
pair 4362d9f0e7f1b20b0493
ab-inbev PICKWICK WINES & SPIRITdoordash pickwick liquor covina0.35Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “same-address” pair)
Pickwick liquor store same address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records are at 454 E Rowland (Ave/Street), Covina 91723, about 29 m apart, and both names are the same Pickwick liquor business (Pickwick Wines & Spirit / pickwick liquor covina), so the shared-building count of 2 is outweighed by the matching name.
pair 1d3672e3b418846af597
doordash pickwick liquor covinaoverture Pickwick Wines & Spirits0.34same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: liquor, spirits, wines · name Jaro-Winkler 0.58 · same street + ZIP · pins 8 m apart · name similarity 0.34
ca-abc PICK WICK WINES & SPIRITSdoordash pickwick liquor covina0.21Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “same-address” pair)
The addresses match exactly (454 E Rowland St, Covina 91723), and the names agree, since 'Pick Wick Wines & Spirits' is an active off-sale liquor store and the DoorDash listing reads 'pickwick liquor'
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give 454 East Rowland Street, Covina, ZIP 91723, and the names are close variants (Pick Wick Wines & Spirits vs Pickwick Liquor), with the CA record an active off-sale liquor licence and coordinates 0.034 km apart; the shared building count of 2 is the main caution, but the matching names support one outlet.
  • Claude Haiku 5.5, prompt v4: same, 82% confident — Both records give 454 E Rowland St, Covina 91723, and the names agree on a Pickwick liquor store (Pick Wick Wines & Spirits vs pickwick liquor covina), with the DoorDash listing matching an off-sale liquor store; the second business at the address has a different name, so the name match is what decides it.
pair 5971395a8fff43405800

Attributes

Channel
off_premise · liquor_store — ca-licence
Chain
Pickwick Liquor Wines & Spirits — ubereats-parent
Alcohol
licensed — a licence or TTB permit on file
Operator
HIAM INC — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off, spirits_off — CA 21
Rule version 9, computed 2026-11-17 18:20.
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
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
199 within 1 mi · 688 within 3 mi
Off / on premise
44 / 124 within 1 mi · 180 / 402 within 3 mi
Selling alcohol
113 within 1 mi · 327 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (5,965 people per sq mi)
People within 3 mi
168,660 (128,013 adults 21+, 51,510 households) from 34 tract(s), tracts within 3 mi
Income
per capita $39,219 · median household ~$102,613 (weighted mean of tract medians)
Age and education
median age ~39.6 · bachelor's or higher 29%
Ethnicity
Hispanic 57% · White 23% · Black 4% · Asian 21%
Adults per alcohol outlet
390
Alcohol spend within 3 mi
$40,578,170 a year ($18,064,218 at home, $22,496,043 away) · $123,714 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 17:29insertab-inbev 2766857 ↔ doordash 429591Claude judge: samemerged14
2026-11-12 17:29insertab-inbev 2766857 ↔ ca-abc 00437858|21|LIC|0Claude judge: samemerged14
2026-11-12 17:29insertdoordash 429591 ↔ overture 953351b7-4d0a-47f8-86e5-ac49fca44a96same address and namemerged14
2026-11-12 14:25insertoverture 953351b7-4d0a-47f8-86e5-ac49fca44a96 ↔ vtinfo b81c1b793e39be38street written two waysmerged12
2026-11-12 14:25insertab-inbev 2766857 ↔ vtinfo b81c1b793e39be38same address and namemerged12
2026-11-11 12:56insertab-inbev 2766857 ↔ overture 953351b7-4d0a-47f8-86e5-ac49fca44a96street written two waysmerged12
2026-11-06 18:13insertca-abc 00437858|21|LIC|0 ↔ overture 953351b7-4d0a-47f8-86e5-ac49fca44a96same address and namemerged11
2026-11-06 18:13insertoverture 953351b7-4d0a-47f8-86e5-ac49fca44a96 ↔ ubereats y-VDi2YgQxiSXRwcSc0_vwsame address and namemerged11
2026-11-02 23:02backfillca-abc 00437858|21|LIC|0 ↔ doordash 429591Claude judge: samemerged
2026-11-02 23:02backfillca-abc 00437858|21|LIC|0 ↔ ubereats y-VDi2YgQxiSXRwcSc0_vwClaude judge: samemerged
2026-11-02 23:02backfilldoordash 429591 ↔ ubereats y-VDi2YgQxiSXRwcSc0_vwClaude judge: samemerged