Baselight

Gross Domestic Product (GDP) And Main Components Per Capita

Eurostat code: nama_10_pc$dv_648

@eurostat.nama_10_pc_dv_648

Gross Domestic Product (GDP) And Main Components Per Capita - Unpivoted
@eurostat.nama_10_pc_dv_648.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.

  • 32.79 KB
  • 5133 rows
  • 6 columns
freq

Freq

unit

Unit

na_item

Na Item

geo

Geo

time_period

Time Period

value

Value

AnnualChain linked volumes (2010), euro per capitaActual individual consumptionAlbania20132660
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionAustria201323160
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionBelgium201322630
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionBulgaria20133930
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionCyprus201315280
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionCzechia20139190
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionGermany201322590
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionDenmark201329700
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)201319640
AnnualChain linked volumes (2010), euro per capitaActual individual consumptionEuro area - 12 countries (2001-2006)201319960

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.