Summer Meal Programs - All Summer Sites - Meal Count - Program Period 2023

<b><a href=https://form.jotform.com/212795081587163 target="_blank">Help us provide the most useful data by completing our ODP User Feedback Survey for Summer Meal Programs Data</a></b><p>

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

This dataset contains <b>site-level meal counts from approved TDA claims for Seamless Summer Option (SSO) and Summer Food Service Program (SFSP) in summer 2023.</b> Summer meal programs typically operate mid-May through August unless otherwise noted. Participants have 60 days from the final meal service day of the month to submit claims to TDA.<p>

Meal count information for individual summer meal programs can be found as filtered views of this dataset on our <b><u><a href=https://data.texas.gov/stories/s/52en-tt82 target=""_blank"">TDA Data Overview - Summer Meals Programs</a></b> </u>page.<p>

Meal reimbursement data is collected at the sponsor/CE level and is reported in the "Summer Meal Programs - Seamless Summer Option (SSO) - Meal Reimbursements" and “Summer Meal Programs – Summer Food Service Program (SFSP) – Meal Reimbursements” datasets found on the Summer Meal Program Data Overview page. <p>

An overview of <b>all Summer Meal Program data available</b> on the Texas Open Data Portal can be found at our <b><u><a href=https://data.texas.gov/stories/s/52en-tt82 target=""_blank"">TDA Data Overview - Summer Meals Programs</a></b> </u>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><u><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></u> page. <p>

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

TDA aims to post new program year data by July 15 of the active program period. <b>Participants have 60 days to submit claims.</b> Data updates will occur daily and end 90 days after the close of the program year. Any data posted during the active program year is subject to change.<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 Programs (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-all-summer-sites-meal-count-ihhh-b9xf\".\"summer_meal_programs_all_summer_sites_meal_count\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.