About this Dataset

Summer Food Service Program (SFSP) And Seamless Summer Option (SSO) - Meal Count Information - Program Period 2018

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

About the Dataset
This dataset combines basic meals served data from the Summer Food Service Program (SFSP) and Seamless Summer Option (SSO) Meal Count datasets currently published on the Texas Open Data Portal for the 2018 summer meal program season.

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
Data is updated regularly during the active program season. A final data update will occur at least six months from the close of the active program season after which data will remain published, but static.

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

For more information on these programs, please visit us at _SquareMeals.org._
Organization: City of Austin
Last updated: 2023-08-25T23:20:37.981546

Tables

Table 1

@usgov.city_of_austin_summer_food_service_program_sfsp_and_se_e58bf401.table_1

403.52 KB
11893 rows
36 columns


CREATE TABLE table_1 (
  "odprecid" VARCHAR,
  "programyear" VARCHAR,
  "program" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "typeofagency" VARCHAR,
  "typeoforg" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "siteid" BIGINT,
  "sitename" 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
);