Annual Enterprise Statistics (1999-2012)

Eurostat code: sbs_cre_tent · (1999 - 2012)

@eurostat.sbs_cre_tent

Table List

2 tables(263.52 KB)

Annual Enterprise Statistics (1999-2012) - Raw

Annual Enterprise Statistics (1999-2012) - Unpivoted

Annual Enterprise Statistics (1999-2012) - Unpivoted

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

125.86 KB
27653 rows
6 columns

freq Freq	indic_sb Indic Sb	nace_r1 Nace R1	geo Geo	time_period Time Period	value Value
Annual	Persons employed - number	Other credit granting	Belgium	1999	74073
Annual	Persons employed on a fixed salary basis - number	Other credit granting	Belgium	1999	74012
Annual	Employees in full time equivalent units - number	Other credit granting	Belgium	1999	64424
Annual	Persons employed - number	Other credit granting	Belgium	2000	75529
Annual	Persons employed on a fixed salary basis - number	Other credit granting	Belgium	2000	75485
Annual	Employees in full time equivalent units - number	Other credit granting	Belgium	2000	65910
Annual	Enterprises - number	Central banking	France	2001	1
Annual	Enterprises - number	Other monetary intermediation	Cyprus	2001	402
Annual	Enterprises - number	Other monetary intermediation	Greece	2001	58
Annual	Enterprises - number	Other monetary intermediation	France	2001	528


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

Share link

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