Baselight
Sign In

EC Indices Of Purchase Prices Of The Means Of Agricultural Production (1995 = 100) - Annual Data

Eurostat code: apri_pi95_purcha ยท (1988 - 2004)

@eurostat.apri_pi95_purcha

EC Indices Of Purchase Prices Of The Means Of Agricultural Production (1995 = 100) - Annual Data - Unpivoted
@eurostat.apri_pi95_purcha.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.

  • 80.39 KB
  • 39727 rows
  • 7 columns
freq

Freq

p_adj

P Adj

unit

Unit

ind_inpu

Ind Inpu

geo

Geo

time_period

Time Period

value

Value

AnnualNominal indexIndex, 1995=100Input total (I+II)United Kingdom198878
AnnualNominal indexIndex, 1995=100Total, goods and services currently consumed in agricultureUnited Kingdom198878.5
AnnualNominal indexIndex, 1995=100SeedsUnited Kingdom198887.4
AnnualNominal indexIndex, 1995=100Energy and lubricantsUnited Kingdom198875.8
AnnualNominal indexIndex, 1995=100Fuels for heatingUnited Kingdom198877.3
AnnualNominal indexIndex, 1995=100Motor fuelsUnited Kingdom198870.4
AnnualNominal indexIndex, 1995=100ElectricityUnited Kingdom198879.4
AnnualNominal indexIndex, 1995=100LubricantsUnited Kingdom198875.3
AnnualNominal indexIndex, 1995=100Fertilizers, soil improversUnited Kingdom198888.5
AnnualNominal indexIndex, 1995=100Straight fertilizersUnited Kingdom198894.1

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

Share link

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