About this Dataset

Summer Meal Programs - Seamless Summer Option (SSO) - Contacts And Program Participation - 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 data set contains contact and program participation information for each site participating in the Seamless Summer Option (SSO) for summer 2023 . Summer meal programs operate mid-May through the end of August.

An overview of all summer meal program data available on the Texas Open Data Portal can be found at our **_TDA Data Overview - Summer Meal 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 year data by May 1 of the active program period. Data will be updated daily until 60 days after the close of the program period. The dataset will be updated six months later after which data will remain static but published. 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 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.
**
Organization: City of Austin
Last updated: 2023-08-25T22:17:20.878587
Tags: child, meals, sso, summer

Tables

Table 1

@usgov.city_of_austin_summer_meal_programs_seamless_summer_op_ee383beb.table_1

507.5 kB
2,974 rows
72 columns

CREATE TABLE table_1 (
  "odprecid" VARCHAR,
  "programyear" VARCHAR,
  "reporttype" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "typeofagency" VARCHAR,
  "typeoforg" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "cestatus" VARCHAR,
  "ceterminationstatus" VARCHAR,
  "ceterminatedasofdate" TIMESTAMP,
  "ceapplicationcycle" VARCHAR,
  "siteid" BIGINT,
  "sitename" VARCHAR,
  "sitestatus" VARCHAR,
  "siteterminationstatus" VARCHAR,
  "siteterminatedasofdate" TIMESTAMP,
  "siteapplicationcycle" VARCHAR,
  "countydistrictcode" VARCHAR,
  "cecounty" VARCHAR,
  "sitecounty" VARCHAR,
  "cestreetaddressline1" VARCHAR,
  "cestreetaddressline2" VARCHAR,
  "cestreetaddresscity" VARCHAR,
  "cestreetaddressstate" VARCHAR,
  "cestreetaddresszipcode" VARCHAR,
  "cemailingaddressline1" VARCHAR,
  "cemailingaddressline2" VARCHAR,
  "cemailingaddresscity" VARCHAR,
  "cemailingaddressstate" VARCHAR,
  "cemailingaddresszipcode" VARCHAR,
  "sitestreetaddressline1" VARCHAR,
  "sitestreetaddressline2" VARCHAR,
  "sitestreetaddresscity" VARCHAR,
  "sitestreetaddressstate" VARCHAR,
  "sitestreetaddresszipcode" 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,
  "seamlesssummercontactsalutation" VARCHAR,
  "seamlesssummercontactfirstname" VARCHAR,
  "seamlesssummercontactlastname" VARCHAR,
  "seamlesssummercontacttitleposition" VARCHAR,
  "seamlesssummercontactemail" VARCHAR,
  "seamlesssummercontactphone" BIGINT,
  "sitetype" VARCHAR,
  "sitestartdate" TIMESTAMP,
  "siteenddate" TIMESTAMP,
  "daysofoperation" VARCHAR,
  "mealservicetype" VARCHAR,
  "mealtypesserved" VARCHAR,
  "breakfasttime" VARCHAR,
  "breakfastdaysserved" VARCHAR,
  "amsnacktime" VARCHAR,
  "amsnackdaysserved" VARCHAR,
  "lunchtime" VARCHAR,
  "lunchdaysserved" VARCHAR,
  "pmsnacktime" VARCHAR,
  "pmsnackdaysserved" VARCHAR,
  "suppertime" VARCHAR,
  "supperdaysserved" VARCHAR,
  "geolocation" VARCHAR
);