Number Of Enterprises And Balance Sheet Total By Residence Of The Parent Enterprise (1997-2012)

Eurostat code: sbs_cre_eres · (1997 - 2012)

@eurostat.sbs_cre_eres

Table List

2 tables(57.75 KB)

Number Of Enterprises And Balance Sheet Total By Residence Of The Parent Enterprise (1997-2012) - Raw

Number Of Enterprises And Balance Sheet Total By Residence Of The Parent Enterprise (1997-2012) - Unpivoted

Number Of Enterprises And Balance Sheet Total By Residence Of The Parent Enterprise (1997-2012) - Unpivoted

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

23.85 KB
4654 rows
7 columns

freq Freq	indic_sb Indic Sb	nace_r1 Nace R1	resid Resid	geo Geo	time_period Time Period	value Value
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Austria	1997	1
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Belgium	1997	47
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Switzerland	1997	152
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Germany	1997	147
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Denmark	1997
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Greece	1997	6
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Spain	1997	81
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Finland	1997	1
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	France	1997	105
Annual	Enterprises broken down by residence of the parent enterprise - number	Other monetary intermediation	Place of residence outside the reporting country	Italy	1997	54


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

Share link

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