Long Time Series Covering Enterprises With 20 Persons Employed And More, Main Indicators (NACE Rev. 1.1, C-F) (1985-2008)

Eurostat code: sbs_na_indc_lgt · (1985 - 2002)

@eurostat.sbs_na_indc_lgt

Table List

2 tables(6.37 MB)

Long Time Series Covering Enterprises With 20 Persons Employed And More, Main Indicators (NACE Rev. 1.1, C-F) (1985-2008) - Raw

Long Time Series Covering Enterprises With 20 Persons Employed And More, Main Indicators (NACE Rev. 1.1, C-F) (1985-2008) - Unpivoted

Long Time Series Covering Enterprises With 20 Persons Employed And More, Main Indicators (NACE Rev. 1.1, C-F) (1985-2008) - Unpivoted

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

3.17 MB
925916 rows
6 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	geo Geo	time_period Time Period	value Value
Annual	Mining and quarrying	Enterprises - number	Japan	1985	71
Annual	Mining and quarrying	Enterprises - number	Sweden	1985	15
Annual	Mining and quarrying	Turnover or gross premiums written - million euro	Japan	1985	264.1
Annual	Mining and quarrying	Turnover or gross premiums written - million euro	Sweden	1985	974.3
Annual	Mining and quarrying	Production value - million euro	Sweden	1985	974.3
Annual	Mining and quarrying	Value added at factor cost - million euro	Japan	1985	74.3
Annual	Mining and quarrying	Value added at factor cost - million euro	Sweden	1985	603.2
Annual	Mining and quarrying	Total purchases of goods and services - million euro	Japan	1985	180.8
Annual	Mining and quarrying	Personnel costs - million euro	Sweden	1985	212.3
Annual	Mining and quarrying	Wages and Salaries - million euro	Japan	1985	31.1


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.