SOUTH BAY WILD FISH HOUSE

ASTORIA, OR 97103 · O07da034a8a5e · first seen 2026-11-03
3 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
SOUTH BAY WILD FISH HOUSE
the most common name a source statesno other value
Street
254 & 262 9TH ST 1 other
or-olcc
262 9TH ST ab-inbevoverture ×2
City
ASTORIA
or-olccno other value
State
OR
or-olccno other value
ZIP
97103
or-olccno other value
Pin
46.18933, -123.83354 map
overtureno other value
Phone
5037413000
overtureno other value
Licences
or-olcc OR|381706|FULL ON-PREMISES SALES - COMMERCIAL
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O18d0e62d62e4; Oe796d3e6df17

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-inbevSOUTH BAY WILD FISH HOUSE
4215123
262 9TH ST, ASTORIA, OR, 9710346.18932, -123.833652026-11-112026-11-12
or-olccSOUTH BAY WILD FISH HOUSE
OR|381706|FULL ON-PREMISES SALES - COMMERCIAL
254 & 262 9TH ST, ASTORIA, OR, 9710346.18933, -123.833632026-11-032026-11-04
overtureSouth Bay Wild Fish House
25e154fb-687c-4683-aacd-1b32b9026ce9
262 9th St, Astoria, OR, 97103503741300046.18933, -123.833542026-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 SOUTH BAY WILD FISH HOUSEor-olcc SOUTH BAY WILD FISH HOUSE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (96% confident; asked as a “proximity” pair)
Same name, overlapping address 262 9th St.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records name SOUTH BAY WILD FISH HOUSE at 262 9th St, Astoria, OR 97103 with coordinates about 2 m apart, and no other business is held at that address, so the one restaurant is the same outlet (OR-OLCC address just adds 254 as a range).
pair 0cc50a1b7292ddd920fe
ab-inbev SOUTH BAY WILD FISH HOUSEoverture South Bay Wild Fish House1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00

Attributes

Channel
on_premise · restaurant — 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 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
124 within 1 mi · 160 within 3 mi
Off / on premise
22 / 65 within 1 mi · 26 / 84 within 3 mi
Selling alcohol
98 within 1 mi · 122 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.02 mi
Setting
rural (365 people per sq mi)
People within 3 mi
10,315 (7,983 adults 21+, 4,510 households) from 3 tract(s), tracts within 3 mi
Income
per capita $40,742 · median household ~$69,680 (weighted mean of tract medians)
Age and education
median age ~40.1 · bachelor's or higher 32%
Ethnicity
Hispanic 16% · White 81% · Black 1% · Asian 1%
Adults per alcohol outlet
65
Alcohol spend within 3 mi
$2,777,254 a year ($1,309,864 at home, $1,466,272 away) · $22,579 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:10insertab-inbev 4215123 ↔ overture 25e154fb-687c-4683-aacd-1b32b9026ce9same address and namemerged15
2026-11-12 17:29insertab-inbev 4215123 ↔ or-olcc OR|381706|FULL ON-PREMISES SALES - COMMERCIALClaude judge: samemerged14