Summer Meal Programs - All Summer Sites - Contact And Program Participation Information - Program Period 2019 by US Government | Environmental and Climate Sciences

About this Dataset

Summer Meal Programs - All Summer Sites - Contact And Program Participation Information - Program Period 2019

About the Dataset
This dataset contains contact and program participation information for all summer meal sites approved by TDA to operate during the 2019 program period. Applications to participate in summer programs open on January 15 and close May 1. Changes in site information can occur through August. 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 April 1 of the active program year. Due to the short duration of the summer meal programs, dataset updates 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. New Data Fields Available!
CE and site status (active/inactive), termination status, termination as of date, and CE 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.

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 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 us atSquareMeals.org.
Organization: City of Austin
Last updated: 2023-08-25T22:29:14.916769
Tags: contact, food, free-summer-meals, meals, nutrition, sfsp, site, sso, summer, tda, texas-department-of-agriculture

Tables

Table 1

@usgov.city_of_austin_summer_meal_programs_all_summer_sites_c_4b0549a8.table_1

926.69 KB
6075 rows
71 columns


CREATE TABLE table_1 (
  "programyear" VARCHAR,
  "reporttype" VARCHAR,
  "program" 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,
  "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,
  "progradministratorsalutation" VARCHAR,
  "progradministratorfirstname" VARCHAR,
  "progradministratorlastname" VARCHAR,
  "progradministratortitleposition" VARCHAR,
  "progradministratoremailaddress" VARCHAR,
  "progradministratorphone" BIGINT,
  "progrcoordinatorsalutation" VARCHAR,
  "progrcoordinatorfirstname" VARCHAR,
  "progrcoordinatorlastname" VARCHAR,
  "progrcoordinatortitleposition" VARCHAR,
  "progrcoordinatoremailaddress" VARCHAR,
  "progrcoordinatorphone" BIGINT,
  "sitecontactsalutation" VARCHAR,
  "sitecontactfirstname" VARCHAR,
  "sitecontactlastname" VARCHAR,
  "sitecontacttitleposition" VARCHAR,
  "sitecontactemailaddress" VARCHAR,
  "sitecontactphone" BIGINT,
  "sitetype" VARCHAR,
  "sitestartdate" TIMESTAMP,
  "siteenddate" TIMESTAMP,
  "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,
  "geolocation" VARCHAR,
  "operationstartdate" VARCHAR
);