Overview
This official Health Canada dataset is the published Total Diet Study trace-element results file for 1993 to 2018, released on the Open Government Portal under the Open Government Licence - Canada. The deposit is a comma-separated values file together with an English data dictionary. There is no PDF occurrence report in the deposit. This page describes what the dataset contains. It does not invent summary means, medians, or detection rates.
The results file has 57,331 data rows after the header and 165 unique values in the Food Name field. Every row uses nanograms per gram (ng/g) as the unit of measurement. The data dictionary defines Food Name as the specific non-branded food name, and Result Operator as the qualifier for the numerical result (equal to the reported value, less than the limit of detection or method detection limit, or not detected, as set out in the dictionary). In this file, 50,273 rows have Result Operator ”=”, and 7,058 rows have Result Operator “<LOD/MDL”.
Fields and coverage
The CSV header includes Food Name, Sample Code, Product Description, Food Group, Country of Origin, sample type and subsample fields, sample comments, Sample Collection Date, sampling location fields, laboratory and method fields, Result Operator, Result Value, Units of measurement, Analyte Name, Analyte Group, LOD, basis and quality-assurance fields, and project and organisation fields.
Analyte Name values present in the file, with row counts, are: Aluminum (Al), 2566; Barium (Ba), 2566; Bismuth (Bi), 2566; Cesium (Cs), 2566; Cobalt (Co), 2566; Copper (Cu), 2566; Lanthanum (La), 2566; Lead (Pb), 2566; Manganese (Mn), 2566; Rubidium (Rb), 2566; Strontium (Sr), 2566; Thallium (Tl), 2566; Zinc (Zn), 2566; Beryllium (Be), 2429; Cadmium (Cd), 2429; Nickel (Ni), 2429; Thorium (Th), 2429; Uranium (U), 2429; Arsenic (As), 1862; Selenium (Se), 1720; Chromium (Cr), 1112; Vanadium (V), 1112; Molybdenum (Mo), 616; Yttrium (Y), 616; Antimony (Sb), 479; Cerium (Ce), 479; Gallium (Ga), 479; Iron (Fe), 479; Lithium (Li), 479; Platinum (Pt), 479; Rhenium (Re), 479; Scandium (Sc), 479; Silver (Ag), 479; Tungsten (W), 479 rows across two label spellings (319 and 160). Mercury is not present as an analyte in this extract.
The official dataset title covers 1993 to 2018. Parsed Sample Collection Date values in the file run from 1999 to 2018 (17 calendar years). Some rows carry comments that sample collection was performed in multiple cities and provinces from 1993 to 1999, with a collection date recorded as 1999-12-31. Early-year composites should be read with that comment rather than treated as a 1999-only sample.
Named foods cited on this site
Food Name values used for citation on this site, with row counts in the file, include:
- Soya Beverage, fortified (250 rows), cited as the closest official matrix for plant milk
- Tomatoes, canned (376 rows), an exact canned-tomato item
- Apple Juice (376), Citrus Juice, Canned (376), Juice, Citrus Frozen Concentrate (376), Juice, Grape (376), Vegetable Juices (361), and Tomato Juice (15), cited as official fruit juice and ready-drink items
- Infant cereals, Mixed Grain Base (376), an exact mixed-grain infant cereal item
- Table Syrups (376), cited as the closest official matrix for pancake syrup (the food is table syrups, not labelled pancake syrup)
- Pork, other (752), cited as the closest official pork matrix (the food is not labelled pork chop)
- Beef Ground, Medium (376), an exact ground-beef item
Readers who need a concentration for a food and analyte should filter the official CSV by Food Name, Analyte Name, Result Operator, and Sample Collection Date, and should apply the data-dictionary definitions for qualifiers and units.
Limitations
This is a long-running surveillance extract, not a single-year mean table. Analyte coverage is not uniform: some elements have many more rows than others, and mercury is absent. Collection dates and the 1993 to 1999 comment must be read together. Table syrups and “Pork, other” are closest-matrix citations, not labelled pancake syrup or pork chop. Soya Beverage, fortified is a fortified soy drink, not a census of all plant milks. Values are in ng/g and should not be compared to milligram-per-kilogram tables without a unit conversion that the reader performs from the official figures.
Related evidence
- Lead
- Cadmium
- Arsenic
- Aluminum
- Plant milk base
- Canned tomatoes
- Fruit Juices, Non-Apple
- Infant Mixed Grain Cereal
- Tree and plant syrups (maple, agave, molasses)
- Meat and Poultry
- Ground beef
Update history
No substantive edit history is available in this build. The full commit record is available in git.
