Farm to School Census Explorer Tool
The searchable database below allows users to drilldown into the data from the USDA Farm to School Census. Once you’ve conducted your query, you can easily download your results in an excel file.
Want the entire dataset, including answers to every question asked? Two exportable excel files are available for download. One excel file contains district level information and the other excel file contains state and national level summaries for selected variables. Identical versions of these data sets are also available from data.gov. For more information about the data presented, see the "About the Data" tab below. For assistance, please contact the USDA Farm to School Program at firstname.lastname@example.org. This website was last updated on May 15, 2014.
|States||Search near zip code||Participated in farm to school activities?|
Yes, in school year 2011-2012
Yes, in school year 2012-2013
No, but has plans to start
No, and has no plans to start
|Food Categories||Would like to purchase||Purchased during 2011-2012 school year|
|Direct sources of local food||Intermediary sources of local food|
Direct from producer
Direct from producer cooperative
Direct from farmers markets
Direct from community supported agriculture (CSA)
Direct from food processors and manufacturers
Food buying cooperative
Food service management companies
DoD Fresh program vendors
USDA Foods (USDA commodity program)
State farm to school program office
|Grade Level||Meal Programs|
Fresh Fruit and Vegetable Program
Data shared in the table below are from select results of the USDA Farm to School Census. Note too, as you narrow your search results using the various filters, only those school districts that responded to any given question will be displayed. In many instances, school districts did not provide answers for every question asked on the USDA Farm to School Census.
Data regarding the total number of schools per district, the total number of students per district, and the percent of students receiving free or reduced price meals as part of the National School Lunch Program were added to the Census data set using Common Core of Data (CCD) Universe Survey School File for 2011-12 from the National Center for Education Statistics. For school food authorities that serve multiple school districts, total schools, total students, and percent of students receiving free or reduced price meals were calculated from the relevant school-level records in the Common Core of Data.
Reported school district information for the total food cost, total dollars spent on local food, and percent of total food dollars spent on local food were for the 2011-12 school year. A small number of school districts reported information about the total cost of food that did not appear to be consistent with the size of the school district. Additionally, some school districts reported spending greater than 100% of their food budget on local foods. In both cases, these responses were screened out and are displayed as missing values in the data set. The total dollars spent on local foods was calculated by multiplying the reported total dollars spent on food by the reported percent of total food dollars spent on local foods.
A small number of school districts reported information about the total cost of food that did not appear to be consistent with the size of the school district. Additionally, some school districts reported spending greater than 100% of their food budget on local foods. In both cases, these responses were screened out and are displayed as missing values in the data set. The total dollars spent on local foods was calculated by multiplying the reported total dollars spent on food by the reported percent of total food dollars spent on local foods.
Several responses represent more than one school food authority (SFA), and some school food authorities represent more than one school district. Responses representing multiple SFAs typically came from a private food service management company that provides meals to several SFAs. The director responsible for those SFAs completed the questionnaire and indicated the SFAs that were represented. In these cases, a new record was created for each SFA included in the response. Some responses were for a single SFA, but that SFA, primarily associated with a given school district, provides meals for a smaller school district as well. In these cases, the state lists indicated what other school districts were served by an SFA. A separate record was created for these districts based on information in the response from the SFA serving that district.
Several responses were also discovered to have typographical errors in reported zip codes. Where necessary, corrected zip codes were taken from the school district website and inserted into the record as part of the data cleaning process.
All of the information collected through the Farm to School Census is self-reported and may conflict with other data sources. For more information about the Farm to School Census, please click here.
|School District||State||Total Schools||Total Students||% of Students Receiving Free or Reduced Price Meals||Total Food Costs||Dollars Spent on Local Food||% of Total Food Dollars Spent on Local Food|