Baselight

Purchasing Power Adjusted GDP Per Capita

Eurostat code: sdg_10_10 · (2000 - 2024)

@eurostat.sdg_10_10

Purchasing Power Adjusted GDP Per Capita - Unpivoted
@eurostat.sdg_10_10.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.

  • 12.65 KB
  • 2251 rows
  • 7 columns
freq

Freq

na_item

Na Item

ppp_cat

Ppp Cat

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualCoefficient of variation of volume indices of expenditure per capita (percentage)Gross domestic productPercentageEuro area - 19 countries (2015-2022)200046.2
AnnualCoefficient of variation of volume indices of expenditure per capita (percentage)Gross domestic productPercentageEuro area – 20 countries (from 2023)200047.8
AnnualCoefficient of variation of volume indices of expenditure per capita (percentage)Gross domestic productPercentageEuropean Union - 27 countries (2007-2013)200049.9
AnnualCoefficient of variation of volume indices of expenditure per capita (percentage)Gross domestic productPercentageEuropean Union - 27 countries (from 2020)200052
AnnualCoefficient of variation of volume indices of expenditure per capita (percentage)Gross domestic productPercentageEuropean Union - 28 countries (2013-2020)200050.6
AnnualReal expenditure per capita (in PPS_EU27_2020)Gross domestic productPercentageAlbania20003200
AnnualReal expenditure per capita (in PPS_EU27_2020)Gross domestic productPercentageAustria200024300
AnnualReal expenditure per capita (in PPS_EU27_2020)Gross domestic productPercentageBelgium200023100
AnnualReal expenditure per capita (in PPS_EU27_2020)Gross domestic productPercentageBulgaria20005300
AnnualReal expenditure per capita (in PPS_EU27_2020)Gross domestic productPercentageSwitzerland200030200

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