Shell

ALOHA, OR 97007 · O06db2f4cf759 · first seen 2026-11-10
2 sourcesoff premise · conveniencechain: Shellalcohol: 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
Shell
the most common name a source statesno other value
Street
17395 SW FARMINGTON ROAD 1 other
shell
17395 SW Farmington Rd overture
City
ALOHA 1 other
shell
Beaverton overture
State
OR
shellno other value
ZIP
97007
shellno other value
Pin
45.48059, -122.85626 map
shellno other value
Phone
5036497591
shellno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O978ba9d04b8c

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
overtureShell
ef613ffb-d5ad-4794-9368-11cc625b913e
17395 SW Farmington Rd, Beaverton, OR, 97007503649759145.48053, -122.856322026-11-132026-11-13
shellShell
10005943
17395 SW FARMINGTON ROAD, ALOHA, OR, 97007
ZIP lookup: Beaverton, OR
503649759145.48059, -122.856262026-11-102026-11-10

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
overture Shellshell Shell1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
off_premise · convenience — chain-locator
Chain
Shell — chain-locator
Alcohol
alcohol_chain — Shell: licensed at 620 of 6239 outlets in licence states
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "chain-locator",
   "off_premise",
   "convenience"
  ],
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
50 within 1 mi · 580 within 3 mi
Off / on premise
15 / 22 within 1 mi · 104 / 369 within 3 mi
Selling alcohol
33 within 1 mi · 316 within 3 mi
Nearest
same channel 0.11 mi · licensed 0.12 mi
Setting
urban (5,070 people per sq mi)
People within 3 mi
143,346 (108,994 adults 21+, 55,458 households) from 32 tract(s), tracts within 3 mi
Income
per capita $50,304 · median household ~$106,522 (weighted mean of tract medians)
Age and education
median age ~38.9 · bachelor's or higher 44%
Ethnicity
Hispanic 21% · White 58% · Black 3% · Asian 12%
Adults per alcohol outlet
344
Alcohol spend within 3 mi
$44,455,186 a year ($19,824,944 at home, $24,610,538 away) · $140,237 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 14:10insertoverture ef613ffb-d5ad-4794-9368-11cc625b913e ↔ shell 10005943same address and namemerged15