Consolidated Statements of Partners' Capital - USD ($) $ in Thousands		Total	Retail Opportunity Investments Partnership L.P.	Retail Opportunity Investments Partnership L.P. Officer	Retail Opportunity Investments Partnership L.P. Limited Partner’s Capital	[1]	Retail Opportunity Investments Partnership L.P. Limited Partner’s Capital Officer	[1]	Retail Opportunity Investments Partnership L.P. ROIC Capital		Retail Opportunity Investments Partnership L.P. ROIC Capital Officer	[2]	Retail Opportunity Investments Partnership L.P. Accumulated other comprehensive income (loss)
Balance (in shares) at Dec. 31, 2022					8,447,117				124,538,811	[2]
Balance at Dec. 31, 2022			$ 1,384,598		$ 88,429				$ 1,296,154	[2]			$ 15
Increase (Decrease) in Partners' Capital [Roll Forward]
OP units issued under the Equity Incentive Plan (in shares)					0				697,691	[2]
OP Units issued under the Equity Incentive Plan		$ 32	32						$ 32	[2]
OP Units withheld for employee taxes (in shares)	[2]								(211,615)
OP Units withheld for employee taxes		(3,181)	(3,181)						$ (3,181)	[2]
Stock based compensation expense		2,927	2,927		$ 87				2,840	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		(343)				343	[2]
Registration expenditures		(10)	(10)						(10)	[2]
Cash distributions			(20,020)	$ (143)	(1,267)		$ (52)		(18,753)	[2]	$ (91)
Net income attributable to Retail Opportunity Investments Partnership, LP		8,696	8,696		$ 554				$ 8,142	[2]
Other comprehensive income (loss)		(5)	(5)										(5)
Balance (in shares) at Mar. 31, 2023					8,447,117				125,024,887	[2]
Balance at Mar. 31, 2023			1,372,894		$ 87,408				$ 1,285,476	[2]			10
Balance (in shares) at Dec. 31, 2023					7,437,117				126,904,085	[2]
Balance at Dec. 31, 2023			1,363,207		$ 75,854				$ 1,286,761	[2]			592
Increase (Decrease) in Partners' Capital [Roll Forward]
OP units issued under the Equity Incentive Plan (in shares)					0				810,507	[2]
OP Units issued under the Equity Incentive Plan		0	0						$ 0	[2]
OP Units withheld for employee taxes (in shares)	[2]								(251,738)
OP Units withheld for employee taxes		(3,532)	(3,532)						$ (3,532)	[2]
Cancellation of OP Units (in shares)	[2]								(5,000)
Stock based compensation expense		2,787	2,787		$ 926				$ 1,861	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		(1,096)				1,096	[2]
Registration expenditures		(33)	(33)						(33)	[2]
Cash distributions			(20,234)	$ (174)	(1,116)		$ (134)		(19,118)	[2]	$ (40)
Net income attributable to Retail Opportunity Investments Partnership, LP		11,665	11,665		$ 647				$ 11,018	[2]
Other comprehensive income (loss)		$ (40)	(40)										(40)
Balance (in shares) at Mar. 31, 2024		134,894,971			7,437,117				127,457,854	[2]
Balance at Mar. 31, 2024			$ 1,353,646		$ 75,081				$ 1,278,013	[2]			$ 552

[1] Consists of limited partnership interests held by third parties.

[2] Consists of general and limited partnership interests held by ROIC.