Daily Consumption Of Fruit And Vegetables By Sex, Age And Income Quintile

Eurostat code: hlth_ehis_fv3i · (2014 - 2019)

@eurostat.hlth_ehis_fv3i

Table List

2 tables(180.23 KB)

Daily Consumption Of Fruit And Vegetables By Sex, Age And Income Quintile - Raw

Daily Consumption Of Fruit And Vegetables By Sex, Age And Income Quintile - Unpivoted

Daily Consumption Of Fruit And Vegetables By Sex, Age And Income Quintile - Unpivoted

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

86.35 KB
57213 rows
9 columns

freq Freq	unit Unit	n_portion N Portion	quant_inc Quant Inc	sex Sex	age Age	geo Geo	time_period Time Period	value Value
Annual	Percentage	0 portions	First quintile	Females	Total	Austria	2014	22.3
Annual	Percentage	0 portions	First quintile	Females	Total	Belgium	2014	17.2
Annual	Percentage	0 portions	First quintile	Females	Total	Bulgaria	2014	73.1
Annual	Percentage	0 portions	First quintile	Females	Total	Cyprus	2014	38.7
Annual	Percentage	0 portions	First quintile	Females	Total	Czechia	2014	48
Annual	Percentage	0 portions	First quintile	Females	Total	Germany	2014	41.2
Annual	Percentage	0 portions	First quintile	Females	Total	Denmark	2014	34.1
Annual	Percentage	0 portions	First quintile	Females	Total	Estonia	2014	41.3
Annual	Percentage	0 portions	First quintile	Females	Total	Greece	2014	29.8
Annual	Percentage	0 portions	First quintile	Females	Total	Spain	2014	29.9


CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "n_portion" VARCHAR,
  "quant_inc" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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