Enterprises In NACE Rev.2 Sections B To G (except G45, G47) - Net Turnover From Selected Activities

Eurostat code: sbs_part_xrtvc · (2021 - 2022)

@eurostat.sbs_part_xrtvc

Table List

2 tables(94.43 KB)

Enterprises In NACE Rev.2 Sections B To G (except G45, G47) - Net Turnover From Selected Activities - Raw

Enterprises In NACE Rev.2 Sections B To G (except G45, G47) - Net Turnover From Selected Activities - Unpivoted

Enterprises In NACE Rev.2 Sections B To G (except G45, G47) - Net Turnover From Selected Activities - Unpivoted

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

47.74 KB
5979 rows
6 columns

freq Freq	nace_r2 Nace R2	indic_sbs Indic Sbs	geo Geo	time_period Time Period	value Value
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Austria	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Bosnia and Herzegovina	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Bulgaria	2021	5.43
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Denmark	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Greece	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Finland	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	France	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Croatia	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Ireland	2021
Annual	Mining of hard coal	Net turnover from the principal activity at the NACE three-digit level - million euro	Iceland	2021


CREATE TABLE tidy (
  "freq" VARCHAR,
  "nace_r2" VARCHAR,
  "indic_sbs" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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