Outlets /
Longs Drug Store
Honolulu, HI 96816 · O4ab6bd61b9eb · 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.
| 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 honolulu doordash |
| Street | 3221 Waialae Ave 1 other | ubereats | 3221 WAIALAE AVE STE 317D ab-inbevvtinfo ×2 |
| City | Honolulu | ubereats | no other value |
| State | HI | ubereats | no other value |
| ZIP | 96816 | ubereats | no other value |
| Pin | 21.28687, -157.80764 map | ubereats | no other value |
| Phone | 8087352811 | vtinfo | no other value |
| Licences | none on file | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O92b460afa7c0; O4f3fc37f9f45; O85d288b854ca; Oa6aac5922814
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 2423253 | 3221 WAIALAE AVE STE 317D, HONOLULU, HI, 96816 | 21.28671, -157.80771 | 2026-11-13 | 2026-11-14 | |
| doordash | longs drugs honolulu 34970931 | 3221 Waialae Ave, Honolulu, HI, 96816 | 21.28685, -157.80780 | 2026-10-08 | 2026-11-11 | |
| overture | Longs Drugs 823c143f-06aa-4389-ae34-717420e278e5 | 3221 Waialae Ave, Honolulu, HI, 96816 | 8087352811 | 21.28687, -157.80763 | 2026-11-06 | 2026-11-11 |
| ubereats | Longs 5HDp8it7UZCbZpvdzPuLHA | 3221 Waialae Ave, Honolulu, HI, 96816 | 21.28687, -157.80764 | 2026-11-05 | 2026-11-11 | |
| vtinfo | LONGS DRUG STORE d0c792fb771c4ac3 | 3221 WAIALAE AVE STE 317D, HONOLULU, HI, 96816 | 8087352811 | 21.28694, -157.80779 | 2026-11-11 | 2026-11-14 |
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 |
|---|---|---|---|---|---|
| ab-inbev LONGS DRUG STORE | vtinfo LONGS DRUG STORE | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 27 m apart · name similarity 1.00 |
| doordash longs drugs honolulu | overture Longs Drugs | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 17 m apart · name similarity 1.00 |
| ab-inbev LONGS DRUG STORE | doordash longs drugs honolulu | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 19 m apart · name similarity 0.64 |
| ab-inbev LONGS DRUG STORE | overture Longs Drugs | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 19 m apart · name similarity 0.64 |
| doordash longs drugs honolulu | vtinfo LONGS DRUG STORE | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 9 m apart · name similarity 0.64 |
| overture Longs Drugs | vtinfo LONGS DRUG STORE | 0.64 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.98 · same street + city + state · pins 18 m apart · name similarity 0.64 · phone: equal |
| ab-inbev LONGS DRUG STORE | ubereats Longs | 0.58 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: drug · name Jaro-Winkler 0.43 · same street + ZIP · pins 19 m apart · name similarity 0.58 |
| ubereats Longs | vtinfo LONGS DRUG STORE | 0.58 | same address and name | merged | address similarity 1.00 · names match with these kind-of-place words set aside: drug · name Jaro-Winkler 0.43 · same street + city + state · pins 18 m apart · name similarity 0.58 |
| doordash longs drugs honolulu | ubereats Longs | 0.56 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair) Both records are Longs Drugs (a CVS chain store) at the same street address, 3221 Waialae Ave, Honolulu 96816, with coordinates 17 m apart, and our data holds only one business at that address. Other Claude answers on this pair:
pair 20bc842b8f106c762cb6 |
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 +8 more 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
],
[
"overture-category",
"off_premise",
"pharmacy"
]
]
}Trade area
- Other outlets
- 184 within 1 mi · 1,228 within 3 mi
- Off / on premise
- 26 / 104 within 1 mi · 137 / 659 within 3 mi
- Selling alcohol
- 72 within 1 mi · 570 within 3 mi
- Nearest
- same channel 0.01 mi · licensed 0.32 mi
- Setting
- urban (6,356 people per sq mi)
- People within 3 mi
- 179,713 (150,422 adults 21+, 79,886 households) from 74 tract(s), tracts within 3 mi
- Income
- per capita $56,890 · median household ~$96,780 (weighted mean of tract medians)
- Age and education
- median age ~45.5 · bachelor's or higher 49%
- Ethnicity
- Hispanic 6% · White 22% · Black 1% · Asian 51%
- Adults per alcohol outlet
- 263
- Alcohol spend within 3 mi
- $58,785,222 a year ($26,434,340 at home, $32,326,696 away) · $102,951 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-13 17:47 | insert | ab-inbev 2423253 ↔ ubereats 5HDp8it7UZCbZpvdzPuLHA | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2423253 ↔ overture 823c143f-06aa-4389-ae34-717420e278e5 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2423253 ↔ doordash 34970931 | same address and name | merged | 15 |
| 2026-11-13 17:47 | insert | ab-inbev 2423253 ↔ vtinfo d0c792fb771c4ac3 | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | ubereats 5HDp8it7UZCbZpvdzPuLHA ↔ vtinfo d0c792fb771c4ac3 | same address and name | merged | 14 |
| 2026-11-11 12:56 | insert | doordash 34970931 ↔ ubereats 5HDp8it7UZCbZpvdzPuLHA | Claude judge: same | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 34970931 ↔ vtinfo d0c792fb771c4ac3 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | overture 823c143f-06aa-4389-ae34-717420e278e5 ↔ vtinfo d0c792fb771c4ac3 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | doordash 34970931 ↔ overture 823c143f-06aa-4389-ae34-717420e278e5 | same address and name | merged | 11 |