Context

Eurostat code: educ_igen · (1998 - 2012)

@eurostat.educ_igen

Table List

2 tables(118.42 KB)

Context - Unpivoted

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

50.61 KB
11013 rows
5 columns

freq Freq	indic_ed Indic Ed	geo Geo	time_period Time Period	value Value
Annual	Population aged 0-9 - as % of the total population	Austria	1998	11.6
Annual	Population aged 0-9 - as % of the total population	Belgium	1998	11.9
Annual	Population aged 0-9 - as % of the total population	Bulgaria	1998	10.2
Annual	Population aged 0-9 - as % of the total population	Switzerland	1998	11.8
Annual	Population aged 0-9 - as % of the total population	Cyprus	1998	15.6
Annual	Population aged 0-9 - as % of the total population	Czechia	1998	11
Annual	Population aged 0-9 - as % of the total population	Germany	1998	10.4
Annual	Population aged 0-9 - as % of the total population	Denmark	1998	12.7
Annual	Population aged 0-9 - as % of the total population	Estonia	1998	11.8
Annual	Population aged 0-9 - as % of the total population	Greece	1998	10.3


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

Share link

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