Occurrence frequencies data formats

Occurrence frequencies are described by one simple table, specifying for pairs of food and substance, the associated occurrence frequencies as percentages.

Download empty dataset template: Zipped CSV Excel

Occurrence frequencies

Occurrence frequencies are specified as percentages for pairs of food and substance. Optionally, a reference can be included in each record to specify the source (e.g., from literature) from which the percentage was obtained.

Accepted table names: OccurrenceFrequencies.

Table 103 Table definition for Occurrence frequencies.
Name Type Description Aliases Required

idFood

AlphaNumeric (50)

The food code.

idFood, CodeFood, FoodId, FoodCode, Food

Yes

idSubstance

AlphaNumeric (50)

Code of the substance.

idSubstance, CodeSubstance, SubstanceId, SubstanceCode, Substance

Yes

Percentage

Numeric

The occurrence frequency percentage.

Percentage, FrequencyPercentage

Yes

Reference

AlphaNumeric (200)

Reference to the source from which this use frequency value is obtained.

Reference, References, Source, Sources

No