Annual Production And Utilisation Of Milk On The Farm

Eurostat code: med_ag32 · (2000 - 2015)

@eurostat.med_ag32

Table List

2 tables(21.76 KB)

Annual Production And Utilisation Of Milk On The Farm - Raw

Annual Production And Utilisation Of Milk On The Farm - Unpivoted

Annual Production And Utilisation Of Milk On The Farm - Unpivoted

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

6.57 KB
271 rows
6 columns

freq Freq	unit Unit	prodmilk Prodmilk	geo Geo	time_period Time Period	value Value
Annual	Tonne	Cows' milk collection	Algeria	2000	100700
Annual	Tonne	Cows' milk collection	Egypt	2000	1645002
Annual	Tonne	Cows' milk collection	Israel	2000	1186040
Annual	Tonne	Cows' milk collection	Jordan	2000	124076
Annual	Tonne	Cows' milk collection	Lebanon	2000	158400
Annual	Tonne	Cows' milk collection	Morocco	2000	1150000
Annual	Tonne	Cows' milk collection	Palestine*	2000	68095
Annual	Tonne	Cows' milk collection	Syria	2000	1156393
Annual	Tonne	Cows' milk collection	Tunisia	2000	870000
Annual	Tonne	Ewes' collection milk	Israel	2000	19366


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

Share link

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