Enterprises By Sourcing Status And Enterprise Group Identification - Collection Round 2007 - Experimental Statistics

Eurostat code: iss_stat · (2007 - 2007)

@eurostat.iss_stat

Table List

2 tables(13.64 KB)

Enterprises By Sourcing Status And Enterprise Group Identification - Collection Round 2007 - Experimental Statistics - Raw

Enterprises By Sourcing Status And Enterprise Group Identification - Collection Round 2007 - Experimental Statistics - Unpivoted

Enterprises By Sourcing Status And Enterprise Group Identification - Collection Round 2007 - Experimental Statistics - Unpivoted

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

7.11 KB
219 rows
7 columns

freq Freq	indic_sb Indic Sb	enterpr Enterpr	entgrp Entgrp	geo Geo	time_period Time Period	value Value
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Czechia	2007	163
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Germany	2007	1900
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Denmark	2007	349
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Spain	2007	57
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	European Union (aggregate changing according to the context)	2007	7220
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Finland	2007	276
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Ireland	2007	402
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Italy	2007	934
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Netherlands	2007	590
Annual	Enterprises - number	Enterprises with international sourcing	Enterprise group	Norway	2007	182


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

Share link

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