Baselight

Cows'milk Collection And Products Obtained - Monthly Data

Eurostat code: apro_mk_colm ยท (1968-01 - 2025-09)

@eurostat.apro_mk_colm

Loading...
Loading...

About this Dataset

Cows'milk Collection And Products Obtained - Monthly Data

This Eurostat dataset contains data on cows'milk collection and products obtained - 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-11-03T23:00:00+0100

Tables

Cows'milk Collection And Products Obtained - Monthly Data - Raw

@eurostat.apro_mk_colm.raw
  • 1.26 MB
  • 571 rows
  • 698 columns
Loading...
CREATE TABLE raw (
  "freq" VARCHAR,
  "milkitem" VARCHAR,
  "dairyprod" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_1968_01" DOUBLE  -- 1968-01,
  "n_1968_02" DOUBLE  -- 1968-02,
  "n_1968_03" DOUBLE  -- 1968-03,
  "n_1968_04" DOUBLE  -- 1968-04,
  "n_1968_05" DOUBLE  -- 1968-05,
  "n_1968_06" DOUBLE  -- 1968-06,
  "n_1968_07" DOUBLE  -- 1968-07,
  "n_1968_08" DOUBLE  -- 1968-08,
  "n_1968_09" DOUBLE  -- 1968-09,
  "n_1968_10" DOUBLE  -- 1968-10,
  "n_1968_11" DOUBLE  -- 1968-11,
  "n_1968_12" DOUBLE  -- 1968-12,
  "n_1969_01" DOUBLE  -- 1969-01,
  "n_1969_02" DOUBLE  -- 1969-02,
  "n_1969_03" DOUBLE  -- 1969-03,
  "n_1969_04" DOUBLE  -- 1969-04,
  "n_1969_05" DOUBLE  -- 1969-05,
  "n_1969_06" DOUBLE  -- 1969-06,
  "n_1969_07" DOUBLE  -- 1969-07,
  "n_1969_08" DOUBLE  -- 1969-08,
  "n_1969_09" DOUBLE  -- 1969-09,
  "n_1969_10" DOUBLE  -- 1969-10,
  "n_1969_11" DOUBLE  -- 1969-11,
  "n_1969_12" DOUBLE  -- 1969-12,
  "n_1970_01" DOUBLE  -- 1970-01,
  "n_1970_02" DOUBLE  -- 1970-02,
  "n_1970_03" DOUBLE  -- 1970-03,
  "n_1970_04" DOUBLE  -- 1970-04,
  "n_1970_05" DOUBLE  -- 1970-05,
  "n_1970_06" DOUBLE  -- 1970-06,
  "n_1970_07" DOUBLE  -- 1970-07,
  "n_1970_08" DOUBLE  -- 1970-08,
  "n_1970_09" DOUBLE  -- 1970-09,
  "n_1970_10" DOUBLE  -- 1970-10,
  "n_1970_11" DOUBLE  -- 1970-11,
  "n_1970_12" DOUBLE  -- 1970-12,
  "n_1971_01" DOUBLE  -- 1971-01,
  "n_1971_02" DOUBLE  -- 1971-02,
  "n_1971_03" DOUBLE  -- 1971-03,
  "n_1971_04" DOUBLE  -- 1971-04,
  "n_1971_05" DOUBLE  -- 1971-05,
  "n_1971_06" DOUBLE  -- 1971-06,
  "n_1971_07" DOUBLE  -- 1971-07,
  "n_1971_08" DOUBLE  -- 1971-08,
  "n_1971_09" DOUBLE  -- 1971-09,
  "n_1971_10" DOUBLE  -- 1971-10,
  "n_1971_11" DOUBLE  -- 1971-11,
  "n_1971_12" DOUBLE  -- 1971-12,
  "n_1972_01" DOUBLE  -- 1972-01,
  "n_1972_02" DOUBLE  -- 1972-02,
  "n_1972_03" DOUBLE  -- 1972-03,
  "n_1972_04" DOUBLE  -- 1972-04,
  "n_1972_05" DOUBLE  -- 1972-05,
  "n_1972_06" DOUBLE  -- 1972-06,
  "n_1972_07" DOUBLE  -- 1972-07,
  "n_1972_08" DOUBLE  -- 1972-08,
  "n_1972_09" DOUBLE  -- 1972-09,
  "n_1972_10" DOUBLE  -- 1972-10,
  "n_1972_11" DOUBLE  -- 1972-11,
  "n_1972_12" DOUBLE  -- 1972-12,
  "n_1973_01" DOUBLE  -- 1973-01,
  "n_1973_02" DOUBLE  -- 1973-02,
  "n_1973_03" DOUBLE  -- 1973-03,
  "n_1973_04" DOUBLE  -- 1973-04,
  "n_1973_05" DOUBLE  -- 1973-05,
  "n_1973_06" DOUBLE  -- 1973-06,
  "n_1973_07" DOUBLE  -- 1973-07,
  "n_1973_08" DOUBLE  -- 1973-08,
  "n_1973_09" DOUBLE  -- 1973-09,
  "n_1973_10" DOUBLE  -- 1973-10,
  "n_1973_11" DOUBLE  -- 1973-11,
  "n_1973_12" DOUBLE  -- 1973-12,
  "n_1974_01" DOUBLE  -- 1974-01,
  "n_1974_02" DOUBLE  -- 1974-02,
  "n_1974_03" DOUBLE  -- 1974-03,
  "n_1974_04" DOUBLE  -- 1974-04,
  "n_1974_05" DOUBLE  -- 1974-05,
  "n_1974_06" DOUBLE  -- 1974-06,
  "n_1974_07" DOUBLE  -- 1974-07,
  "n_1974_08" DOUBLE  -- 1974-08,
  "n_1974_09" DOUBLE  -- 1974-09,
  "n_1974_10" DOUBLE  -- 1974-10,
  "n_1974_11" DOUBLE  -- 1974-11,
  "n_1974_12" DOUBLE  -- 1974-12,
  "n_1975_01" DOUBLE  -- 1975-01,
  "n_1975_02" DOUBLE  -- 1975-02,
  "n_1975_03" DOUBLE  -- 1975-03,
  "n_1975_04" DOUBLE  -- 1975-04,
  "n_1975_05" DOUBLE  -- 1975-05,
  "n_1975_06" DOUBLE  -- 1975-06,
  "n_1975_07" DOUBLE  -- 1975-07,
  "n_1975_08" DOUBLE  -- 1975-08,
  "n_1975_09" DOUBLE  -- 1975-09,
  "n_1975_10" DOUBLE  -- 1975-10,
  "n_1975_11" DOUBLE  -- 1975-11
);

Cows'milk Collection And Products Obtained - Monthly Data - Unpivoted

@eurostat.apro_mk_colm.tidy
  • 431.48 kB
  • 151,611 rows
  • 7 columns
Loading...
CREATE TABLE tidy (
  "freq" VARCHAR,
  "milkitem" VARCHAR,
  "dairyprod" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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