Preliminary Results On Employer Enterprise Deaths Presented By Size Class (until 2007, NACE Rev. 1.1)

Eurostat code: bd_9h_size_cl · (2006 - 2007)

@eurostat.bd_9h_size_cl

Table List

2 tables(279.17 KB)

Preliminary Results On Employer Enterprise Deaths Presented By Size Class (until 2007, NACE Rev. 1.1) - Raw

Preliminary Results On Employer Enterprise Deaths Presented By Size Class (until 2007, NACE Rev. 1.1) - Unpivoted

Preliminary Results On Employer Enterprise Deaths Presented By Size Class (until 2007, NACE Rev. 1.1) - Unpivoted

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

135.04 KB
48685 rows
7 columns

freq Freq	sizeclas Sizeclas	indic_sb Indic Sb	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Mining and quarrying	Latvia	2006	3
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Mining and quarrying	Netherlands	2006	11
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Mining and quarrying	Slovenia	2006	4
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry (except construction)	Estonia	2006	281
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry (except construction)	Latvia	2006	189
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry (except construction)	Netherlands	2006	1120
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry (except construction)	Sweden	2006	1446
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry (except construction)	Slovenia	2006	584
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry and services (except management activities of holding companies; public administration and community services; activities of households and extra-territorial organizations)	Estonia	2006	2610
Annual	From 1 to 4 employees	Deaths of enterprises in t - number	Industry and services (except management activities of holding companies; public administration and community services; activities of households and extra-territorial organizations)	Latvia	2006	2012


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

Share link

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