Name: European Union And Euro Area Balance Of Payments - Quarterly Data (BPM6)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

European Union And Euro Area Balance Of Payments - Quarterly Data (BPM6)

This Eurostat dataset contains data on european union and euro area balance of payments - quarterly data (bpm6), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-10-29T23:00:00+0100

Tables

European Union And Euro Area Balance Of Payments - Quarterly Data (BPM6) - Raw

@eurostat.bop_eu6_q.raw

5.08 MB
28,619 rows
141 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "s_adj" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "n_1999" DOUBLE  -- 1999,
  "n_1999_q1" DOUBLE  -- 1999-Q1,
  "n_1999_q2" DOUBLE  -- 1999-Q2,
  "n_1999_q3" DOUBLE  -- 1999-Q3,
  "n_1999_q4" DOUBLE  -- 1999-Q4,
  "n_2000" DOUBLE  -- 2000,
  "n_2000_q1" DOUBLE  -- 2000-Q1,
  "n_2000_q2" DOUBLE  -- 2000-Q2,
  "n_2000_q3" DOUBLE  -- 2000-Q3,
  "n_2000_q4" DOUBLE  -- 2000-Q4,
  "n_2001" DOUBLE  -- 2001,
  "n_2001_q1" DOUBLE  -- 2001-Q1,
  "n_2001_q2" DOUBLE  -- 2001-Q2,
  "n_2001_q3" DOUBLE  -- 2001-Q3,
  "n_2001_q4" DOUBLE  -- 2001-Q4,
  "n_2002" DOUBLE  -- 2002,
  "n_2002_q1" DOUBLE  -- 2002-Q1,
  "n_2002_q2" DOUBLE  -- 2002-Q2,
  "n_2002_q3" DOUBLE  -- 2002-Q3,
  "n_2002_q4" DOUBLE  -- 2002-Q4,
  "n_2003" DOUBLE  -- 2003,
  "n_2003_q1" DOUBLE  -- 2003-Q1,
  "n_2003_q2" DOUBLE  -- 2003-Q2,
  "n_2003_q3" DOUBLE  -- 2003-Q3,
  "n_2003_q4" DOUBLE  -- 2003-Q4,
  "n_2004" DOUBLE  -- 2004,
  "n_2004_q1" DOUBLE  -- 2004-Q1,
  "n_2004_q2" DOUBLE  -- 2004-Q2,
  "n_2004_q3" DOUBLE  -- 2004-Q3,
  "n_2004_q4" DOUBLE  -- 2004-Q4,
  "n_2005" DOUBLE  -- 2005,
  "n_2005_q1" DOUBLE  -- 2005-Q1,
  "n_2005_q2" DOUBLE  -- 2005-Q2,
  "n_2005_q3" DOUBLE  -- 2005-Q3,
  "n_2005_q4" DOUBLE  -- 2005-Q4,
  "n_2006" DOUBLE  -- 2006,
  "n_2006_q1" DOUBLE  -- 2006-Q1,
  "n_2006_q2" DOUBLE  -- 2006-Q2,
  "n_2006_q3" DOUBLE  -- 2006-Q3,
  "n_2006_q4" DOUBLE  -- 2006-Q4,
  "n_2007" DOUBLE  -- 2007,
  "n_2007_q1" DOUBLE  -- 2007-Q1,
  "n_2007_q2" DOUBLE  -- 2007-Q2,
  "n_2007_q3" DOUBLE  -- 2007-Q3,
  "n_2007_q4" DOUBLE  -- 2007-Q4,
  "n_2008" DOUBLE  -- 2008,
  "n_2008_q1" DOUBLE  -- 2008-Q1,
  "n_2008_q2" DOUBLE  -- 2008-Q2,
  "n_2008_q3" DOUBLE  -- 2008-Q3,
  "n_2008_q4" DOUBLE  -- 2008-Q4,
  "n_2009" DOUBLE  -- 2009,
  "n_2009_q1" DOUBLE  -- 2009-Q1,
  "n_2009_q2" DOUBLE  -- 2009-Q2,
  "n_2009_q3" DOUBLE  -- 2009-Q3,
  "n_2009_q4" DOUBLE  -- 2009-Q4,
  "n_2010" DOUBLE  -- 2010,
  "n_2010_q1" DOUBLE  -- 2010-Q1,
  "n_2010_q2" DOUBLE  -- 2010-Q2,
  "n_2010_q3" DOUBLE  -- 2010-Q3,
  "n_2010_q4" DOUBLE  -- 2010-Q4,
  "n_2011" DOUBLE  -- 2011,
  "n_2011_q1" DOUBLE  -- 2011-Q1,
  "n_2011_q2" DOUBLE  -- 2011-Q2,
  "n_2011_q3" DOUBLE  -- 2011-Q3,
  "n_2011_q4" DOUBLE  -- 2011-Q4,
  "n_2012" DOUBLE  -- 2012,
  "n_2012_q1" DOUBLE  -- 2012-Q1,
  "n_2012_q2" DOUBLE  -- 2012-Q2,
  "n_2012_q3" DOUBLE  -- 2012-Q3,
  "n_2012_q4" DOUBLE  -- 2012-Q4,
  "n_2013" DOUBLE  -- 2013,
  "n_2013_q1" DOUBLE  -- 2013-Q1,
  "n_2013_q2" DOUBLE  -- 2013-Q2,
  "n_2013_q3" DOUBLE  -- 2013-Q3,
  "n_2013_q4" DOUBLE  -- 2013-Q4,
  "n_2014" DOUBLE  -- 2014,
  "n_2014_q1" DOUBLE  -- 2014-Q1,
  "n_2014_q2" DOUBLE  -- 2014-Q2,
  "n_2014_q3" DOUBLE  -- 2014-Q3,
  "n_2014_q4" DOUBLE  -- 2014-Q4,
  "n_2015" DOUBLE  -- 2015,
  "n_2015_q1" DOUBLE  -- 2015-Q1,
  "n_2015_q2" DOUBLE  -- 2015-Q2,
  "n_2015_q3" DOUBLE  -- 2015-Q3,
  "n_2015_q4" DOUBLE  -- 2015-Q4,
  "n_2016" DOUBLE  -- 2016,
  "n_2016_q1" DOUBLE  -- 2016-Q1,
  "n_2016_q2" DOUBLE  -- 2016-Q2,
  "n_2016_q3" DOUBLE  -- 2016-Q3,
  "n_2016_q4" DOUBLE  -- 2016-Q4,
  "n_2017" DOUBLE  -- 2017
);

European Union And Euro Area Balance Of Payments - Quarterly Data (BPM6) - Unpivoted

@eurostat.bop_eu6_q.tidy

4.53 MB
861,528 rows
11 columns

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