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, 2021					8,542,097				122,685,266	[2]
Balance at Dec. 31, 2021			$ 1,366,353		$ 89,680				$ 1,280,048	[2]			$ (3,375)
Increase (Decrease) in Partners' Capital [Roll Forward]
OP units issued under the Equity Incentive Plan (in shares)					201,860				406,106	[2]
OP Units issued under the Equity Incentive Plan		$ 302	302						$ 302	[2]
OP Units withheld for employee taxes (in shares)	[2]								(122,658)
OP Units withheld for employee taxes		(2,405)	(2,405)						$ (2,405)	[2]
Cancellation of OP Units (in shares)	[2]								(10,649)
Stock based compensation expense		2,572	2,572		$ 0				$ 2,572	[2]
Equity Redemption of OP Units (in shares)					(50,000)				50,000	[2]
Equity redemption of OP Units		978	978		$ (978)				$ 978	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		2,668				$ (2,668)	[2]
Issuance of OP Units in connection with sale of common stock, in shares	[2]								724,279
Issuance of OP Units in connection with sale of common stock		14,211	14,211						$ 14,211	[2]
Registration expenditures		(172)	(172)						(172)	[2]
Cash distributions			(17,139)	$ (110)	(1,130)		$ 0		(16,009)	[2]	$ (110)
Net income attributable to Retail Opportunity Investments Partnership, LP		12,466	12,466		$ 825				$ 11,641	[2]
Other comprehensive income (loss)		2,203	2,203										2,203
Balance (in shares) at Mar. 31, 2022					8,693,957				123,732,344	[2]
Balance at Mar. 31, 2022			1,378,281		$ 91,065				$ 1,288,388	[2]			(1,172)
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		133,472,004			8,447,117				125,024,887	[2]
Balance at Mar. 31, 2023			$ 1,372,894		$ 87,408				$ 1,285,476	[2]			$ 10

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

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