Enterprises In High-tech Sectors By NACE Rev.2 Activity

Eurostat code: htec_eco_ent2 · (2008 - 2020)

@eurostat.htec_eco_ent2

Table List

2 tables(62.09 KB)

Enterprises In High-tech Sectors By NACE Rev.2 Activity - Raw

Enterprises In High-tech Sectors By NACE Rev.2 Activity - Unpivoted

Enterprises In High-tech Sectors By NACE Rev.2 Activity - Unpivoted

@eurostat.htec_eco_ent2.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.73 KB
3455 rows
6 columns

freq Freq	nace_r2 Nace R2	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Manufacturing	Number	Austria	2008	26081
Annual	Manufacturing	Number	Belgium	2008	37209
Annual	Manufacturing	Number	Bulgaria	2008	30288
Annual	Manufacturing	Number	Cyprus	2008	5530
Annual	Manufacturing	Number	Czechia	2008	151753
Annual	Manufacturing	Number	Germany	2008	195439
Annual	Manufacturing	Number	Denmark	2008	16676
Annual	Manufacturing	Number	Estonia	2008	5478
Annual	Manufacturing	Number	Greece	2008	85004
Annual	Manufacturing	Number	Spain	2008	207499


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

Share link

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