Annual Enterprise Statistics By Geographical Breakdown (2004-2007)

Eurostat code: sbs_ins_5fco04 · (2004 - 2007)

@eurostat.sbs_ins_5fco04

Table List

2 tables(77.38 KB)

Annual Enterprise Statistics By Geographical Breakdown (2004-2007) - Raw

Annual Enterprise Statistics By Geographical Breakdown (2004-2007) - Unpivoted

Annual Enterprise Statistics By Geographical Breakdown (2004-2007) - Unpivoted

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

38.38 KB
19064 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	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Austria	Spain	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Austria	Italy	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Austria	Lithuania	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Austria	Portugal	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Belgium	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Spain	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Italy	2004	1
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Lithuania	2004
Annual	Total number and location of branches in other countries - number	Composite insurance enterprises	Belgium	Portugal	2004


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.