Baselight

Real GDP Per Capita

Eurostat code: sdg_08_10 ยท (2000 - 2024)

@eurostat.sdg_08_10

Real GDP Per Capita - Unpivoted
@eurostat.sdg_08_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.

  • 13.33 KB
  • 1892 rows
  • 6 columns
freq

Freq

unit

Unit

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesAlbania20002120
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesAustria200037880
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesBelgium200035370
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesBulgaria20004160
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesSwitzerland200065020
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesCyprus200020500
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesCzechia200013410
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesGermany200034680
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesDenmark200047150
AnnualChain linked volumes (2020), euro per capitaGross domestic product at market pricesEuro area - 19 countries (2015-2022)200030330

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

Share link

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