Dataset: Summer Meal Programs - Seamless Summer Option (SSO) - Contacts And Program Participation - Program Period 2019

About this Dataset

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

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

New Data Fields Available!
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.

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.

More information about accessing and working with TDA data on the Texas Open Data Portal can be found on the SquareMeals.org website on the **TDA Food and Nutrition Open Data **page.

About Dataset Updates
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.

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. Any data posted during the active update schedule is subject to change.

A detailed list of TDA Food and Nutrition datasets and data fields available on the Texas Open Data Portal can be downloaded as a PDFhere._

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 ourwebsite.
Organization: City of Austin
Last updated: 2023-08-25T21:59:28.189700
Tags: address, administration, breakfast, child, children, contact, email, food-and-nutrition, free-meals, lunch, meal-days, meal-times, meal-type, meals, phone, seamless-summer-option, service, site-information, site-operation, snack, sso, summer, supper, tda, texas-department-of-agriculture

Tables

Table 1

@usgov.city_of_austin_summer_meal_programs_seamless_summer_op_156f4644.table_1

348.49 KB
2297 rows
70 columns


CREATE TABLE table_1 (
  "programyear" VARCHAR,
  "reporttype" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "typeofagency" VARCHAR,
  "typeoforg" VARCHAR,
  "countydistrictcode" VARCHAR,
  "cecounty" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "cestreetaddressline1" VARCHAR,
  "cestreetaddressline2" VARCHAR,
  "cestreetaddresscity" VARCHAR,
  "cestreetaddressstate" VARCHAR,
  "cestreetaddresszipcode" VARCHAR,
  "cemailingaddressline1" VARCHAR,
  "cemailingaddressline2" VARCHAR,
  "cemailingaddresscity" VARCHAR,
  "cemailingaddressstate" VARCHAR,
  "cemailingaddresszipcode" VARCHAR,
  "superintendentsalutation" VARCHAR,
  "superintendentfirstname" VARCHAR,
  "superintendentlastname" VARCHAR,
  "superintendenttitleposition" VARCHAR,
  "superintendentemail" VARCHAR,
  "superintendentphone" BIGINT,
  "childnutdirsalutation" VARCHAR,
  "childnutdirfirstname" VARCHAR,
  "childnutdirlastname" VARCHAR,
  "childnutdirtitleposition" VARCHAR,
  "childnutdiremail" VARCHAR,
  "childnutdirphone" BIGINT,
  "siteid" BIGINT,
  "sitename" VARCHAR,
  "sitecounty" VARCHAR,
  "sitetype" VARCHAR,
  "sitestreetaddressline1" VARCHAR,
  "sitestreetaddressline2" VARCHAR,
  "sitestreetcity" VARCHAR,
  "sitestreetstate" VARCHAR,
  "sitestreetzipcode" VARCHAR,
  "seamlesssummercontactsalutation" VARCHAR,
  "seamlesssummercontactfirstname" VARCHAR,
  "seamlesssummercontactlastname" VARCHAR,
  "seamlesssummercontacttitleposition" VARCHAR,
  "seamlesssummercontactemail" VARCHAR,
  "seamlesssummercontactphone" BIGINT,
  "sitestartdate" VARCHAR,
  "siteenddate" VARCHAR,
  "days_of_operation" VARCHAR,
  "meal_types_served" VARCHAR,
  "breakfasttime" VARCHAR,
  "breakfastdaysserved" VARCHAR,
  "amsnacktime" VARCHAR,
  "amsnackdaysserved" VARCHAR,
  "lunchtime" VARCHAR,
  "lunchdaysserved" VARCHAR,
  "pmsnacktime" VARCHAR,
  "pmsnackdaysserved" VARCHAR,
  "suppertime" VARCHAR,
  "supperdaysserved" VARCHAR,
  "new_georeferenced_column" VARCHAR,
  "cestatus" VARCHAR,
  "ceterminationstatus" VARCHAR,
  "ceterminatedasofdate" VARCHAR,
  "ceapplicationcycle" VARCHAR,
  "sitestatus" VARCHAR,
  "siteterminationstatus" VARCHAR,
  "siteterminatedasofdate" VARCHAR,
  "siteapplicationcycle" VARCHAR
);