Annual Enterprise Statistics By Legal Status (1995-2012)

Eurostat code: sbs_ins_5b · (1995 - 2012)

@eurostat.sbs_ins_5b

Table List

2 tables(139.56 KB)

Annual Enterprise Statistics By Legal Status (1995-2012) - Raw

Annual Enterprise Statistics By Legal Status (1995-2012) - Unpivoted

Annual Enterprise Statistics By Legal Status (1995-2012) - Unpivoted

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

65.18 KB
18452 rows
7 columns

freq Freq	indic_sb Indic Sb	enterpr Enterpr	leg_form Leg Form	geo Geo	time_period Time Period	value Value
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Branches of non European Economic Area (EEA) enterprise	Belgium	1995	1
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Branches of non European Economic Area (EEA) enterprise	Denmark	1995
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Branches of non European Economic Area (EEA) enterprise	Italy	1995	1
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Branches of non European Economic Area (EEA) enterprise	United Kingdom	1995
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Cooperative	Denmark	1995
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Cooperative	Spain	1995	12
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Cooperative	Italy	1995	1
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Cooperative	United Kingdom	1995	4
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Limited liability enterprise	Belgium	1995	43
Annual	Enterprises broken down by legal status - number	Composite insurance enterprises	Limited liability enterprise	Denmark	1995


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

Share link

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