Employment By NACE Rev. 2 Activity And Other Typologies

Eurostat code: urt_10r_3emp · (1995 - 2022)

@eurostat.urt_10r_3emp

Table List

2 tables(2.02 MB)

Employment By NACE Rev. 2 Activity And Other Typologies - Raw

Employment By NACE Rev. 2 Activity And Other Typologies - Unpivoted

Employment By NACE Rev. 2 Activity And Other Typologies - Unpivoted

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

918.26 KB
214648 rows
8 columns

freq Freq	unit Unit	wstatus Wstatus	nace_r2 Nace R2	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Border regions	Czechia	1995	203.57
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Border regions	Estonia	1995	41.8
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Border regions	Luxembourg	1995	5.7
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Border regions	Portugal	1995	244.44
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Coastal regions	Estonia	1995	42.2
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Coastal regions	Portugal	1995	435.07
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Intermediate regions	Czechia	1995	132.14
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Intermediate regions	Luxembourg	1995	5.7
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Intermediate regions	Portugal	1995	138.72
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Intermediate regions - close to city	Czechia	1995	132.14


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "wstatus" VARCHAR,
  "nace_r2" VARCHAR,
  "terrtypo" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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