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

Eurostat code: earn_ses_actrl · (2006 - 2006)

@eurostat.earn_ses_actrl

Table List

2 tables(9.96 KB)

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

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

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

@eurostat.earn_ses_actrl.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.26 KB
64 rows
6 columns

freq Freq	unit Unit	owner Owner	geo Geo	time_period Time Period	value Value
Annual	Euro	Private ownership	Austria	2006	34853
Annual	Euro	Private ownership	Belgium	2006	37259
Annual	Euro	Private ownership	Bulgaria	2006	2405
Annual	Euro	Private ownership	Cyprus	2006	21790
Annual	Euro	Private ownership	Czechia	2006	9822
Annual	Euro	Private ownership	Germany	2006	36865
Annual	Euro	Private ownership	Denmark	2006	44020
Annual	Euro	Private ownership	Euro area - 16 countries (2009-2010)	2006	31008
Annual	Euro	Private ownership	Estonia	2006	8301
Annual	Euro	Private ownership	Greece	2006	25314


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.