School Nutrition Programs – Contact Information and Site-Level Program Participation – Program Year 2018-2019

<b>New Data Fields Available!</b><br>

Dataset content and column order have been updated starting with program year 2018-2019 forward. Older program year datasets will retain original content and organization. <p>

<b>About the Agency</b><br>

The Texas Department of Agriculture administers 12 U.S. Department of Agriculture nutrition programs in Texas including the National School Lunch and School Breakfast Programs and the Child and Adult Care Food Program (CACFP). TDA’s Food and Nutrition division provides technical assistance and training resources to partners operating the programs and oversees the USDA reimbursements they receive to cover part of the cost associated with serving food in their facilities. By working to ensure these partners serve nutritious meals and snacks, the division adheres to its mission — <i>Feeding the Hungry and Promoting Healthy Lifestyles.</i><p>

<b>For more information on these programs, please visit our <a href=http://www.SquareMeals.org target="_blank">website</a>.</b><br>

<i>A detailed list of TDA Food and Nutrition datasets and data fields available on the Texas Open Data Portal can be found on our <b><a href=https://data.texas.gov/stories/s/TDA-Data-Overview-Food-and-Nutrition-Programs-Open/nk79-w2cs/ target="_blank">TDA Data Overview - Food and Nutrition Open Data</a></b> </i>page. <p>

<b>About the Dataset</b><br>

<b>This dataset contains contact information and program participation information for all School Nutrition Program meal sites approved by TDA to operate during the 2018-2019 program year.</b> The school nutrition program year begins July 1 and ends June 30.<p>

An overview of <b>all SNP data available</b> on the Texas Open Data Portal can be found at our <b><a href=https://data.texas.gov/stories/s/e2dm-5r4v target="_blank">TDA Data Overview - School Nutrition Programs</a></b> page.<p>

<b>About Dataset Updates</b><br>

TDA aims to post new program year data by September 1 of the active program year. Updates will occur quarterly and end 90 days after the close of the program year. Any data posted during the active program year is subject to change. After 90 days from the close of the program year, this dataset will remain published but will no longer be updated.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"texas-gov/school-nutrition-programs-contact-information-and-jezb-2499\".\"school_nutrition_programs_contact_information_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.