Current Account - Quarterly Data

Eurostat code: ei_bpm6ca_q · (1991-Q1 - 2024-Q4)

@eurostat.ei_bpm6ca_q

Table List

2 tables(2.78 MB)

Current Account - Quarterly Data - Raw

Current Account - Quarterly Data - Unpivoted

Current Account - Quarterly Data - Raw

@eurostat.ei_bpm6ca_q.raw

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

1.61 MB
3439 rows
145 columns
Only the first 100 columns are shown

freq Freq	unit Unit	s_adj S Adj	sector10 Sector10	sectpart Sectpart	partner Partner	stk_flow Stk Flow	bop_item Bop Item	geo Geo	n_2013_q1 2013-Q1	n_2013_q2 2013-Q2	n_2013_q3 2013-Q3
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Current account	Euro area – 20 countries (from 2023)	14633.9	43762.9	52573.1
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Current plus capital account (balance = net lending (+) / net borrowing (-))	Euro area – 20 countries (from 2023)	15859.9	44816.7	57321.3
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Primary income: compensation of employees	Euro area – 20 countries (from 2023)	5668.3	5130.4	4696.9
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Primary income: other primary income	Euro area – 20 countries (from 2023)	8968.6	-10	-429.5
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Primary income: investment income; direct investment	Euro area – 20 countries (from 2023)	21404.9	29676.4	23877.3
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Primary income: investment income	Euro area – 20 countries (from 2023)	8509.4	-5736.4	12018.2
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Primary income: investment income; other investment	Euro area – 20 countries (from 2023)	866.9	1137.7	1074.5
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Primary income: investment income; portfolio investment	Euro area – 20 countries (from 2023)	-14347.2	-37157.1	-13546.2
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	Goods	Euro area – 20 countries (from 2023)	29587.6	47705.9	37912.8
Quarterly	Million euro	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total economy	Total economy	Extra-euro area - 20 countries (from 2023)	Balance	General merchandise on a balance of payments basis	Euro area – 20 countries (from 2023)	29768.7	47844.4	40492.5


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "partner" VARCHAR,
  "stk_flow" VARCHAR,
  "bop_item" VARCHAR,
  "geo" VARCHAR,
  "n_1991_q1" DOUBLE,
  "n_1991_q2" DOUBLE,
  "n_1991_q3" DOUBLE,
  "n_1991_q4" DOUBLE,
  "n_1992_q1" DOUBLE,
  "n_1992_q2" DOUBLE,
  "n_1992_q3" DOUBLE,
  "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
);