John S Marketplace on Premise

PORTLAND, OR 97219 · O207802dcbddf · first seen 2026-11-03
4 sourcesoff premisechain: John's Marketplacealcohol: 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
John S Marketplace on Premise 3 other
a licence name in capitals, cleaned (derived; record_title.py)
JOHN'S MARKETPLACE or-olccoverture ×2
JOHNS MARKETPLACE OFF PREMISE ab-inbev
P SQUARED HOLDINGS LLC or-olcc (legal name)
Street
3535 SW MULTNOMAH BLVD 1 other
or-olcc
3535 SW MULTNOMAH BL vtinfo
City
PORTLAND
or-olccno other value
State
OR
or-olccno other value
ZIP
97219
or-olccno other value
Pin
45.46737, -122.71320 map
overtureno other value
Phone
5032442617
vtinfono other value
Licences
or-olcc OR|388061|LIMITED ON-PREMISES SALES
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Odb0ce3c1e43d; O332f44f6ac56; O8a2d84ccdfe7

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-inbevJOHNS MARKETPLACE OFF PREMISE
194527
3535 SW MULTNOMAH BLVD, PORTLAND, OR, 9721945.46725, -122.713142026-11-112026-11-11
or-olccJOHN'S MARKETPLACE
legal name: P SQUARED HOLDINGS LLC
OR|388061|LIMITED ON-PREMISES SALES
3535 SW MULTNOMAH BLVD, PORTLAND, OR, 9721945.46726, -122.713282026-11-032026-11-12
overtureJohn's Marketplace
9965111e-1a55-4346-bb2f-f7912d189dd6
3535 SW Multnomah Blvd, Portland, OR, 97219503244261745.46737, -122.713202026-11-062026-11-12
vtinfoJOHN S MARKETPLACE ON PREMISE
5f0b43cc670b9728
3535 SW MULTNOMAH BL, PORTLAND, OR, 97219503244261745.46759, -122.713102026-11-112026-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 JOHNS MARKETPLACE OFF PREMISEvtinfo JOHNS MARKETPLACE OFF PREMISE1.00same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 38 m apart · name similarity 1.00
or-olcc JOHN'S MARKETPLACEvtinfo JOHNS MARKETPLACE OFF PREMISE0.62one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: e96165ce265e5c0e4cdf · person: None · rule: names contained at one address · stratum: near
or-olcc JOHN'S MARKETPLACEoverture John's Marketplace1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 14 m apart · name similarity 1.00
ab-inbev JOHNS MARKETPLACE OFF PREMISEor-olcc JOHN'S MARKETPLACE0.62Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “near” pair)
Same name and address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 93% confident — Both records sit at the same street address and ZIP in Portland, OR with nearly identical coordinates, the only business at that address is this one, and the names 'JOHNS MARKETPLACE OFF PREMISE' and 'JOHN'S MARKETPLACE' match, so this is one market's off-premise alcohol listing and its OLCC licence.
pair 133123ee0899e6375b77
ab-inbev JOHNS MARKETPLACE OFF PREMISEvtinfo JOHN S MARKETPLACE ON PREMISE0.59street written two waysmergedname Jaro-Winkler 0.96 · matched on city · pins 38 m apart · name similarity 0.59 · street similarity 0.94

Attributes

Channel
off_premise — overture-category
Chain
John's Marketplace — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
P SQUARED HOLDINGS LLC — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off — OR LIMITED ON-PREMISES SALES
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
85 within 1 mi · 464 within 3 mi
Off / on premise
19 / 47 within 1 mi · 97 / 240 within 3 mi
Selling alcohol
63 within 1 mi · 327 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (4,177 people per sq mi)
People within 3 mi
118,111 (93,370 adults 21+, 53,879 households) from 31 tract(s), tracts within 3 mi
Income
per capita $75,080 · median household ~$120,993 (weighted mean of tract medians)
Age and education
median age ~43.1 · bachelor's or higher 68%
Ethnicity
Hispanic 9% · White 77% · Black 2% · Asian 6%
Adults per alcohol outlet
285
Alcohol spend within 3 mi
$46,990,086 a year ($20,452,549 at home, $26,520,953 away) · $143,262 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-16 14:56insertor-olcc OR|388061|LIMITED ON-PREMISES SALES ↔ vtinfo 8692c825b8baf8faone name contains the other, same addressheld: same-source-conflict15
2026-11-14 20:23updateab-inbev 194527 ↔ vtinfo 8692c825b8baf8fasame address and nameheld: same-source-conflict15
2026-11-12 17:29insertab-inbev 194527 ↔ or-olcc OR|388061|LIMITED ON-PREMISES SALESClaude judge: samemerged14
2026-11-12 14:25insertab-inbev 194527 ↔ vtinfo 8692c825b8baf8fasame address and nameheld: same-source-conflict12
2026-11-11 12:56insertab-inbev 194527 ↔ vtinfo 5f0b43cc670b9728street written two waysmerged12
2026-11-06 18:13insertor-olcc OR|388061|LIMITED ON-PREMISES SALES ↔ overture 9965111e-1a55-4346-bb2f-f7912d189dd6same address and namemerged11