Single value consumptions data formats

Single value consumptions data provides a single per-individual-day and per-food consumption amount for a population. Also the bodyweight should be specified, and optionally also age, sex, and other properties may be recorded. The consumption amounts are usually expressed in grams, but may also be expressed in alternative units of plates, cups, or spoons. Optionally, the uncertainty of food consumption quantifications can be specified, see Souverein et al. (2011).

Single value consumptions are described using one table: PopulationConsumptionSingleValues.

Download empty dataset template: Zipped CSV Excel

Population consumption single values

Population consumption single values describe population food consumptions in the form of single value statistics.

Accepted table names: ConsumptionSingleValues, SingleValueConsumptions, PopulationConsumptionSingleValues, PopulationConsumptionValues.

Table 52 Table definition for Population consumption single values.
Name Type Description Aliases Required

idPopulation

AlphaNumeric (50)

Unique identification code of the population.

IdPopulation, PopulationId

Yes

idFood

AlphaNumeric (50)

The unique identification code of the consumed food.

idFood, FoodCode, Food

Yes

Value type of the single value consumption amount.

ConsumptionValueType

The value type of this consumption value.

ConsumptionType, ValueType, ConsumptionValueType, ConsumptionSingleValueType

Yes

Percentile

Numeric

The percentile (if consumption value type is a percentile).

Percentile

No

ConsumptionAmount

Numeric

The consumed amount.

Amount, Consumption, ConsumptionAmount, AmountConsumed

Yes

ConsumptionUnit

ConsumptionIntakeUnit

The unit of the consumption amount.

AmountUnit, UnitAmount, ConsumptionUnit

No

Reference

AlphaNumeric (200)

Reference to the source from which this value is obtained.

Reference, References, Source, Sources

No