Longs Drug Store

Kaneohe, HI 96744 · O0cf0c7ce36fe · 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 kaneohe doordash
Street
46 047 Kamehameha Hwy Ste C 3 other
ubereats
46047 KAMEHAMEHA HWY STE C ab-inbevvtinfo ×2
46-047 Kamehameha Hwy Ste c overture
46-047 Kamehameha Hwy Ste C # Ste doordash
City
Kaneohe
ubereatsno other value
State
HI
ubereatsno other value
ZIP
96744
ubereatsno other value
Pin
21.42063, -157.80236 map 2 other
ubereats
95 m away ab-inbev
124 m away vtinfo
Phone
8082354551
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od2efb42d56d0; O3f020e92d2fa; O6298da24e588; O40d36703f098

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
2423260
46047 KAMEHAMEHA HWY STE C, KANEOHE, HI, 9674421.41981, -157.802112026-11-132026-11-14
doordashlongs drugs kaneohe
34970961
46-047 Kamehameha Hwy Ste C # Ste, Kaneohe, HI, 9674421.42066, -157.802262026-10-082026-11-11
overtureLongs Drugs
724e1ab3-92d2-4662-a0b0-8d546a18fd04
46-047 Kamehameha Hwy Ste c, Kaneohe, HI, 96744808235455121.42064, -157.802402026-11-132026-11-13
ubereatsLongs
7IJwwdJdVMW_jQzvmgqK3g
46 047 Kamehameha Hwy Ste C, Kaneohe, HI, 9674421.42063, -157.802362026-11-102026-11-10
vtinfoLONGS DRUG STORE
14eca3eda5c6a12e
46047 KAMEHAMEHA HWY STE C, KANEOHE, HI, 96744808235455121.41959, -157.801922026-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 31 m apart · name similarity 1.00
doordash longs drugs kaneoheoverture Longs Drugs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ab-inbev LONGS DRUG STOREdoordash longs drugs kaneohe0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 96 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 97 m apart · name similarity 0.64
doordash longs drugs kaneohevtinfo LONGS DRUG STORE0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 124 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 127 m apart · name similarity 0.64 · phone: equal
doordash longs drugs kaneoheubereats Longs0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair)
Both records are Longs Drugs (a CVS chain) at the same address, 46-047 Kamehameha Hwy Ste C in Kaneohe, with the same suite and coordinates 11 m apart; the names agree, which outweighs the shared buil
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records name Longs (Longs Drugs), give the same street address and suite (Ste C) in Kaneohe, and sit about 11 m apart, so they are one drugstore listed on two delivery apps; the shared building with five businesses is outweighed by the matching name and suite.
pair d78a5c13f4337a6654f0

Attributes

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

Trade area

Other outlets
84 within 1 mi · 122 within 3 mi
Off / on premise
13 / 43 within 1 mi · 18 / 62 within 3 mi
Selling alcohol
35 within 1 mi · 52 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.57 mi
Setting
suburban (1,733 people per sq mi)
People within 3 mi
49,005 (38,418 adults 21+, 15,342 households) from 14 tract(s), tracts within 3 mi
Income
per capita $52,102 · median household ~$136,300 (weighted mean of tract medians)
Age and education
median age ~44.4 · bachelor's or higher 40%
Ethnicity
Hispanic 11% · White 17% · Black 1% · Asian 36%
Adults per alcohol outlet
725
Alcohol spend within 3 mi
$14,548,695 a year ($6,262,138 at home, $8,281,156 away) · $274,504 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 2423260 ↔ doordash 34970961same address and namemerged15
2026-11-13 17:47insertab-inbev 2423260 ↔ overture 724e1ab3-92d2-4662-a0b0-8d546a18fd04same address and namemerged15
2026-11-13 17:47insertab-inbev 2423260 ↔ vtinfo 14eca3eda5c6a12esame address and namemerged15
2026-11-13 14:10insertoverture 724e1ab3-92d2-4662-a0b0-8d546a18fd04 ↔ vtinfo 14eca3eda5c6a12esame address and namemerged15
2026-11-13 14:10insertdoordash 34970961 ↔ overture 724e1ab3-92d2-4662-a0b0-8d546a18fd04same address and namemerged15
2026-11-11 12:56insertdoordash 34970961 ↔ ubereats 7IJwwdJdVMW_jQzvmgqK3gClaude judge: samemerged12
2026-11-11 12:56insertdoordash 34970961 ↔ vtinfo 14eca3eda5c6a12esame address and namemerged12