Employment By NACE Rev. 2 Activity And Metropolitan Typology

Eurostat code: met_10r_3emp · (1995 - 2022)

@eurostat.met_10r_3emp

Table List

2 tables(1.46 MB)

Employment By NACE Rev. 2 Activity And Metropolitan Typology - Raw

Employment By NACE Rev. 2 Activity And Metropolitan Typology - Unpivoted

Employment By NACE Rev. 2 Activity And Metropolitan Typology - Unpivoted

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

624.44 KB
171018 rows
7 columns

freq Freq	unit Unit	wstatus Wstatus	nace_r2 Nace R2	metroreg Metroreg	time_period Time Period	value Value
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Czechia	1995	270.46
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Praha	1995	39.15
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Brno	1995	27.37
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Ostrava	1995	19.15
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Plzen	1995	21.33
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Non-metropolitan regions in Czech Republic	1995	163.45
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Estonia	1995	64.9
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Tallinn	1995	8.4
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Non-metropolitan regions in Estonia	1995	56.5
Annual	Thousand	Employed persons	Agriculture, forestry and fishing	Italy	1995	1264.6


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

Share link

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