General Government Expenditure By Function

Eurostat code: tepsr_sp110 · (2005 - 2023)

@eurostat.tepsr_sp110

Table List

2 tables(33.7 KB)

General Government Expenditure By Function - Raw

General Government Expenditure By Function - Unpivoted

General Government Expenditure By Function - Unpivoted

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

9.54 KB
1881 rows
8 columns

freq Freq	na_item Na Item	sector Sector	cofog99 Cofog99	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Austria	2005	7.7
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Belgium	2005	6.8
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Bulgaria	2005	4.9
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Switzerland	2005	1.8
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Cyprus	2005	2.8
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Czechia	2005	6.9
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Germany	2005	6.4
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Denmark	2005	7.4
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Euro area - 19 countries (2015-2022)	2005	6.6
Annual	Total general government expenditure	General government	Health	Percentage of gross domestic product (GDP)	Euro area – 20 countries (from 2023)	2005	6.6


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

Share link

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