Purchasing Power Parities In The European Union (Duty Stations) - Index (Brussels = 1)

Eurostat code: prc_colc_ppptot · (2010-S1 - 2024-S1)

@eurostat.prc_colc_ppptot

Table List

2 tables(37.29 KB)

Purchasing Power Parities In The European Union (Duty Stations) - Index (Brussels = 1) - Raw

Purchasing Power Parities In The European Union (Duty Stations) - Index (Brussels = 1) - Unpivoted

Purchasing Power Parities In The European Union (Duty Stations) - Index (Brussels = 1) - Unpivoted

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

10.18 KB
1142 rows
6 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	time_period Time Period	value Value
Half-yearly, semesterly	Index	Total	Wien	2010-S1	1.062
Half-yearly, semesterly	Index	Total	Bruxelles/Brussel	2010-S1	1
Half-yearly, semesterly	Index	Total	Sofia	2010-S1	1.226
Half-yearly, semesterly	Index	Total	Lefkosia	2010-S1	0.837
Half-yearly, semesterly	Index	Total	Praha	2010-S1	21.68
Half-yearly, semesterly	Index	Total	Berlin	2010-S1	0.948
Half-yearly, semesterly	Index	Total	Karlsruhe	2010-S1	0.921
Half-yearly, semesterly	Index	Total	München	2010-S1	1.037
Half-yearly, semesterly	Index	Total	Bonn	2010-S1	0.947
Half-yearly, semesterly	Index	Total	København	2010-S1	9.99


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.