Mining And Quarrying By Employment Size Class (NACE Rev. 1.1, C) (2002-2007)

Eurostat code: sbs_sc_2d_mi02 · (2002 - 2007)

@eurostat.sbs_sc_2d_mi02

Table List

2 tables(1.33 MB)

Mining And Quarrying By Employment Size Class (NACE Rev. 1.1, C) (2002-2007) - Raw

Mining And Quarrying By Employment Size Class (NACE Rev. 1.1, C) (2002-2007) - Unpivoted

Mining And Quarrying By Employment Size Class (NACE Rev. 1.1, C) (2002-2007) - Raw

@eurostat.sbs_sc_2d_mi02.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

675.99 KB
120431 rows
11 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	size_emp Size Emp	geo Geo	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Austria	273	288	281	290	284	276
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Belgium					183	200
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Bulgaria	85	111	126	147	176	199
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Cyprus			79	78	78	79
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Czechia	210	188	331	226	198	215
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Germany	1399	1306	1410	1542	1540	1594
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Denmark	178	173	158	162	159	154
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Estonia	42	39	40	48	51	62
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Greece			578	578
Annual	Mining and quarrying	Enterprises - number	From 1 to 19 persons employed	Spain	2295	2210	2300	2307	2298	2383


CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "indic_sb" VARCHAR,
  "size_emp" VARCHAR,
  "geo" VARCHAR,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE
);

Share link

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