texas-gov/summer-meal-programs-seamless-summer-option-sso-3hpz-ajxk
Icon for Socrata external plugin
 
Readme
Updated 2 years ago
Indexed 5 hours ago

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

NameSocrata field nameColumn name in sgr mountData typeDescription
SiteStatussitestatussitestatusTextSite is eligible and/or participating in nutrition program. Data displayed as: Active/Inactive. New field added for program year 2018-2019
SeamlessSummerContactTitlePositionseamlesssummercontacttitseamlesssummercontacttitTextSummer program contact title or position
SeamlessSummerContactLastNameseamlesssummercontactlastnameseamlesssummercontactlastnameTextSummer program contact last name
SiteStreetZipCodesitestreetzipcodesitestreetzipcodeTextSite street address, zip code
ChildNutDirTitlePositionchildnutdirtitlepositionchildnutdirtitlepositionTextChild Nutrition Director (CND) title or position
SuperintendentPhonesuperintendentphonesuperintendentphoneTextCE administrator/superintendent phone number
ESCescescTextEducational Service Center (ESC) region
TypeofOrgtypeofsnporgtypeofsnporgTextType of organization the sponsored site operates as. Data displayed as: Charter/Private/Public/RCCI (Residential Child Care Institution)
ChildNutDirSalutationchildnutdirsalutationchildnutdirsalutationTextHonorific salutation for Child Nutrition Director (CND). Optional entry for CE. Format: Mr., Ms. Dr., etc.
SiteApplicationCyclesiteapplicationcyclesiteapplicationcycleTextDescription 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
CEStreetAddressStatecestreetaddressstatecestreetaddressstateTextContracting Entity (CE) street address, state
LunchDaysServedlunchdaysservedlunchdaysservedTextDays 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
SeamlessSummerContactEmailseamlesssummercontactemailseamlesssummercontactemailTextSummer program contact email address
SeamlessSummerContactFirstNameseamlesssummercontactfirstnameseamlesssummercontactfirstnameTextSummer program contact first name
CEMailingAddressZipCodecemailingaddresszipcodecemailingaddresszipcodeTextContracting Entity (CE) mailing address, zip code
CEMailingAddressCitycemailingaddresscitycemailingaddresscityTextContracting Entity (CE) mailing address, city
SeamlessSummerContactSalutationseamlesssummercontactsalseamlesssummercontactsalTextHonorific salutation for summer program contact. Optional entry. Format: Mr., Ms. Dr., etc.
CEStreetAddressLine2cestreetaddressline2cestreetaddressline2TextContracting Entity (CE) street address, line 2 (if applicable)
SuperintendentEmailsuperintendentemailsuperintendentemailTextCE administrator/superintendent email address
SuperintendentFirstNamesuperintendentfirstnamesuperintendentfirstnameTextCE administrator/superintendent first name
CEIDceidceidTextUnique number assigned to Contracting Entity (CE) to identify organization as a program sponsor
ReportTypereporttypereporttypeTextType of information being reported in the dataset
SiteStreetStatesitestreetstatesitestreetstateTextSite street address, state
AMSnackDaysServedamsnackdaysservedamsnackdaysservedTextDays 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
CEStatuscestatuscestatusTextContracting Entity is eligible and/or participating in nutrition program. Data displayed as: Active/Inactive
CETerminationStatusceterminationstatusceterminationstatusTextTermination 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
SuperintendentSalutationsuperintendentsalutationsuperintendentsalutationTextHonorific salutation for CE administrator/superintendent. Optional entry for CE. Format: Mr., Ms., Dr., etc.
SiteEndDatesiteenddatesiteenddateCalendar dateOperational end date for the site
SiteStreetAddressLine1sitestreetaddressline1sitestreetaddressline1TextSite street address, line 1
BreakfastTimebreakfasttimebreakfasttimeTextTime breakfast service starts and ends. Data displayed as: H:MM – H:MM
ChildNutDirPhonechildnutdirphonechildnutdirphoneTextChild Nutrition Director (CND) phone number
ChildNutDirEmailchildnutdiremailchildnutdiremailTextChild Nutrition Director (CND) email address
SuperintendentTitlePositionsuperintendenttitlepositionsuperintendenttitlepositionTextCE administrator/superintendent title or position
CEMailingAddressLine1cemailingaddressline1cemailingaddressline1TextContracting Entity (CE) mailing address, line 1
CEStreetAddressCitycestreetaddresscitycestreetaddresscityTextContracting Entity (CE) street address, city
ProgramYearprogramyearprogramyearTextA program period for summer feeding programs is defined as mid-May through the end of August for the same calendar year.
Days Of Operationdays_of_operationdays_of_operationTextDays 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
ChildNutDirLastNamechildnutdirlastnamechildnutdirlastnameTextChild Nutrition Director (CND) last name
ChildNutDirFirstNamechildnutdirfirstnamechildnutdirfirstnameTextChild Nutrition Director (CND) first name
SuperintendentLastNamesuperintendentlastnamesuperintendentlastnameTextCE administrator/superintendent last name
SiteTerminatedAsOfDatesiteterminatedasofdatesiteterminatedasofdateCalendar dateDate 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
SupperTimesuppertimesuppertimeTextTime supper service starts and ends. Data displayed as: H:MM – H:MM
CEStreetAddressZipCodecestreetaddresszipcodecestreetaddresszipcodeTextContracting Entity (CE) street address, zip code
CEStreetAddressLine1cestreetaddressline1cestreetaddressline1TextContracting Entity (CE) street address, line 1
CECountycecountycecountyTextCounty in which the Contracting Entity (CE) is located
PMSnackDaysServedpmsnackdaysservedpmsnackdaysservedTextDays 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
LunchTimelunchtimelunchtimeTextTime lunch service starts and ends. Data displayed as: H:MM – H:MM
BreakfastDaysServedbreakfastdaysservedbreakfastdaysservedTextDays 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 Servedmeal_types_servedmeal_types_servedTextType of meals served at the site during operation. Data displayed as: Breakfast/Lunch/Dinner/AM Snack/PM Snack; multiple entries separated by commas
SiteStartDatesitestartdatesitestartdateCalendar dateOperational start date for the site
SeamlessSummerContactPhoneseamlesssummercontactphoneseamlesssummercontactphoneTextSummer program contact phone number
SiteStreetAddressLine2sitestreetaddressline2sitestreetaddressline2TextSite street address, line 2 (if applicable)
CountyDistrictCodecountydistrictcodecountydistrictcodeTextCounty District Code for county in which Contracting Entity (CE) in located
CENamecenamecenameTextContracting Entity (CE) name
SiteTypesitetypesitetypeTextSite type description. Data displayed as: Camp/Closed/Open/Open Restricted
SiteStreetCitysitestreetcitysitestreetcityTextSite street address, city
SiteIDsiteidsiteidTextIdentification number assigned to site within CE
PMSnackTimepmsnacktimepmsnacktimeTextTime afternoon snack service starts and ends. Data displayed as: H:MM – H:MM
CETerminatedAsOfDateceterminatedasofdateceterminatedasofdateCalendar dateDate 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
SiteCountysitecountysitecountyTextCounty in which the site is located
TDARegiontdaregiontdaregionTextTexas Department of Agriculture (TDA) service region
CEMailingAddressLine2cemailingaddressline2cemailingaddressline2TextContracting Entity (CE) mailing address, line 2 (if applicable)
CEMailingAddressStatecemailingaddressstatecemailingaddressstateTextContracting Entity (CE) mailing address, state
SiteTerminationStatussiteterminationstatussiteterminationstatusTextTermination 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
CEApplicationCycleceapplicationcycleceapplicationcycleTextDescription 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 Columngeocoded_columngeocoded_columnPointGeo-location of site based on site street address for map visualization.
SupperDaysServedsupperdaysservedsupperdaysservedTextDays 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
AMSnackTimeamsnacktimeamsnacktimeTextTime morning snack service starts and ends. Data displayed as: H:MM – H:MM
SiteNamesitenamesitenameTextSite name
TypeOfAgencytypeofagencytypeofagencyTextType 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_j34zNumber
Texas Congressional Districts:@computed_region_ywmh_rrwq:@computed_region_ywmh_rrwqNumber
Texas Senate Districts:@computed_region_hy99_5a2i:@computed_region_hy99_5a2iNumber
Texas House Districts:@computed_region_346f_s9gh:@computed_region_346f_s9ghNumber
Texas Councils of Government:@computed_region_9y59_55ru:@computed_region_9y59_55ruNumber
 
Preview
  • summer_meal_programs_seamless_summer_option_sso
     
Upstream Metadata