Summer Meal Programs - Seamless Summer Option (SSO) - Contacts and Program Participation - Program Period 2019
<b>About the Dataset</b><br>
This dataset contains <b>contact and program participation information for each site participating in the Seamless Summer Option (SSO) for summer 2019 (SNP program year 2018-2019).</b> The active application period for summer program participants runs January through April. <b>Changes in participant information can occur through August.</b> Summer meals programs operate mid-May through the end of August. <p>
<b>New Data Fields Available!</b><br>
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.<p>
An overview of <b>all Summer Meal Program data available</b> on the Texas Open Data Portal can be found at our <b><a href=https://data.texas.gov/stories/s/52en-tt82 target="_blank">TDA Data Overview - Summer Meals Programs</a></b> page.<p>
An overview of <b>all TDA Food and Nutrition data available</b> on the Texas Open Data Portal can be found at our <b><a href=https://data.texas.gov/stories/s/TDA-Data-Overview-Food-and-Nutrition-Programs-Open/nk79-w2cs/ target="_blank">TDA Data Overview - Food and Nutrition Open Data</a></b> page. <p>
<b>More information about accessing and working with TDA data on the Texas Open Data Portal</b> can be found on the SquareMeals.org website on the <b><a href=http://www.squaremeals.org/FandNResources/PublicInformationRequests/TDAFoodandNutritionOpenData.aspx target="_blank">TDA Food and Nutrition Open Data</a> </b>page.<p>
<b>About Dataset Updates</b><br>
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.<p>
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. <b>Any data posted during the active update schedule is subject to change.</b><p>
<b>A detailed list of TDA Food and Nutrition datasets and data fields available on the Texas Open Data Portal can be downloaded as a PDF <a href=https://www.squaremeals.org/Portals/8/files/PIR/TDA%20Food%20and%20Nutrition%20Data%20Fields%20and%20Definitions.pdf target="_blank">here</a>.</b></i><p>
<b>About the Agency</b><br>
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 — <i>Feeding the Hungry and Promoting Healthy Lifestyles.</i><p>
<i><b>For more information on these programs, please visit our <a href=http://www.SquareMeals.org target="_blank">website</a>.</b></i><br>
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| SiteStatus | sitestatus | sitestatus | Text | Site is eligible and/or participating in nutrition program. Data displayed as: Active/Inactive. New field added for program year 2018-2019 |
| SeamlessSummerContactTitlePosition | seamlesssummercontacttit | seamlesssummercontacttit | Text | Summer program contact title or position |
| SeamlessSummerContactLastName | seamlesssummercontactlastname | seamlesssummercontactlastname | Text | Summer program contact last name |
| SiteStreetZipCode | sitestreetzipcode | sitestreetzipcode | Text | Site street address, zip code |
| ChildNutDirTitlePosition | childnutdirtitleposition | childnutdirtitleposition | Text | Child Nutrition Director (CND) title or position |
| SuperintendentPhone | superintendentphone | superintendentphone | Text | CE administrator/superintendent phone number |
| ESC | esc | esc | Text | Educational Service Center (ESC) region |
| TypeofOrg | typeofsnporg | typeofsnporg | Text | Type of organization the sponsored site operates as. Data displayed as: Charter/Private/Public/RCCI (Residential Child Care Institution) |
| ChildNutDirSalutation | childnutdirsalutation | childnutdirsalutation | Text | Honorific salutation for Child Nutrition Director (CND). Optional entry for CE. Format: Mr., Ms. Dr., etc. |
| SiteApplicationCycle | siteapplicationcycle | siteapplicationcycle | Text | Description of site application type based on program participation in previous program year. Date displayed as: NewApp/Renewal. New field added for program year 2018-2019 |
| CEStreetAddressState | cestreetaddressstate | cestreetaddressstate | Text | Contracting Entity (CE) street address, state |
| LunchDaysServed | lunchdaysserved | lunchdaysserved | Text | Days of the week lunch served at the site during operation Data displayed as: S/M/T/W/TH/F/SA; multiple entries separated by commas |
| SeamlessSummerContactEmail | seamlesssummercontactemail | seamlesssummercontactemail | Text | Summer program contact email address |
| SeamlessSummerContactFirstName | seamlesssummercontactfirstname | seamlesssummercontactfirstname | Text | Summer program contact first name |
| CEMailingAddressZipCode | cemailingaddresszipcode | cemailingaddresszipcode | Text | Contracting Entity (CE) mailing address, zip code |
| CEMailingAddressCity | cemailingaddresscity | cemailingaddresscity | Text | Contracting Entity (CE) mailing address, city |
| SeamlessSummerContactSalutation | seamlesssummercontactsal | seamlesssummercontactsal | Text | Honorific salutation for summer program contact. Optional entry. Format: Mr., Ms. Dr., etc. |
| CEStreetAddressLine2 | cestreetaddressline2 | cestreetaddressline2 | Text | Contracting Entity (CE) street address, line 2 (if applicable) |
| SuperintendentEmail | superintendentemail | superintendentemail | Text | CE administrator/superintendent email address |
| SuperintendentFirstName | superintendentfirstname | superintendentfirstname | Text | CE administrator/superintendent first name |
| CEID | ceid | ceid | Text | Unique number assigned to Contracting Entity (CE) to identify organization as a program sponsor |
| ReportType | reporttype | reporttype | Text | Type of information being reported in the dataset |
| SiteStreetState | sitestreetstate | sitestreetstate | Text | Site street address, state |
| AMSnackDaysServed | amsnackdaysserved | amsnackdaysserved | Text | Days of the week morning snacks served at the site during operation Data displayed as: S/M/T/W/TH/F/SA; multiple entries separated by commas |
| CEStatus | cestatus | cestatus | Text | Contracting Entity is eligible and/or participating in nutrition program. Data displayed as: Active/Inactive |
| CETerminationStatus | ceterminationstatus | ceterminationstatus | Text | Termination category for Contracting Entity (CE) that is no longer participating in this TDA nutrition program. Data displayed as: Self Cancelled/TDA cancelled/(blank – not terminated). New field added for program year 2018-2019 |
| SuperintendentSalutation | superintendentsalutation | superintendentsalutation | Text | Honorific salutation for CE administrator/superintendent. Optional entry for CE. Format: Mr., Ms., Dr., etc. |
| SiteEndDate | siteenddate | siteenddate | Calendar date | Operational end date for the site |
| SiteStreetAddressLine1 | sitestreetaddressline1 | sitestreetaddressline1 | Text | Site street address, line 1 |
| BreakfastTime | breakfasttime | breakfasttime | Text | Time breakfast service starts and ends. Data displayed as: H:MM – H:MM |
| ChildNutDirPhone | childnutdirphone | childnutdirphone | Text | Child Nutrition Director (CND) phone number |
| ChildNutDirEmail | childnutdiremail | childnutdiremail | Text | Child Nutrition Director (CND) email address |
| SuperintendentTitlePosition | superintendenttitleposition | superintendenttitleposition | Text | CE administrator/superintendent title or position |
| CEMailingAddressLine1 | cemailingaddressline1 | cemailingaddressline1 | Text | Contracting Entity (CE) mailing address, line 1 |
| CEStreetAddressCity | cestreetaddresscity | cestreetaddresscity | Text | Contracting Entity (CE) street address, city |
| ProgramYear | programyear | programyear | Text | A program period for summer feeding programs is defined as mid-May through the end of August for the same calendar year. |
| Days Of Operation | days_of_operation | days_of_operation | Text | Days of the week meals served at the site during operation. Data displayed as: S/M/T/W/TH/F/SA; multiple entries separated by commas |
| ChildNutDirLastName | childnutdirlastname | childnutdirlastname | Text | Child Nutrition Director (CND) last name |
| ChildNutDirFirstName | childnutdirfirstname | childnutdirfirstname | Text | Child Nutrition Director (CND) first name |
| SuperintendentLastName | superintendentlastname | superintendentlastname | Text | CE administrator/superintendent last name |
| SiteTerminatedAsOfDate | siteterminatedasofdate | siteterminatedasofdate | Calendar date | Date that participation in this TDA nutrition program effectively ends for the site. Data displayed as: MM/DD/YYYY / (blank – not terminated). New field added for program year 2018-2019 |
| SupperTime | suppertime | suppertime | Text | Time supper service starts and ends. Data displayed as: H:MM – H:MM |
| CEStreetAddressZipCode | cestreetaddresszipcode | cestreetaddresszipcode | Text | Contracting Entity (CE) street address, zip code |
| CEStreetAddressLine1 | cestreetaddressline1 | cestreetaddressline1 | Text | Contracting Entity (CE) street address, line 1 |
| CECounty | cecounty | cecounty | Text | County in which the Contracting Entity (CE) is located |
| PMSnackDaysServed | pmsnackdaysserved | pmsnackdaysserved | Text | Days of the week afternoon snacks served at the site during operation Data displayed as: S/M/T/W/TH/F/SA; multiple days separated by commas |
| LunchTime | lunchtime | lunchtime | Text | Time lunch service starts and ends. Data displayed as: H:MM – H:MM |
| BreakfastDaysServed | breakfastdaysserved | breakfastdaysserved | Text | Days of the week breakfast served at the site during operation Data displayed as: S/M/T/W/TH/F/SA; multiple entries separated by commas |
| Meal Types Served | meal_types_served | meal_types_served | Text | Type of meals served at the site during operation. Data displayed as: Breakfast/Lunch/Dinner/AM Snack/PM Snack; multiple entries separated by commas |
| SiteStartDate | sitestartdate | sitestartdate | Calendar date | Operational start date for the site |
| SeamlessSummerContactPhone | seamlesssummercontactphone | seamlesssummercontactphone | Text | Summer program contact phone number |
| SiteStreetAddressLine2 | sitestreetaddressline2 | sitestreetaddressline2 | Text | Site street address, line 2 (if applicable) |
| CountyDistrictCode | countydistrictcode | countydistrictcode | Text | County District Code for county in which Contracting Entity (CE) in located |
| CEName | cename | cename | Text | Contracting Entity (CE) name |
| SiteType | sitetype | sitetype | Text | Site type description. Data displayed as: Camp/Closed/Open/Open Restricted |
| SiteStreetCity | sitestreetcity | sitestreetcity | Text | Site street address, city |
| SiteID | siteid | siteid | Text | Identification number assigned to site within CE |
| PMSnackTime | pmsnacktime | pmsnacktime | Text | Time afternoon snack service starts and ends. Data displayed as: H:MM – H:MM |
| CETerminatedAsOfDate | ceterminatedasofdate | ceterminatedasofdate | Calendar date | Date that participation in this TDA nutrition program effectively ends for the Contracting Entity (CE). Data displayed as: MM/DD/YYYY / (blank – not terminated). New field added for program year 2018-2019 |
| SiteCounty | sitecounty | sitecounty | Text | County in which the site is located |
| TDARegion | tdaregion | tdaregion | Text | Texas Department of Agriculture (TDA) service region |
| CEMailingAddressLine2 | cemailingaddressline2 | cemailingaddressline2 | Text | Contracting Entity (CE) mailing address, line 2 (if applicable) |
| CEMailingAddressState | cemailingaddressstate | cemailingaddressstate | Text | Contracting Entity (CE) mailing address, state |
| SiteTerminationStatus | siteterminationstatus | siteterminationstatus | Text | Termination category for site that is no longer participating in this TDA nutrition program. Data for SSO displayed as: Contracting Entity Closed /Self Cancelled/TDA cancelled/TDA Terminated(blank – not terminated). New field added for program year 2018-2019 |
| CEApplicationCycle | ceapplicationcycle | ceapplicationcycle | Text | Description of Contracting Entity (CE) application type based on program participation in previous program year. Data displayed as: Continuing/NewApp/Renewal. New field added for program year 2018-2019 |
| New Georeferenced Column | geocoded_column | geocoded_column | Point | Geo-location of site based on site street address for map visualization. |
| SupperDaysServed | supperdaysserved | supperdaysserved | Text | Days of the week supper served at the site during operation Data displayed as: S/M/T/W/TH/F/SA; multiple days separated by commas |
| AMSnackTime | amsnacktime | amsnacktime | Text | Time morning snack service starts and ends. Data displayed as: H:MM – H:MM |
| SiteName | sitename | sitename | Text | Site name |
| TypeOfAgency | typeofagency | typeofagency | Text | Type of agency the Contracting Entity (CE) operates as. Data displayed as: Educational Institution/Government Agency/Indian Tribe/Military Installation/Private Non Profit Organization |
| Counties | :@computed_region_fd5q_j34z | :@computed_region_fd5q_j34z | Number | |
| Texas Congressional Districts | :@computed_region_ywmh_rrwq | :@computed_region_ywmh_rrwq | Number | |
| Texas Senate Districts | :@computed_region_hy99_5a2i | :@computed_region_hy99_5a2i | Number | |
| Texas House Districts | :@computed_region_346f_s9gh | :@computed_region_346f_s9gh | Number | |
| Texas Councils of Government | :@computed_region_9y59_55ru | :@computed_region_9y59_55ru | Number |