Concentration distributions data formats

Concentration distributions describe substance concentrations on foods in the form of summary statistics. These distributions can be characterised by a mean and a dispersion factor, the standard deviation or, preferably, a percentile point e.g. p95.

Download empty dataset template: Zipped CSV Excel

Concentration distributions

Substance concentrations on foods specified in the form of summary statistics.

Accepted table names: ConcentrationDistributions, ConcentrationDistribution.

Table 50 Table definition for Concentration distributions.
Name Type Description Aliases Required

idFood

AlphaNumeric (50)

Food code, the raw agricultural commodity.

idFood

Yes

idSubstance

AlphaNumeric (50)

The code of the substance.

idSubstance, SubstanceId, SubstanceCode, Substance

Yes

Mean

Numeric

The mean of (monitoring) samples, on the original scale (in mg/kg).

Mean

Yes

CV

Numeric

Coefficient of variation, for samples of the size of the TDS pooled amount.

CV

No

Percentile

Numeric

The percentile at the point specified by the percentage.

Percentile

No

Percentage

Numeric

The percentage that belongs to the given the percentile, e.g., 95 (in mg/kg).

Percentage

No

Limit

Numeric

The specified norm value or limit value (in mg/kg).

Limit

No

ConcentrationUnit

ConcentrationUnit

The unit of the limit value (default mg/kg).

ConcentrationUnit, Unit

No