Longs

Waipahu, HI 96797 · O7a4323b1836b · first seen 2026-10-08
2 sourcesoff premise · conveniencechain: CVSalcohol: alcohol chain

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 1 other
the most common name a source states
longs drugs kapolei doordash
Street
94 060 Farrington Highway #6 1 other
ubereats
94 Farrington Hwy # 060 # 60 doordash
City
Waipahu 1 other
ubereats
Kapolei doordash
State
HI
ubereatsno other value
ZIP
96797
ubereatsno other value
Pin
21.37789, -158.02490 map
ubereatsno other value
Phone
none
no other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of35232b3ce49

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 kapolei
34970973
94 Farrington Hwy # 060 # 60, Kapolei, HI, 96797
ZIP lookup: Waipahu, HI
21.37795, -158.024862026-10-082026-11-03
ubereatsLongs
RgRMXFPPXeWX-ZmCppBpzA
94 060 Farrington Highway #6, Waipahu, HI, 9679721.37789, -158.024902026-11-032026-11-06

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 kapoleiubereats Longs0.38Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (85% confident; asked as a “same-address” pair)
Both records are Longs Drugs at 94-060 Farrington Hwy in ZIP 96797, 8 m apart, with only one business known at the address; the unit 'differ' flag is an artifact of the Hawaiian hyphenated street numb
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 80% confident — Both records are Longs drugstores (a CVS-owned chain) at 94-060 Farrington Hwy in ZIP 96797, with coordinates about 8 m apart and only one business at the address. The unit numbers (#60 vs #6) differ, but they look like a formatting variant of one suite, and the matching names prove the same premises.
pair 982f9970cd43a7533867

Attributes

Channel
off_premise · convenience — ubereats-type
Chain
CVS — ubereats-parent
Alcohol
alcohol_chain — CVS: licensed at 322 of 1687 outlets in licence states
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:42.
Every vote behind these (raw)
{
 "ue_location": [
  "GROCERY_STORE"
 ],
 "votes": [
  [
   "ubereats-type",
   "off_premise",
   "convenience"
  ],
  [
   "doordash-url",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
66 within 1 mi · 153 within 3 mi
Off / on premise
9 / 45 within 1 mi · 25 / 90 within 3 mi
Selling alcohol
16 within 1 mi · 44 within 3 mi
Nearest
same channel 0.05 mi · licensed none within 3 mi
Setting
urban (3,098 people per sq mi)
People within 3 mi
87,606 (66,057 adults 21+, 24,167 households) from 26 tract(s), tracts within 3 mi
Income
per capita $37,665 · median household ~$113,990 (weighted mean of tract medians)
Age and education
median age ~40.7 · bachelor's or higher 25%
Ethnicity
Hispanic 8% · White 5% · Black 2% · Asian 62%
Adults per alcohol outlet
1,468
Alcohol spend within 3 mi
$20,443,462 a year ($8,992,500 at home, $11,441,942 away) · $454,299 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-06 18:13insertdoordash 34970973 ↔ ubereats RgRMXFPPXeWX-ZmCppBpzAClaude judge: samemerged11