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-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 |
| LETTUCE-ROMAINE | HEARTS |
| LETTUCE-ROMAINE | Not Specified |
| LETTUCE-ROMAINE | CROWN CUT LEAVES |
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.)