Longs Drugs Pharmacy

Kailua, HI 96734 · O3ba1fc2f0eaa · first seen 2026-10-08
2 sourcesoff premise · pharmacyalcohol: unknown

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 Drugs Pharmacy 1 other
the most common name a source states
longs drugs kailua doordash
Street
609 Kailua Rd
doordashno other value
City
Kailua
doordashno other value
State
HI
doordashno other value
ZIP
96734
doordashno other value
Pin
21.39341, -157.74223 map
doordashno other value
Phone
8082619794
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofbbb6a864d83

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
doordashlongs drugs kailua
34970959
609 Kailua Rd, Kailua, HI, 9673421.39341, -157.742232026-10-082026-11-04
overtureLongs Drugs Pharmacy
3caadaa7-e5cf-4be0-8903-fd20ae9cf5cc
609 Kailua Rd, Kailua, HI, 96734808261979421.39359, -157.742092026-11-132026-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
doordash longs drugs kailuavtinfo CVS PHARMACY0.13Claude judge: sameheld same-source-conflict
Claude Opus 5.5, prompt v12 said same (85% confident; asked as a “same-address” pair)
Longs Drugs is CVS banner, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Record A is Longs Drugs at 609 Kailua Rd, and Record B is CVS Pharmacy at the same address with coordinates about 26 m apart; Longs Drugs is a CVS-owned banner, so B's pharmacy department is the same store, and Hawaii's rule treats the drug store's alcohol as its own department, though six businesses share the building and the names differ.
pair 1d18715d354acfd6ae63
doordash longs drugs kailuaoverture Longs Drugs Pharmacy0.69same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: pharmacy · name Jaro-Winkler 0.91 · same street + ZIP · pins 25 m apart · name similarity 0.69

Attributes

Channel
off_premise · pharmacy — doordash-url
Chain
none
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "off_premise",
   null
  ],
  [
   "overture-category",
   "off_premise",
   "pharmacy"
  ]
 ]
}

Trade area

Other outlets
110 within 1 mi · 138 within 3 mi
Off / on premise
23 / 65 within 1 mi · 31 / 77 within 3 mi
Selling alcohol
54 within 1 mi · 70 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.15 mi
Setting
suburban (1,767 people per sq mi)
People within 3 mi
49,960 (38,777 adults 21+, 16,918 households) from 15 tract(s), tracts within 3 mi
Income
per capita $61,020 · median household ~$150,896 (weighted mean of tract medians)
Age and education
median age ~44.4 · bachelor's or higher 54%
Ethnicity
Hispanic 8% · White 39% · Black 1% · Asian 23%
Adults per alcohol outlet
554
Alcohol spend within 3 mi
$17,013,292 a year ($7,266,271 at home, $9,741,103 away) · $243,047 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-19 20:37insertdoordash 34970959 ↔ vtinfo 00caee2390468a9fClaude judge: sameheld: same-source-conflict17
2026-11-13 14:10insertdoordash 34970959 ↔ overture 3caadaa7-e5cf-4be0-8903-fd20ae9cf5ccsame address and namemerged15