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.

• COVID-19 confirmed case are from Johns Hopkins: 

  • https://coronavirus.jhu.edu/us-map

• County-level total population is for 2019 from the U.S. Census Bureau: 

  • https://www.census.gov/data/datasets/time-series/demo/popest/2010s-counties-total.html

• County-level data on number of farmers is from the 2017 Census of Agriculture (measured as the numbers of “producers”): 

  • https://quickstats.nass.usda.gov/

• County-level data on number of hired farm laborers is from the 2017 Census of Agriculture (measured as an expense associated with “labor, hired – number of workers”): 

  • https://quickstats.nass.usda.gov/

• County-level production for each commodity is from the 2017 Census of Agriculture: 

  • https://quickstats.nass.usda.gov/

• j indexes each county
• TCC_j is the total number of confirmed cases of COVID19 in county j
• AW_j are the number of agricultural farm workers in county j, defined as the sum of the number of “producers” and “hired labor” in the county
• POP_j is the total population of county j
• The expected number of agricultural workers with COVID, or “Ag Workers COVID”, AW_CVD_j , in county j is AW_CVD_j  .= TCC_j ( AW_j  / POP_j ). The assumption is that agricultural workers in a county contract COVID19 at a rate equal to that of everyone else in the county, implying that the expected number of ag worker COVID cases is equal to the share of the total population that is an agricultural worker multiplied by the total number of COVID cases.
• y_jk is the production of commodity k in county j (units depend on the commodity in question).
• Labor productivity for commodity k in county j is: LaborP_jk = y_jk / AW_j. This is the amount of commodity k produced per agricultural worker in the county. 
• If AW_CVD_j  agricultural workers are ill, then there is the potential lost productivity, LaborP_jk, of commodity k is:  LP_jk = AW_CVD_j * ( LaborP_jk )
• Total estimated lost production in a state or for the country as a whole with J total counties is determined by summing over counties: TOTAL_LP_k = Σ^J_{j =1} LP_jk.
• Total production of a commodity in a state or for the country as a whole with J total counties is determined by summing over counties: TOTAL_y_k = Σ^J_{j =1} y_jk .
• The potential percent of lost production from COVID for commodity k is: ( TOTAL_LP_k / TOTAL_y_k ) * 100.