Monthly Earnings By Economic Control (enterprises With 10 Employed Persons Or More) - NACE Rev. 1.1, C-O Excluding L

Eurostat code: earn_ses_mctrl · (2006 - 2006)

@eurostat.earn_ses_mctrl

Table List

2 tables(9.99 KB)

Monthly Earnings By Economic Control (enterprises With 10 Employed Persons Or More) - NACE Rev. 1.1, C-O Excluding L - Raw

Monthly Earnings By Economic Control (enterprises With 10 Employed Persons Or More) - NACE Rev. 1.1, C-O Excluding L - Unpivoted

Monthly Earnings By Economic Control (enterprises With 10 Employed Persons Or More) - NACE Rev. 1.1, C-O Excluding L - Unpivoted

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

5.28 KB
66 rows
6 columns

freq Freq	unit Unit	owner Owner	geo Geo	time_period Time Period	value Value
Annual	Euro	Private ownership	Austria	2006	2281
Annual	Euro	Private ownership	Belgium	2006	2640
Annual	Euro	Private ownership	Bulgaria	2006	188
Annual	Euro	Private ownership	Cyprus	2006	1635
Annual	Euro	Private ownership	Czechia	2006	731
Annual	Euro	Private ownership	Germany	2006	2709
Annual	Euro	Private ownership	Denmark	2006	3335
Annual	Euro	Private ownership	Euro area - 16 countries (2009-2010)	2006	2266
Annual	Euro	Private ownership	Estonia	2006	658
Annual	Euro	Private ownership	Greece	2006	1473


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

Share link

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