Annual Earnings By Economic Control - NACE Rev. 2, B-S Excluding O (2022)

Eurostat code: earn_ses22_actrl · (2022 - 2022)

@eurostat.earn_ses22_actrl

Table List

2 tables(10.16 KB)

Annual Earnings By Economic Control - NACE Rev. 2, B-S Excluding O (2022) - Raw

Annual Earnings By Economic Control - NACE Rev. 2, B-S Excluding O (2022) - Unpivoted

Annual Earnings By Economic Control - NACE Rev. 2, B-S Excluding O (2022) - Unpivoted

@eurostat.earn_ses22_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.37 KB
72 rows
6 columns

freq Freq	owner Owner	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Private ownership	Euro	Albania	2022	7097
Annual	Private ownership	Euro	Austria	2022	51775
Annual	Private ownership	Euro	Bosnia and Herzegovina	2022	10058
Annual	Private ownership	Euro	Belgium	2022	52186
Annual	Private ownership	Euro	Bulgaria	2022	12702
Annual	Private ownership	Euro	Switzerland	2022	94658
Annual	Private ownership	Euro	Cyprus	2022	27540
Annual	Private ownership	Euro	Czechia	2022	22034
Annual	Private ownership	Euro	Germany	2022	50150
Annual	Private ownership	Euro	Denmark	2022	67536


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

Share link

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