The Sub Shop

Keizer, OR 97303 · O27e71ab98aa5 · first seen 2026-10-16
5 sourceson premise · restaurantalcohol: licensed1 licence

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
The Sub Shop 4 other
a licence name in capitals, cleaned (derived; record_title.py)
SUB SHOP ab-inbevvtinfo ×2
SUBS WITH LOVE or-olccoverture ×2
HARGIS LLC or-olcc (legal name)
Keizer Sub Shop ubereats
Street
4490 RIVER RD N
or-olccno other value
City
KEIZER 1 other
or-olcc
SALEM ab-inbevvtinfo ×2
State
OR
or-olccno other value
ZIP
97303
or-olccno other value
Pin
44.98952, -123.02657 map
ubereatsno other value
Phone
5033930175
vtinfono other value
Licences
or-olcc OR|383324|LIMITED ON-PREMISES SALES
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O9f62c41d6217; Ob70c96ef6492; O9665174a7eb3; O36676f941407

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-inbevSUB SHOP
3032231
4490 RIVER RD N, SALEM, OR, 9730344.98930, -123.026222026-11-122026-11-16
or-olccSUBS WITH LOVE
legal name: HARGIS LLC
OR|383324|LIMITED ON-PREMISES SALES
4490 RIVER RD N, KEIZER, OR, 9730344.98955, -123.026512026-11-032026-11-16
overtureSubs With Love
02d51048-7d12-408a-8099-f9e7876e8110
4490 River Rd N, Keizer, OR, 97303503393017544.98938, -123.026192026-11-062026-11-16
ubereatsKeizer Sub Shop
8cQ5pXOwQ_-0fjs1rFFOFQ
4490 River Rd N, Keizer, OR, 9730344.98952, -123.026572026-10-162026-11-03
vtinfoSUB SHOP
b0fd63676bc58897
4490 RIVER RD N, SALEM, OR, 97303503393017544.98944, -123.026202026-11-132026-11-16

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 SUB SHOPvtinfo SUB SHOP1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 16 m apart · name similarity 1.00
or-olcc SUBS WITH LOVEoverture Subs With Love1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 31 m apart · name similarity 1.00
ab-inbev SUB SHOPubereats Keizer Sub Shop0.48one name contains the other, same addressmergedjudge: None · pair_id: bae3cefc5c86b191e4a2 · person: None · rule: names contained at one address · stratum: near
ubereats Keizer Sub Shopvtinfo SUB SHOP0.48one name contains the other, same addressmergedjudge: None · pair_id: b93c4fc1e4cce54048e5 · person: None · rule: names contained at one address · stratum: near
ab-inbev SUB SHOPor-olcc SUBS WITH LOVE0.18one name contains the other, same addressmergedjudge: None · pair_id: 47f0adf0af659bad11cc · person: None · rule: names contained at one address · stratum: same-address
or-olcc SUBS WITH LOVEvtinfo SUB SHOP0.18one name contains the other, same addressmergedjudge: None · pair_id: 3524bbc8532c5666db46 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
HARGIS LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — OR LIMITED ON-PREMISES SALES
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "ue_location": [
  "DEFAULT"
 ],
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
96 within 1 mi · 429 within 3 mi
Off / on premise
14 / 55 within 1 mi · 87 / 234 within 3 mi
Selling alcohol
56 within 1 mi · 238 within 3 mi
Nearest
same channel 0.04 mi · licensed 0.00 mi
Setting
urban (3,231 people per sq mi)
People within 3 mi
91,365 (64,128 adults 21+, 33,925 households) from 17 tract(s), tracts within 3 mi
Income
per capita $33,435 · median household ~$74,020 (weighted mean of tract medians)
Age and education
median age ~34.6 · bachelor's or higher 24%
Ethnicity
Hispanic 31% · White 64% · Black 1% · Asian 2%
Adults per alcohol outlet
268
Alcohol spend within 3 mi
$20,166,128 a year ($9,518,497 at home, $10,637,353 away) · $84,377 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-16 14:56insertab-inbev 3032231 ↔ or-olcc OR|383324|LIMITED ON-PREMISES SALESone name contains the other, same addressmerged15
2026-11-16 14:56insertor-olcc OR|383324|LIMITED ON-PREMISES SALES ↔ vtinfo b0fd63676bc58897one name contains the other, same addressmerged15
2026-11-16 14:56insertubereats 8cQ5pXOwQ_-0fjs1rFFOFQ ↔ vtinfo b0fd63676bc58897one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 3032231 ↔ ubereats 8cQ5pXOwQ_-0fjs1rFFOFQone name contains the other, same addressmerged15
2026-11-13 14:10insertab-inbev 3032231 ↔ vtinfo b0fd63676bc58897same address and namemerged15
2026-11-06 18:13insertor-olcc OR|383324|LIMITED ON-PREMISES SALES ↔ overture 02d51048-7d12-408a-8099-f9e7876e8110same address and namemerged11