​Purdue Food and Agriculture Vulnerability Index

in collaboration with Microsoft

The Department of Agricultural Economics at Purdue University, in collaboration with Microsoft, has created an online dashboard, built on top of Microsoft Azure and Power BI platforms, to quantify the potential risk to the supply of agricultural products as a result of farm and agricultural worker illnesses from COVID19. 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. 

Food and Agriculture Vulnerability Index Dashboard


 





Using the Dashboard

To use the dashboard, click on one of the agricultural commodities at the top of the table. The pie-chart shows the estimated percent of total U.S. production of the selected commodity potentially at risk because of COVID19 farmer and farm worker illnesses. The table below shows the estimated number of agricultural worker COVID19 case by state, the level of production of the commodity in each state (in bushels, pounds, acres, or number of head, depending on the commodity), the estimated loss in productivity because of worker illnesses, and the percent of total production in the state potentially lost due to illnesses. The map shows the total number of COVID cases in each state. To drill into the county-level detail, click on a state to see a more detailed county-level map with the estimated number of farm and agricultural workers with COVID-19 along with other county-level statistics on production. 

This work was financially supported by a grant from the Foundation for Food and Agriculture Research under award number – Grant ID: DSnew-0000000017. The content of this tool are solely the responsibility of the authors and does not necessarily represent the official views of the Foundation for Food and Agriculture Research

Please note: this is a work in progress and we are working to add new data and eliminate errors. If you have questions about the tool or project, contact Jayson Lusk at 765.494.4191 or jlusk@purdue.edu.


Additional Information

A related paper, "Farmer and farm worker illnesses and deaths from COVID-19 and impacts on agricultural output," was published on PLOS ONE, April 28, 2021 and is available at: doi.org/10.1371/journal.pone.0250621


Agricultural Economics, 403 West State Street, West Lafayette, IN 47907 USA, (765) 494-4191

© Purdue University | An equal access/equal opportunity university | Integrity Statement | Copyright Complaints | Maintained by Agricultural Communication

Trouble with this page? Disability-related accessibility issue? Please contact us at agweb@purdue.edu so we can help.

Sign In