Food Price Monitoring Tool

Eurostat code: prc_fsc_idx · (2005-01 - 2025-04)

@eurostat.prc_fsc_idx

Table List

2 tables(5.14 MB)

Food Price Monitoring Tool - Unpivoted

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

2.03 MB
1025396 rows
7 columns

freq Freq	unit Unit	indx Indx	coicop Coicop	geo Geo	time_period Time Period	value Value
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Austria	2005-01	88.4
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Belgium	2005-01	94.9
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Bulgaria	2005-01	72.1
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Cyprus	2005-01	119.3
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Czechia	2005-01	83.8
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Germany	2005-01	84.5
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Denmark	2005-01	84.2
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Estonia	2005-01	99.7
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Greece	2005-01	85
Monthly	Index, 2015=100	Agricultural commodity price index	Food	Spain	2005-01	99


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

Share link

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