Consolidated Statements of Partners' Capital (Parentheticals) - $ / shares	3 Months Ended
Jun. 30, 2023	Mar. 31, 2023	Jun. 30, 2022	Mar. 31, 2022
Retail Opportunity Investments Partnership L.P.
Cash distributions per unit (in dollars per share)	$ 0.15	$ 0.15	$ 0.13	$ 0.13

Per unit of ownership amount of cash distributions paid to unit-holder of a limited partnership (LP).

Reference 1: http://fasb.org/us-gaap/role/ref/legacyRef
-Topic 505
-SubTopic 10
-Name Accounting Standards Codification
-Section S99
-Paragraph 1
-Subparagraph (SX 210.3-04)
-Publisher FASB
-URI https://asc.fasb.org//1943274/2147480008/505-10-S99-1

Name:	us-gaap_DistributionMadeToLimitedPartnerDistributionsPaidPerUnit
Namespace Prefix:	us-gaap_
Data Type:	dtr-types:perShareItemType
Balance Type:	na
Period Type:	duration