US Department of Agriculture (USDA)

Overview

The US Department of Agriculture (USDA) publishes data that offers insights into global agricultural commodity production, supply, and distribution (PSD) figures for the United States and other key producing and consuming countries. Managed by the USDA's Foreign Agricultural Service (FAS), the data covers a range of commodities including grains, oilseeds, fruits, and vegetables.

Example topics covered:

  • Production

  • Imports

  • Exports

  • Consumption

Additionally, the USDA's weekly US Export Sales Report (ESR) provides export sales activity for 40+ US agricultural commodities sold abroad. The weekly ESR is the most current source of US export sales data.

Example topics covered:

  • Weekly and accumulated exports

  • Outstanding and gross new sales

  • Total commitments

Key Attributes

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

The PSD dataset details parameters such as area harvested, production, imports, exports, and consumption for each commodity, covering both calendar years (running from January 1st to December 31st) and marketing years. Marketing years typically begin in the month when the harvest of a particular crop starts and end before the beginning of the next year's harvest. This period can vary significantly among different crops and countries, depending on when these crops are sown and harvested. The specific starting month of the marketing year for each crop is essential because it affects how production, stocks, and trade are accounted for and compared year-over-year. Marketing years are used to better align the supply and demand statistics of a commodity with its normal production cycle.

The international portion of the data is updated with input from agricultural attachΓ©s stationed at U.S. embassies around the world, FAS commodity analysts, and country and commodity analysts with the USDA's Economic Research Service (ERS). The U.S. domestic data is updated with input from analysts in FAS, ERS, the National Agricultural Statistical Service, and USDA's Farm Service Agency (FSA).

The USDA's Export Sales Reporting (ESR) data provides weekly updates on the export sales activity of major commodities, further enhancing the understanding of market dynamics within defined marketing years and giving an indication of the potential impact foreign sales may have on US supplies and prices.

USDA ESR Resources: Definitions and FAQs published by the USDA.

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

Cybersyn Products

Tables above are available in the following Cybersyn data products:

Examples & Sample Queries

Commodity production data by country over time.

Determine how olive oil production is changing over time by country by market year.

SELECT
    geo.geo_name,
    ts.date,
    ts.value,
    ts.unit
FROM cybersyn.us_department_of_agriculture_commodities_timeseries AS ts
JOIN cybersyn.geography_index AS geo
  ON ts.geo_id = geo.geo_id
WHERE ts.variable_name = 'Olive Oil: Production';

Disclaimers

The data in this product is sourced from US Department of Agriculture (USDA).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact support@cybersyn.com for questions.

Last updated

Copyright Β© 2024 Cybersyn