Name: Control Of Foreign Affiliates And Estimated Employment By Business Function, Country Location Of Affiliates And Economic Activity - Experimental Statistics
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Control Of Foreign Affiliates And Estimated Employment By Business Function, Country Location Of Affiliates And Economic Activity - Experimental Statistics

This Eurostat dataset contains data on control of foreign affiliates and estimated employment by business function, country location of affiliates and economic activity - experimental statistics, 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: 2013-09-23T23:00:00+0200

Tables

Control Of Foreign Affiliates And Estimated Employment By Business Function, Country Location Of Affiliates And Economic Activity - Experimental Statistics - Raw

@eurostat.iss_11aestemp.raw

34.92 KB
18610 rows
8 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_sb" VARCHAR,
  "bus_func" VARCHAR,
  "partner" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "n_2011" DOUBLE
);

Control Of Foreign Affiliates And Estimated Employment By Business Function, Country Location Of Affiliates And Economic Activity - Experimental Statistics - Unpivoted

@eurostat.iss_11aestemp.tidy

35.67 KB
14867 rows
9 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "indic_sb" VARCHAR,
  "bus_func" VARCHAR,
  "partner" VARCHAR,
  "nace_r2" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);