Baselight
Sign In

Turnover Of Enterprises From New Or Significantly Improved Products, By NACE Rev. 2 Activity And Size Class (2018)

Eurostat code: inn_cis11_prodt ยท (2018 - 2018)

@eurostat.inn_cis11_prodt

Turnover Of Enterprises From New Or Significantly Improved Products, By NACE Rev. 2 Activity And Size Class (2018) - Unpivoted
@eurostat.inn_cis11_prodt.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.

  • 93.65 KB
  • 17628 rows
  • 8 columns
freq

Freq

innovat

Innovat

sizeclas

Sizeclas

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageBelgium20180.1
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageCzechia201816.5
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageGermany20180.4
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageDenmark20180.4
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageEstonia201811.3
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageGreece201813.1
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageSpain20180.6
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageCroatia20183.7
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageHungary20181.1
AnnualNew or significantly improved productsFrom 10 to 49 employeesMining and quarryingPercentageIreland2018

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

Share link

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