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) - Unpivoted

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

691.72 KB
146643 rows
6 columns

freq Freq	indic_sb Indic Sb	enterpr Enterpr	geo Geo	time_period Time Period	value Value
Annual	Enterprises - number	Composite insurance enterprises	Austria	1985	30
Annual	Enterprises - number	Composite insurance enterprises	Belgium	1985	62
Annual	Enterprises - number	Composite insurance enterprises	Greece	1985	30
Annual	Enterprises - number	Composite insurance enterprises	Spain	1985	132
Annual	Enterprises - number	Composite insurance enterprises	Italy	1985	27
Annual	Enterprises - number	Composite insurance enterprises	Luxembourg	1985	7
Annual	Enterprises - number	Composite insurance enterprises	United Kingdom	1985	71
Annual	Enterprises - number	Life insurance enterprises	Austria	1985	5
Annual	Enterprises - number	Life insurance enterprises	Belgium	1985	31
Annual	Enterprises - number	Life insurance enterprises	Switzerland	1985	22


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

Share link

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