EU Direct Investment Positions, By Country And Economic Activity (NACE Rev. 2)

Eurostat code: bop_fdi_pos_r2 · (2008 - 2012)

@eurostat.bop_fdi_pos_r2

Table List

2 tables(5.18 MB)

EU Direct Investment Positions, By Country And Economic Activity (NACE Rev. 2) - Raw

EU Direct Investment Positions, By Country And Economic Activity (NACE Rev. 2) - Unpivoted

EU Direct Investment Positions, By Country And Economic Activity (NACE Rev. 2) - Unpivoted

@eurostat.bop_fdi_pos_r2.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

2.91 MB
1841074 rows
8 columns

freq Freq	currency Currency	post Post	nace_r2 Nace R2	partner Partner	geo Geo	time_period Time Period
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	African, Caribbean and Pacific Group of States, signatories of the Partnership Agreement	Malta	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	African, Caribbean and Pacific Group of States, signatories of the Partnership Agreement	Slovakia	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	African ACP states	Malta	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	African ACP states	Slovakia	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	Caribbean ACP states	Malta	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	Caribbean ACP states	Slovakia	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	Pacific ACP states	Malta	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	Pacific ACP states	Slovakia	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	Andorra	Malta	2008
Annual	Million euro	Financial account, direct investment, abroad	Agriculture, forestry and fishing	Andorra	Slovakia	2008


CREATE TABLE tidy (
  "freq" VARCHAR,
  "currency" VARCHAR,
  "post" VARCHAR,
  "nace_r2" VARCHAR,
  "partner" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.