Baselight
Sign In

Enterprises' Expenditure By Area, Innovations Status, NACE Rev. 2 Activity And Size Class (CIS2022)

Eurostat code: inn_cis13_expt ยท (2022 - 2022)

@eurostat.inn_cis13_expt

Enterprises' Expenditure By Area, Innovations Status, NACE Rev. 2 Activity And Size Class (CIS2022) - Unpivoted
@eurostat.inn_cis13_expt.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.

  • 130.06 KB
  • 31754 rows
  • 9 columns
freq

Freq

unit

Unit

expend

Expend

enterpr

Enterpr

sizeclas

Sizeclas

nace_r2

Nace R2

geo

Geo

time_period

Time Period

value

Value

AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesMining and quarryingGermany202241.1
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesMining and quarryingGreece202251.5
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesMining and quarryingHungary20229.6
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesMining and quarryingMalta20226.7
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesMining and quarryingPoland202225.9
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesIndustry (except construction)Germany202270
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesIndustry (except construction)Greece202277.3
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesIndustry (except construction)Spain202247
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesIndustry (except construction)Croatia202234.2
AnnualPercentageAcquisition of machinery, equipment, buildings and other tangible assetsInnovation active enterprisesFrom 10 to 49 employeesIndustry (except construction)Hungary202223.2

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

Share link

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