Harmonised Index Of Consumer Prices - Monthly Data
Eurostat code: ei_cphi_m ยท (1996-01 - 2025-09)
@eurostat.ei_cphi_m
Eurostat code: ei_cphi_m ยท (1996-01 - 2025-09)
@eurostat.ei_cphi_m
This Eurostat dataset contains data on harmonised index of consumer prices - monthly data, as collected and published by the Statistical Office of the European Union.
raw
: Original table as downloaded from Eurostat.tidy
: A cleaned and transformed version of the raw
table, where time period values appear as rows instead of columns (unpivoted format).Last updated: 2025-10-01T11:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"unit" VARCHAR,
"s_adj" VARCHAR,
"indic" VARCHAR,
"geo" VARCHAR,
"n_1996_01" DOUBLE -- 1996-01,
"n_1996_02" DOUBLE -- 1996-02,
"n_1996_03" DOUBLE -- 1996-03,
"n_1996_04" DOUBLE -- 1996-04,
"n_1996_05" DOUBLE -- 1996-05,
"n_1996_06" DOUBLE -- 1996-06,
"n_1996_07" DOUBLE -- 1996-07,
"n_1996_08" DOUBLE -- 1996-08,
"n_1996_09" DOUBLE -- 1996-09,
"n_1996_10" DOUBLE -- 1996-10,
"n_1996_11" DOUBLE -- 1996-11,
"n_1996_12" DOUBLE -- 1996-12,
"n_1997_01" DOUBLE -- 1997-01,
"n_1997_02" DOUBLE -- 1997-02,
"n_1997_03" DOUBLE -- 1997-03,
"n_1997_04" DOUBLE -- 1997-04,
"n_1997_05" DOUBLE -- 1997-05,
"n_1997_06" DOUBLE -- 1997-06,
"n_1997_07" DOUBLE -- 1997-07,
"n_1997_08" DOUBLE -- 1997-08,
"n_1997_09" DOUBLE -- 1997-09,
"n_1997_10" DOUBLE -- 1997-10,
"n_1997_11" DOUBLE -- 1997-11,
"n_1997_12" DOUBLE -- 1997-12,
"n_1998_01" DOUBLE -- 1998-01,
"n_1998_02" DOUBLE -- 1998-02,
"n_1998_03" DOUBLE -- 1998-03,
"n_1998_04" DOUBLE -- 1998-04,
"n_1998_05" DOUBLE -- 1998-05,
"n_1998_06" DOUBLE -- 1998-06,
"n_1998_07" DOUBLE -- 1998-07,
"n_1998_08" DOUBLE -- 1998-08,
"n_1998_09" DOUBLE -- 1998-09,
"n_1998_10" DOUBLE -- 1998-10,
"n_1998_11" DOUBLE -- 1998-11,
"n_1998_12" DOUBLE -- 1998-12,
"n_1999_01" DOUBLE -- 1999-01,
"n_1999_02" DOUBLE -- 1999-02,
"n_1999_03" DOUBLE -- 1999-03,
"n_1999_04" DOUBLE -- 1999-04,
"n_1999_05" DOUBLE -- 1999-05,
"n_1999_06" DOUBLE -- 1999-06,
"n_1999_07" DOUBLE -- 1999-07,
"n_1999_08" DOUBLE -- 1999-08,
"n_1999_09" DOUBLE -- 1999-09,
"n_1999_10" DOUBLE -- 1999-10,
"n_1999_11" DOUBLE -- 1999-11,
"n_1999_12" DOUBLE -- 1999-12,
"n_2000_01" DOUBLE -- 2000-01,
"n_2000_02" DOUBLE -- 2000-02,
"n_2000_03" DOUBLE -- 2000-03,
"n_2000_04" DOUBLE -- 2000-04,
"n_2000_05" DOUBLE -- 2000-05,
"n_2000_06" DOUBLE -- 2000-06,
"n_2000_07" DOUBLE -- 2000-07,
"n_2000_08" DOUBLE -- 2000-08,
"n_2000_09" DOUBLE -- 2000-09,
"n_2000_10" DOUBLE -- 2000-10,
"n_2000_11" DOUBLE -- 2000-11,
"n_2000_12" DOUBLE -- 2000-12,
"n_2001_01" DOUBLE -- 2001-01,
"n_2001_02" DOUBLE -- 2001-02,
"n_2001_03" DOUBLE -- 2001-03,
"n_2001_04" DOUBLE -- 2001-04,
"n_2001_05" DOUBLE -- 2001-05,
"n_2001_06" DOUBLE -- 2001-06,
"n_2001_07" DOUBLE -- 2001-07,
"n_2001_08" DOUBLE -- 2001-08,
"n_2001_09" DOUBLE -- 2001-09,
"n_2001_10" DOUBLE -- 2001-10,
"n_2001_11" DOUBLE -- 2001-11,
"n_2001_12" DOUBLE -- 2001-12,
"n_2002_01" DOUBLE -- 2002-01,
"n_2002_02" DOUBLE -- 2002-02,
"n_2002_03" DOUBLE -- 2002-03,
"n_2002_04" DOUBLE -- 2002-04,
"n_2002_05" DOUBLE -- 2002-05,
"n_2002_06" DOUBLE -- 2002-06,
"n_2002_07" DOUBLE -- 2002-07,
"n_2002_08" DOUBLE -- 2002-08,
"n_2002_09" DOUBLE -- 2002-09,
"n_2002_10" DOUBLE -- 2002-10,
"n_2002_11" DOUBLE -- 2002-11,
"n_2002_12" DOUBLE -- 2002-12,
"n_2003_01" DOUBLE -- 2003-01,
"n_2003_02" DOUBLE -- 2003-02,
"n_2003_03" DOUBLE -- 2003-03,
"n_2003_04" DOUBLE -- 2003-04,
"n_2003_05" DOUBLE -- 2003-05,
"n_2003_06" DOUBLE -- 2003-06,
"n_2003_07" DOUBLE -- 2003-07,
"n_2003_08" DOUBLE -- 2003-08,
"n_2003_09" DOUBLE -- 2003-09,
"n_2003_10" DOUBLE -- 2003-10,
"n_2003_11" DOUBLE -- 2003-11
);
CREATE TABLE tidy (
"freq" VARCHAR,
"unit" VARCHAR,
"s_adj" VARCHAR,
"indic" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);
Anyone who has the link will be able to view this.