Baselight

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

City of Austin

@usgov.city_of_austin_summer_meal_programs_all_summer_sites_m_85000334

Loading...
Loading...

About this Dataset

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

Help us provide the most useful data by completing our ODP User Feedback Survey for Summer Meal Programs Data

About the Dataset
This dataset contains site-level meal counts from approved TDA claims for Seamless Summer Option (SSO) and Summer Food Service Program (SFSP) in summer 2023. 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.

Meal count information for individual summer meal programs can be found as filtered views of this dataset on our _TDA Data Overview - Summer Meals Programs _page.

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.

An overview of all Summer Meal Program data available on the Texas Open Data Portal can be found at our _TDA Data Overview - Summer Meals Programs _page.

An overview of all TDA Food and Nutrition data available on the Texas Open Data Portal can be found at our _TDA Data Overview - Food and Nutrition Open Data_ page.

About Dataset Updates
TDA aims to post new program year data by July 15 of the active program period. Participants have 60 days to submit claims. 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.

About the Agency
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 — Feeding the Hungry and Promoting Healthy Lifestyles.

For more information on these programs, please visit ourwebsite.
Organization: City of Austin
Last updated: 2023-08-25T23:00:03.134923
Tags: child, meal-served, sfsp, sso

Tables

Table 1

@usgov.city_of_austin_summer_meal_programs_all_summer_sites_m_85000334.table_1
  • 346.46 KB
  • 9808 rows
  • 37 columns
Loading...

CREATE TABLE table_1 (
  "odprecid" VARCHAR,
  "programyear" BIGINT,
  "program" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "typeofagency" VARCHAR,
  "typeoforg" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "siteid" BIGINT,
  "sitename" VARCHAR,
  "countydistrictcode" VARCHAR,
  "cecounty" VARCHAR,
  "sitecounty" VARCHAR,
  "claimdate" TIMESTAMP,
  "breakfastdays" BIGINT,
  "breakfast" BIGINT,
  "secondbreakfast" DOUBLE,
  "breakfasttotal" BIGINT,
  "amsnackdays" BIGINT,
  "amsnack" BIGINT,
  "secondamsnack" DOUBLE,
  "amsnacktotal" BIGINT,
  "lunchdays" BIGINT,
  "lunch" BIGINT,
  "secondlunch" DOUBLE,
  "lunchtotal" BIGINT,
  "pmsnackdays" BIGINT,
  "pmsnack" BIGINT,
  "secondpmsnack" DOUBLE,
  "pmsnacktotal" BIGINT,
  "supperdays" BIGINT,
  "supper" BIGINT,
  "secondsupper" DOUBLE,
  "suppertotal" BIGINT,
  "totalsnacks" BIGINT,
  "totalmeals_snacks" BIGINT
);

Share link

Anyone who has the link will be able to view this.