Summer Meal Programs - All Summer Sites - Contact and Program Participation Information - Program Period 2019

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

This dataset contains <b>contact and program participation information for all summer meal sites approved by TDA to operate during the 2019 program period.</b> Applications to participate in summer programs open on January 15 and close May 1. Changes in site information can occur through August. Summer meal programs operate mid-May through the end of August. <p>

An overview of <b>all summer meal program data available</b> on the Texas Open Data Portal can be found at our <b><i> <a href=https://data.texas.gov/stories/s/52en-tt82 target="_blank">TDA Data Overview - Summer Meal Programs</a> </b></i>page.<p>

An overview of <b>all TDA Food and Nutrition data available</b> on the Texas Open Data Portal can be found at 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> page. <p>

<b>More information about accessing and working with TDA data on the Texas Open Data Portal</b> can be found on the SquareMeals.org website on the <b><a href=http://www.squaremeals.org/FandNResources/PublicInformationRequests/TDAFoodandNutritionOpenData.aspx target="_blank">TDA Food and Nutrition Open Data</a> </b>page.<p>

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

TDA aims to post new program year data by April 1 of the active program year. Due to the short duration of the summer meal programs, dataset updates will occur every two weeks until the end of August. <p>

All TDA datasets will have a final active update 90 days after the close of the program period. Datasets will be updated at six months and one year from the close of program period before becoming archived. <b>Any data posted during the active update schedule is subject to change.</b>

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

CE and site status (active/inactive), termination status, termination as of date, and CE application cycle (new/renewal) are now available on this dataset. These fields have been added to the last columns of the report and data descriptions have been added to the column metadata.<p>

<b>A detailed list of TDA Food and Nutrition datasets and data fields available on the Texas Open Data Portal can be downloaded as a PDF <a href=http://www.squaremeals.org/Portals/8/files/PIR/TDA%20Food%20and%20Nutrition%20Data%20Fields%20and%20Definitions.pdf target="_blank">here</a>.</b></i><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>

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

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/summer-meal-programs-all-summer-sites-contact-and-aj5s-8pui\".\"summer_meal_programs_all_summer_sites_contact_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.