Longs Drug Store

Pearl City, HI 96782 · Obd4f633182d2 · 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 pearl city doordash
Street
850 Kamehameha Hwy Ste 107 1 other
ubereats
850 Kamehameha Hwy Ste 107 # Ste doordash
City
Pearl City
ubereatsno other value
State
HI
ubereatsno other value
ZIP
96782
ubereatsno other value
Pin
21.39401, -157.96837 map 2 other
ubereats
110 m away ab-inbev
63 m away vtinfo
Phone
8084551087 1 other
vtinfo
8084554555 overture
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oec25f021ff5c; Obf239a43da5b; Oebe1cb27c89b; Oe8a64f720d7b

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
2423268
850 KAMEHAMEHA HWY STE 107, PEARL CITY, HI, 9678221.39491, -157.967942026-11-132026-11-14
doordashlongs drugs pearl city
34970969
850 Kamehameha Hwy Ste 107 # Ste, Pearl City, HI, 9678221.39407, -157.968332026-10-082026-11-06
overtureLongs Drugs
5b02b09b-5508-470c-8a21-21d0fd5319a7
850 Kamehameha Hwy Ste 107, Pearl City, HI, 96782808455455521.39413, -157.968392026-11-062026-11-06
ubereatsLongs
xN-XvkhhXOuw_V5rSAYXLg
850 Kamehameha Hwy Ste 107, Pearl City, HI, 9678221.39401, -157.968372026-11-042026-11-11
vtinfoLONGS DRUG STORE
489c9630d1c535f8
850 KAMEHAMEHA HWY STE 107, PEARL CITY, HI, 96782808455108721.39433, -157.968882026-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 117 m apart · name similarity 1.00
doordash longs drugs pearl cityoverture Longs Drugs1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev LONGS DRUG STOREdoordash longs drugs pearl city0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 101 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 98 m apart · name similarity 0.64
doordash longs drugs pearl cityvtinfo LONGS DRUG STORE0.64same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 64 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 55 m apart · name similarity 0.64 · phone: differs
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 110 m apart · name similarity 0.58
ubereats Longsvtinfo LONGS DRUG STORE0.58Claude judge: samemerged
Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “near” pair)
Both records name Longs Drugs at the identical address and suite (850 Kamehameha Hwy Ste 107, Pearl City), so the names agree even though the building is shared.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 90% confident — Both records are at 850 Kamehameha Hwy Ste 107, Pearl City, with the same suite and about 63 m apart; 'Longs' (Uber Eats, CVS chain) matches 'LONGS DRUG STORE' (VTInfo), so they are one drugstore listed in two sources.
pair 000d4ceabb4e60b770b7
doordash longs drugs pearl cityubereats Longs0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair)
Both records are Longs Drugs at 850 Kamehameha Hwy Ste 107, Pearl City: the suite matches and the coordinates are 8 m apart, so the names agree despite the shared building.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 86% confident — Both records are Longs Drugs at the same street address and suite (Ste 107 in Pearl City, 8 m apart), and the Uber Eats record's CVS chain field matches the Longs banner, so they are one store listed on two apps, though four businesses share the building.
pair 7d3c33b1055bb71c973f

Attributes

Channel
off_premise · convenience — ubereats-type
Chain
CVS — ubereats-parent
Alcohol
alcohol — listed as carrying Boston Beer, Bud Light (AB InBev), Diageo Beer Company +7 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:37.
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
87 within 1 mi · 330 within 3 mi
Off / on premise
15 / 53 within 1 mi · 60 / 169 within 3 mi
Selling alcohol
31 within 1 mi · 112 within 3 mi
Nearest
same channel 0.04 mi · licensed 1.17 mi
Setting
urban (3,684 people per sq mi)
People within 3 mi
104,158 (81,709 adults 21+, 32,116 households) from 33 tract(s), tracts within 3 mi
Income
per capita $43,014 · median household ~$111,306 (weighted mean of tract medians)
Age and education
median age ~43.4 · bachelor's or higher 32%
Ethnicity
Hispanic 7% · White 11% · Black 2% · Asian 57%
Adults per alcohol outlet
723
Alcohol spend within 3 mi
$26,386,394 a year ($11,670,106 at home, $14,704,758 away) · $233,508 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 2423268 ↔ ubereats xN-XvkhhXOuw_V5rSAYXLgsame address and namemerged15
2026-11-13 17:47insertab-inbev 2423268 ↔ overture 5b02b09b-5508-470c-8a21-21d0fd5319a7same address and namemerged15
2026-11-13 17:47insertab-inbev 2423268 ↔ doordash 34970969same address and namemerged15
2026-11-13 17:47insertab-inbev 2423268 ↔ vtinfo 489c9630d1c535f8same address and namemerged15
2026-11-12 14:25insertubereats xN-XvkhhXOuw_V5rSAYXLg ↔ vtinfo 489c9630d1c535f8Claude judge: samemerged12
2026-11-11 12:56insertdoordash 34970969 ↔ ubereats xN-XvkhhXOuw_V5rSAYXLgClaude judge: samemerged12
2026-11-11 12:56insertdoordash 34970969 ↔ vtinfo 489c9630d1c535f8same address and namemerged12
2026-11-11 12:56insertoverture 5b02b09b-5508-470c-8a21-21d0fd5319a7 ↔ vtinfo 489c9630d1c535f8same address and namemerged12
2026-11-06 18:13insertdoordash 34970969 ↔ overture 5b02b09b-5508-470c-8a21-21d0fd5319a7same address and namemerged11