Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

About the

...

data

Commodity balances show the balance of staple foods. The purpose of this domain is to show the consumption, import, and export of these staple foods for each country. 

...

Info

The Hub uploads Historical Commodity Balance Sheet data. If users have questions about this domain or run into issues with uploading or exporting data, please submit a helpdesk ticket with a detailed description of the issue and the path taken to arrive at the issue. 

Data

...

upload process

Preparing

...

data for

...

upload

Each file should contain the following columns or their equivalent names at a minimum: 

...

  • 1000 t for weight units (indicators like Net Supply, Export, Requirements etc.)

  • Percent for indicators Self-Sufficiency and Stock to Use

  • Person for Population indicator

  • 1 kg for Consumption per capita per year

Importing

...

commodity balance sheet data

Commodity balance sheet data must be uploaded twice: under Commodity Balances and Commodity Balance Values.

  1. Go to Dataseries Management > Commodity Balances > Commodity Balances.

  2. Click Import Commodity Balances.

  3. Click Choose File and select your spreadsheet to load the file.

  4. Click Submit and the file will be in draft status. 

  5. Go to Dataseries Management > Data Points > Commodity Balance Values.

  6. Click Import Commodity Balance Values.

  7. Click Choose File and select the same spreadsheet to load the file.

  8. Click Submit and the file will be in draft status. 

Accessing

...

commodity balance sheet data

There are four endpoints that allow retrieving Commodity Balance data:

...