Name: Innovative Enterprises Whose Innovation Activities Have Been Affected, Or Not Affected, By Legislation Or Regulations, By Type Of Effect, NACE Rev.2 Activity And Size Class (2016)
Creator: Eurostat
License: https://ec.europa.eu/eurostat/statistics-explained/index.php?title=Copyright/licence_policy

About this Dataset

Innovative Enterprises Whose Innovation Activities Have Been Affected, Or Not Affected, By Legislation Or Regulations, By Type Of Effect, NACE Rev.2 Activity And Size Class (2016)

This Eurostat dataset contains data on innovative enterprises whose innovation activities have been affected, or not affected, by legislation or regulations, by type of effect, nace rev.2 activity and size class (2016), 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: 2019-02-12T23:00:00+0100

Tables

Innovative Enterprises Whose Innovation Activities Have Been Affected, Or Not Affected, By Legislation Or Regulations, By Type Of Effect, NACE Rev.2 Activity And Size Class (2016) - Raw

@eurostat.inn_cis10_legis.raw

63.16 KB
37276 rows
8 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "effect" VARCHAR,
  "yes_no" VARCHAR,
  "sizeclas" VARCHAR,
  "nace_r2" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2016" DOUBLE
);

Innovative Enterprises Whose Innovation Activities Have Been Affected, Or Not Affected, By Legislation Or Regulations, By Type Of Effect, NACE Rev.2 Activity And Size Class (2016) - Unpivoted

@eurostat.inn_cis10_legis.tidy

60.07 KB
23043 rows
9 columns


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