The Department of Agricultural Economics at Purdue University has created an online dashboard that quantifies the potential supply risk of agricultural products due to farm and agricultural worker COVID19 illnesses. The Department collaborated with Microsoft to build the dashboard on top of Microsoft Azure and Power BI platform. Stated on the dashboard’s site:
Vulnerability of the supply of an agricultural commodity to risks such as COVID-19 depend on the number of farmers and agricultural workers affected, the location of affected workers, the crops and animals that are grown in the most impacted regions, and the degree to which production is concentrated in a particular geographic region. By combining data on the number of COVID cases in each U.S. county with the county’s total population, U.S. Department of Agriculture data on the number of farmers and hired farm workers in each county, and data on agricultural production of each county, and estimate of the share of agricultural production at risk can be computed.
It is noted that the dashboard is a work in progress and they are working to add new data and eliminate errors. The online dashboard is open access.