Longs Drug Store

Honolulu, HI 96816 · O4ab6bd61b9eb · first seen 2026-10-08
5 sourcesoff premise · conveniencechain: CVSalcohol: alcohol

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
Longs Drug Store 3 other
a licence name in capitals, cleaned (derived; record_title.py)
Longs ubereats
Longs Drugs overture
longs drugs honolulu doordash
Street
3221 Waialae Ave 1 other
ubereats
3221 WAIALAE AVE STE 317D ab-inbevvtinfo ×2
City
Honolulu
ubereatsno other value
State
HI
ubereatsno other value
ZIP
96816
ubereatsno other value
Pin
21.28687, -157.80764 map
ubereatsno other value
Phone
8087352811
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O92b460afa7c0; O4f3fc37f9f45; O85d288b854ca; Oa6aac5922814

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-inbevLONGS DRUG STORE
2423253
3221 WAIALAE AVE STE 317D, HONOLULU, HI, 9681621.28671, -157.807712026-11-132026-11-14
doordashlongs drugs honolulu
34970931
3221 Waialae Ave, Honolulu, HI, 9681621.28685, -157.807802026-10-082026-11-11
overtureLongs Drugs
823c143f-06aa-4389-ae34-717420e278e5
3221 Waialae Ave, Honolulu, HI, 96816808735281121.28687, -157.807632026-11-062026-11-11
ubereatsLongs
5HDp8it7UZCbZpvdzPuLHA
3221 Waialae Ave, Honolulu, HI, 9681621.28687, -157.807642026-11-052026-11-11
vtinfoLONGS DRUG STORE
d0c792fb771c4ac3
3221 WAIALAE AVE STE 317D, HONOLULU, HI, 96816808735281121.28694, -157.807792026-11-112026-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 LONGS DRUG STOREvtinfo LONGS DRUG STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00
doordash longs drugs honoluluoverture Longs Drugs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00
ab-inbev LONGS DRUG STOREdoordash longs drugs honolulu0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 19 m apart · name similarity 0.64
ab-inbev LONGS DRUG STOREoverture Longs Drugs0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 19 m apart · name similarity 0.64
doordash longs drugs honoluluvtinfo LONGS DRUG STORE0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 9 m apart · name similarity 0.64
overture Longs Drugsvtinfo LONGS DRUG STORE0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 18 m apart · name similarity 0.64 · phone: equal
ab-inbev LONGS DRUG STOREubereats Longs0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: drug · name Jaro-Winkler 0.43 · same street + ZIP · pins 19 m apart · name similarity 0.58
ubereats Longsvtinfo LONGS DRUG STORE0.58same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: drug · name Jaro-Winkler 0.43 · same street + city + state · pins 18 m apart · name similarity 0.58
doordash longs drugs honoluluubereats Longs0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Both records are Longs Drugs (a CVS chain store) at the same street address, 3221 Waialae Ave, Honolulu 96816, with coordinates 17 m apart, and our data holds only one business at that address.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 88% confident — Longs Drugs same address both listings
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at 3221 Waialae Ave, Honolulu (about 17 m apart), the only business at that address, and both are the Longs Drugs store (CVS banner), one storefront listed on two delivery apps.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records are 'Longs' (Longs Drugs, a CVS banner) at the identical street address and ZIP in Honolulu, with coordinates about 17 m apart, and no other business is held at that address, so they are two listings of one store.
pair 20bc842b8f106c762cb6

Attributes

Channel
off_premise · convenience — ubereats-type
Chain
CVS — ubereats-parent
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +8 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
184 within 1 mi · 1,228 within 3 mi
Off / on premise
26 / 104 within 1 mi · 137 / 659 within 3 mi
Selling alcohol
72 within 1 mi · 570 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.32 mi
Setting
urban (6,356 people per sq mi)
People within 3 mi
179,713 (150,422 adults 21+, 79,886 households) from 74 tract(s), tracts within 3 mi
Income
per capita $56,890 · median household ~$96,780 (weighted mean of tract medians)
Age and education
median age ~45.5 · bachelor's or higher 49%
Ethnicity
Hispanic 6% · White 22% · Black 1% · Asian 51%
Adults per alcohol outlet
263
Alcohol spend within 3 mi
$58,785,222 a year ($26,434,340 at home, $32,326,696 away) · $102,951 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-13 17:47insertab-inbev 2423253 ↔ ubereats 5HDp8it7UZCbZpvdzPuLHAsame address and namemerged15
2026-11-13 17:47insertab-inbev 2423253 ↔ overture 823c143f-06aa-4389-ae34-717420e278e5same address and namemerged15
2026-11-13 17:47insertab-inbev 2423253 ↔ doordash 34970931same address and namemerged15
2026-11-13 17:47insertab-inbev 2423253 ↔ vtinfo d0c792fb771c4ac3same address and namemerged15
2026-11-12 17:29insertubereats 5HDp8it7UZCbZpvdzPuLHA ↔ vtinfo d0c792fb771c4ac3same address and namemerged14
2026-11-11 12:56insertdoordash 34970931 ↔ ubereats 5HDp8it7UZCbZpvdzPuLHAClaude judge: samemerged12
2026-11-11 12:56insertdoordash 34970931 ↔ vtinfo d0c792fb771c4ac3same address and namemerged12
2026-11-11 12:56insertoverture 823c143f-06aa-4389-ae34-717420e278e5 ↔ vtinfo d0c792fb771c4ac3same address and namemerged12
2026-11-06 18:13insertdoordash 34970931 ↔ overture 823c143f-06aa-4389-ae34-717420e278e5same address and namemerged11