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		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	[1]			122,685,266	[2]
Balance at Dec. 31, 2021			$ 1,366,353		$ 89,680	[1]			$ 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	[1]			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	[1]			$ 2,572	[2]
Equity Redemption of OP Units (in shares)					(50,000)	[1]			50,000	[2]
Equity redemption of OP Units					$ (978)	[1]			$ 978	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		2,668	[1]			$ (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)	[1]	$ 0		(16,009)	[2]	$ (110)
Net income attributable to Retail Opportunity Investments Partnership, LP			12,466		$ 825	[1]			$ 11,641	[2]
Other comprehensive income (loss)		2,203	2,203										2,203
Balance (in shares) at Mar. 31, 2022					8,693,957	[1]			123,732,344	[2]
Balance at Mar. 31, 2022			1,378,281		$ 91,065	[1]			$ 1,288,388	[2]			(1,172)
Balance (in shares) at Dec. 31, 2021					8,542,097	[1]			122,685,266	[2]
Balance at Dec. 31, 2021			1,366,353		$ 89,680	[1]			$ 1,280,048	[2]			(3,375)
Increase (Decrease) in Partners' Capital [Roll Forward]
Equity redemption of OP Units		1,895	1,895
Net income attributable to Retail Opportunity Investments Partnership, LP		24,780	24,780
Balance (in shares) at Jun. 30, 2022					8,647,117	[1]			124,341,618	[2]
Balance at Jun. 30, 2022			1,388,224		$ 90,761	[1]			$ 1,297,468	[2]			(5)
Balance (in shares) at Mar. 31, 2022					8,693,957	[1]			123,732,344	[2]
Balance at Mar. 31, 2022			1,378,281		$ 91,065	[1]			$ 1,288,388	[2]			(1,172)
Increase (Decrease) in Partners' Capital [Roll Forward]
Cancellation of OP Units (in shares)	[2]								(1,500)
Stock based compensation expense		3,028	3,028		$ 0	[1]			$ 3,028	[2]
Equity Redemption of OP Units (in shares)					(46,840)	[1]			46,840	[2]
Equity redemption of OP Units			0		$ (917)	[1]			$ 917	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		932	[1]			$ (932)	[2]
Issuance of OP Units in connection with sale of common stock, in shares	[2]								563,934
Issuance of OP Units in connection with sale of common stock		10,988	10,988						$ 10,988	[2]
Registration expenditures		(161)	(161)						(161)	[2]
Cash distributions			(17,290)	(103)	(1,126)	[1]	0		(16,164)	[2]	(103)
Net income attributable to Retail Opportunity Investments Partnership, LP		12,314	12,314		$ 807	[1]			$ 11,507	[2]
Other comprehensive income (loss)		1,167	1,167										1,167
Balance (in shares) at Jun. 30, 2022					8,647,117	[1]			124,341,618	[2]
Balance at Jun. 30, 2022			1,388,224		$ 90,761	[1]			$ 1,297,468	[2]			(5)
Balance (in shares) at Dec. 31, 2022					8,447,117	[1]			124,538,811	[2]
Balance at Dec. 31, 2022			1,384,598		$ 88,429	[1]			$ 1,296,154	[2]			15
Increase (Decrease) in Partners' Capital [Roll Forward]
OP units issued under the Equity Incentive Plan (in shares)					0	[1]			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	[1]			2,840	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		(343)	[1]			343	[2]
Registration expenditures		(10)	(10)						(10)	[2]
Cash distributions			(20,020)	(143)	(1,267)	[1]	(52)		(18,753)	[2]	(91)
Net income attributable to Retail Opportunity Investments Partnership, LP			8,696		$ 554	[1]			$ 8,142	[2]
Other comprehensive income (loss)		$ (5)	(5)										(5)
Balance (in shares) at Mar. 31, 2023					8,447,117	[1]			125,024,887	[2]
Balance at Mar. 31, 2023			1,372,894		$ 87,408	[1]			$ 1,285,476	[2]			10
Balance (in shares) at Dec. 31, 2022					8,447,117	[1]			124,538,811	[2]
Balance at Dec. 31, 2022			1,384,598		$ 88,429	[1]			$ 1,296,154	[2]			15
Increase (Decrease) in Partners' Capital [Roll Forward]
Equity Redemption of OP Units (in shares)		1,010,000
Equity redemption of OP Units		$ 13,389	13,389
Net income attributable to Retail Opportunity Investments Partnership, LP		$ 19,214	19,214
Balance (in shares) at Jun. 30, 2023		133,440,912			7,437,117	[1]			126,003,795	[2]
Balance at Jun. 30, 2023			1,367,931		$ 76,590	[1]			$ 1,289,925	[2]			1,416
Balance (in shares) at Mar. 31, 2023					8,447,117	[1]			125,024,887	[2]
Balance at Mar. 31, 2023			1,372,894		$ 87,408	[1]			$ 1,285,476	[2]			10
Increase (Decrease) in Partners' Capital [Roll Forward]
OP units issued under the Equity Incentive Plan (in shares)					0				1,000	[2]
OP Units issued under the Equity Incentive Plan		$ 0	0						$ 0	[2]
OP Units withheld for employee taxes (in shares)	[2]								(8,667)
OP Units withheld for employee taxes		(110)	(110)						$ (110)	[2]
Cancellation of OP Units (in shares)	[2]								(23,425)
Stock based compensation expense		3,430	3,430		$ 669	[1]			$ 2,761	[2]
Equity Redemption of OP Units (in shares)					(1,010,000)	[1]			1,010,000	[2]
Equity redemption of OP Units		0	0		$ (13,389)	[1]			$ 13,389	[2]
Adjustment to non-controlling interests ownership in Operating Partnership		0	0		2,486	[1]			(2,486)	[2]
Registration expenditures		(36)	(36)						(36)	[2]
Cash distributions			(20,015)	$ (156)	(1,116)	[1]	$ (57)		(18,899)	[2]	$ (99)
Net income attributable to Retail Opportunity Investments Partnership, LP		10,518	10,518		$ 589	[1]			$ 9,929	[2]
Other comprehensive income (loss)		$ 1,406	1,406										1,406
Balance (in shares) at Jun. 30, 2023		133,440,912			7,437,117	[1]			126,003,795	[2]
Balance at Jun. 30, 2023			$ 1,367,931		$ 76,590	[1]			$ 1,289,925	[2]			$ 1,416

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

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