John's Marketplace

PORTLAND, OR 97202 · O06305230adf5 · first seen 2026-10-08
4 sourceson premise · restaurantchain: 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 3 other
the most common name a source states
johns marketplace grill on powell portland doordash
JOHNS MARKETPLACE ON PREMISE vtinfo
P SQUARED HOLDINGS LLC or-olcc (legal name)
Street
3560 SE POWELL BLVD
or-olccno other value
City
PORTLAND
or-olccno other value
State
OR
or-olccno other value
ZIP
97202
or-olccno other value
Pin
45.49656, -122.62711 map
doordashno other value
Phone
5032442617 1 other
vtinfo
5032065273 overture
Licences
or-olcc OR|386300|LIMITED ON-PREMISES SALES
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Obb1bdee53336; Oa01e0f06a4bc; O7ba3432171b1; Ocb19889bfb7e

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
doordashjohns marketplace grill on powell portland
49416860
3560 SE Powell Blvd, Portland, OR, 9720245.49656, -122.627112026-10-082026-11-19
or-olccJOHN'S MARKETPLACE
legal name: P SQUARED HOLDINGS LLC
OR|386300|LIMITED ON-PREMISES SALES
3560 SE POWELL BLVD, PORTLAND, OR, 9720245.49692, -122.627332026-11-032026-11-09
overtureJohn's Marketplace
6000405f-5386-4330-99f6-5c9afd954d7c
3560 SE Powell Blvd, Portland, OR, 97202503206527345.49649, -122.627062026-11-062026-11-06
vtinfoJOHNS MARKETPLACE ON PREMISE
ada068ce58bf7396
3560 SE POWELL BLVD, PORTLAND, OR, 97202503244261745.49683, -122.627292026-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 JOHNS MARKETPLACE OFF PREMISEvtinfo JOHNS MARKETPLACE ON PREMISE0.77same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 28 m apart · name similarity 0.77
ab-inbev JOHNS MARKETPLACE OFF PREMISEor-olcc JOHN'S MARKETPLACE0.62one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 8595c09eebe2d9febf83 · person: None · rule: names contained at one address · stratum: near
or-olcc JOHN'S MARKETPLACEvtinfo JOHNS MARKETPLACE OFF PREMISE0.62one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 1b260236f16a259cd255 · person: None · rule: names contained at one address · stratum: near
or-olcc JOHN'S MARKETPLACEoverture 00a4e6d7-7bcd-4aa1-9ed9-705c83a267b91.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 759 m apart · name similarity 1.00
or-olcc JOHN'S MARKETPLACEoverture John's Marketplace1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 52 m apart · name similarity 1.00
or-olcc JOHN'S MARKETPLACEvtinfo JOHNS MARKETPLACE ON PREMISE0.63same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 10 m apart · name similarity 0.63
overture John's Marketplacevtinfo JOHNS MARKETPLACE ON PREMISE0.63same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + city + state · pins 43 m apart · name similarity 0.63 · phone: differs
doordash johns marketplace grill on powell portlandvtinfo JOHNS MARKETPLACE ON PREMISE0.63Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (75% confident; asked as a “near” pair)
John's Marketplace on-premise grill, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records share the same street address (3560 SE Powell Blvd, Portland OR, coordinates about 0.03 km apart) and the same distinctive name 'Johns Marketplace', with the DoorDash 'grill' and the VTInfo 'on premise' label reading as one operation's restaurant listings; the second business at the address makes this less certain than a sole-occupant match.
pair 2a42e9ab2e34c3630c6f
doordash johns marketplace grill on powell portlandor-olcc JOHN'S MARKETPLACE0.54one name contains the other, same addressmergedjudge: None · pair_id: 77eeac63350325a632e7 · person: None · rule: names contained at one address · stratum: near

Attributes

Channel
on_premise · restaurant — doordash-url conflicting evidence
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 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "off_premise",
   null
  ]
 ]
}

Trade area

Other outlets
267 within 1 mi · 2,395 within 3 mi
Off / on premise
49 / 145 within 1 mi · 361 / 1,307 within 3 mi
Selling alcohol
190 within 1 mi · 1,642 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.03 mi
Setting
urban (7,165 people per sq mi)
People within 3 mi
202,591 (168,911 adults 21+, 96,986 households) from 54 tract(s), tracts within 3 mi
Income
per capita $60,391 · median household ~$96,649 (weighted mean of tract medians)
Age and education
median age ~39.0 · bachelor's or higher 61%
Ethnicity
Hispanic 10% · White 75% · Black 3% · Asian 7%
Adults per alcohol outlet
103
Alcohol spend within 3 mi
$73,691,473 a year ($32,954,959 at home, $40,707,036 away) · $44,852 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-19 20:37insertdoordash 49416860 ↔ vtinfo ada068ce58bf7396Claude judge: samemerged17
2026-11-17 17:19updateab-inbev 4374387 ↔ vtinfo ada068ce58bf7396same address and nameheld: same-source-conflict15
2026-11-16 14:56insertdoordash 49416860 ↔ or-olcc OR|386300|LIMITED ON-PREMISES SALESone name contains the other, same addressmerged15
2026-11-16 14:56insertor-olcc OR|386300|LIMITED ON-PREMISES SALES ↔ vtinfo fe3eefed4a8a7f65one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertab-inbev 4374387 ↔ or-olcc OR|386300|LIMITED ON-PREMISES SALESone name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56updateab-inbev 4374387 ↔ vtinfo ada068ce58bf7396same address and nameheld: same-source-conflict15
2026-11-14 20:23updateab-inbev 4374387 ↔ vtinfo ada068ce58bf7396same address and nameheld: same-source-conflict15
2026-11-12 14:25insertoverture 6000405f-5386-4330-99f6-5c9afd954d7c ↔ vtinfo ada068ce58bf7396same address and namemerged12
2026-11-12 14:25insertor-olcc OR|386300|LIMITED ON-PREMISES SALES ↔ vtinfo ada068ce58bf7396same address and namemerged12
2026-11-12 14:25insertab-inbev 4374387 ↔ vtinfo ada068ce58bf7396same address and nameheld: same-source-conflict12
2026-11-09 15:32updateor-olcc OR|386300|LIMITED ON-PREMISES SALES ↔ overture 6000405f-5386-4330-99f6-5c9afd954d7csame address and namemerged11
2026-11-06 18:13insertor-olcc OR|386300|LIMITED ON-PREMISES SALES ↔ overture 6000405f-5386-4330-99f6-5c9afd954d7csame address and nameheld: same-source-conflict11
2026-11-06 18:13insertor-olcc OR|386300|LIMITED ON-PREMISES SALES ↔ overture 00a4e6d7-7bcd-4aa1-9ed9-705c83a267b9same address and namemerged11