The Secondary Price Index (SPI) Indexes domain provides consumer price indices and other price indices not calculated by FEWS NET.
The SPI Secondary Price Indexes domain is broken into three sections:
1. Search and Filter
...
...
| title | Expand to learn about search and filter |
|---|
You can search by various criteria including:
Data source document: name and organization
Data series: name, description, and metadata
Learn more about search functionality in FDE.
You can filter the available data series using one or more of the following criteria:
...
Start date and End date:Filters data series by the
...
Start date: Returns all data series starting on or before this date.
...
period dates of all data points within the series. All data series with at least one data point that has a period date inside the date range will be displayed.
Data Series status: Filters data series by active or inactive status. Inactive Data Series have been marked by a data manager as no longer receiving new data. This may be because a change in the way the data is being collected (such as a new source or change in units) warranted starting a new Data Series, or because the data is no longer being collected.
Geographic: Filters by country.
Searching and/or applying filters creates a savable dataset. For more information on creating and saving datasets, see Create and Save Datasets.
2. Data Selection
...
...
| title | Expand to learn about data selection |
|---|
Once you have applied your search terms and filters, you will be presented with a list of all available data series that match your criteria. A data series is a collection of related data points from a single data source that are viewable as a single row within a table of data. They represent the change over time of a specific indicator. Data series are presented in table format where each row represents a single data series.
The
...
Secondary Price Indexes domain data selection table includes the following columns:
Name: Name of the data series.
Country: Country
...
for which the price index was reported.
Data source organization: The name of the organization that provided the data source document.
Data source document: The name of the document used as the primary source of information or data.
First: Period date for the first collection/reporting period in the data series.
Last: Period date for the last collection/reporting period in the data series.
Count: The number of data points in the data series.
Info: Hover over the information icon in a row to see more details including the data series ID, data source document, and data usage policy.
| Tip |
|---|
To visualize and export data, you will need to select one or more data series by checking the box at the beginning of the row containing that series. |
In addition to selecting data series, you can interact with the data selection table in the following ways:
Selected data series can be viewed in the Selected tab.
You can clear your selections using the Clear
...
Selection button.
By default the series are ordered alphabetically by country. You can click on the header of any column to sort by that column instead of by country.
3. Data Visualization and Export
| Expand | ||
|---|---|---|
| ||
Options within the Exchange Rate domain allow for aggregation or conversion of the trade data into reporting schedules and units of measures specified by the user. The available parameters are:
|
...
| title | Expand to learn about the Chart visualization |
|---|
Chart
...
Visualize
The Secondary Price Indexes domain currently includes Chart and Table visualizations.
| Note |
|---|
If you have selected dates in the filter section, these visualizations will only contain data points with an associated period date within the specified date range. Data points within the selected data series with a period date outside of the specified date range will not be displayed. |
The Chart tab in the Secondary Price Indexes domain displays a line graph where each data series is represented by a line of a different color. The chart plots the value of the price index (y-axis) against time (x-axis).
You can interact with the chart in the following ways:
Hover over a line to see more details including
...
specific values.
Single click on a legend item to exclude it from the graph.
...
Double click on a legend item to display only its trace.
Move the sliders in the
...
bar below the graph
...
to zoom in
...
or out, or use the zoom buttons above the graph
...
to
...
Click the pan icon in the top right to enable panning functionality. This will allow you to use your mouse to drag the graph left or right.
...
Click the autoscale icon in the top right to have the graph automatically select to the best period to display.
...
zoom to a specific length of time (e.g., 3 months or 5 years).
When zoomed in, drag the slider bar below the graph to change the time period you are viewing.
Click the download icon in the top right to download the chart
...
| title | Expand to learn about the Table visualization |
|---|
The Table tab for the SPI domain is organized by each column representing a reporting country. The rows provide the following metadata:
...
or
...
geographic_group: Grouping of countries or regions based on the United Nations Standard Country or Area Codes for Statistical (UN M49) Classifications.
...
country: Represents the national, dependent territory, or special area of geographical interest level administrative unit, standardized to ISO 3166 naming.
...
country_code: The ISO 3166-1 alpha-2 two letter code for a country.
...
geographic_unit: A geographic area or point such as a portion of a country or other region delineated for a specific purpose, such as an Administrative Unit (Province, District, County, etc.), Livelihood Zone, or Market.
...
index_name:
...
admin_1: Represents the first level administrative units.
...
admin_2: Represents the second level administrative units.
...
base_period_start:
...
base_period_end:
...
base_value:
...
start_date: The start date of a collection period. For monthly data, this is the first day of the month of the reporting period. For example, data from January 2021 have a start_date of January 1, 2021.
...
period_date: The last day of the collection period. For monthly data, this is the last day of the month of the reporting period. For example, data from January 2021 have a period date of January 31, 2021.
...
value: The value of the data point during the reporting period.
...
source_organization: The organization that provided the source document.
...
source_document: The document used as the primary source of information or data.
...
dataseries_name: The name of a data series derived from the full set of metadata added at the time of creation.
...
value_one_month_ago: The mean averaged value of the price of the product in the prior calendar month.
...
value_one_year_ago: The mean averaged value of the price of the product for the calendar month one year ago.
...
value_two_years_ago: The value of the price of the product two years ago.
...
value_three_years_ago: The value of the price of the product three years ago.
...
value_four_years_ago: The value of the price of the product four years ago.
...
value_five_years_ago: The value of the price of the product five years ago.
...
value_one_year_ahead: A value forecast one year from the current period.
...
two_year_average: The average price during the reporting period from the previous two years.
...
five_year_average: The average price during the reporting period from the previous five years.
...
pct_change_from_one_month_ago: The percentage change in value between the current value and the value_one_month_ago.
...
pct_change_from_one_year_ago: The percentage change in value between the current value and the value_one_year_ago.
...
description: Any extra information or detail that is relevant to the object. In the case of a source document, it can contain more information about the datasource including the name of document in the native language of the country the source document belongs to.
...
geographic_unit_id:
...
id: Unique identifier assigned by the system.
...
datacollectionperiod: A specific period for which Data Points are collected as specified by a datasource document. For example, if the Data Source Document specifies that its data is collected Monthly then we may have Data Collection Periods for Jan 2013, Feb 2013, Mar 2013, etc. All the data points for a Collection Period must be part of the same data collection.
...
datacollection: A collection of data points for a single source document. A Data Collection can contain data points for more than one data collection period.
...
datasourcedocument: The document used as the primary source of information or data.
...
datasourceorganization: The unique numeric id of the organization that provided the data source document.
...
dataseries: The internal id for a Data Series.
...
dataseries_specialization_type: Shows which data domain/classification a data series belongs to. For example, Market Product.
...
specialization_type: Shows which data domain/classification a record belongs to.
...
data_usage_policy:
...
created: The date of the creation of the datapoint, specified in YYYY-MM-DD format.
...
modified: Date the datapoint was last modified, specified in YYYY-MM-DD format.
...
status: The status of a data point value (i.e., Collected, Not Collected, Not Available, Missing Historic Data, Calculated, and Interpolated) for a specific collection period.
...
status_changed: Date the status was last changed, specified in YYYY-MM-DD format.
...
collection_status_changed: Date the collection status was last changed or modified, specified in YYYY-MM-DD format.
...
collection_schedule: The frequency of the data collections (e.g., monthly or weekly).
...
collection_status: The status of a data collection (i.e., Draft, Submitted, Under Review or Published).
...
| title | Expand to learn about data export |
|---|
The Export tab includes the following options:
to view it in full screen.
Customize
Customization options within the Secondary Price Indexes domain allows for aggregation or conversion of the data. The available parameters are:
Reporting Schedule: Provides reporting options on a daily, weekly, monthly, quarterly and annual basis. The default reporting schedule is monthly.
Export
The Secondary Price Indexes domain includes the following options:
File format: Choose from one of the available file formats. This will apply to both downloads and refreshable links.
Download as: Provides a download of a static dataset. This will export only the data series that you have selected.
...
Flat format CSV
...
Copy link: Copies a refreshable link that connects directly to the FEWS NET Data Warehouse database server, allowing Excel, your browser, or another application to automatically fetch data from the server whenever the link is accessed.
...
Flat CSV
...
Flat HTML
...
JSON
...