texas-gov/summer-meal-programs-all-summer-sites-contact-and-aj5s-8pui
Icon for Socrata external plugin
 
Readme
Updated 12 months ago
Indexed 4 hours ago

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

<b>About the Dataset</b><br>

This dataset contains <b>contact and program participation information for all summer meal sites approved by TDA to operate during the 2019 program period.</b> 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. <p>

An overview of <b>all summer meal program data available</b> on the Texas Open Data Portal can be found at our <b><i> <a href=https://data.texas.gov/stories/s/52en-tt82 target="_blank">TDA Data Overview - Summer Meal Programs</a> </b></i>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 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. <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>

<b>New Data Fields Available!</b><br>

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.<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=http://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 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 us at <a href=http://www.SquareMeals.org target="_blank">SquareMeals.org</a>.</b></i><br>

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
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
SiteTerminationStatussiteterminationstatussiteterminationstatusTextTermination category for site that is no longer participating in this TDA nutrition program. Data for SFSP and SSO displayed as: Contracting Entity Closed /Self Cancelled/TDA cancelled/TDA Terminated(blank – not terminated). New field added for program year 2018-2019
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
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
SupperTimesuppertimesuppertimeTextTime supper service starts and ends. Data displayed as: H:MM – H:MM
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
PMSnackTimepmsnacktimepmsnacktimeTextTime afternoon snack service starts and ends. Data displayed as: H:MM – H:MM
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
LunchTimelunchtimelunchtimeTextTime lunch service starts and ends. Data displayed as: H:MM – H:MM
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
AMSnackTimeamsnacktimeamsnacktimeTextTime morning snack 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
BreakfastTimebreakfasttimebreakfasttimeTextTime breakfast service starts and ends. Data displayed as: H:MM – H:MM
Meal Types Servedmeal_types_served_b_reakfastmeal_types_served_b_reakfastTextType of meals served at the site during operation. Data displayed as: Breakfast/Lunch/Dinner/AM Snack/PM Snack; multiple entries separated by commas
Days Of Operationdays_of_operation_s_m_t_wdays_of_operation_s_m_t_wTextDays 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
SiteEndDatesiteenddatesiteenddateCalendar dateOperational end date for the site
SiteContactPhonesitesupervisor_emailaddresssitesupervisor_emailaddressTextSite contact phone number
SiteContactEmailAddresssitesupervisor_phonenumbersitesupervisor_phonenumberTextSite contact email address
SiteContactTitlePositionsitesupervisor_titlepositionsitesupervisor_titlepositionTextSite contact title or position
SiteContactLastNamesitesupervisor_lastnamesitesupervisor_lastnameTextSite contact last name
SiteContactFirstNamesitesupervisor_firstnamesitesupervisor_firstnameTextSite contact first name
SiteContactSalutationsitesupervisor_salutationsitesupervisor_salutationTextHonorific salutation for site contact. Optional entry. Format: Mr., Ms. Dr., etc.
SiteStreetAddressZipCodesitestreetaddresszipcodesitestreetaddresszipcodeTextSite street address, zip code
SiteStreetAddressStatesitestreetaddressstatesitestreetaddressstateTextSite street address, state
SiteStreetAddressLine2sitestreetaddressstreet2sitestreetaddressstreet2TextSite street address, line 2 (if applicable)
SiteStreetAddressLine1sitestreetaddressstreet1sitestreetaddressstreet1TextSite street address, line 1
SiteTypesitetypesitetypeTextSite type description. Data displayed as: Camp-Non-Residential/Camp-Residential/Closed/Closed-Enrolled in Needy Area/Closed-Enrolled in Non-Needy Area/Homeless (site is not a residential child care institution)/Open/Open Restricted
SiteCountysitecountysitecountyTextCounty in which the site is located
SiteNamesitenamesitenameTextSite name
SiteIDsiteidsiteidTextIdentification number assigned to site within CE
ProgrCoordinatorPhoneprimaryauthorizedreprese_5primaryauthorizedreprese_5TextProgram coordinator phone number
ProgrCoordinatorEmailAddressprimaryauthorizedreprese_4primaryauthorizedreprese_4TextProgram coordinator email address
ProgrCoordinatorTitlePositionprimaryauthorizedreprese_3primaryauthorizedreprese_3TextProgram coordinator title or position
ProgrCoordinatorLastNameprimaryauthorizedreprese_2primaryauthorizedreprese_2TextProgram coordinator last name
ProgrCoordinatorFirstNameprimaryauthorizedreprese_1primaryauthorizedreprese_1TextProgram coordinator first name
ProgrAdministratorPhonece_administrator_phonenumberce_administrator_phonenumberTextProgram administrator phone number
ProgrAdministratorEmailAddressce_administrator_emailaddressce_administrator_emailaddressTextProgram administrator email address
ProgrAdministratorTitlePositionce_administrator_titlepositionce_administrator_titlepositionTextProgram administrator title or position
ProgrAdministratorLastNamece_administrator_lastnamece_administrator_lastnameTextProgram administrator last name
ProgrAdministratorFirstNamece_administrator_firstnamece_administrator_firstnameTextProgram administrator first name
CEMailingAddressZipCodecemailingaddresszipcodecemailingaddresszipcodeTextContracting Entity (CE) mailing address, zip code
CEMailingAddressCitycemailingaddresscitycemailingaddresscityTextContracting Entity (CE) mailing address, city
CEMailingAddressLine2cemailingaddressline2cemailingaddressline2TextContracting Entity (CE) mailing address, line 2 (if applicable)
CEStreetAddressZipCodecestreetaddresszipcodecestreetaddresszipcodeTextContracting Entity (CE) street address, zip code
CEStreetAddressStatecestreetaddressstatecestreetaddressstateTextContracting Entity (CE) street address, state
CEStreetAddressCitycestreetaddresscitycestreetaddresscityTextContracting Entity (CE) street address, city
CEStreetAddressLine2cestreetaddressline2cestreetaddressline2TextContracting Entity (CE) street address, line 2 (if applicable)
CEStreetAddressLine1cestreetaddressline1cestreetaddressline1TextContracting Entity (CE) street address, line 1
ESCescescTextEducational Service Center (ESC) region
CECountycecountycecountyTextCounty in which the Contracting Entity (CE) is located
CountyDistrictCodecountydistrictcodecountydistrictcodeTextCounty District Code for county in which Contracting Entity (CE) in located
TypeOfAgencytypeofagencytypeofagencyTextType of agency the Contracting Entity (CE) operates as. Data displayed as: Educational Institution/Government Agency/Indian Tribe/Military Installation/Private Non Profit Organization
CENamecenamecenameTextContracting Entity (CE) name
CEIDceidceidTextUnique number assigned to Contracting Entity (CE) to identify organization as a program sponsor
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
CEStatuscestatuscestatusTextContracting Entity is eligible and/or participating in nutrition program. Data displayed as: Active/Inactive. New field added for program year 2018-2019
SiteStartDatesitestartdatesitestartdateCalendar dateOperational start date for the site
SiteStreetAddressCitysitestreetaddresscitysitestreetaddresscityTextSite street address, city
TypeofOrgtypeof_x_orgtypeof_x_orgTextType of organization the sponsor operates as. Data displayed as: Charter/Nonresidential Summer Camp/Private Nonprofit/Residential Camp/Public/School Food Authority/Unit of Government
Texas House Districts:@computed_region_346f_s9gh:@computed_region_346f_s9ghNumber
SiteStatussitestatussitestatusTextSite is eligible and/or participating in nutrition program. Data displayed as: Active/Inactive. 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
ProgrCoordinatorSalutationprimaryauthorizedrepreseprimaryauthorizedrepreseTextHonorific salutation for program coordinator. Optional entry for CE. Format: Mr., Ms. Dr., etc.
CEMailingAddressLine1cemailingaddressline1cemailingaddressline1TextContracting Entity (CE) mailing address, line 1
TDARegiontdaregiontdaregionTextTexas Department of Agriculture (TDA) service region
ProgrAdministratorSalutationce_administrator_salutationce_administrator_salutationTextHonorific salutation for program administrator. Optional entry for CE. Format: Mr., Ms., Dr., etc.
CEMailingAddressStatecemailingaddressstatecemailingaddressstateTextContracting Entity (CE) mailing address, state
ReportTypereporttypereporttypeTextType of information being reported in the dataset
ProgramprogramprogramTextEducational institutions participating in School Nutrition Programs are eligible to participate in the Seamless Summer Option (SSO) or the Summer Food Service Program (SFSP). Private non-profit organizations are eligible to participate in SFSP only. Data is displayed as: SFSP/SSO.
ProgramYearprogramyearprogramyearTextA program period for summer meal programs is defined as mid-May through the end of August for the same calendar year.
Texas State House Districts Plan H414 (Effective Jan 2021):@computed_region_45pq_umjc:@computed_region_45pq_umjcNumber
Texas U.S. Congressional Districts Plan C235 (Effective Jan 2013):@computed_region_czj8_xg26:@computed_region_czj8_xg26Number
Texas Senate Districts Plan S172 (Effective Jan 2013):@computed_region_5xir_5pdr:@computed_region_5xir_5pdrNumber
Texas Counties Cartographic Boundary Map:@computed_region_59h5_km5p:@computed_region_59h5_km5pNumber
US States Cartographic Boundary Map:@computed_region_de3d_j5mj:@computed_region_de3d_j5mjNumber
ESC Regions:@computed_region_dvbw_p2gv:@computed_region_dvbw_p2gvNumber
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 Councils of Government:@computed_region_9y59_55ru:@computed_region_9y59_55ruNumber
 
Preview
  • summer_meal_programs_all_summer_sites_contact_and
     
Upstream Metadata