Baselight

Annual Data On Employment In Knowledge-intensive Activities At The National Level, By Sex And NACE Rev. 1.1 (2000-2008),

Eurostat code: htec_kia_emp ยท (2000 - 2008)

@eurostat.htec_kia_emp

Annual Data On Employment In Knowledge-intensive Activities At The National Level, By Sex And NACE Rev. 1.1 (2000-2008), - Unpivoted
@eurostat.htec_kia_emp.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.

  • 20.1 KB
  • 3444 rows
  • 7 columns
freq

Freq

sex

Sex

nace_r1

Nace R1

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentAustria200045
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentBelgium200062.4
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentBulgaria200036.5
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentSwitzerland200053.2
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentCyprus200042.6
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentCzechia200042.2
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentGermany200051.9
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentDenmark200063
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentEstonia200042.1
AnnualFemalesTotal knowledge-intensive activitiesPercentage of total employmentGreece200037.1

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

Share link

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