Dataset: Poultry - Monthly Data

About this Dataset

Poultry - Monthly Data

This Eurostat dataset contains data on poultry - 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

Poultry - Monthly Data - Raw

@eurostat.apro_ec_poulm.raw

2.01 MB
2693 rows
705 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "hatchitm" VARCHAR,
  "animals" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1967_01" DOUBLE,
  "n_1967_02" DOUBLE,
  "n_1967_03" DOUBLE,
  "n_1967_04" DOUBLE,
  "n_1967_05" DOUBLE,
  "n_1967_06" DOUBLE,
  "n_1967_07" DOUBLE,
  "n_1967_08" DOUBLE,
  "n_1967_09" DOUBLE,
  "n_1967_10" DOUBLE,
  "n_1967_11" DOUBLE,
  "n_1967_12" DOUBLE,
  "n_1968_01" DOUBLE,
  "n_1968_02" DOUBLE,
  "n_1968_03" DOUBLE,
  "n_1968_04" DOUBLE,
  "n_1968_05" DOUBLE,
  "n_1968_06" DOUBLE,
  "n_1968_07" DOUBLE,
  "n_1968_08" DOUBLE,
  "n_1968_09" DOUBLE,
  "n_1968_10" DOUBLE,
  "n_1968_11" DOUBLE,
  "n_1968_12" DOUBLE,
  "n_1969_01" DOUBLE,
  "n_1969_02" DOUBLE,
  "n_1969_03" DOUBLE,
  "n_1969_04" DOUBLE,
  "n_1969_05" DOUBLE,
  "n_1969_06" DOUBLE,
  "n_1969_07" DOUBLE,
  "n_1969_08" DOUBLE,
  "n_1969_09" DOUBLE,
  "n_1969_10" DOUBLE,
  "n_1969_11" DOUBLE,
  "n_1969_12" DOUBLE,
  "n_1970_01" DOUBLE,
  "n_1970_02" DOUBLE,
  "n_1970_03" DOUBLE,
  "n_1970_04" DOUBLE,
  "n_1970_05" DOUBLE,
  "n_1970_06" DOUBLE,
  "n_1970_07" DOUBLE,
  "n_1970_08" DOUBLE,
  "n_1970_09" DOUBLE,
  "n_1970_10" DOUBLE,
  "n_1970_11" DOUBLE,
  "n_1970_12" DOUBLE,
  "n_1971_01" DOUBLE,
  "n_1971_02" DOUBLE,
  "n_1971_03" DOUBLE,
  "n_1971_04" DOUBLE,
  "n_1971_05" DOUBLE,
  "n_1971_06" DOUBLE,
  "n_1971_07" DOUBLE,
  "n_1971_08" DOUBLE,
  "n_1971_09" DOUBLE,
  "n_1971_10" DOUBLE,
  "n_1971_11" DOUBLE,
  "n_1971_12" DOUBLE,
  "n_1972_01" DOUBLE,
  "n_1972_02" DOUBLE,
  "n_1972_03" DOUBLE,
  "n_1972_04" DOUBLE,
  "n_1972_05" DOUBLE,
  "n_1972_06" DOUBLE,
  "n_1972_07" DOUBLE,
  "n_1972_08" DOUBLE,
  "n_1972_09" DOUBLE,
  "n_1972_10" DOUBLE,
  "n_1972_11" DOUBLE,
  "n_1972_12" DOUBLE,
  "n_1973_01" DOUBLE,
  "n_1973_02" DOUBLE,
  "n_1973_03" DOUBLE,
  "n_1973_04" DOUBLE,
  "n_1973_05" DOUBLE,
  "n_1973_06" DOUBLE,
  "n_1973_07" DOUBLE,
  "n_1973_08" DOUBLE,
  "n_1973_09" DOUBLE,
  "n_1973_10" DOUBLE,
  "n_1973_11" DOUBLE,
  "n_1973_12" DOUBLE,
  "n_1974_01" DOUBLE,
  "n_1974_02" DOUBLE,
  "n_1974_03" DOUBLE,
  "n_1974_04" DOUBLE,
  "n_1974_05" DOUBLE,
  "n_1974_06" DOUBLE,
  "n_1974_07" DOUBLE,
  "n_1974_08" DOUBLE,
  "n_1974_09" DOUBLE,
  "n_1974_10" DOUBLE,
  "n_1974_11" DOUBLE
);

Poultry - Monthly Data - Unpivoted

@eurostat.apro_ec_poulm.tidy

1.24 MB
593695 rows
7 columns


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