Name: USDA Production Supply And Distribution - Complete
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

USDA Production Supply And Distribution - Complete

This dataset contains basic information about soft commodities (mostly agricultural) production, supply and distribution.

The most interesting part of this dataset is that it contains not only the latest numbers but also all the revisions USDA released for a specific Country/Commodity/Attribute/Year combination. This reflects their point of view on how large events impacted these production, supply and distribution numbers.

Questions you may answer with this dataset:

How much Coffee Brazil exported in an yearly basis between 1990 until 2021?
How the USDA changed their estimations for India 2020 Cotton production across 2019-2021?
Did Corn yearly consumption raised in the U.S. between 1990 and 1999? And between 2000 and 2010?
These questions are answered with code examples, check them out

To make things interesting, try to cross this data with weather forecasts and large geopolitic events (sanctions, embargos, etc.) and specific consumption trends (e.g. Corn to make biofuel)

Tables

Final

@kaggle.jeffersongranado_usdapsd.final

61.95 MB
9,402,563 rows
9 columns

CREATE TABLE final (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "commodity_description" VARCHAR,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "year" BIGINT,
  "attribute_description" VARCHAR,
  "unit_description" VARCHAR,
  "value" DOUBLE,
  "seen_on" BIGINT
);