Outlets /
Longs Drug Store
WAIANAE, HI 96792 · O2be096296c60 · first seen 2026-10-08
4 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.
| Field | Master value | Taken from | What 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 waianae doordash |
| Street | 84-1160 Farrington Hwy 2 other | ubereats | 84 1160 FARRINGTON HWY ab-inbev 84-1160 FARRINGTON Highway overture |
| City | Waianae | ubereats | no other value |
| State | HI | ubereats | no other value |
| ZIP | 96792 | ubereats | no other value |
| Pin | 21.46085, -158.20747 map | ubereats | no other value |
| Phone | 8086964334 | overture | no other value |
| Licences | none on file | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Od184eaf37d1e; O529adcabca35; O39eacd45a9c9
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | LONGS DRUG STORE 4110272 | 84 1160 FARRINGTON HWY, WAIANAE, HI, 96792 | 21.46099, -158.20732 | 2026-11-13 | 2026-11-18 | |
| doordash | longs drugs waianae 34970919 | 84-1160 Farrington Hwy, Waianae, HI, 96792 | 21.46092, -158.20737 | 2026-10-08 | 2026-11-11 | |
| overture | Longs Drugs 991050b2-07ca-466e-9c8f-70e361d3f84c | 84-1160 FARRINGTON Highway, WAIANAE, HI, 96792 | 8086964334 | 21.46096, -158.20738 | 2026-11-13 | 2026-11-13 |
| ubereats | Longs sBuVoiJOXXeK1RIfrrmAMQ | 84-1160 Farrington Hwy, Waianae, HI, 96792 | 21.46085, -158.20747 | 2026-11-04 | 2026-11-04 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| doordash longs drugs waianae | overture Longs Drugs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 5 m apart · name similarity 1.00 |
| ab-inbev LONGS DRUG STORE | doordash longs drugs waianae | 0.64 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair) Longs Drugs same address Other Claude answers on this pair:
pair 3416e36b6db1ff03c22f |
| ab-inbev LONGS DRUG STORE | ubereats Longs | 0.58 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “near” pair) Longs same address Other Claude answers on this pair:
pair 34cf572ed57345c78833 |
| doordash longs drugs waianae | ubereats Longs | 0.56 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair) Both records are Longs Drugs (a CVS chain) at the identical street address 84-1160 Farrington Hwy, Waianae, 13 m apart, and they are the only business at that address; the DoorDash slug simply appends Other Claude answers on this pair:
pair aff53bc243a2215250c5 |
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 11, computed 2026-11-19 21:41.
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
- 5 within 1 mi · 40 within 3 mi
- Off / on premise
- 1 / 0 within 1 mi · 4 / 13 within 3 mi
- Selling alcohol
- 2 within 1 mi · 20 within 3 mi
- Nearest
- same channel 0.02 mi · licensed none within 3 mi
- Setting
- suburban (697 people per sq mi)
- People within 3 mi
- 19,701 (13,547 adults 21+, 5,355 households) from 5 tract(s), tracts within 3 mi
- Income
- per capita $27,291 · median household ~$78,901 (weighted mean of tract medians)
- Age and education
- median age ~36.3 · bachelor's or higher 13%
- Ethnicity
- Hispanic 14% · White 12% · Black 2% · Asian 10%
- Adults per alcohol outlet
- 645
- Alcohol spend within 3 mi
- $3,464,016 a year ($1,599,768 at home, $1,862,503 away) · $164,953 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-18 18:58 | insert | ab-inbev 4110272 ↔ ubereats sBuVoiJOXXeK1RIfrrmAMQ | Claude judge: same | merged | 15 |
| 2026-11-18 18:58 | insert | ab-inbev 4110272 ↔ doordash 34970919 | Claude judge: same | merged | 15 |
| 2026-11-13 19:03 | insert | doordash 34970919 ↔ overture 991050b2-07ca-466e-9c8f-70e361d3f84c | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | doordash 34970919 ↔ ubereats sBuVoiJOXXeK1RIfrrmAMQ | Claude judge: same | merged | 12 |