Summer Meal Programs – Summer Food Service Program (SFSP) – Meal Count Information – Program Period 2018 by US Government | Environmental and Climate Sciences

About this Dataset

Summer Meal Programs – Summer Food Service Program (SFSP) – Meal Count Information – Program Period 2018

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

For more information on these programs, please visit ourwebsite.

About the Dataset
This dataset contains claimed meals served by summer feeding sites participating in the Summer Food Service Program (SFSP) for summer 2018 (SNP program year 2017-2018). Summer feeding programs operate mid-May through the end of August.

This dataset contains site-level claimed meal counts. Reimbursement data is collected at the sponsor level and is reported in the “Summer Feeding Programs – Summer Food Service Program (SFSP) – Meal Reimbursements” dataset for the program year.

For data on sites participating in the Seamless Summer Option (SSO), please refer to the Summer Feeding Programs – Seamless Summer Option – Meal Counts and Meal Reimbursement datasets available on the State of Texas Open Data Portal.

About Dataset Updates
TDA aims to post new program year data by July 15 of the active program period. Participants have 60 days to file monthly claims. Dataset updates will occur monthly until 90 days after the close of the program period. After 90 days from the close of the program period, the dataset will be updated at six months and one year from the close of program period before becoming archived. Archived datasets will remain published but will not be updated. Any data posted during the active program year is subject to change.
Organization: City of Austin
Last updated: 2023-08-25T22:52:00.087218
Tags: adp, average-daily-participation, breakfast, child, children, claims, combined-claims, food-and-nutrition, free-meals, lunch, meal-counts, meals, service-days, sfsp, snack, summer, summer-food-service-program, supper, tda, texas-department-of-agriculture

Tables

Table 1

@usgov.city_of_austin_summer_meal_programs_summer_food_servic_abc691ef.table_1

296.92 KB
8138 rows
40 columns


CREATE TABLE table_1 (
  "programyear" VARCHAR,
  "reporttype" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "cecounty" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "typeofagency" VARCHAR,
  "typeofsfsporg" VARCHAR,
  "siteid" BIGINT,
  "sitename" VARCHAR,
  "sitecounty" VARCHAR,
  "ruralorurbancode" VARCHAR,
  "claimdate" VARCHAR,
  "combinedclaim" VARCHAR,
  "breakfastdays" BIGINT,
  "breakfast" BIGINT,
  "secondbreakfast" BIGINT,
  "breakfasttotal" BIGINT,
  "breakfastadp" DOUBLE,
  "amsnackdays" BIGINT,
  "amsnack" BIGINT,
  "secondamsnack" BIGINT,
  "amsnacktotal" BIGINT,
  "amsnackadp" DOUBLE,
  "lunchdays" BIGINT,
  "lunch" BIGINT,
  "secondlunch" BIGINT,
  "lunchtotal" BIGINT,
  "lunchadp" DOUBLE,
  "pmsnackdays" BIGINT,
  "pmsnack" BIGINT,
  "secondpmsnack" BIGINT,
  "pmsnacktotal" BIGINT,
  "pmsnackadp" DOUBLE,
  "supperdays" BIGINT,
  "supper" BIGINT,
  "secondsupper" BIGINT,
  "suppertotal" BIGINT,
  "supperadp" DOUBLE
);