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