Baselight

Price Indices Of The Means Of Agricultural Production, Input (2000 = 100) - Quarterly Data

Eurostat code: apri_pi00_inq ยท (2000-Q1 - 2008-Q4)

@eurostat.apri_pi00_inq

Loading...
Loading...

About this Dataset

Price Indices Of The Means Of Agricultural Production, Input (2000 = 100) - Quarterly Data

This Eurostat dataset contains data on price indices of the means of agricultural production, input (2000 = 100) - quarterly data, as collected and published by the Statistical Office of the European Union.

Tables included:

  • 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: 2009-09-10T23:00:00+0200

Tables

Price Indices Of The Means Of Agricultural Production, Input (2000 = 100) - Quarterly Data - Raw

@eurostat.apri_pi00_inq.raw
  • 322.29 KB
  • 5472 rows
  • 41 columns
Loading...

CREATE TABLE raw (
  "freq" VARCHAR,
  "p_adj" VARCHAR,
  "unit" VARCHAR,
  "product" VARCHAR,
  "geo" VARCHAR,
  "n_2000_q1" DOUBLE,
  "n_2000_q2" DOUBLE,
  "n_2000_q3" DOUBLE,
  "n_2000_q4" DOUBLE,
  "n_2001_q1" DOUBLE,
  "n_2001_q2" DOUBLE,
  "n_2001_q3" DOUBLE,
  "n_2001_q4" DOUBLE,
  "n_2002_q1" DOUBLE,
  "n_2002_q2" DOUBLE,
  "n_2002_q3" DOUBLE,
  "n_2002_q4" DOUBLE,
  "n_2003_q1" DOUBLE,
  "n_2003_q2" DOUBLE,
  "n_2003_q3" DOUBLE,
  "n_2003_q4" DOUBLE,
  "n_2004_q1" DOUBLE,
  "n_2004_q2" DOUBLE,
  "n_2004_q3" DOUBLE,
  "n_2004_q4" DOUBLE,
  "n_2005_q1" DOUBLE,
  "n_2005_q2" DOUBLE,
  "n_2005_q3" DOUBLE,
  "n_2005_q4" DOUBLE,
  "n_2006_q1" DOUBLE,
  "n_2006_q2" DOUBLE,
  "n_2006_q3" DOUBLE,
  "n_2006_q4" DOUBLE,
  "n_2007_q1" DOUBLE,
  "n_2007_q2" DOUBLE,
  "n_2007_q3" DOUBLE,
  "n_2007_q4" DOUBLE,
  "n_2008_q1" DOUBLE,
  "n_2008_q2" DOUBLE,
  "n_2008_q3" DOUBLE,
  "n_2008_q4" DOUBLE
);

Price Indices Of The Means Of Agricultural Production, Input (2000 = 100) - Quarterly Data - Unpivoted

@eurostat.apri_pi00_inq.tidy
  • 216.64 KB
  • 112531 rows
  • 7 columns
Loading...

CREATE TABLE tidy (
  "freq" VARCHAR,
  "p_adj" VARCHAR,
  "unit" VARCHAR,
  "product" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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