Data Food groups

Food group

Last imported 03:05AM UTC on Tuesday, March 26, 2013. See log

Food groups (e.g. dairy).

We take the food groups used in the U.S. Department of Agriculture Economic Research Service (USDA ERS) Food Availability Data System (FADS). We calculate the emissions intensity of each food group by dividing the total U.S. emissions from that food group, taken from Weber & Matthews (2007), by the total calories consumed in the U.S. from that food group, taken from the USDA FADS, and applying a multiplier to account for the fact that the USDA ERS Loss-Adjusted Food data show that more food is available than people report eating. The energy for each food group allows users to specify consumption of different food groups in familiar units (e.g. eggs or ounces of meat) rather than kilocalories.

Citing this data

To cite this data, reference Brighter Planet, "Food groups," <http://data.brighterplanet.com/food_groups>, retrieved 2013-05-18 15:57:41 UTC.

Download

Total: 10 records.

Random data sample

Sample: 5 records.

name intensity intensity units energy energy units suggested imperial measurement
cereals_and_grains 2.9 grams_per_kilocalorie 81.3 unknown ounces
dairy 6.48 grams_per_kilocalorie 83.87 unknown ounces
eggs 5.77 grams_per_kilocalorie 100.0 unknown eggs
fish 7.64 grams_per_kilocalorie 33.96 unknown ounces
fruit 5.46 grams_per_kilocalorie 101.11 unknown cups

Import steps

Click a step for more detail.

  1. Import a list of food groups and their emissions intensities

    1. Fetch data from static.brighterplanet.com.
    2. Store
      • name
      • intensity
      .

  2. Import energy and units

    1. Fetch data from spreadsheets.google.com.
    2. Store
      • name
      • energy
      • suggested_imperial_measurement
      .

Table structure

CREATE TABLE food_groups
  (
     name                           CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     intensity                      FLOAT,
     intensity_units                CHARACTER VARYING(255),
     energy                         FLOAT,
     energy_units                   CHARACTER VARYING(255),
     suggested_imperial_measurement CHARACTER VARYING(255)
  );