Annual Enterprise Statistics By Geographical Breakdown (2001-2005)

Eurostat code: sbs_cre_6g_01 · (2001 - 2005)

@eurostat.sbs_cre_6g_01

Table List

2 tables(62.83 KB)

Annual Enterprise Statistics By Geographical Breakdown (2001-2005) - Raw

Annual Enterprise Statistics By Geographical Breakdown (2001-2005) - Unpivoted

Annual Enterprise Statistics By Geographical Breakdown (2001-2005) - Unpivoted

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

32.72 KB
21461 rows
7 columns

freq Freq	indic_sb Indic Sb	nace_r1 Nace R1	partner Partner	geo Geo	time_period Time Period	value Value
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	Switzerland	Cyprus	2001
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	Switzerland	Greece	2001
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	Switzerland	France	2001	1
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	Japan	Cyprus	2001
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	Japan	Greece	2001
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	Japan	France	2001	7
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	United States	Cyprus	2001
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	United States	Greece	2001
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	United States	France	2001	9
Annual	Branches broken down by location in non-EEA countries - number	Other monetary intermediation	World - not allocated	Cyprus	2001	16


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

Share link

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