**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"
  }