All data used in this presentation is downloaded from the FDIC site operated by the US Government (https://www7.fdic.gov/sdi/download_large_list_outside.asp). They operate a public page on which they publish all of their quarterly reports. (Outstanding Debt, Whether it is being actively repaid, how long since the last payment)

In addition, the Department of Agriculture tabulates land use data (https://www.ers.usda.gov/data-products/major-land-uses.aspx), which was used to normalize the debt load since states with large amounts of land area would naturally have more debt on an absolute basis.

The FDIC data was extracted and plotted both geographically and as a time series for each individual state.

• The maps show 30 - 90 day delinquencies on debt secured by farmland in the United States
• The ratio of delinquent debt per acre of cropland in the state is plotted
• A time series for each state shows a rolling 4 quarter average to smooth out seasonal spikes (Shiny App)
• The state for which the time series is shown can be selected from a drop-down in the sidebar (Shiny App)
• Two sliders, one for the year and one for the month, can be adjusted to select the time frame for the map (Shiny App)

(Farm Debt Example 1 - $/acre-farmland)

(Farm Debt Example 2- $/acre-farmland)