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

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