About the data 
Congress passed the Agricultural Foreign Investment Disclosure Act (AFIDA) in 1978 to better track ownership of U.S. crop, pasture and timber land. Under terms of the act, foreign interests are required to notify the U.S. Department of Agriculture whenever they buy or sell American agricultural land.

That information is then used to make periodic reports to Congress and the President.

Investigate Midwest filed a Freedom of Information Act request for the AFIDA database, which has entries spanning from 1900 to 2019. Information compiled under AFIDA includes ownership and land-use details filed by owners with the U.S. Department of Agriculture.

There are more than 34,000 records, dating to as far back as 1900. Since the law wasn’t passed until 1978, it’s unclear how complete and accurate records before that date are.
[The complete database may be purchased here. All proceeds support Investigate Midwest].

You can search by country, state, county or owner. You can download the dataset by clicking “get the data.”

Though Investigate Midwest has taken steps to ensure that no errors were introduced into the data during the initial data cleaning, users will find errors in the data and should double-check any figures that you use.

The USDA acknowledges there are errors and omissions in the data. The USDA does not do verification of the data and is entirely dependent on self-reported data and thus errors can occur.

As a result, this data has typos and missing information.

Specifically, purchases are usually tracked, but it’s unclear whether sales of foreign-held agricultural land are.

For example, in the USDA data, almost 1 million acres of foreign held agricultural land do not list the country owning the land. In another example, typos result in an entry reporting that a 199-acre dairy farm in Ohio was bought for $594 million, when it was bought for $594,000.

Investigate Midwest did not do extensive verifying or correcting of the data. It has has only verified records that it has used in its stories.

Nonetheless, the database is a good starting point for inquiries in foreign owned agricultural land.

If you have any questions regarding the processing of this database that are not answered in the documentation, please call the Midwest Center for Investigative Reporting at (312) 970-0395.

The complete data set may be purchased here : The full data set has 70 fields, including name, location (county, state), purchase price, and type and usage of the land. As this is a flat file rather than a relational database, related lookup tables where merged with the AFIDA data. Fields named *_lookup are the result of merging the AFIDA dataset with other lookup tables, For example, owner_no and owner_no_lookup provide the owner's name given the owner_no; country_code_lookup translates the ISO country_code numbers into country names, etc. County and state information where extracted from the 5 digit FIPS code. The file "FOIA Key to AFIDA Data Fields.pdf" contains many of the lookup tables that were used.