Powdered Dairy Products - Distribution Of Enterprises By Volume Of Annual Production

Eurostat code: apro_mk_strpd · (1994 - 2021)

@eurostat.apro_mk_strpd

Table List

2 tables(27.02 KB)

Powdered Dairy Products - Distribution Of Enterprises By Volume Of Annual Production - Raw

Powdered Dairy Products - Distribution Of Enterprises By Volume Of Annual Production - Unpivoted

Powdered Dairy Products - Distribution Of Enterprises By Volume Of Annual Production - Unpivoted

@eurostat.apro_mk_strpd.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.79 KB
2244 rows
6 columns

freq Freq	indic_ag Indic Ag	volume Volume	geo Geo	time_period Time Period	value Value
Annual	Number of enterprises	From 1 001 to 5 000 t	Austria	1994	3
Annual	Number of enterprises	From 1 001 to 5 000 t	Belgium	1994	3
Annual	Number of enterprises	From 1 001 to 5 000 t	Germany	1994	11
Annual	Number of enterprises	From 1 001 to 5 000 t	Spain	1994
Annual	Number of enterprises	From 1 001 to 5 000 t	France	1994	10
Annual	Number of enterprises	From 1 001 to 5 000 t	Ireland	1994	3
Annual	Number of enterprises	From 1 001 to 5 000 t	Portugal	1994	4
Annual	Number of enterprises	From 1 001 to 5 000 t	Sweden	1994	3
Annual	Number of enterprises	From 1 001 to 5 000 t	United Kingdom	1994	4
Annual	Number of enterprises	From 5 001 to 20 000 t	Austria	1994	3


CREATE TABLE tidy (
  "freq" VARCHAR,
  "indic_ag" VARCHAR,
  "volume" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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