Annual Detailed Enterprise Statistics On Manufacturing Subsections DA-DE And Total Manufacturing (NACE Rev. 1.1, D) (1995-2008)

Eurostat code: sbs_na_2a_dade · (1995 - 2008)

@eurostat.sbs_na_2a_dade

Table List

2 tables(9 MB)

Annual Detailed Enterprise Statistics On Manufacturing Subsections DA-DE And Total Manufacturing (NACE Rev. 1.1, D) (1995-2008) - Raw

Annual Detailed Enterprise Statistics On Manufacturing Subsections DA-DE And Total Manufacturing (NACE Rev. 1.1, D) (1995-2008) - Unpivoted

Annual Detailed Enterprise Statistics On Manufacturing Subsections DA-DE And Total Manufacturing (NACE Rev. 1.1, D) (1995-2008) - Unpivoted

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

4.52 MB
1628831 rows
6 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	geo Geo	time_period Time Period	value Value
Annual	Manufacturing	Enterprises - number	Austria	1995	25509
Annual	Manufacturing	Enterprises - number	Czechia	1995	106170
Annual	Manufacturing	Enterprises - number	Denmark	1995	26092
Annual	Manufacturing	Enterprises - number	Estonia	1995	3799
Annual	Manufacturing	Enterprises - number	Spain	1995	145906
Annual	Manufacturing	Enterprises - number	Finland	1995	28345
Annual	Manufacturing	Enterprises - number	Ireland	1995	4289
Annual	Manufacturing	Enterprises - number	Italy	1995	535554
Annual	Manufacturing	Enterprises - number	Lithuania	1995	7070
Annual	Manufacturing	Enterprises - number	Luxembourg	1995	887


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

Share link

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