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:
Population consumption single values
Population consumption single values describe population food consumptions in the form of single value statistics.
Table aliases: ConsumptionSingleValues, SingleValueConsumptions, PopulationConsumptionSingleValues, PopulationConsumptionValues.
| 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 |