Annual Enterprise Statistics (1985-2012)

Eurostat code: sbs_ins_5a · (1985 - 2012)

@eurostat.sbs_ins_5a

Table List

2 tables(1.38 MB)

Annual Enterprise Statistics (1985-2012) - Raw

Annual Enterprise Statistics (1985-2012) - Unpivoted

Annual Enterprise Statistics (1985-2012) - Raw

@eurostat.sbs_ins_5a.raw

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

725.29 KB
17580 rows
28 columns

freq Freq	indic_sb Indic Sb	enterpr Enterpr	geo Geo	n_1985 1985	n_1990 1990	n_1992 1992	n_1993 1993	n_1994 1994	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	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012
Annual	Enterprises - number	Composite insurance enterprises	Austria	30	32	32	32	34	34	36	35	34	32	32			29	28	28	28	27	28	28	28		27
Annual	Enterprises - number	Composite insurance enterprises	Belgium	62	59	55	50	49	47	44	45	41	38	36	33	31	30	27	24	22
Annual	Enterprises - number	Composite insurance enterprises	Bulgaria
Annual	Enterprises - number	Composite insurance enterprises	Switzerland
Annual	Enterprises - number	Composite insurance enterprises	Cyprus														11	11	11	11	11	10	10	10	10	10
Annual	Enterprises - number	Composite insurance enterprises	Czechia										19	17	17	16	16	16	15	16	17				15	15
Annual	Enterprises - number	Composite insurance enterprises	Germany
Annual	Enterprises - number	Composite insurance enterprises	Denmark
Annual	Enterprises - number	Composite insurance enterprises	Estonia
Annual	Enterprises - number	Composite insurance enterprises	Greece	30	22	19	16	26	13	16	17					29	45	45	43	40	34	28	11	11	11	11


CREATE TABLE raw (
  "freq" VARCHAR,
  "indic_sb" VARCHAR,
  "enterpr" VARCHAR,
  "geo" VARCHAR,
  "n_1985" DOUBLE,
  "n_1990" DOUBLE,
  "n_1991" DOUBLE,
  "n_1992" DOUBLE,
  "n_1993" DOUBLE,
  "n_1994" DOUBLE,
  "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,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE
);

Share link

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