texas-gov/summer-meal-programs-meal-count-measure-dataset-5gm9-7rqm
Icon for Socrata external plugin
 
Readme
Updated 8 months ago
Indexed 2 hours ago

Summer Meal Programs - Meal Count Measure Dataset - Oct 2020-Sep 2021

This dataset lists monthly meals served by Seamless Summer Option (SSO) and Summer Food Service Program (SFSP) sites between October 2020 and September 2021 as of October 19, 2021. <p>

This dataset is a merge of SFSP and SSO Contacts data and Meal Count data for the purposes of visualizations on the <a href=https://data.texas.gov/stories/s/52en-tt82 target="_blank">Summer Meals Data Overview page </a>. Please refer to the original datasets for the most detailed and updated information.<p>

In March 2020, USDA began allowing flexibility in nutrition assistance program policies to support continued meal access during the coronavirus pandemic (COVID-19). This included providing School Nutrition Program sponsors the option to provide meals through Seamless Summer Option (SSO) or Summer Food Service Program (SFSP) during the school year.<p>

For more information on these flexibilities, please visit our website at <a href=http://www.SquareMeals.org target="_blank">SquareMeals.org</a>.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
geoloc datageoloc_datageoloc_dataPointGeolocation data based on site address.
SiteStreetAddressZipCodesitestreetaddresszipcodesitestreetaddresszipcodeTextSite street address, zip code
SiteStreetAddressStatesitestreetaddressstatesitestreetaddressstateTextSite street address, state
SiteStreetAddressCitysitestreetaddresscitysitestreetaddresscityTextSite street address, city
SiteStreetAddressLine2sitestreetaddressline2sitestreetaddressline2TextSite street address, line 2 (if applicable)
SiteStreetAddressLine1sitestreetaddressline1sitestreetaddressline1TextSite street address, line 1
Total Meals & Snackstotal_meals_snackstotal_meals_snacksNumberTotal breakfast, lunch, snack and supper meals served by site for claim month
SupperDayssupperdayssupperdaysNumberNumber of days supper meals served at site for claim month
PMSnackTotalpmsnacktotalpmsnacktotalNumberTotal number of afternoon snacks served at site for claim month
PMSnackDayspmsnackdayspmsnackdaysNumberNumber of days afternoon snacks were served at site for claim month
LunchTotallunchtotallunchtotalNumberTotal lunches served by site for claim month
LunchDayslunchdayslunchdaysNumberNumber of days lunch meals were served at site for claim month
AMSnackTotalamsnacktotalamsnacktotalNumberTotal number of morning snacks served at site for claim month
AMSnackDaysamsnackdaysamsnackdaysNumberNumber of days morning snacks were served at site for claim month
BreakfastTotalbreakfasttotalbreakfasttotalNumberTotal breakfasts served by site for claim month
BreakfastDaysbreakfastdaysbreakfastdaysNumberNumber of days breakfast meals were served at site for claim month
ClaimDateclaimdateclaimdateCalendar dateMonth and year being reported for reimbursement of meals served
SiteCountysitecountysitecountyTextCounty in which the site is located
CountyDistrictCodecountydistrictcodecountydistrictcodeTextCounty District Code for county in which Contracting Entity (CE) in located
COVIDMealSitecovidmealsitecovidmealsiteTextCOVID-19 Meal Site indicator, Indicates whether site is operating under USDA flexibilities offered in response to the COVID-19 pandemic. Data displayed as: Yes/No.
SiteNamesitenamesitenameTextSite name
SiteIDsiteidsiteidTextIdentification number assigned to site under CE sponsorship
TDARegiontdaregiontdaregionTextTexas Department of Agriculture (TDA) service region
ESCescescTextEducational Service Center (ESC) region
TypeOfOrgtypeoforgtypeoforgTextType of organization the Contracting Entity (CE) operates as within a specific nutrition program. Data for SFSP displayed as: Nonresidential Summer Camp/Private Non Profit/Residential Camp/School Food Authority/Unit of Government. Data for School Nutrition Programs/SSO displayed as: Charter/Private/Public/RCCI (Residential Child Care Institution).
TypeOfAgencytypeofagencytypeofagencyTextType of agency the Contracting Entity (CE) operates as. Data displayed as: Educational Institution/For Profit Organization/Government Agency/Indian Tribe/Military Installation/Private Non Profit Organization/Other
CENamecenamecenameTextContracting Entity (CE) name; sponsor or district name
CEIDceidceidTextUnique number assigned by TDA to Contracting Entity (CE) to identify organization as program sponsor
ReportTypereporttypereporttypeTextType of information being reported in the dataset
Texas U.S. Congressional Districts Plan C235 (Effective Jan 2013):@computed_region_czj8_xg26:@computed_region_czj8_xg26NumberThis column was automatically created in order to record in what polygon from the dataset 'Texas U.S. Congressional Districts Plan C235 (Effective Jan 2013)' (czj8-xg26) the point in column 'geoloc_data' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Texas State House Districts Plan H414 (Effective Jan 2021):@computed_region_45pq_umjc:@computed_region_45pq_umjcNumberThis column was automatically created in order to record in what polygon from the dataset 'Texas State House Districts Plan H414 (Effective Jan 2021)' (45pq-umjc) the point in column 'geoloc_data' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Texas Senate Districts Plan S172 (Effective Jan 2013):@computed_region_5xir_5pdr:@computed_region_5xir_5pdrNumberThis column was automatically created in order to record in what polygon from the dataset 'Texas Senate Districts Plan S172 (Effective Jan 2013)' (5xir-5pdr) the point in column 'geoloc_data' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
US States Cartographic Boundary Map:@computed_region_de3d_j5mj:@computed_region_de3d_j5mjNumberThis column was automatically created in order to record in what polygon from the dataset 'US States Cartographic Boundary Map' (de3d-j5mj) the point in column 'geoloc_data' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Texas Counties Cartographic Boundary Map:@computed_region_59h5_km5p:@computed_region_59h5_km5pNumberThis column was automatically created in order to record in what polygon from the dataset 'Texas Counties Cartographic Boundary Map' (59h5-km5p) the point in column 'geoloc_data' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
ProgramYearprogramyearprogramyearTextA program period for summer meal programs (SFSP and SSO) is defined as mid-May through the end of August for the same calendar year. USDA policy flexibility due to the pandemic has extended summer meal program period from October to September.
CECountycecountycecountyTextCounty in which the Contracting Entity (CE) is located
SupperTotalsuppertotalsuppertotalNumberTotal suppers served by site for claim month
 
Preview
  • summer_meal_programs_meal_count_measure_dataset
     
Upstream Metadata