Pub 26

WELCHES, OR 97067 · O3afaa8b3470b · first seen 2026-11-03
3 sourceson premise · baralcohol: 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
Pub 26
a source's own spelling of the licence name (record_title.py)no other value
Street
67351 E HIGHWAY 26 2 other
or-olcc
67350 HWY 26 ab-inbev
67350 US-26 overture
City
WELCHES
or-olccno other value
State
OR
or-olccno other value
ZIP
97067
or-olccno other value
Pin
45.35118, -121.97229 map 1 other
overture
65 m away ab-inbev
Phone
5035649072
overtureno other value
Licences
or-olcc OR|382260|FULL ON-PREMISES SALES - COMMERCIAL
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O8b273a33c118; O81d9f561efab

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-inbevPUB 26
4729334
67350 HWY 26, WELCHES, OR, 9706745.35073, -121.971762026-11-122026-11-13
or-olccPUB 26
OR|382260|FULL ON-PREMISES SALES - COMMERCIAL
67351 E HIGHWAY 26, WELCHES, OR, 9706745.35095, -121.972472026-11-032026-11-18
overturePub 26
e4a23ef9-45f2-4923-b74f-9b567550773b
67350 US-26, Welches, OR, 97067503564907245.35118, -121.972292026-11-132026-11-13

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 PUB 26or-olcc PUB 261.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “proximity” pair)
Same pub name, near-identical highway address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records name PUB 26 in Welches, OR, with addresses on Highway 26 about 60 meters apart (67350 vs 67351 HWY 26), and no other business is listed at that address, so this is one pub with a beer account and an Oregon liquor licence.
pair da96c9a03d42c5e26f5f
ab-inbev PUB 26overture Pub 261.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 65 m apart · name similarity 1.00

Attributes

Channel
on_premise · bar — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — OR FULL ON-PREMISES SALES - COMMERCIAL
Rule version 11, computed 2026-11-19 21:41.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
13 within 1 mi · 25 within 3 mi
Off / on premise
2 / 8 within 1 mi · 4 / 10 within 3 mi
Selling alcohol
10 within 1 mi · 22 within 3 mi
Nearest
same channel 0.05 mi · licensed 0.02 mi
Setting
rural (113 people per sq mi)
People within 3 mi
3,209 (2,591 adults 21+, 1,569 households) from 1 tract(s), tracts within 3 mi
Income
per capita $49,950 · median household ~$91,815 (weighted mean of tract medians)
Age and education
median age ~51.3 · bachelor's or higher 34%
Ethnicity
Hispanic 18% · White 72% · Black 0% · Asian 1%
Adults per alcohol outlet
113
Alcohol spend within 3 mi
$1,037,289 a year ($472,022 at home, $564,887 away) · $45,100 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-18 18:58insertab-inbev 4729334 ↔ or-olcc OR|382260|FULL ON-PREMISES SALES - COMMERCIALClaude judge: samemerged15
2026-11-13 14:10insertab-inbev 4729334 ↔ overture e4a23ef9-45f2-4923-b74f-9b567550773bsame address and namemerged15