SQL query to AMIS dashboard API:
select p.product_name, d.year,d.season,d.value,d.units,e.element_name,d.element_code
from `fao-maps.fao_amis.amis_data` d
join `fao-maps.fao_amis.amis_product` p on d.product_code=p.product_code
join `fao-maps.fao_amis.amis_element` e on d.element_code=e.element_code
where d.database='CBS' and d.max_lastupdate=1 and d.element_code=2 and d.region_code=999000 and d.year=2000
order by p.product_name;

API response rows:
product_name  year season value units element_name element_code
COARSE GRAINS 2000 2000/01 305.179783 Million Ha Area Harvested 2
Maize 2000 2000/01 138.766837 Million Ha Area Harvested 2
Rice 2000 2000/01 153.785933 Million Ha Area Harvested 2
Soybean 2000 2000/01 76.143 Million Ha Area Harvested 2
Wheat 2000 2000/01 216.93709 Million Ha Area Harvested 2