Black Rose Liquor

PORTLAND, OR 97230 · O1a4fe99aa79e · first seen 2026-11-03
4 sourcesoff premise · liquor_storealcohol: 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
Black Rose Liquor 3 other
a licence name in capitals, cleaned (derived; record_title.py)
BLACK ROSE LIQUOR - PARKROSE or-olcc
Black Rose Liquor- Parkrose overture
JOHNS FAMILY INC. or-olcc (legal name)
Street
4200 NE 122ND AVE
or-olccno other value
City
PORTLAND
or-olccno other value
State
OR
or-olccno other value
ZIP
97230
or-olccno other value
Pin
45.55318, -122.53634 map 3 other
overture
87 m away ab-inbev
58 m away or-olcc
68 m away vtinfo
Phone
9713462019
vtinfono other value
Licences
or-olcc OR|LQ-OPS-13228|OFF-PREMISES SALES
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O51b318b5ee4c; Oc4f1c0f5fd4d; O91797aa0e02d

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-inbevBLACK ROSE LIQUOR
4892788
4200 NE 122ND AVE, PORTLAND, OR, 9723045.55373, -122.537142026-11-112026-11-11
or-olccBLACK ROSE LIQUOR - PARKROSE
legal name: JOHNS FAMILY INC.
OR|LQ-OPS-13228|OFF-PREMISES SALES
4200 NE 122ND AVE, PORTLAND, OR, 9723045.55317, -122.537082026-11-032026-11-05
overtureBlack Rose Liquor- Parkrose
5397d220-72e0-4455-90f5-95556ad576d2
4200 NE 122nd Ave, Portland, OR, 97230971346201945.55318, -122.536342026-11-062026-11-06
vtinfoBLACK ROSE LIQUOR
f525c6c2e0cba827
4200 NE 122ND AVE, PORTLAND, OR, 97230971346201945.55364, -122.536912026-11-122026-11-14

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 BLACK ROSE LIQUORvtinfo BLACK ROSE LIQUOR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 20 m apart · name similarity 1.00
or-olcc BLACK ROSE LIQUOR - PARKROSEoverture Black Rose Liquor- Parkrose1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 58 m apart · name similarity 1.00
ab-inbev BLACK ROSE LIQUORor-olcc BLACK ROSE LIQUOR - PARKROSE0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 62 m apart · name similarity 0.77
ab-inbev BLACK ROSE LIQUORoverture Black Rose Liquor- Parkrose0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 87 m apart · name similarity 0.77
or-olcc BLACK ROSE LIQUOR - PARKROSEvtinfo BLACK ROSE LIQUOR0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 54 m apart · name similarity 0.77
overture Black Rose Liquor- Parkrosevtinfo BLACK ROSE LIQUOR0.77same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + city + state · pins 68 m apart · name similarity 0.77 · phone: equal

Attributes

Channel
off_premise · liquor_store — overture-category
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
JOHNS FAMILY INC. — 1 outlets in the master under this operator
Licence privileges
beer_off, wine_off — OR OFF-PREMISES SALES
Rule version 10, computed 2026-11-18 20:35.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
71 within 1 mi · 514 within 3 mi
Off / on premise
13 / 34 within 1 mi · 113 / 257 within 3 mi
Selling alcohol
53 within 1 mi · 347 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.02 mi
Setting
urban (3,779 people per sq mi)
People within 3 mi
106,849 (83,597 adults 21+, 44,654 households) from 23 tract(s), tracts within 3 mi
Income
per capita $40,652 · median household ~$76,563 (weighted mean of tract medians)
Age and education
median age ~40.7 · bachelor's or higher 35%
Ethnicity
Hispanic 18% · White 57% · Black 9% · Asian 10%
Adults per alcohol outlet
240
Alcohol spend within 3 mi
$28,767,787 a year ($13,262,397 at home, $15,492,617 away) · $82,666 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 14:25insertor-olcc OR|LQ-OPS-13228|OFF-PREMISES SALES ↔ vtinfo f525c6c2e0cba827same address and namemerged12
2026-11-12 14:25insertoverture 5397d220-72e0-4455-90f5-95556ad576d2 ↔ vtinfo f525c6c2e0cba827same address and namemerged12
2026-11-12 14:25insertab-inbev 4892788 ↔ vtinfo f525c6c2e0cba827same address and namemerged12
2026-11-11 12:56insertab-inbev 4892788 ↔ overture 5397d220-72e0-4455-90f5-95556ad576d2same address and namemerged12
2026-11-11 12:56insertab-inbev 4892788 ↔ or-olcc OR|LQ-OPS-13228|OFF-PREMISES SALESsame address and namemerged12
2026-11-06 18:13insertor-olcc OR|LQ-OPS-13228|OFF-PREMISES SALES ↔ overture 5397d220-72e0-4455-90f5-95556ad576d2same address and namemerged11