Longs Drug Store

Kapaa, HI 96746 · O337f5bbf5943 · first seen 2026-10-08
4 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 kapaʻa doordash
Street
645 Aleka Loop
ubereatsno other value
City
Kapaa 1 other
ubereats
Kapaʻa doordash
State
HI
ubereatsno other value
ZIP
96746
ubereatsno other value
Pin
22.05789, -159.32380 map 1 other
ubereats
60 m away ab-inbev
Phone
8088224918
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8c06149f429b; O364de409d461; O7401386463f6

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
3737920
645 ALEKA LOOP, KAPAA, HI, 9674622.05735, -159.323842026-11-132026-11-13
doordashlongs drugs kapaʻa
23321428
645 Aleka Loop, Kapaʻa, HI, 9674622.05782, -159.323722026-10-082026-11-18
overtureLongs Drugs
1bf08fd5-5319-4bcf-853d-dd70a7605c22
645 Aleka Loop, Kapaa, HI, 96746808822491822.05797, -159.323602026-11-132026-11-13
ubereatsLongs
srfvX5ZhXlW4IJHNexqZ_Q
645 Aleka Loop, Kapaa, HI, 9674622.05789, -159.323802026-11-052026-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 LONGS DRUG STOREoverture Longs Drugs0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 74 m apart · name similarity 0.64
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 60 m apart · name similarity 0.58
doordash longs drugs kapaʻaubereats Longs0.28Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “same-address” pair)
Both records are Longs Drugs (CVS) at the same street address, 645 Aleka Loop, Kapaa 96746, 11 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 share the identical street address, ZIP and near-identical coordinates (about 11 m apart), and both name the Longs Drugs store, which is a CVS banner; the DoorDash slug 'longs drugs' matches the Uber Eats name 'Longs', and no other business is at the address, so this is one pharmacy store listed on two platforms.
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 645 Aleka Loop, Kapaa, HI 96746 with coordinates about 11 m apart, and the DoorDash slug 'longs drugs kapa%CA%BBa' is the same Longs Drugs store as the Uber Eats listing 'Longs', with no shared-building or suite conflict and only one business at the address.
pair 20f3835326202adaa3d9

Attributes

Channel
off_premise · convenience — ubereats-type
Chain
CVS — ubereats-parent
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:35.
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
40 within 1 mi · 61 within 3 mi
Off / on premise
7 / 19 within 1 mi · 7 / 27 within 3 mi
Selling alcohol
19 within 1 mi · 30 within 3 mi
Nearest
same channel 0.00 mi · licensed none within 3 mi
Setting
rural (461 people per sq mi)
People within 3 mi
13,031 (10,151 adults 21+, 4,376 households) from 3 tract(s), tracts within 3 mi
Income
per capita $44,495 · median household ~$87,178 (weighted mean of tract medians)
Age and education
median age ~47.6 · bachelor's or higher 30%
Ethnicity
Hispanic 13% · White 32% · Black 1% · Asian 36%
Adults per alcohol outlet
327
Alcohol spend within 3 mi
$3,105,365 a year ($1,407,834 at home, $1,696,203 away) · $100,173 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 19:03insertab-inbev 3737920 ↔ overture 1bf08fd5-5319-4bcf-853d-dd70a7605c22same address and namemerged15
2026-11-13 17:47insertab-inbev 3737920 ↔ ubereats srfvX5ZhXlW4IJHNexqZ_Qsame address and namemerged15
2026-11-11 12:56insertdoordash 23321428 ↔ ubereats srfvX5ZhXlW4IJHNexqZ_QClaude judge: samemerged12