Number Of Employees, Hours Worked And Paid, By Working Time And NACE Rev. 2 Activity

Eurostat code: lc_nnum1_r2 · (2008 - 2020)

@eurostat.lc_nnum1_r2

Table List

2 tables(12.05 MB)

Number Of Employees, Hours Worked And Paid, By Working Time And NACE Rev. 2 Activity - Raw

Number Of Employees, Hours Worked And Paid, By Working Time And NACE Rev. 2 Activity - Unpivoted

Number Of Employees, Hours Worked And Paid, By Working Time And NACE Rev. 2 Activity - Raw

@eurostat.lc_nnum1_r2.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

6.09 MB
475569 rows
11 columns

freq Freq	sizeclas Sizeclas	worktime Worktime	indic_lc Indic Lc	nace_r2 Nace R2	unit Unit	geo Geo	n_2016 2016	n_2020 2020
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Belgium		967097
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Bulgaria
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Cyprus
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Denmark		718675
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Euro area - 17 countries (2011-2013)
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Euro area - 18 countries (2014)
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Greece
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	European Union - 15 countries (1995-2004)
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	Finland		1899253
Annual	From 10 to 49 employees	Full-time	Hours paid for employees per year	Mining and quarrying	Number	France	12948914	17859419


CREATE TABLE raw (
  "freq" VARCHAR,
  "sizeclas" VARCHAR,
  "worktime" VARCHAR,
  "indic_lc" VARCHAR,
  "nace_r2" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2008" DOUBLE,
  "n_2012" DOUBLE,
  "n_2016" DOUBLE,
  "n_2020" DOUBLE
);

Share link

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