Employment By Main Industry (NACE Rev.2) - National Accounts

Eurostat code: nama_10_a10_e · (1975 - 2024)

@eurostat.nama_10_a10_e

Table List

2 tables(2.36 MB)

Employment By Main Industry (NACE Rev.2) - National Accounts - Raw

Employment By Main Industry (NACE Rev.2) - National Accounts - Unpivoted

Employment By Main Industry (NACE Rev.2) - National Accounts - Unpivoted

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

1.11 MB
369587 rows
7 columns

freq Freq	unit Unit	nace_r2 Nace R2	na_item Na Item	geo Geo	time_period Time Period	value Value
Annual	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Total employment domestic concept	Denmark	1975	407.8
Annual	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Total employment domestic concept	Norway	1975	311.2
Annual	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Employees domestic concept	Denmark	1975	229.1
Annual	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Employees domestic concept	Norway	1975	144.7
Annual	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Self-employed domestic concept	Denmark	1975	599.5
Annual	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Self-employed domestic concept	Norway	1975	392.3
Annual	Index, 2015=100 (based on hours worked)	Industry (except construction)	Total employment domestic concept	Denmark	1975	173.6
Annual	Index, 2015=100 (based on hours worked)	Industry (except construction)	Total employment domestic concept	Norway	1975	132.4
Annual	Index, 2015=100 (based on hours worked)	Industry (except construction)	Employees domestic concept	Denmark	1975	166.5
Annual	Index, 2015=100 (based on hours worked)	Industry (except construction)	Employees domestic concept	Norway	1975	129.6


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

Share link

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