Economic Accounts For Agriculture (EAA)

Eurostat code: med_ag50 · (2000 - 2013)

@eurostat.med_ag50

Table List

2 tables(28 KB)

Economic Accounts For Agriculture (EAA) - Raw

Economic Accounts For Agriculture (EAA) - Unpivoted

Economic Accounts For Agriculture (EAA) - Unpivoted

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

10.33 KB
835 rows
6 columns

freq Freq	itm_newa Itm Newa	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Crop output	Million euro (at constant 2000 prices)	Israel	2000	2071.8
Annual	Crop output	Million euro (at constant 2000 prices)	Morocco	2000	4254.2
Annual	Crop output	Million euro (at constant 2000 prices)	Tunisia	2000	1682.3
Annual	Crop output	Million euro	Algeria	2000	2534.4
Annual	Crop output	Million euro	Israel	2000	2071.8
Annual	Crop output	Million euro	Morocco	2000	4254.2
Annual	Crop output	Million euro	Tunisia	2000	1682.3
Annual	Animal output	Million euro (at constant 2000 prices)	Israel	2000	1653.8
Annual	Animal output	Million euro (at constant 2000 prices)	Morocco	2000	2835.8
Annual	Animal output	Million euro (at constant 2000 prices)	Tunisia	2000	1067.1


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

Share link

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