Annual Detailed Enterprise Statistics On Electricity, Gas And Water Supply (NACE Rev. 1.1, E) (1995-2008)

Eurostat code: sbs_na_2a_el · (1995 - 2008)

@eurostat.sbs_na_2a_el

Table List

2 tables(760.31 KB)

Annual Detailed Enterprise Statistics On Electricity, Gas And Water Supply (NACE Rev. 1.1, E) (1995-2008) - Raw

Annual Detailed Enterprise Statistics On Electricity, Gas And Water Supply (NACE Rev. 1.1, E) (1995-2008) - Unpivoted

Annual Detailed Enterprise Statistics On Electricity, Gas And Water Supply (NACE Rev. 1.1, E) (1995-2008) - Raw

@eurostat.sbs_na_2a_el.raw

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

412.05 KB
19501 rows
18 columns

freq Freq	nace_r1 Nace R1	indic_sb Indic Sb	geo Geo	n_1995 1995	n_1996 1996	n_1997 1997	n_1998 1998	n_1999 1999	n_2000 2000	n_2001 2001	n_2002 2002	n_2003 2003	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008
Annual	Electricity, gas and water supply	Enterprises - number	Albania				48
Annual	Electricity, gas and water supply	Enterprises - number	Austria	613	698	699	656	710	700	734	707	925	1037	1417	1496	1595	2101
Annual	Electricity, gas and water supply	Enterprises - number	Belgium					81	118	133		145	142	156	164	176	319
Annual	Electricity, gas and water supply	Enterprises - number	Bulgaria		127	132	134	140	174	186	181	214	247	279	309	422	671
Annual	Electricity, gas and water supply	Enterprises - number	Cyprus						91	91	11	11	11	11	11	11	11
Annual	Electricity, gas and water supply	Enterprises - number	Czechia	866	834	776	685	668	862	707	942	883	1066	1083	1090	1165	1531
Annual	Electricity, gas and water supply	Enterprises - number	Germany				3643	3435	3306	3268	3281	3258	3315	3322	3305	3359	3299
Annual	Electricity, gas and water supply	Enterprises - number	Denmark	5207	5302	5306	5285	5392	4488	4426	4441	3770	3939	3828	3670	3671	3668
Annual	Electricity, gas and water supply	Enterprises - number	Estonia	351	339	350	275	293	287	283	260	265	269	262	268	269	263
Annual	Electricity, gas and water supply	Enterprises - number	Greece									80	94	93	95	91	100


CREATE TABLE raw (
  "freq" VARCHAR,
  "nace_r1" VARCHAR,
  "indic_sb" VARCHAR,
  "geo" VARCHAR,
  "n_1995" DOUBLE,
  "n_1996" DOUBLE,
  "n_1997" DOUBLE,
  "n_1998" DOUBLE,
  "n_1999" DOUBLE,
  "n_2000" DOUBLE,
  "n_2001" DOUBLE,
  "n_2002" DOUBLE,
  "n_2003" DOUBLE,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE
);

Share link

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