Detailed Average Prices - 2015

Eurostat code: prc_dap15 · (2015 - 2015)

@eurostat.prc_dap15

Table List

2 tables(50.46 KB)

Detailed Average Prices - 2015 - Raw

Detailed Average Prices - 2015 - Unpivoted

Detailed Average Prices - 2015 - Unpivoted

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

25.52 KB
4324 rows
6 columns

freq Freq	unit Unit	coicop Coicop	geo Geo	time_period Time Period	value Value
Annual	Euro	Long-grain rice (1 kg)	Cyprus	2015	2.26
Annual	Euro	Long-grain rice (1 kg)	Czechia	2015	1.32
Annual	Euro	Long-grain rice (1 kg)	Spain	2015	1.29
Annual	Euro	Long-grain rice (1 kg)	Finland	2015	2.41
Annual	Euro	Long-grain rice (1 kg)	Croatia	2015	3.02
Annual	Euro	Long-grain rice (1 kg)	Italy	2015	2.59
Annual	Euro	Long-grain rice (1 kg)	Lithuania	2015	1.02
Annual	Euro	Long-grain rice (1 kg)	Malta	2015	2.88
Annual	Euro	Long-grain rice (1 kg)	Netherlands	2015	2.31
Annual	Euro	Long-grain rice (1 kg)	Norway	2015	3.73


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.