Baselight

Purchasing Power Parities In The European Union (Countries) - Index (Belgium = 1)

Eurostat code: prc_colc_pppnat ยท (2010-S1 - 2024-S1)

@eurostat.prc_colc_pppnat

Purchasing Power Parities In The European Union (Countries) - Index (Belgium = 1) - Unpivoted
@eurostat.prc_colc_pppnat.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.71 KB
  • 992 rows
  • 6 columns
freq

Freq

unit

Unit

coicop

Coicop

geo

Geo

time_period

Time Period

value

Value

Half-yearly, semesterlyIndexTotalAustria2010-S11.051
Half-yearly, semesterlyIndexTotalBelgium2010-S11
Half-yearly, semesterlyIndexTotalBulgaria2010-S11.161
Half-yearly, semesterlyIndexTotalCyprus2010-S10.867
Half-yearly, semesterlyIndexTotalCzechia2010-S119.95
Half-yearly, semesterlyIndexTotalGermany2010-S10.965
Half-yearly, semesterlyIndexTotalDenmark2010-S19.719
Half-yearly, semesterlyIndexTotalEstonia2010-S111.99
Half-yearly, semesterlyIndexTotalGreece2010-S10.943
Half-yearly, semesterlyIndexTotalSpain2010-S10.91

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

Share link

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