Public Expenditure On Education

Eurostat code: enps_educ_figdp · (2005 - 2022)

@eurostat.enps_educ_figdp

Table List

2 tables(18.8 KB)

Public Expenditure On Education - Unpivoted

Public Expenditure On Education - Unpivoted

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

4.44 KB
58 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Percentage of total public expenditure	Algeria	2005	12.3
Annual	Percentage of total public expenditure	Israel	2005	9.9
Annual	Percentage of total public expenditure	Algeria	2006	14.8
Annual	Percentage of total public expenditure	Egypt	2006	13.9
Annual	Percentage of total public expenditure	Israel	2006	9.8
Annual	Percentage of total public expenditure	Algeria	2007	9.7
Annual	Percentage of total public expenditure	Egypt	2007	14.4
Annual	Percentage of total public expenditure	Israel	2007	10.1
Annual	Percentage of total public expenditure	Algeria	2008	8.3
Annual	Percentage of total public expenditure	Egypt	2008	13.7


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

Share link

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