Name: European Union And Euro Area Balance Of Payments - Monthly 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 - Monthly Data (BPM6)

This Eurostat dataset contains data on european union and euro area balance of payments - monthly 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-20T23:00:00+0200

Tables

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

@eurostat.bop_eu6_m.raw

799.29 kB
573 rows
329 columns

CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "s_adj" VARCHAR,
  "sectpart" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "n_1999_01" DOUBLE  -- 1999-01,
  "n_1999_02" DOUBLE  -- 1999-02,
  "n_1999_03" DOUBLE  -- 1999-03,
  "n_1999_04" DOUBLE  -- 1999-04,
  "n_1999_05" DOUBLE  -- 1999-05,
  "n_1999_06" DOUBLE  -- 1999-06,
  "n_1999_07" DOUBLE  -- 1999-07,
  "n_1999_08" DOUBLE  -- 1999-08,
  "n_1999_09" DOUBLE  -- 1999-09,
  "n_1999_10" DOUBLE  -- 1999-10,
  "n_1999_11" DOUBLE  -- 1999-11,
  "n_1999_12" DOUBLE  -- 1999-12,
  "n_2000_01" DOUBLE  -- 2000-01,
  "n_2000_02" DOUBLE  -- 2000-02,
  "n_2000_03" DOUBLE  -- 2000-03,
  "n_2000_04" DOUBLE  -- 2000-04,
  "n_2000_05" DOUBLE  -- 2000-05,
  "n_2000_06" DOUBLE  -- 2000-06,
  "n_2000_07" DOUBLE  -- 2000-07,
  "n_2000_08" DOUBLE  -- 2000-08,
  "n_2000_09" DOUBLE  -- 2000-09,
  "n_2000_10" DOUBLE  -- 2000-10,
  "n_2000_11" DOUBLE  -- 2000-11,
  "n_2000_12" DOUBLE  -- 2000-12,
  "n_2001_01" DOUBLE  -- 2001-01,
  "n_2001_02" DOUBLE  -- 2001-02,
  "n_2001_03" DOUBLE  -- 2001-03,
  "n_2001_04" DOUBLE  -- 2001-04,
  "n_2001_05" DOUBLE  -- 2001-05,
  "n_2001_06" DOUBLE  -- 2001-06,
  "n_2001_07" DOUBLE  -- 2001-07,
  "n_2001_08" DOUBLE  -- 2001-08,
  "n_2001_09" DOUBLE  -- 2001-09,
  "n_2001_10" DOUBLE  -- 2001-10,
  "n_2001_11" DOUBLE  -- 2001-11,
  "n_2001_12" DOUBLE  -- 2001-12,
  "n_2002_01" DOUBLE  -- 2002-01,
  "n_2002_02" DOUBLE  -- 2002-02,
  "n_2002_03" DOUBLE  -- 2002-03,
  "n_2002_04" DOUBLE  -- 2002-04,
  "n_2002_05" DOUBLE  -- 2002-05,
  "n_2002_06" DOUBLE  -- 2002-06,
  "n_2002_07" DOUBLE  -- 2002-07,
  "n_2002_08" DOUBLE  -- 2002-08,
  "n_2002_09" DOUBLE  -- 2002-09,
  "n_2002_10" DOUBLE  -- 2002-10,
  "n_2002_11" DOUBLE  -- 2002-11,
  "n_2002_12" DOUBLE  -- 2002-12,
  "n_2003_01" DOUBLE  -- 2003-01,
  "n_2003_02" DOUBLE  -- 2003-02,
  "n_2003_03" DOUBLE  -- 2003-03,
  "n_2003_04" DOUBLE  -- 2003-04,
  "n_2003_05" DOUBLE  -- 2003-05,
  "n_2003_06" DOUBLE  -- 2003-06,
  "n_2003_07" DOUBLE  -- 2003-07,
  "n_2003_08" DOUBLE  -- 2003-08,
  "n_2003_09" DOUBLE  -- 2003-09,
  "n_2003_10" DOUBLE  -- 2003-10,
  "n_2003_11" DOUBLE  -- 2003-11,
  "n_2003_12" DOUBLE  -- 2003-12,
  "n_2004_01" DOUBLE  -- 2004-01,
  "n_2004_02" DOUBLE  -- 2004-02,
  "n_2004_03" DOUBLE  -- 2004-03,
  "n_2004_04" DOUBLE  -- 2004-04,
  "n_2004_05" DOUBLE  -- 2004-05,
  "n_2004_06" DOUBLE  -- 2004-06,
  "n_2004_07" DOUBLE  -- 2004-07,
  "n_2004_08" DOUBLE  -- 2004-08,
  "n_2004_09" DOUBLE  -- 2004-09,
  "n_2004_10" DOUBLE  -- 2004-10,
  "n_2004_11" DOUBLE  -- 2004-11,
  "n_2004_12" DOUBLE  -- 2004-12,
  "n_2005_01" DOUBLE  -- 2005-01,
  "n_2005_02" DOUBLE  -- 2005-02,
  "n_2005_03" DOUBLE  -- 2005-03,
  "n_2005_04" DOUBLE  -- 2005-04,
  "n_2005_05" DOUBLE  -- 2005-05,
  "n_2005_06" DOUBLE  -- 2005-06,
  "n_2005_07" DOUBLE  -- 2005-07,
  "n_2005_08" DOUBLE  -- 2005-08,
  "n_2005_09" DOUBLE  -- 2005-09,
  "n_2005_10" DOUBLE  -- 2005-10,
  "n_2005_11" DOUBLE  -- 2005-11,
  "n_2005_12" DOUBLE  -- 2005-12,
  "n_2006_01" DOUBLE  -- 2006-01,
  "n_2006_02" DOUBLE  -- 2006-02,
  "n_2006_03" DOUBLE  -- 2006-03,
  "n_2006_04" DOUBLE  -- 2006-04,
  "n_2006_05" DOUBLE  -- 2006-05,
  "n_2006_06" DOUBLE  -- 2006-06,
  "n_2006_07" DOUBLE  -- 2006-07
);

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

@eurostat.bop_eu6_m.tidy

573.81 kB
84,434 rows
11 columns

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