Joint Index

Eurostat code: prc_rem_idx · (2004-S2 - 2024-S2)

@eurostat.prc_rem_idx

Table List

2 tables(23.94 KB)

Joint Index - Unpivoted

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

4.89 KB
24 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2004-S2	101.9
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2005-S2	102.2
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2006-S2	102.1
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2007-S2	101.4
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2008-S2	104.4
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2009-S2	100.9
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2010-S2	102.4
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2011-S2	103.6
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2012-S2	102.8
Half-yearly, semesterly	Index	European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)	2013-S2	101.5


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

Share link

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