Enterprise Statistics By Size Class And NACE Rev. 2 Activity (from 2021 Onwards)

Eurostat code: sbs_sc_ovw$dv_2302

@eurostat.sbs_sc_ovw_dv_2302

Table List

2 tables(56.97 KB)

Enterprise Statistics By Size Class And NACE Rev. 2 Activity (from 2021 Onwards) - Raw

Enterprise Statistics By Size Class And NACE Rev. 2 Activity (from 2021 Onwards) - Unpivoted

Enterprise Statistics By Size Class And NACE Rev. 2 Activity (from 2021 Onwards) - Unpivoted

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

27.92 KB
3679 rows
7 columns

freq Freq	indic_sbs Indic Sbs	nace_r2 Nace R2	size_emp Size Emp	geo Geo	time_period Time Period	value Value
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Albania	2021	5423.95
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Austria	2021	254152.56
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Bosnia and Herzegovina	2021	11227.99
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Belgium	2021	324985.75
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Bulgaria	2021	40806.56
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Switzerland	2021	457419.69
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Cyprus	2021	15509.29
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Czechia	2021	142268.32
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Germany	2021	2697838.4
Annual	Value added - million euro	Industry, construction and market services (except public administration and defence; compulsory social security; activities of membership organisations)	Total	Denmark	2021	191405.07


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

Share link

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