Name: General Information About The Enterprises (2008)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

General Information About The Enterprises (2008)

This Eurostat dataset contains data on general information about the enterprises (2008), 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: 2010-11-03T23:00:00+0100

Tables

General Information About The Enterprises (2008) - Raw

@eurostat.inn_cis6_gen.raw

372.15 KB
202821 rows
8 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_in" VARCHAR,
  "nace_r2" VARCHAR,
  "sizeclas" VARCHAR,
  "unit" VARCHAR,
  "type_inn" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE
);

General Information About The Enterprises (2008) - Unpivoted

@eurostat.inn_cis6_gen.tidy

362.93 KB
139254 rows
9 columns


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_in" VARCHAR,
  "nace_r2" VARCHAR,
  "sizeclas" VARCHAR,
  "unit" VARCHAR,
  "type_inn" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);