Summer Meal Programs - Seamless Summer Option (SSO) - Contacts and Program Participation - Program Period 2019

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

This dataset contains <b>contact and program participation information for each site participating in the Seamless Summer Option (SSO) for summer 2019 (SNP program year 2018-2019).</b> The active application period for summer program participants runs January through April. <b>Changes in participant information can occur through August.</b> Summer meals programs operate mid-May through the end of August. <p>

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

CE and site status (active/inactive), termination status, termination as of date, and 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>

An overview of <b>all Summer Meal Program data available</b> on the Texas Open Data Portal can be found at our <b><a href=https://data.texas.gov/stories/s/52en-tt82 target="_blank">TDA Data Overview - Summer Meals Programs</a></b> 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 participation data by April 1 of the active program year. Due to the short duration of the summer meal programs, updates to the program participation dataset 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><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=https://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, the Child and Adult Care Food Program (CACFP), and summer meal programs. 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 our <a href=http://www.SquareMeals.org target="_blank">website</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-seamless-summer-option-sso-3hpz-ajxk\".\"summer_meal_programs_seamless_summer_option_sso\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.