Pineapple Cafe

SEATTLE, WA 98105 · O4509a74c6ce8 · first seen 2026-11-12
3 sourceson premise · predictedalcohol: 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
Pineapple Cafe 1 other
a source's own spelling of the licence name (record_title.py)
PINEAPPLE RESTAURANT GROUP LLC wa-lcb (legal name)
Street
4242 ROOSEVELT WAY NE
wa-lcbno other value
City
SEATTLE
wa-lcbno other value
State
WA
wa-lcbno other value
ZIP
98105
wa-lcbno other value
Pin
47.65955, -122.31735 map
overtureno other value
Phone
5092807392 2 other
vtinfo
2068264244 overture
4254555825 wa-lcb
Licences
wa-lcb WA|084858|BEER/WINE REST - BEER/WINE
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc976616c38fb; O4fbe6ee865af

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
overturePineapple Cafe
3dd8e59c-a438-4f6d-b251-fa4e8f5b19f8
4242 Roosevelt Way NE, Seattle, WA, 98105206826424447.65955, -122.317352026-11-132026-11-13
vtinfoPINEAPPLE CAFE
e5ffa15db5565b04
4242 ROOSEVELT WAY NE, SEATTLE, WA, 98105509280739247.65955, -122.317432026-11-122026-11-14
wa-lcbPINEAPPLE CAFE
legal name: PINEAPPLE RESTAURANT GROUP LLC
WA|084858|BEER/WINE REST - BEER/WINE
4242 ROOSEVELT WAY NE, SEATTLE, WA, 98105425455582547.65951, -122.317672026-11-152026-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
overture Pineapple Cafevtinfo PINEAPPLE CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 6 m apart · name similarity 1.00 · phone: differs
overture Pineapple Cafewa-lcb PINEAPPLE CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: differs
vtinfo PINEAPPLE CAFEwa-lcb PINEAPPLE CAFE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: differs

Attributes

Channel
unknown
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PINEAPPLE RESTAURANT GROUP LLC — 3 outlets in the master under this operator
Licence privileges
none — WA BEER/WINE REST - BEER/WINE (not mapped)
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
380 within 1 mi · 1,795 within 3 mi
Off / on premise
41 / 251 within 1 mi · 228 / 1,001 within 3 mi
Selling alcohol
195 within 1 mi · 1,184 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.03 mi
Setting
urban (9,761 people per sq mi)
People within 3 mi
275,990 (228,056 adults 21+, 136,305 households) from 69 tract(s), tracts within 3 mi
Income
per capita $95,156 · median household ~$139,680 (weighted mean of tract medians)
Age and education
median age ~34.3 · bachelor's or higher 79%
Ethnicity
Hispanic 7% · White 67% · Black 3% · Asian 17%
Adults per alcohol outlet
192
Alcohol spend within 3 mi
$128,477,452 a year ($55,062,585 at home, $73,373,897 away) · $108,420 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-15 16:24insertvtinfo e5ffa15db5565b04 ↔ wa-lcb WA|084858|BEER/WINE REST - BEER/WINEsame address and namemerged15
2026-11-15 16:24insertoverture 3dd8e59c-a438-4f6d-b251-fa4e8f5b19f8 ↔ wa-lcb WA|084858|BEER/WINE REST - BEER/WINEsame address and namemerged15
2026-11-13 14:10insertoverture 3dd8e59c-a438-4f6d-b251-fa4e8f5b19f8 ↔ vtinfo e5ffa15db5565b04same address and namemerged15