HDX Food Market Info Database
The following is the MySQL schema for the HDX Food market table:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| Market_Name | varchar(100) | YES | NULL | ||
| Commodity_Name | varchar(100) | YES | NULL | ||
| Commodity_Category | varchar(100) | YES | NULL | ||
| Currency_Code | varchar(4) | YES | NULL | ||
| Unit | varchar(100) | YES | NULL | ||
| Price_Flag | varchar(100) | YES | NULL | ||
| Price_Type | varchar(100) | YES | NULL | ||
| Price | decimal(9,2) | YES | NULL | ||
| Lat | decimal(9,6) | YES | NULL | ||
| Lon | decimal(9,6) | YES | NULL | ||
| Reference_Period_Start | datetime | YES | NULL | ||
| Reference_Period_End | datetime | YES | NULL |
An example JSON object for the dataset:
{
"location_code": "MOZ",
"location_name": "Mozambique",
"admin1_code": "MZ07",
"admin1_name": "Nampula",
"admin2_code": "MZ0717",
"admin2_name": "Muecate",
"admin_level": 2,
"resource_hdx_id": "d62af4be-cff6-437b-89a3-67f8fa4c53bf",
"market_code": "7776",
"market_name": "Meconta (rural)",
"commodity_code": "92",
"commodity_name": "Eggs",
"commodity_category": "meat, fish and eggs",
"currency_code": "MZN",
"unit": "30 pcs",
"price_flag": "actual",
"price_type": "Retail",
"price": 300.0,
"lat": -14.57,
"lon": 39.5,
"reference_period_start": "2025-06-15T00:00:00",
"reference_period_end": "2025-07-14T23:59:59"
}