Number Of Enterprises And Balance Sheet Total By Legal Status (1997-2012)

Eurostat code: sbs_cre_elegsta · (1997 - 2012)

@eurostat.sbs_cre_elegsta

Table List

2 tables(71 KB)

Number Of Enterprises And Balance Sheet Total By Legal Status (1997-2012) - Raw

Number Of Enterprises And Balance Sheet Total By Legal Status (1997-2012) - Unpivoted

Number Of Enterprises And Balance Sheet Total By Legal Status (1997-2012) - Unpivoted

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

30.61 KB
8268 rows
7 columns

freq Freq	indic_sb Indic Sb	nace_r1 Nace R1	leg_form Leg Form	geo Geo	time_period Time Period	value Value
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Austria	1997	1
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Belgium	1997	15
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Switzerland	1997	18
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Germany	1997	30
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Denmark	1997
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Greece	1997	9
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Spain	1997	54
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Finland	1997	1
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	France	1997	96
Annual	Enterprises broken down by legal status - number	Other monetary intermediation	Branches of non European Economic Area (EEA) enterprise	Italy	1997	17


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

Share link

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