Baselight

HICP - Annual Data (average Index And Rate Of Change)

Eurostat code: prc_hicp_aind ยท (1996 - 2024)

@eurostat.prc_hicp_aind

HICP - Annual Data (average Index And Rate Of Change) - Unpivoted
@eurostat.prc_hicp_aind.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.

  • 1.32 MB
  • 569627 rows
  • 6 columns
freq

Freq

unit

Unit

coicop

Coicop

geo

Geo

time_period

Time Period

value

Value

AnnualAnnual average indexAll-items HICPAustria199671.77
AnnualAnnual average indexAll-items HICPBelgium199670.48
AnnualAnnual average indexAll-items HICPCyprus199666.81
AnnualAnnual average indexAll-items HICPCzechia199658.8
AnnualAnnual average indexAll-items HICPGermany199675.7
AnnualAnnual average indexAll-items HICPDenmark199671.6
AnnualAnnual average indexAll-items HICPEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)199671.74
AnnualAnnual average indexAll-items HICPEuro area - 19 countries (2015-2022)199671.23
AnnualAnnual average indexAll-items HICPEstonia199645.7
AnnualAnnual average indexAll-items HICPEuropean Economic Area (EEA18-1995, EEA28-2004, EEA30-2007, EEA31-2013, EEA30-2020)199670.24

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.