Price Indices Of Agricultural Products, Output (2020 = 100) - Quarterly Data
Eurostat code: apri_pi20_outq · (2020-Q1 - 2025-Q2)
@eurostat.apri_pi20_outq
Eurostat code: apri_pi20_outq · (2020-Q1 - 2025-Q2)
@eurostat.apri_pi20_outq
This Eurostat dataset contains data on price indices of agricultural products, output (2020 = 100) - quarterly 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-09-09T11:00:00+0200
CREATE TABLE raw (
"freq" VARCHAR,
"product" VARCHAR,
"p_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"n_2020_q1" DOUBLE -- 2020-Q1,
"n_2020_q2" DOUBLE -- 2020-Q2,
"n_2020_q3" DOUBLE -- 2020-Q3,
"n_2020_q4" DOUBLE -- 2020-Q4,
"n_2021_q1" DOUBLE -- 2021-Q1,
"n_2021_q2" DOUBLE -- 2021-Q2,
"n_2021_q3" DOUBLE -- 2021-Q3,
"n_2021_q4" DOUBLE -- 2021-Q4,
"n_2022_q1" DOUBLE -- 2022-Q1,
"n_2022_q2" DOUBLE -- 2022-Q2,
"n_2022_q3" DOUBLE -- 2022-Q3,
"n_2022_q4" DOUBLE -- 2022-Q4,
"n_2023_q1" DOUBLE -- 2023-Q1,
"n_2023_q2" DOUBLE -- 2023-Q2,
"n_2023_q3" DOUBLE -- 2023-Q3,
"n_2023_q4" DOUBLE -- 2023-Q4,
"n_2024_q1" DOUBLE -- 2024-Q1,
"n_2024_q2" DOUBLE -- 2024-Q2,
"n_2024_q3" DOUBLE -- 2024-Q3,
"n_2024_q4" DOUBLE -- 2024-Q4,
"n_2025_q1" DOUBLE -- 2025-Q1,
"n_2025_q2" DOUBLE -- 2025-Q2
);CREATE TABLE tidy (
"freq" VARCHAR,
"product" VARCHAR,
"p_adj" VARCHAR,
"unit" VARCHAR,
"geo" VARCHAR,
"time_period" VARCHAR,
"value" DOUBLE
);Anyone who has the link will be able to view this.