Joint Index

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

@eurostat.prc_rem_idx

Table List

2 tables(23.94 KB)

Joint Index - Raw

Joint Index - Unpivoted

Joint Index - Raw

@eurostat.prc_rem_idx.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

19.04 KB
1 row
27 columns

freq

Freq

unit

Unit

geo

Geo

n_2004_s2

2004-S2

n_2005_s2

2005-S2

n_2006_s2

2006-S2

n_2007_s2

2007-S2

n_2008_s2

2008-S2

n_2009_s2

2009-S2

n_2010_s2

2010-S2

n_2011_s2

2011-S2

n_2012_s2

2012-S2

n_2013_s2

2013-S2

n_2014_s2

2014-S2

n_2015_s2

2015-S2

n_2016_s2

2016-S2

n_2017_s2

2017-S2

n_2018_s2

2018-S2

n_2019_s2

2019-S2

n_2020_s2

2020-S2

n_2021_s2

2021-S2

n_2022_s1

2022-S1

n_2022_s2

2022-S2

n_2023_s1

2023-S1

n_2023_s2

2023-S2

n_2024_s1

2024-S1

n_2024_s2

2024-S2

Half-yearly, semesterly

Index

European Union (EU6-1958, EU9-1973, EU10-1981, EU12-1986, EU15-1995, EU25-2004, EU27-2007, EU28-2013, EU27-2020)

101.9

102.2

102.1

101.4

104.4

100.9

102.4

103.6

102.8

101.5

100.9

101.2

101.4

101.1

102.1

101.5

100.7

102.1

103.5

104.9

103.7

100.9

103

102


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2004_s2" DOUBLE,
  "n_2005_s2" DOUBLE,
  "n_2006_s2" DOUBLE,
  "n_2007_s2" DOUBLE,
  "n_2008_s2" DOUBLE,
  "n_2009_s2" DOUBLE,
  "n_2010_s2" DOUBLE,
  "n_2011_s2" DOUBLE,
  "n_2012_s2" DOUBLE,
  "n_2013_s2" DOUBLE,
  "n_2014_s2" DOUBLE,
  "n_2015_s2" DOUBLE,
  "n_2016_s2" DOUBLE,
  "n_2017_s2" DOUBLE,
  "n_2018_s2" DOUBLE,
  "n_2019_s2" DOUBLE,
  "n_2020_s2" DOUBLE,
  "n_2021_s2" DOUBLE,
  "n_2022_s1" DOUBLE,
  "n_2022_s2" DOUBLE,
  "n_2023_s1" DOUBLE,
  "n_2023_s2" DOUBLE,
  "n_2024_s1" DOUBLE,
  "n_2024_s2" DOUBLE
);

Share link

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