International Investment Position - Quarterly Data

Eurostat code: ei_bpm6iip_q · (1992-Q4 - 2024-Q4)

@eurostat.ei_bpm6iip_q

Table List

2 tables(951.12 KB)

International Investment Position - Quarterly Data - Raw

International Investment Position - Quarterly Data - Unpivoted

International Investment Position - Quarterly Data - Raw

@eurostat.ei_bpm6iip_q.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

521.97 KB
757 rows
138 columns
Only the first 100 columns are shown

freq Freq	unit Unit	s_adj S Adj	bop_item Bop Item	sector10 Sector10	sectpart Sectpart	stk_flow Stk Flow	partner Partner	geo Geo	n_1993_q4 1993-Q4	n_1994_q4 1994-Q4	n_1995_q4 1995-Q4	n_1996_q4 1996-Q4	n_1997_q4 1997-Q4	n_1998_q4 1998-Q4	n_1999_q1 1999-Q1	n_1999_q2 1999-Q2	n_1999_q3 1999-Q3	n_1999_q4 1999-Q4	n_2000_q1 2000-Q1	n_2000_q2 2000-Q2	n_2000_q3 2000-Q3	n_2000_q4 2000-Q4	n_2001_q1 2001-Q1	n_2001_q2 2001-Q2	n_2001_q3 2001-Q3	n_2001_q4 2001-Q4	n_2002_q1 2002-Q1	n_2002_q2 2002-Q2	n_2002_q3 2002-Q3	n_2002_q4 2002-Q4	n_2003_q1 2003-Q1	n_2003_q2 2003-Q2	n_2003_q3 2003-Q3	n_2003_q4 2003-Q4	n_2004_q1 2004-Q1	n_2004_q2 2004-Q2	n_2004_q3 2004-Q3	n_2004_q4 2004-Q4	n_2005_q1 2005-Q1	n_2005_q2 2005-Q2	n_2005_q3 2005-Q3	n_2005_q4 2005-Q4	n_2006_q1 2006-Q1	n_2006_q2 2006-Q2	n_2006_q3 2006-Q3	n_2006_q4 2006-Q4	n_2007_q1 2007-Q1	n_2007_q2 2007-Q2	n_2007_q3 2007-Q3	n_2007_q4 2007-Q4	n_2008_q1 2008-Q1	n_2008_q2 2008-Q2	n_2008_q3 2008-Q3	n_2008_q4 2008-Q4	n_2009_q1 2009-Q1	n_2009_q2 2009-Q2	n_2009_q3 2009-Q3	n_2009_q4 2009-Q4	n_2010_q1 2010-Q1	n_2010_q2 2010-Q2	n_2010_q3 2010-Q3	n_2010_q4 2010-Q4	n_2011_q1 2011-Q1	n_2011_q2 2011-Q2	n_2011_q3 2011-Q3	n_2011_q4 2011-Q4	n_2012_q1 2012-Q1	n_2012_q2 2012-Q2	n_2012_q3 2012-Q3	n_2012_q4 2012-Q4	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3	n_2013_q4 2013-Q4	n_2014_q1 2014-Q1	n_2014_q2 2014-Q2	n_2014_q3 2014-Q3	n_2014_q4 2014-Q4	n_2015_q1 2015-Q1	n_2015_q2 2015-Q2
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	Extra-euro area - 20 countries (from 2023)	Euro area – 20 countries (from 2023)																																																															20996730	20498014.2	20379127.2	20351626.6	20827526.2	21483264.2	22605608.7	24009690.5	26757562.6	25856124.1
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	Albania																																																																							5935.7	5950.5
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	Austria							206400	213859	227147	234497	249342	261310	285519	289395	298206	306163	301674	314588	328743	319729	323961	331889	344481	358507	362921	362082	390202	400483	414823	416953	509787	549861	565288	577934	628984	636227	644984	678336	716214	760884	762519	771881	788776	815047	814537	783802	782610	784842	801186	796706	836184	860067	851855	807162	836001	838009	835211	840803	857918	859859	866596	862966	883166	875395	875362	868187	872337	890242	889334	894560	942425	914467
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	Bosnia and Herzegovina																																							5226.5	6164.7	5887.3	6605.4	6370.2	6272.6	6485.2	6524.8	6267.5	6015.6	6517.7	6401.9	6518.1	6389.5	6377.5	6260.7	6045.9	5994.3	6161.3	6117	6078	6119.7	6254.9	6299.5	6211.1	6454.1	6631.2	6885.3	6763.4	6863	7199.6	7149.5	6927.7	7013.2
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	Belgium																															1218409.1	1259397.9	1295900.5	1342263.5	1382114.9	1347873.5	1380767.9	1462020.6	1550457.4	1635307.8	1613910.6	1689026.7	1855695	1892532	1970591	1855626	1827598	1824177	1837098	1887784	1890485	1962743	1930071	1945061	1912586	1919360	1995020	2022528	2036648	2068943	2088837	2009675	2050682	1996307	2027640	1929074	1950015	1975871	2004433	2040138	2226475	2129547
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	Bulgaria														9696.4	10013.6	10307.8	9826.2	10565.8	10200.5	9349.1	9928.1	9836.6	9309.2	9214.7	9566.2	9609.2	10132.3	11075.4	11181.5	12611.8	12312	13179.4	13333.5	13559.9	14031.8	14990	16485.6	17795.9	17589.7	18202.4	20317.2	20529.9	20143.4	22253.4	23610	21904.4	21415.6	21616.6	22571.7	23394.7	23157.4	23295.9	24025.8	25118.6	24862.8	25553.5	27109.1	26787.6	27700.4	28202	29732.5	30294	30452.6	30286	31085.7	31000.8	32022.7	32317.4	34708.8	36140.7	38967.8	37932.2
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	Switzerland											1345305.1	1338398.6	1447960.4	1458108.4	1500559.2	1537465.5	1424216.5	1496639.8	1554244.7	1464201.6	1426920.8	1456505.8	1433150.5	1428098.4	1426673.2	1415041.5	1495643.6	1530159.7	1493874.9	1501042.6	1567057.9	1682735.1	1763670.4	1800335	1914173.5	1919573.5	1978162.9	1945027.8	2166805.3	2191019.5	2189260.6	2264204.9	2268570.2	2163380	2237681	2187588.9	2188586.1	2228190.3	2244265.9	2301325.8	2436848.2	2654977.9	2642387.8	2777125.6	2687914.4	2813418.6	2936085	2963126.9	2981064.4	3114524.3	3199346.9	3193908.5	3230994.4	3154462	3185171.3	3178345.5	3200358.2	3240708.2	3346645.3	3508673.5	3950313.8	3907082.2
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	Cyprus																											108726	112065	115243	118963	123393	127071	131743	138026	143831	148786	157822	164034	169806	178540	185020	191403	220023.6	220431.1	230708	242605.5	254780.4	300877.5	300014.1	298960.7	309394.7	333574.4	307062.5	312142.6	319174.1	325903.5	338483.9	336844.2	374582.1	382037.8	388829.5	388045.7	379640.3	380463.6	383280.4	389879.3	402753.1	413637.4	433047.8	447779.4	465990.6	474483.6
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	Czechia	16017.9	16744.9	22378.5	24444.3	27123.2	30900.4				37336.4	37849.4	39253.5	41165.7	41327.4	43267.6	45666.3	44856	48337.5	45409.2	50336.6	50387.7	50034	49382.4	49241.8	48994.7	47432.4	52076.5	54817.4	54980.4	55878.6	59787.5	67526.4	69030.7	71275.4	71824.8	72388	72991.8	77390.6	77021.3	79824.4	80991	88239.9	94695.8	104381.1	103517.8	97683.3	96251.8	97694.7	99400.3	99884.4	104705.5	110300.7	113850.3	113206.8	112440.2	113282.5	114605.4	115380.5	122532.8	120947.2	122926.7	126807.8	129045.1	128729.4	131951.8	136247.2	142429.1	145235.1	148542.1	149826.6	161092.4	162588
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	Germany										2506687				2925611				3227559				3191363				3367103	3495613	3498969	3590105	3641455	3851907	4053564	4168414	4251510	4440727	4474300	4609940	4742380	4926487	5106039	5193556	5214550	5259997	5277137	5380043	5099016	5055510	5165809	5194569	5243721	5422066	5652289	5661349	6540517	6366449	6398731	6914889	6849408	7089271	7345683	7405798	7299763	7266384	7077668	7024881	6943122	7048919	7259486	7515183	7658350	8301303	7917874


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "n_1992_q4" DOUBLE,
  "n_1993_q1" DOUBLE,
  "n_1993_q2" DOUBLE,
  "n_1993_q3" DOUBLE,
  "n_1993_q4" DOUBLE,
  "n_1994_q1" DOUBLE,
  "n_1994_q2" DOUBLE,
  "n_1994_q3" DOUBLE,
  "n_1994_q4" DOUBLE,
  "n_1995_q1" DOUBLE,
  "n_1995_q2" DOUBLE,
  "n_1995_q3" DOUBLE,
  "n_1995_q4" DOUBLE,
  "n_1996_q1" DOUBLE,
  "n_1996_q2" DOUBLE,
  "n_1996_q3" DOUBLE,
  "n_1996_q4" DOUBLE,
  "n_1997_q1" DOUBLE,
  "n_1997_q2" DOUBLE,
  "n_1997_q3" DOUBLE,
  "n_1997_q4" DOUBLE,
  "n_1998_q1" DOUBLE,
  "n_1998_q2" DOUBLE,
  "n_1998_q3" DOUBLE,
  "n_1998_q4" DOUBLE,
  "n_1999_q1" DOUBLE,
  "n_1999_q2" DOUBLE,
  "n_1999_q3" DOUBLE,
  "n_1999_q4" DOUBLE,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE,
  "n_2004_q4" DOUBLE,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE,
  "n_2009_q1" DOUBLE,
  "n_2009_q2" DOUBLE,
  "n_2009_q3" DOUBLE,
  "n_2009_q4" DOUBLE,
  "n_2010_q1" DOUBLE,
  "n_2010_q2" DOUBLE,
  "n_2010_q3" DOUBLE,
  "n_2010_q4" DOUBLE,
  "n_2011_q1" DOUBLE,
  "n_2011_q2" DOUBLE,
  "n_2011_q3" DOUBLE,
  "n_2011_q4" DOUBLE,
  "n_2012_q1" DOUBLE,
  "n_2012_q2" DOUBLE,
  "n_2012_q3" DOUBLE,
  "n_2012_q4" DOUBLE,
  "n_2013_q1" DOUBLE,
  "n_2013_q2" DOUBLE,
  "n_2013_q3" DOUBLE,
  "n_2013_q4" DOUBLE,
  "n_2014_q1" DOUBLE,
  "n_2014_q2" DOUBLE,
  "n_2014_q3" DOUBLE,
  "n_2014_q4" DOUBLE,
  "n_2015_q1" DOUBLE,
  "n_2015_q2" DOUBLE
);