Frequency Of Fruit And Vegetables Consumption By Sex, Age And Body Mass Index

Eurostat code: hlth_ehis_fv1m · (2019 - 2019)

@eurostat.hlth_ehis_fv1m

Table List

2 tables(169.96 KB)

Frequency Of Fruit And Vegetables Consumption By Sex, Age And Body Mass Index - Raw

Frequency Of Fruit And Vegetables Consumption By Sex, Age And Body Mass Index - Unpivoted

Frequency Of Fruit And Vegetables Consumption By Sex, Age And Body Mass Index - Unpivoted

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

85.63 KB
58167 rows
10 columns

freq Freq	unit Unit	frequenc Frequenc	coicop Coicop	sex Sex	age Age	bmi Bmi	geo Geo	time_period Time Period	value Value
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Austria	2019	18.5
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Belgium	2019	15.2
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Bulgaria	2019	22.3
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Cyprus	2019	14.6
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Czechia	2019	16.1
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Germany	2019	12.3
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Denmark	2019	16.1
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Estonia	2019	16.2
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Greece	2019	20.5
Annual	Percentage	From 1 to 3 times a week	Fruit	Females	Total	Normal	Spain	2019	14.1


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "frequenc" VARCHAR,
  "coicop" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "bmi" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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