Baselight

Employed HRST By Category, NACE Rev. 1.1 Activity And NUTS 1 Region (1994 - 2007)

Eurostat code: hrst_st_rsec · (1999 - 2008)

@eurostat.hrst_st_rsec

Employed HRST By Category, NACE Rev. 1.1 Activity And NUTS 1 Region (1994 - 2007) - Unpivoted
@eurostat.hrst_st_rsec.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.

  • 681.47 KB
  • 320056 rows
  • 7 columns
freq

Freq

category

Category

nace_r1

Nace R1

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentAustria19991.5
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentOstösterreich19991.4
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentWestösterreich19991.5
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentBelgium19990.6
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentVlaams Gewest19990.5
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentSwitzerland19991.8
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentSchweiz/Suisse/Svizzera19991.8
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentCyprus19990.7
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentKýpros19990.7
AnnualPersons with tertiary education (ISCED) and/or employed in science and technologyAgriculture; fishing; mining and quarryingPercentage of total employmentCzechia19993.3

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