Annual Enterprise Statistics By Geographical Breakdown (1995-2003)

Eurostat code: sbs_ins_5fco96 · (1995 - 2003)

@eurostat.sbs_ins_5fco96

Table List

2 tables(46.6 KB)

Annual Enterprise Statistics By Geographical Breakdown (1995-2003) - Raw

Annual Enterprise Statistics By Geographical Breakdown (1995-2003) - Unpivoted

Annual Enterprise Statistics By Geographical Breakdown (1995-2003) - Unpivoted

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

20.07 KB
6602 rows
7 columns

freq Freq	indic_sb Indic Sb	enterpr Enterpr	partner Partner	geo Geo	time_period Time Period	value Value
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Austria	Belgium	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Austria	Denmark	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Austria	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Denmark	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Switzerland	Austria	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Switzerland	Belgium	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Switzerland	Denmark	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Germany	Austria	1995
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Germany	Belgium	1995	8
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Germany	Denmark	1995


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

Share link

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