Dataset: International Investment Position Of The EU Institutions (BPM6)

About this Dataset

International Investment Position Of The EU Institutions (BPM6)

This Eurostat dataset contains data on international investment position of the eu institutions (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-05-28T23:00:00+0200

Tables

International Investment Position Of The EU Institutions (BPM6) - Raw

@eurostat.bop_euins6_iip.raw

503.72 KB
22179 rows
34 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "bop_item" VARCHAR,
  "sector10" VARCHAR,
  "sectpart" VARCHAR,
  "stk_flow" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

International Investment Position Of The EU Institutions (BPM6) - Unpivoted

@eurostat.bop_euins6_iip.tidy

546.51 KB
314071 rows
10 columns


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