ASTORIA COFFEE HOUSE

ASTORIA, OR 97103 · O08ec0ee3ae18 · first seen 2026-11-03
3 sourceson premise · restaurantalcohol: licensed2 licences

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
ASTORIA COFFEE HOUSE 3 other
the most common name a source states
ACH INC or-olcc (legal name) ×2
Astoria Coffee House & Bistro overture
ASTORIA COFFEEHOUSE ab-inbev
Street
243 11TH ST 1 other
or-olcc
243 11TH AVE ab-inbev
City
ASTORIA
or-olccno other value
State
OR
or-olccno other value
ZIP
97103
or-olccno other value
Pin
46.18946, -123.83192 map
overtureno other value
Phone
5033251787
overtureno other value
Licences
or-olcc OR|381271|FULL ON-PREMISES SALES - COMMERCIAL · or-olcc OR|381272|OFF-PREMISES SALES
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ob662ec95a92b; O8a5a5dc2e0ba; O4f0b9adda15e

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-inbevASTORIA COFFEEHOUSE
2970004
243 11TH AVE, ASTORIA, OR, 9710346.18939, -123.831822026-11-112026-11-11
or-olccASTORIA COFFEE HOUSE
legal name: ACH INC
OR|381271|FULL ON-PREMISES SALES - COMMERCIAL
243 11TH ST, ASTORIA, OR, 9710346.18942, -123.831812026-11-032026-11-12
or-olccASTORIA COFFEE HOUSE
legal name: ACH INC
OR|381272|OFF-PREMISES SALES
243 11TH ST, ASTORIA, OR, 9710346.18942, -123.831812026-11-032026-11-12
overtureAstoria Coffee House & Bistro
ceb97276-12af-45a4-9a99-e2f98178ccac
243 11th St, Astoria, OR, 97103503325178746.18946, -123.831922026-11-062026-11-12

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
or-olcc ASTORIA COFFEE HOUSEor-olcc ASTORIA COFFEE HOUSE1.00one store listed twicemergedsame street + ZIP · name: identical
or-olcc ASTORIA COFFEE HOUSEoverture Astoria Coffee House & Bistro0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · pins 9 m apart · name similarity 0.80
or-olcc ASTORIA COFFEE HOUSEoverture Astoria Coffee House & Bistro0.80same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.90 · same street + ZIP · pins 9 m apart · name similarity 0.80
ab-inbev ASTORIA COFFEEHOUSEor-olcc ASTORIA COFFEE HOUSE0.61Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (88% confident; asked as a “near” pair)
Same distinctive name, same number, near-identical location
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records are in Astoria, OR, zip 97103, at house number 243 with coordinates about 4 m apart, and the names are essentially identical (ASTORIA COFFEEHOUSE vs ASTORIA COFFEE HOUSE), with only one business at that address; the AVE/ST suffix difference is most likely a geocoding or data-entry inconsistency.
pair 134a8e5420faeaff6c94

Attributes

Channel
on_premise · restaurant — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
ACH INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — OR FULL ON-PREMISES SALES - COMMERCIAL; OR OFF-PREMISES SALES
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
127 within 1 mi · 160 within 3 mi
Off / on premise
22 / 66 within 1 mi · 26 / 84 within 3 mi
Selling alcohol
100 within 1 mi · 122 within 3 mi
Nearest
same channel 0.02 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-12 17:29insertab-inbev 2970004 ↔ or-olcc OR|381272|OFF-PREMISES SALESClaude judge: samemerged14
2026-11-06 18:13insertor-olcc OR|381271|FULL ON-PREMISES SALES - COMMERCIAL ↔ overture ceb97276-12af-45a4-9a99-e2f98178ccacsame address and namemerged11
2026-11-06 18:13insertor-olcc OR|381272|OFF-PREMISES SALES ↔ overture ceb97276-12af-45a4-9a99-e2f98178ccacsame address and namemerged11
2026-11-03 13:33backfillor-olcc OR|381271|FULL ON-PREMISES SALES - COMMERCIAL ↔ or-olcc OR|381272|OFF-PREMISES SALESone store listed twicemerged