Longs Drug Store

WAIANAE, HI 96792 · O2be096296c60 · 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 waianae doordash
Street
84-1160 Farrington Hwy 2 other
ubereats
84 1160 FARRINGTON HWY ab-inbev
84-1160 FARRINGTON Highway overture
City
Waianae
ubereatsno other value
State
HI
ubereatsno other value
ZIP
96792
ubereatsno other value
Pin
21.46085, -158.20747 map
ubereatsno other value
Phone
8086964334
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od184eaf37d1e; O529adcabca35; O39eacd45a9c9

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
4110272
84 1160 FARRINGTON HWY, WAIANAE, HI, 9679221.46099, -158.207322026-11-132026-11-18
doordashlongs drugs waianae
34970919
84-1160 Farrington Hwy, Waianae, HI, 9679221.46092, -158.207372026-10-082026-11-11
overtureLongs Drugs
991050b2-07ca-466e-9c8f-70e361d3f84c
84-1160 FARRINGTON Highway, WAIANAE, HI, 96792808696433421.46096, -158.207382026-11-132026-11-13
ubereatsLongs
sBuVoiJOXXeK1RIfrrmAMQ
84-1160 Farrington Hwy, Waianae, HI, 9679221.46085, -158.207472026-11-042026-11-04

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
doordash longs drugs waianaeoverture Longs Drugs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00
ab-inbev LONGS DRUG STOREdoordash longs drugs waianae0.64Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Longs Drugs same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records sit at the same street address (84-1160 Farrington Hwy, Waianae, ZIP 96792) with coordinates about 10 m apart, and the DoorDash slug 'longs drugs waianae' matches the Longs Drug Store name, so they describe one drugstore listed by a wholesale account and a delivery app; the shared building with another business lowers confidence slightly.
pair 3416e36b6db1ff03c22f
ab-inbev LONGS DRUG STOREubereats Longs0.58Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair)
Longs same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 84-1160 Farrington Hwy, Waianae HI 96792, about 22 m apart, and the names 'LONGS DRUG STORE' and 'Longs' agree; the Uber Eats listing is tagged to the CVS chain, which owns the Longs banner, so this is one drugstore. The address is shared with one other business, but the names match, so the shared building does not undermine the match.
pair 34cf572ed57345c78833
doordash longs drugs waianaeubereats Longs0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
Both records are Longs Drugs (a CVS chain) at the identical street address 84-1160 Farrington Hwy, Waianae, 13 m apart, and they are the only business at that address; the DoorDash slug simply appends
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records sit at the same street address, ZIP and near-identical coordinates, and both are the Longs Drugs store (a CVS banner), with no other business at that address, so they describe one pharmacy-store outlet listed on two delivery apps.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records are at the identical street address, ZIP and near-identical coordinates, with no other business at that address, and the DoorDash slug 'longs drugs waianae' matches the Uber Eats name 'Longs' (a CVS-owned drug store chain), so they are one store listed on two delivery apps; Hawaii has no special alcohol-premises rule in the facts provided, and the chain/location match is strong despite the chain's multiple stores.
pair aff53bc243a2215250c5

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 11, computed 2026-11-19 21:41.
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
5 within 1 mi · 40 within 3 mi
Off / on premise
1 / 0 within 1 mi · 4 / 13 within 3 mi
Selling alcohol
2 within 1 mi · 20 within 3 mi
Nearest
same channel 0.02 mi · licensed none within 3 mi
Setting
suburban (697 people per sq mi)
People within 3 mi
19,701 (13,547 adults 21+, 5,355 households) from 5 tract(s), tracts within 3 mi
Income
per capita $27,291 · median household ~$78,901 (weighted mean of tract medians)
Age and education
median age ~36.3 · bachelor's or higher 13%
Ethnicity
Hispanic 14% · White 12% · Black 2% · Asian 10%
Adults per alcohol outlet
645
Alcohol spend within 3 mi
$3,464,016 a year ($1,599,768 at home, $1,862,503 away) · $164,953 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-18 18:58insertab-inbev 4110272 ↔ ubereats sBuVoiJOXXeK1RIfrrmAMQClaude judge: samemerged15
2026-11-18 18:58insertab-inbev 4110272 ↔ doordash 34970919Claude judge: samemerged15
2026-11-13 19:03insertdoordash 34970919 ↔ overture 991050b2-07ca-466e-9c8f-70e361d3f84csame address and namemerged15
2026-11-11 12:56insertdoordash 34970919 ↔ ubereats sBuVoiJOXXeK1RIfrrmAMQClaude judge: samemerged12