Enterprises In High-tech Sectors By NACE Rev.1.1 Activity (1995-2007)

Eurostat code: htec_eco_ent · (1995 - 2007)

@eurostat.htec_eco_ent

Table List

2 tables(50.64 KB)

Enterprises In High-tech Sectors By NACE Rev.1.1 Activity (1995-2007) - Raw

Enterprises In High-tech Sectors By NACE Rev.1.1 Activity (1995-2007) - Unpivoted

Enterprises In High-tech Sectors By NACE Rev.1.1 Activity (1995-2007) - Unpivoted

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

22.12 KB
2499 rows
6 columns

freq Freq	nace_r1 Nace R1	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Manufacturing	Number	Austria	1995	25509
Annual	Manufacturing	Number	Czechia	1995	106170
Annual	Manufacturing	Number	Denmark	1995	26092
Annual	Manufacturing	Number	Estonia	1995	3799
Annual	Manufacturing	Number	Spain	1995	145906
Annual	Manufacturing	Number	Finland	1995	28345
Annual	Manufacturing	Number	Ireland	1995	4289
Annual	Manufacturing	Number	Italy	1995	535554
Annual	Manufacturing	Number	Lithuania	1995	7070
Annual	Manufacturing	Number	Luxembourg	1995	887


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

Share link

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