...

The Crop domain is broken into two sections:

1. 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:

• Period: Filters by the collection/reporting period.

  • Start date: Returns all data series starting on or before this date.

  • End date: Returns all data series ending on or after this date.

• Geographic: Filters by crop location. This filter aggregates items into a multi-level lists (e.g., admin 1 units are aggregated into countries, which are aggregated into regions). Selecting the higher-level item in the list will automatically select all the lower-level items in the list.

• Geo Aggregation: Filters by type of geographic unit which is 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.

• Product: Filters by commodity or service, classified using a modified FEWS NET version of the UN CPC v2. This filters aggregates items into a multi-level lists. Selecting the higher-level item in the list will automatically select all the lower-level items in the list.

• Indicator: Filers by a metric of interest and allows for meaningful comparisons over time. The indicator options for the crop domain are area harvested, area planted, quantity produced, and yield.

• Data Source Document: Filters by the name of the document used as the primary source of information or data.

2. Data Visualization and Export

...

Visualize

The

...

Crop domain

...

• country: Represents the national, dependent territory, or special area of geographical interest level administrative unit, standardized to ISO 3166 naming.

• source_organization: The organization that provided the source document.

• source_document: The document used as the primary source of information or data.

• fnid: FEWS NET ID, a unique code used to identify a specific geographic unit.

• admin_0: Represents the country level administrative unit.

• admin_1: Represents the first level administrative units.

• admin_2: Represents the second level administrative units.

• admin_3: Represents the third level administrative units.

• admin_4: Represents the fourth level administrative units.

• population_group: The population group for which the crop production indicators are estimated and reported.

• crop_production_system: Explains the system used to produce/grow a certain crop (e.g., Irrigated). Represented as part of the livelihood zone type.

• 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.

• season_name: The name of the particular season at the Locality when the crop was grown.

• season_type: Gives details about a particular season based on weather conditions or happenings at that particular season (e.g., Wet, Harvest, Summer, Spring, Dry).

• population:

• product: The commodity or service classified using a modified FEWS NET version of the UN CPC v2 codes.

• cpcv2: Classification structure of products based on the UN’s Central Product Classification (CPC) rules, prefixed with R, L, P or S, indicating whether the Product is Raw agricultural output, Live animals, a Processed product or a Service, and suffixed with letters where additional distinctions are required by FEWS NET, e.g., to distinguish milled wheat from wheat grain.

• cpcv2_description: A description of the UN CPC v2 code.

• geographic_group: Grouping of countries or regions based on the United Nations Standard Country or Area Codes for Statistical (UN M49) Classifications.

• fewsnet_region: Grouping of countries or regions based on the FEWS NET regional Classifications. They are similar to the UN M49 Groups but they use the M49 code values between 900 and 999.

• country_code: The ISO 3166-1 alpha-2 two letter code for a country.

• collection_schedule: The frequency of the data collections (e.g., monthly or weekly).

• collection_date: Date the records were collected, specified in YYYY-MM-DD format.

• season_date:

• season_year:

• 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.

• collection_status: The status of a data collection (i.e., Draft, Submitted, Under Review or Published).

• publication_name: The name of the publication associated with the data collection. Typically, this is a publication containing a year's worth of data.

• document_type: The type of Data Source Document (e.g., Market Product, Preliminary Crop Production Estimate, Rapid MUAC, SMART, 30x30). In particular, in the Crop Production domain the Document Type distinguishes between crop:preliminary and crop:final Data Source Documents with the same name.

• id: Unique identifier assigned by the system.

• dataseries_name: The name of a data series derived from the full set of metadata added at the time of creation.

• crop:harvested:ha*:

• crop:harvested:ha:value_per_capita*:

• crop:planted:ha*:

• crop:planted:ha:value_per_capita*:

• crop:quantity:t*:

• crop:quantity:t:value_per_capita*:

• crop:yield:MT/ha*:

Items with an asterisk ( * ) are specific to particular indicators and will only appear when they are relevant to your search and selection.

...

The Export tab includes the following options:

...

currently includes a Table visualization. The About tab contains descriptions and definitions of the metadata included in the table and export data.

Export

The Crop domain includes the following export options:

• File format: Choose from one of the available file formats. This will apply to both downloads and refreshable links.

• Download: Provides a download of a static dataset. This will export only the data series that you have selected.

...

• Flat format CSV

• Time series 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

...

Crosstab CSV

...

Flat HTML

...

Crosstab HTML

...

JSON

...

Crosstab JSON

...