Baselight

Innovation Activity And Expenditure (2000)

Eurostat code: inn_exp ยท (2000 - 2000)

@eurostat.inn_exp

Innovation Activity And Expenditure (2000) - Unpivoted
@eurostat.inn_exp.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.

  • 653.51 KB
  • 123424 rows
  • 9 columns
freq

Freq

indic_in

Indic In

nace_r1

Nace R1

sizeclas

Sizeclas

unit

Unit

type_inn

Type Inn

geo

Geo

time_period

Time Period

value

Value

AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 249 employeesNumberProduct and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities)France20002077.3024
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 249 employeesNumberProduct and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities)Norway200026219.1382
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 249 employeesNumberProcess innovative enterprises onlyDenmark2000
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 249 employeesNumberProcess innovative enterprises onlySpain20004032.4332
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 249 employeesNumberProcess innovative enterprises onlyIceland2000
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 249 employeesNumberProduct innovative enterprises onlyNorway200012264.8882
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 49 employeesNumberProduct and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities)Netherlands20007712.9892
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 49 employeesNumberProduct and/or process innovative enterprises, regardless of organisational or marketing innovation (including enterprises with abandoned/suspended or on-going innovation activities)Norway200025927.8397
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 49 employeesNumberEnterprises with abandoned/suspended and on-going innovation activities onlyPortugal2000
AnnualTotal innovation expenditure, per employee 2000Mining and quarryingFrom 10 to 49 employeesNumberProcess innovative enterprises onlyBelgium2000

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

Share link

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