FoodRisk.org

Methods and Data

The Produce Point of Origin Database(PPOD) is based on data collected by United States Department of Agriculture - Agriculture Marketing Service(USDA/AMS). It is publically available via the USDA/AMS "Fruit & Vegatble" Market News Portal.


Original Data Structure

The data used for PPOD is gathered from a custom movement report on USDA/AMS's Fruits and Vegatble portal. The report is generated by commodity and aggregated by month. The fields "Package Description","District Name" and "Season" are not used.

USDA/AMS Table Data Structure

Commodity Name Origin Name Type Package Description Variety Name Date Total Weight Sum Disctict Name Season Transportation Mode Import Export Flag Environment
Apple Appalachia Organic BINS 24 INCH MCINTOSH 07/01/1998 1220000.0 APPALACHIAN DISTRICT 1998 Truck D Greenhouse

Generalized Names

The generalized names PPOD uses for the commodities were hand selected by experts and matched to their appropriate results in the USDA/AMS database. The following table shows a complete list of the associations.

Note: USDA/AMS Names used are according the standard found in the Daily Movement Report on the USDA/AMS Portal. This naming convention combines Commodity Name, Type, and Environment into one field.

Arugula (USDA/AMS Name,USDA/AMS Variety)
MISC HERBS ARRUGULA
MISC HERBS-GREENHOUSE ARRUGULA
Avocado (USDA/AMS Name,USDA/AMS Variety)
AVOCADOS Not Specified
AVOCADOS HASS
AVOCADOS-ORGANIC HASS
AVOCADOS-ORGANIC Not Specified
AVOCADOS VARIOUS GREENSKIN VARIETIES
Basil (USDA/AMS Name,USDA/AMS Variety)
MISC HERBS BASIL
MISC HERBS-ORGANIC BASIL
MISC HERBS-GREENHOUSE BASIL
Blackberry (USDA/AMS Name,USDA/AMS Variety)
BLACKBERRIES Not Specified
BLACKBERRIES-ORGANIC Not Specified
Blueberry (USDA/AMS Name,USDA/AMS Variety)
BLUEBERRIES Not Specified
BLUEBERRIES-ORGANIC Not Specified
Cabbage (USDA/AMS Name,USDA/AMS Variety)
CABBAGE ROUND GREEN TYPE
CABBAGE SAVOY TYPE
Cantaloupe (USDA/AMS Name,USDA/AMS Variety)
CANTALOUPS Not Specified
CANTALOUPS ATHENA TYPE
CANTALOUPS TUSCAN TYPE
CANTALOUPS-ORGANIC Not Specified
Celery (USDA/AMS Name,USDA/AMS Variety)
CELERY Not Specified
CELERY HEARTS
CELERY-ORGANIC Not Specified
CELERY-ORGANIC HEARTS
CELERY-GREENHOUSE Not Specified
Cilantro (USDA/AMS Name,USDA/AMS Variety)
MISC HERBS CILANTRO
MISC HERBS-ORGANIC CILANTRO
MISC HERBS-GREENHOUSE CILANTRO
Cucumber (USDA/AMS Name,USDA/AMS Variety)
CUCUMBERS Not Specified
CUCUMBERS LONG SEEDLESS
CUCUMBERS PERSIAN
CUCUMBERS-ORGANIC Not Specified
CUCUMBERS-GREENHOUSE Not Specified
CUCUMBERS-GREENHOUSE LONG SEEDLESS
CUCUMBERS-GREENHOUSE PERSIAN
CUCUMBERS PICKLES
CUCUMBERS-GREENHOUSE PICKLES
Green Grapes (USDA/AMS Name,USDA/AMS Variety)
GRAPES PERLETTE
GRAPES PRINCESS
GRAPES SUGRAONE
GRAPES THOMPSON SEEDLESS
GRAPES WHITE SEEDLESS TYPE
GRAPES-ORGANIC PERLETTE
GRAPES-ORGANIC SUGRAONE
Green Onion (USDA/AMS Name,USDA/AMS Variety)
ONIONS GREEN LEEKS
ONIONS GREEN Not Specified
ONIONS GREEN BULB TYPE
Honeydew Melon (USDA/AMS Name,USDA/AMS Variety)
HONEYDEWS Not Specified
HONEYDEWS-ORGANIC Not Specified
Jalapeno Pepper (USDA/AMS Name,USDA/AMS Variety)
PEPPERS, OTHER JALAPENO
Kale (USDA/AMS Name,USDA/AMS Variety)
KALE GREENS Not Specified
KALE GREENS-ORGANIC Not Specified
Lettuce (Iceberg) (USDA/AMS Name,USDA/AMS Variety)
LETTUCE, ICEBERG Not Specified
Lettuce (Romaine) (USDA/AMS Name,USDA/AMS Variety)
LETTUCE, ROMAINE Not Specified
LETTUCE, ROMAINE HEARTS
LETTUCE, ROMAINE CROWN CUT LEAVES
LETTUCE, ROMAINE-ORGANIC Not Specified
Mango (USDA/AMS Name,USDA/AMS Variety)
MANGOES Not Specified
Nectarine (USDA/AMS Name,USDA/AMS Variety)
NECTARINES Not Specified
Papaya (USDA/AMS Name,USDA/AMS Variety)
PAPAYA Not Specified
Parsley (USDA/AMS Name,USDA/AMS Variety)
PARSLEY Not Specified
PARSLEY CURLY
PARSLEY PLAIN
PARSLEY-GREENHOUSE Not Specified
PARSLEY ROOT
Peach (USDA/AMS Name,USDA/AMS Variety)
PEACHES Not Specified
PEACHES-ORGANIC Not Specified
Plum (USDA/AMS Name,USDA/AMS Variety)
PLUMS Not Specified
PLUMS INTERSPECIFIC TYPE
PLUMS VARIOUS VARIETIES
Raspberry (USDA/AMS Name,USDA/AMS Variety)
RASPBERRIES Not Specified
RASPBERRIES-ORGANIC Not Specified
Serrano Peppers (USDA/AMS Name,USDA/AMS Variety)
PEPPERS, OTHER SERRANO
Snow Peas (USDA/AMS Name,USDA/AMS Variety)
PEAS GREEN SNOW PEAS
Spinach (USDA/AMS Name,USDA/AMS Variety)
SPINACH Not Specified
SPINACH-GREENHOUSE Not Specified
Strawberry (USDA/AMS Name,USDA/AMS Variety)
STRAWBERRIES Not Specified
STRAWBERRIES CHANDLER
STRAWBERRIES WITH STEMS
STRAWBERRIES-ORGANIC Not Specified
Tomato (USDA/AMS Name,USDA/AMS Variety)
TOMATOES MATURE GREENS
TOMATOES VINE RIPES
TOMATOES Not Specified
TOMATOES-ORGANIC Not Specified
TOMATOES-ORGANIC MATURE GREENS
TOMATOES-GREENHOUSE Not Specified
TOMATOES-OPEN FIELD Not Specified
TOMATOES-ADAPTED ENVIRONMENT Not Specified
TOMATOES-ORGANIC-GREENHOUSE Not Specified
TOMATOES-ORGANIC-OPEN FIELD Not Specified
TOMATOES-GREENHOUSE MATURE GREENS
TOMATOES-OPEN FIELD MATURE GREENS
Tomato (Grape) (USDA/AMS Name,USDA/AMS Variety)
TOMATOES, GRAPE TYPE Not Specified
TOMATOES, GRAPE TYPE-GREENHOUSE Not Specified
TOMATOES, GRAPE TYPE-OPEN FIELD Not Specified
TOMATOES, GRAPE TYPE-ADAPTED ENVIRONMENT Not Specified
TOMATOES, GRAPE TYPE-ORGANIC Not Specified
TOMATOES, GRAPE TYPE-ORGANIC-ADAPTED ENVIRONMENT Not Specified
Tomato (Red Round) (USDA/AMS Name,USDA/AMS Variety)
TOMATOES-ORGANIC Not Specified
TOMATOES-ORGANIC MATURE GREENS
TOMATOES-GREENHOUSE Not Specified
TOMATOES-OPEN FIELD Not Specified
TOMATOES-ADAPTED ENVIRONMENT Not Specified
TOMATOES-ORGANIC-GREENHOUSE Not Specified
TOMATOES-ORGANIC-OPEN FIELD Not Specified
TOMATOES-GREENHOUSE MATURE GREENS
TOMATOES-OPEN FIELD MATURE GREENS
Tomato (Roma) (USDA/AMS Name,USDA/AMS Variety)
TOMATOES, PLUM TYPE ROMA
TOMATOES, PLUM TYPE-ORGANIC ROMA
TOMATOES, PLUM TYPE Not Specified
TOMATOES, PLUM TYPE-ADAPTED ENVIRONMENT Not Specified
TOMATOES, PLUM TYPE-GREENHOUSE Not Specified
TOMATOES, PLUM TYPE-OPEN FIELD Not Specified
TOMATOES, PLUM TYPE-ORGANIC Not Specified

Final Product

Records with the same name, variety, location, year, month and transport type are grouped into one row with their "Total Weight Sum" field summed together. The resulting sum is then rounded to the nearest integer (as per scale.)