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

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
-Publisher FASB
-Name Accounting Standards Codification
-Topic 505
-SubTopic 10
-Section S99
-Paragraph 1
-Subparagraph (SX 210.3-04)
-URI http://asc.fasb.org/extlink&oid=120397183&loc=d3e187085-122770

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