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

Eurostat code: namq_10_a10_e · (1980-Q1 - 2024-Q4)

@eurostat.namq_10_a10_e

Table List

2 tables(18.68 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.namq_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.

9.33 MB
3345665 rows
8 columns

freq Freq	unit Unit	nace_r2 Nace R2	s_adj S Adj	na_item Na Item	geo Geo	time_period Time Period	value Value
Quarterly	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total employment domestic concept	France	1980-Q1	269.6
Quarterly	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Employees domestic concept	France	1980-Q1	127.1
Quarterly	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Self-employed domestic concept	France	1980-Q1	328.2
Quarterly	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Seasonally and calendar adjusted data	Total employment domestic concept	France	1980-Q1	269.4
Quarterly	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Seasonally and calendar adjusted data	Employees domestic concept	France	1980-Q1	126.9
Quarterly	Index, 2015=100 (based on hours worked)	Agriculture, forestry and fishing	Seasonally and calendar adjusted data	Self-employed domestic concept	France	1980-Q1	328
Quarterly	Index, 2015=100 (based on hours worked)	Industry (except construction)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Total employment domestic concept	France	1980-Q1	197.1
Quarterly	Index, 2015=100 (based on hours worked)	Industry (except construction)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Employees domestic concept	France	1980-Q1	199.4
Quarterly	Index, 2015=100 (based on hours worked)	Industry (except construction)	Unadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)	Self-employed domestic concept	France	1980-Q1	174.9
Quarterly	Index, 2015=100 (based on hours worked)	Industry (except construction)	Seasonally and calendar adjusted data	Total employment domestic concept	France	1980-Q1	196.7


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

Share link

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