Readme
Updated 2 years ago
‧ Indexed 5 hours ago
Summer Meal Programs – Seamless Summer Option (SSO) – Contacts and Program Participation – Program Period 2018
<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 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 — <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><p>
<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 2018 (SNP program year 2017-2018).</b> Summer meals programs operate mid-May through the end of August. <p>
For data on sites participating in the Summer Food Service Program (SFSP), please refer to the Summer Feeding Programs – Summer Feeding Program (SFSP) – Contact and Program Participation datasets available on the State of Texas Open Data Portal. <p>
<b>About Dataset Updates</b><br>
TDA aims to post new program year data by July 15 of the active program period. Due to the short duration of the summer feeding programs, dataset updates will occur monthly until 90 days after the close of the program period. After 90 days from the close of the program period, the dataset will be updated at six months and one year from the close of program period before becoming archived. Archived datasets will remain published but will not be updated. Any data posted during the active program year is subject to change.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| SeamlessSummerContactSalutation | seamlesssummercontactsal | seamlesssummercontactsal | Text | Honorific salutation for summer program contact. Optional entry. Format: Mr., Ms. Dr., etc. |
| CEStreetAddressState | cestreetaddressstate | cestreetaddressstate | Text | Contracting Entity (CE) street address, state |
| CountyDistrictCode | countydistrictcode | countydistrictcode | Text | County District Code for county in which Contracting Entity (CE) in located |
| CEStreetAddressZipCode | cestreetaddresszipcode | cestreetaddresszipcode | Text | Contracting Entity (CE) street address, zip code |
| SiteStreetAddressLine1 | sitestreetaddressline1 | sitestreetaddressline1 | Text | Site street address, line 1 |
| CEStreetAddressLine2 | cestreetaddressline2 | cestreetaddressline2 | Text | Contracting Entity (CE) street address, line 2 (if applicable) |
| SiteName | sitename | sitename | Text | Site name |
| CEName | cename | cename | Text | Contracting Entity (CE) name |
| ChildNutDirTitlePosition | childnutdirtitleposition | childnutdirtitleposition | Text | Child Nutrition Director (CND) title or position |
| ChildNutDirFirstName | childnutdirfirstname | childnutdirfirstname | Text | Child Nutrition Director (CND) first name |
| SuperintendentLastName | superintendentlastname | superintendentlastname | Text | CE administrator/superintendent last name |
| CEStreetAddressCity | cestreetaddresscity | cestreetaddresscity | Text | Contracting Entity (CE) street address, city |
| Georeference | geocoded_column | geocoded_column | Point | Geo-location of site based on site street address for map visualization. Null values in geolocation data is most likely due to a P.O. Box address listed for a site address. |
| 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 |
| BreakfastTime | breakfasttime | breakfasttime | Text | Time breakfast service starts and ends. Data displayed as: H:MM – H:MM |
| LunchTime | lunchtime | lunchtime | Text | Time lunch service starts and ends. Data displayed as: H:MM – H:MM |
| SiteEndDate | siteenddate | siteenddate | Calendar date | Operational end date for the site |
| SiteStartDate | sitestartdate | sitestartdate | Calendar date | Operational start date for the site |
| SeamlessSummerContactEmail | seamlesssummercontactemail | seamlesssummercontactemail | Text | Summer program contact email address |
| SeamlessSummerContactLastName | seamlesssummercontactlastname | seamlesssummercontactlastname | Text | Summer program contact last name |
| SiteStreetCity | sitestreetcity | sitestreetcity | Text | Site street address, city |
| SiteStreetAddressLine2 | sitestreetaddressline2 | sitestreetaddressline2 | Text | Site street address, line 2 (if applicable) |
| SiteCounty | sitecounty | sitecounty | Text | County in which the site is located |
| SiteID | siteid | siteid | Text | Identification number assigned to site within CE |
| ChildNutDirEmail | childnutdiremail | childnutdiremail | Text | Child Nutrition Director (CND) email address |
| SuperintendentPhone | superintendentphone | superintendentphone | Text | CE administrator/superintendent phone number |
| SuperintendentEmail | superintendentemail | superintendentemail | Text | CE administrator/superintendent email address |
| ChildNutDirLastName | childnutdirlastname | childnutdirlastname | Text | Child Nutrition Director (CND) last name |
| SuperintendentTitlePosition | superintendenttitleposition | superintendenttitleposition | Text | CE administrator/superintendent title or position |
| CEMailingAddressZipCode | cemailingaddresszipcode | cemailingaddresszipcode | Text | Contracting Entity (CE) mailing address, zip code |
| CEMailingAddressCity | cemailingaddresscity | cemailingaddresscity | Text | Contracting Entity (CE) mailing address, city |
| CEMailingAddressLine1 | cemailingaddressline1 | cemailingaddressline1 | Text | Contracting Entity (CE) mailing address, line 1 |
| CEStreetAddressLine1 | cestreetaddressline1 | cestreetaddressline1 | Text | Contracting Entity (CE) street address, line 1 |
| ESC | esc | esc | Text | Educational Service Center (ESC) region |
| SeamlessSummerContactPhone | seamlesssummercontactphone | seamlesssummercontactphone | Text | Summer program contact phone number |
| SiteStreetState | sitestreetstate | sitestreetstate | Text | Site street address, state |
| 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 |
| SuperintendentFirstName | superintendentfirstname | superintendentfirstname | Text | CE administrator/superintendent first 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 |
| CECounty | cecounty | cecounty | Text | County in which the Contracting Entity (CE) is located |
| CEID | ceid | ceid | Text | Unique number assigned to Contracting Entity (CE) to identify organization as a program sponsor |
| PMSnackTime | pmsnacktime | pmsnacktime | Text | Time afternoon snack 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 |
| 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 |
| SeamlessSummerContactTitlePosition | seamlesssummercontacttit | seamlesssummercontacttit | Text | Summer program contact title or position |
| SeamlessSummerContactFirstName | seamlesssummercontactfirstname | seamlesssummercontactfirstname | Text | Summer program contact first name |
| SiteType | sitetype | sitetype | Text | Site type description. Data displayed as: Camp/Closed/Open/Open Restricted |
| CEMailingAddressState | cemailingaddressstate | cemailingaddressstate | Text | Contracting Entity (CE) mailing address, state |
| CEMailingAddressLine2 | cemailingaddressline2 | cemailingaddressline2 | Text | Contracting Entity (CE) mailing address, line 2 (if applicable) |
| TDARegion | tdaregion | tdaregion | Text | Texas Department of Agriculture (TDA) service region |
| TypeofSNPOrg | typeofsnporg | typeofsnporg | Text | Type of organization the sponsored site operates as. Data displayed as: Charter/Private/Public/RCCI (Residential Child Care Institution) |
| 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 |
| SupperTime | suppertime | suppertime | Text | Time supper service starts and ends. Data displayed as: H:MM – H:MM |
| 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 |
| SuperintendentSalutation | superintendentsalutation | superintendentsalutation | Text | Honorific salutation for CE administrator/superintendent. Optional entry for CE. Format: Mr., Ms., Dr., etc. |
| 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. |
| ReportType | reporttype | reporttype | Text | Type of information being reported in the dataset |
| Texas Senate Districts | :@computed_region_hy99_5a2i | :@computed_region_hy99_5a2i | Number | |
| Texas Congressional Districts | :@computed_region_ywmh_rrwq | :@computed_region_ywmh_rrwq | Number | |
| ChildNutDirPhone | childnutdirphone | childnutdirphone | Text | Child Nutrition Director (CND) phone number |
| SiteStreetZipCode | sitestreetzipcode | sitestreetzipcode | Text | Site street address, zip code |
| ChildNutDirSalutation | childnutdirsalutation | childnutdirsalutation | Text | Honorific salutation for Child Nutrition Director (CND). Optional entry for CE. Format: Mr., Ms. Dr., etc. |
| Counties | :@computed_region_fd5q_j34z | :@computed_region_fd5q_j34z | Number | |
| Texas House Districts | :@computed_region_346f_s9gh | :@computed_region_346f_s9gh | Number | |
| AMSnackTime | amsnacktime | amsnacktime | Text | Time morning snack service starts and ends. Data displayed as: H:MM – H:MM |
| Texas Councils of Government | :@computed_region_9y59_55ru | :@computed_region_9y59_55ru | Number | |
| 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 |
Upstream Metadata