Longs Drug Store

Hauula, HI 96717 · O3d5e14b8ddaa · first seen 2026-10-08
3 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 2 other
a licence name in capitals, cleaned (derived; record_title.py)
Longs ubereats
longs drugs hauula doordash
Street
54-316 Kamehameha Hwy 1 other
ubereats
54316 KAMEHAMEHA HWY ab-inbev
City
Hauula
ubereatsno other value
State
HI
ubereatsno other value
ZIP
96717
ubereatsno other value
Pin
21.61983, -157.91622 map 1 other
ubereats
227 m away ab-inbev
Phone
none
no other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oaf92d29aa757; O524209264d8e

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
3579420
54316 KAMEHAMEHA HWY, HAUULA, HI, 9671721.62169, -157.917122026-11-132026-11-13
doordashlongs drugs hauula
34970927
54-316 Kamehameha Hwy, Hauula, HI, 9671721.61970, -157.916292026-10-082026-11-13
ubereatsLongs
wZd8uLZuU9GLw5v1qtt3fQ
54-316 Kamehameha Hwy, Hauula, HI, 9671721.61983, -157.916222026-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
ab-inbev LONGS DRUG STOREdoordash longs drugs hauula0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 238 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 227 m apart · name similarity 0.58
doordash longs drugs hauulaubereats Longs0.56Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (93% confident; asked as a “near” pair)
Longs Drugs same address Hauula.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 54-316 Kamehameha Hwy, Hauula, ZIP 96717, about 16 m apart, and both names are Longs (Longs Drugs is a CVS banner), so they look like one store listed on two delivery apps. The shared building with three businesses lowers confidence somewhat, but the matching name supports SAME.
pair 2b1604a9ae93306e41a5

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:36.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
9 within 1 mi · 15 within 3 mi
Off / on premise
1 / 3 within 1 mi · 2 / 5 within 3 mi
Selling alcohol
2 within 1 mi · 2 within 3 mi
Nearest
same channel 0.01 mi · licensed none within 3 mi
Setting
rural (328 people per sq mi)
People within 3 mi
9,262 (5,849 adults 21+, 1,900 households) from 2 tract(s), tracts within 3 mi
Income
per capita $30,014 · median household ~$119,858 (weighted mean of tract medians)
Age and education
median age ~27.2 · bachelor's or higher 41%
Ethnicity
Hispanic 8% · White 29% · Black 1% · Asian 11%
Adults per alcohol outlet
1,950
Alcohol spend within 3 mi
$1,582,131 a year ($706,442 at home, $874,789 away) · $527,377 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 34970927 ↔ ubereats wZd8uLZuU9GLw5v1qtt3fQClaude judge: samemerged17
2026-11-13 17:47insertab-inbev 3579420 ↔ ubereats wZd8uLZuU9GLw5v1qtt3fQsame address and namemerged15
2026-11-13 17:47insertab-inbev 3579420 ↔ doordash 34970927same address and namemerged15