Employment In Technology And Knowledge-intensive Sectors At The National Level, By Sex (from 2008 Onwards, NACE Rev. 2)

Eurostat code: htec_emp_nat2$dv_1870

@eurostat.htec_emp_nat2_dv_1870

Table List

2 tables(94.24 KB)

Employment In Technology And Knowledge-intensive Sectors At The National Level, By Sex (from 2008 Onwards, NACE Rev. 2) - Raw

Employment In Technology And Knowledge-intensive Sectors At The National Level, By Sex (from 2008 Onwards, NACE Rev. 2) - Unpivoted

Employment In Technology And Knowledge-intensive Sectors At The National Level, By Sex (from 2008 Onwards, NACE Rev. 2) - Unpivoted

@eurostat.htec_emp_nat2_dv_1870.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.

40.29 KB
10748 rows
7 columns

freq Freq	sex Sex	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Austria	2015	4.2
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Belgium	2015	0.7
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Bulgaria	2015	4.6
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Switzerland	2015	2.7
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Cyprus	2015	2.3
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Czechia	2015	1.8
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Germany	2015	1
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Denmark	2015	1.1
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Euro area – 20 countries (from 2023)	2015	2.2
Annual	Females	Agriculture, forestry and fishing; mining and quarrying	Percentage of total employment	Estonia	2015	2.7


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