Data Warehouse Knowledge Base
Data Warehouse Knowledge Base
Breadcrumbs

Population Indicator

The FEWS NET Data Warehouse (FDW) stores population estimates and census values in the Population Indicator data domain.

This page covers the process for uploading the custom country population estimates that are used for the population in need (PIN) estimates included in the Food Assistance Outlook Briefing (FAOB). Typically these numbers are revised once per year, but may be updated sooner as needed.

These population estimates are stored within the Surveys metadata as Internal population estimates for FEWS NET analysis with Annual schedule.

For more information on preparing FAOB data, see the guidance for Acutely Food Insecure Population Estimates.

Uploading FEWS NET population estimates

Template guidelines

The template contains all necessary metadata and columns, required for data upload.
Only the following columns, highlighted in yellow in the template, need to be filled in:

  • fnid: Two-letter ISO country code. The data is loaded on the country level, therefore only a country needs to be provided.

  • start_date: Start date of the period for which the population is estimated.

    • The period_date column uses a formula based on the start_date. Drag down the fill handle to create new rows.

  • value: Estimated number of people.

  • description: Optional field that allows to add information about how the population was estimated, e.g. “Landscan population adjusted by conflict and displacement data.”

Do not remove any columns or change column headers, as this will cause the upload to fail. The population_group and dominant_livelihood_zone columns need to present in the template but can remain empty.

Uploading and publishing population estimates

Follow the steps below to upload the completed template and publish the data:

  1. Navigate to https://fdw.fews.net/en/admin/survey/populationindicatorvalue/import/.

  2. Choose the upload file.

  3. Select the format xlsx.

  4. Click Submit button. This will create both Data Series (if necessary) and Data Points defined in the upload file.

  5. Navigate to https://fdw.fews.net/en/admin/warehouse/datacollection/?data_domain=PopulationIndicator.

  6. Use the checkboxes to select the Data Collection(s) from the table. They should have a Submitted status.

  7. Select the Publish option from the Action dropdown.