Farm Machinery: Number Of Farms And Machines By Size Of Farm (UAA)

Eurostat code: ef_so_mpmachin · (1990 - 2005)

@eurostat.ef_so_mpmachin

Table List

2 tables(122.19 KB)

Farm Machinery: Number Of Farms And Machines By Size Of Farm (UAA) - Raw

Farm Machinery: Number Of Farms And Machines By Size Of Farm (UAA) - Unpivoted

Farm Machinery: Number Of Farms And Machines By Size Of Farm (UAA) - Unpivoted

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

54.6 KB
15555 rows
7 columns

freq Freq	agrarea Agrarea	unit Unit	variable Variable	geo Geo	time_period Time Period	value Value
Annual	Zero ha	Holding	No. of holdings	Belgium	1990	1930
Annual	Zero ha	Holding	No. of holdings	Denmark	1990	160
Annual	Zero ha	Holding	No. of holdings	Greece	1990	8140
Annual	Zero ha	Holding	No. of holdings	Spain	1990	21520
Annual	Zero ha	Holding	No. of holdings	Metropolitan France	1990	6450
Annual	Zero ha	Holding	No. of holdings	Ireland	1990	320
Annual	Zero ha	Holding	No. of holdings	Italy	1990	6890
Annual	Zero ha	Holding	No. of holdings	Luxembourg	1990	10
Annual	Zero ha	Holding	No. of holdings	Netherlands	1990	2550
Annual	Zero ha	Holding	No. of holdings	Portugal	1990	4320


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

Share link

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