Baselight
Sign In

Enterprises, Employed Persons And Turnover By Innovation Profile, NACE Rev. 2 Activity And Size Class (2020)

Eurostat code: inn_cis12_pf_bas ยท (2020 - 2020)

@eurostat.inn_cis12_pf_bas

Enterprises, Employed Persons And Turnover By Innovation Profile, NACE Rev. 2 Activity And Size Class (2020) - Unpivoted
@eurostat.inn_cis12_pf_bas.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.

  • 113.85 KB
  • 26958 rows
  • 9 columns
freq

Freq

inn_pf

Inn Pf

indic_inn

Indic Inn

sizeclas

Sizeclas

nace_r2

Nace R2

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberAustria202018242
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberBelgium202025024
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberBulgaria202013426
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberCzechia202028354
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberGermany2020102534
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberEstonia20202692
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberGreece202022928
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberSpain202035315
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberFinland202013393
AnnualEnterprises that have developed product innovations themselves, with market novelties (profile I)Employed persons in 2020From 10 to 49 employeesIndustry (except construction)NumberCroatia20208676

CREATE TABLE tidy (
  "freq" VARCHAR,
  "inn_pf" VARCHAR,
  "indic_inn" 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.