About this Dataset

School Nutrition Programs – Food Service Management Company (FSMC) Information – Program Year 2021-2022

About the Dataset
This dataset contains contact information for each Contracting Entity (CE) sponsor participating in a school nutrition programs during program year 2021-2022 and information on Food Service Management Company (FSMC) they may contract with. The school nutrition program year begins July 1 and ends June 30.

An overview of all TDA Food and Nutrition data available on the Texas Open Data Portal can be found at our TDA Data Overview - Food and Nutrition Open Data page.

About Dataset Updates
TDA aims to post new data by September 15 of the active school nutrition program year. This dataset contains multi-year data. Due to the relatively static nature of this data, there are no planned updates for this dataset. About the Agency
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 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 — Feeding the Hungry and Promoting Healthy Lifestyles.

For more information on these programs, please visit us atSquareMeals.org.
Organization: City of Austin
Last updated: 2023-08-25T22:58:10.607983
Tags: food-service-management-company, food-supplier, food-vendor, fsmc, meal, nutrition, school, school-nutrition-program, tda, texas-department-of-agriculture

Tables

Table 1

@usgov.city_of_austin_school_nutrition_programs_food_service__25021833.table_1

248.11 KB
1221 rows
39 columns


CREATE TABLE table_1 (
  "programyear" VARCHAR,
  "reporttype" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "typeofagency" VARCHAR,
  "typeoforg" VARCHAR,
  "countydistrictcode" DOUBLE,
  "cecounty" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "fsmcmanaged" VARCHAR,
  "fsmcname" VARCHAR,
  "initialyear" DOUBLE,
  "finalyear" DOUBLE,
  "numberofrenewalyears" DOUBLE,
  "effectivedate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "cestreetaddressline1" VARCHAR,
  "cestreetaddressline2" VARCHAR,
  "cestreetcity" VARCHAR,
  "cestreetstate" VARCHAR,
  "cestreetzipcode" VARCHAR,
  "cemailingaddressline1" VARCHAR,
  "cemailingaddressline2" VARCHAR,
  "cemailingcity" VARCHAR,
  "cemailingstate" VARCHAR,
  "cemailingzipcode" VARCHAR,
  "superintendentsalutation" VARCHAR,
  "superintendentfirstname" VARCHAR,
  "superintendentlastname" VARCHAR,
  "superintendenttitleposition" VARCHAR,
  "superintendentemailaddress" VARCHAR,
  "superintendentphonenumber" BIGINT,
  "childnutdirsalutation" VARCHAR,
  "childnutdirfirstname" VARCHAR,
  "childnutdirlastname" VARCHAR,
  "childnutdirtitleposition" VARCHAR,
  "childnutdiremailaddress" VARCHAR,
  "childnutdirphonenumber" BIGINT
);