Dataset: International Investment Position - Quarterly Data

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

freq Freq	unit Unit	s_adj S Adj	bop_item Bop Item	sector10 Sector10	sectpart Sectpart	stk_flow Stk Flow	partner Partner	geo Geo	time_period Time Period	value Value
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account	Total economy	Total economy	Net positions at the end of period	Rest of the world	Spain	1992-Q4	-70096
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account; other investment	Total economy	Total economy	Assets - positions at the end of period	Rest of the world	Spain	1992-Q4	58183
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account; other investment	Total economy	Total economy	Liabilities - positions at the end of period	Rest of the world	Spain	1992-Q4	81402
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account; other investment	Total economy	Total economy	Net positions at the end of period	Rest of the world	Spain	1992-Q4	-23219
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account; portfolio investment	Total economy	Total economy	Liabilities - positions at the end of period	Rest of the world	Spain	1992-Q4	40742
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account	Total economy	Total economy	Assets - positions at the end of period	Rest of the world	Spain	1993-Q1	131520
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account	Total economy	Total economy	Liabilities - positions at the end of period	Rest of the world	Spain	1993-Q1	210011
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account	Total economy	Total economy	Net positions at the end of period	Rest of the world	Spain	1993-Q1	-78491
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account; direct investment	Total economy	Total economy	Assets - positions at the end of period	Rest of the world	Spain	1993-Q1	14003
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Financial account; direct investment	Total economy	Total economy	Liabilities - positions at the end of period	Rest of the world	Spain	1993-Q1	61279

freq

Freq

unit

Unit

s_adj

S Adj

bop_item

Bop Item

sector10

Sector10

sectpart

Sectpart

stk_flow

Stk Flow

partner

Partner

geo

Geo

time_period

Time Period

value

Value

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account

Total economy

Net positions at the end of period

Rest of the world

Spain

1992-Q4

-70096

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account; other investment

Total economy

Assets - positions at the end of period

Rest of the world

Spain

1992-Q4

58183

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account; other investment

Total economy

Liabilities - positions at the end of period

Rest of the world

Spain

1992-Q4

81402

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account; other investment

Total economy

Net positions at the end of period

Rest of the world

Spain

1992-Q4

-23219

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account; portfolio investment

Total economy

Liabilities - positions at the end of period

Rest of the world

Spain

1992-Q4

40742

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account

Total economy

Assets - positions at the end of period

Rest of the world

Spain

1993-Q1

131520

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account

Total economy

Liabilities - positions at the end of period

Rest of the world

Spain

1993-Q1

210011

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account

Total economy

Net positions at the end of period

Rest of the world

Spain

1993-Q1

-78491

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account; direct investment

Total economy

Assets - positions at the end of period

Rest of the world

Spain

1993-Q1

14003

Quarterly

Million euro

Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)

Financial account; direct investment

Total economy

Liabilities - positions at the end of period

Rest of the world

Spain

1993-Q1

61279

CREATE TABLE tidy ( "freq" VARCHAR, "unit" VARCHAR, "s_adj" VARCHAR, "bop_item" VARCHAR, "sector10" VARCHAR, "sectpart" VARCHAR, "stk_flow" VARCHAR, "partner" VARCHAR, "geo" VARCHAR, "time_period" VARCHAR, "value" DOUBLE );

International Investment Position - Quarterly Data

Table List

International Investment Position - Quarterly Data - Unpivoted

@eurostat.ei_bpm6iip_q.tidy

freq

unit

s_adj

bop_item

sector10

sectpart

stk_flow

partner

geo

time_period

value

Share link