Dataset: Meat Production And Foreign Trade - Head - Monthly Data

About this Dataset

Meat Production And Foreign Trade - Head - Monthly Data

This Eurostat dataset contains data on meat production and foreign trade - head - monthly 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: 2025-05-27T23:00:00+0200

Tables

Meat Production And Foreign Trade - Head - Monthly Data - Raw

@eurostat.apro_mt_pheadm.raw

4.13 MB
7366 rows
909 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "meatitem" VARCHAR,
  "meat" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1950_01" DOUBLE,
  "n_1950_02" DOUBLE,
  "n_1950_03" DOUBLE,
  "n_1950_04" DOUBLE,
  "n_1950_05" DOUBLE,
  "n_1950_06" DOUBLE,
  "n_1950_07" DOUBLE,
  "n_1950_08" DOUBLE,
  "n_1950_09" DOUBLE,
  "n_1950_10" DOUBLE,
  "n_1950_11" DOUBLE,
  "n_1950_12" DOUBLE,
  "n_1951_01" DOUBLE,
  "n_1951_02" DOUBLE,
  "n_1951_03" DOUBLE,
  "n_1951_04" DOUBLE,
  "n_1951_05" DOUBLE,
  "n_1951_06" DOUBLE,
  "n_1951_07" DOUBLE,
  "n_1951_08" DOUBLE,
  "n_1951_09" DOUBLE,
  "n_1951_10" DOUBLE,
  "n_1951_11" DOUBLE,
  "n_1951_12" DOUBLE,
  "n_1952_01" DOUBLE,
  "n_1952_02" DOUBLE,
  "n_1952_03" DOUBLE,
  "n_1952_04" DOUBLE,
  "n_1952_05" DOUBLE,
  "n_1952_06" DOUBLE,
  "n_1952_07" DOUBLE,
  "n_1952_08" DOUBLE,
  "n_1952_09" DOUBLE,
  "n_1952_10" DOUBLE,
  "n_1952_11" DOUBLE,
  "n_1952_12" DOUBLE,
  "n_1953_01" DOUBLE,
  "n_1953_02" DOUBLE,
  "n_1953_03" DOUBLE,
  "n_1953_04" DOUBLE,
  "n_1953_05" DOUBLE,
  "n_1953_06" DOUBLE,
  "n_1953_07" DOUBLE,
  "n_1953_08" DOUBLE,
  "n_1953_09" DOUBLE,
  "n_1953_10" DOUBLE,
  "n_1953_11" DOUBLE,
  "n_1953_12" DOUBLE,
  "n_1954_01" DOUBLE,
  "n_1954_02" DOUBLE,
  "n_1954_03" DOUBLE,
  "n_1954_04" DOUBLE,
  "n_1954_05" DOUBLE,
  "n_1954_06" DOUBLE,
  "n_1954_07" DOUBLE,
  "n_1954_08" DOUBLE,
  "n_1954_09" DOUBLE,
  "n_1954_10" DOUBLE,
  "n_1954_11" DOUBLE,
  "n_1954_12" DOUBLE,
  "n_1955_01" DOUBLE,
  "n_1955_02" DOUBLE,
  "n_1955_03" DOUBLE,
  "n_1955_04" DOUBLE,
  "n_1955_05" DOUBLE,
  "n_1955_06" DOUBLE,
  "n_1955_07" DOUBLE,
  "n_1955_08" DOUBLE,
  "n_1955_09" DOUBLE,
  "n_1955_10" DOUBLE,
  "n_1955_11" DOUBLE,
  "n_1955_12" DOUBLE,
  "n_1956_01" DOUBLE,
  "n_1956_02" DOUBLE,
  "n_1956_03" DOUBLE,
  "n_1956_04" DOUBLE,
  "n_1956_05" DOUBLE,
  "n_1956_06" DOUBLE,
  "n_1956_07" DOUBLE,
  "n_1956_08" DOUBLE,
  "n_1956_09" DOUBLE,
  "n_1956_10" DOUBLE,
  "n_1956_11" DOUBLE,
  "n_1956_12" DOUBLE,
  "n_1957_01" DOUBLE,
  "n_1957_02" DOUBLE,
  "n_1957_03" DOUBLE,
  "n_1957_04" DOUBLE,
  "n_1957_05" DOUBLE,
  "n_1957_06" DOUBLE,
  "n_1957_07" DOUBLE,
  "n_1957_08" DOUBLE,
  "n_1957_09" DOUBLE,
  "n_1957_10" DOUBLE,
  "n_1957_11" DOUBLE
);

Meat Production And Foreign Trade - Head - Monthly Data - Unpivoted

@eurostat.apro_mt_pheadm.tidy

2.55 MB
1153637 rows
7 columns


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