Baselight

Employment In Technology And Knowledge-intensive Sectors By NUTS 1 Region And Type Of Occupation (1994-2008, NACE Rev. 1.1)

Eurostat code: htec_emp_risco · (1999 - 2008)

@eurostat.htec_emp_risco

Employment In Technology And Knowledge-intensive Sectors By NUTS 1 Region And Type Of Occupation (1994-2008, NACE Rev. 1.1) - Unpivoted
@eurostat.htec_emp_risco.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.

  • 556.7 KB
  • 263938 rows
  • 7 columns
freq

Freq

nace_r1

Nace R1

unit

Unit

isco88

Isco88

geo

Geo

time_period

Time Period

value

Value

AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsCzechia19992.1
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsČesko19992.1
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsGermany19993.6
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsBayern19992
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsNiedersachsen19993.6
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsNordrhein-Westfalen19994.1
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsThüringen199910.7
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsSpain19990.9
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsNoroeste19990.9
AnnualAgriculture; fishing; mining and quarryingPercentage of total employmentProfessionalsSur19991

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

Share link

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