About this Dataset

School Nutrition Programs - Meal Reimbursement Information - Program Year 2020-2021

Help us provide the most useful data by completing our ODP User Feedback Survey for School Nutrition Data

About the Dataset
This dataset contains claims information for paid or approved to pay meal reimbursement for sites participating in school nutrition programs for program year 2020-2021. The school nutrition program year begins July 1 and ends June 30.

In October 1, 2020, USDA began allowing flexibility in School Nutrition Program policy to support continued meal access should the coronavirus pandemic (COVID-19) impact meal service operation. For more information on the waivers implemented for this purpose, please visit our website at SquareMeals.org.

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

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.

More information about accessing and working with TDA data on the Texas Open Data Portal can be found on the SquareMeals.org website on the **TDA Food and Nutrition Open Data **page.

About Dataset Updates
TDA aims to post new data by November 1 of the active program year. Participants have 60 days to file monthly reimbursement claims. Dataset updates will occur monthly until 90 days after the close of the program year. After 90 days from the close of the program year, the dataset will be updated at six months and at one year from the close of program year 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.

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 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 — Feeding the Hungry and Promoting Healthy Lifestyles.

For more information on these programs, please visit ourwebsite._
Organization: City of Austin
Last updated: 2023-08-25T22:58:47.367798
Tags: afterschool-care-program, ascp, average-daily-participation, child, food, free-eligible, meal, national-school-lunch-program, nslp, nutrition, reduced-price-eligible, reimbursement, sbp, school, school-breakfast-program, special-milk-program, tda, texas-department-of-agriculture

Tables

Table 1

@usgov.city_of_austin_school_nutrition_programs_meal_reimburs_d351e214.table_1

2 MB
36433 rows
48 columns


CREATE TABLE table_1 (
  "programyear" VARCHAR,
  "reporttype" VARCHAR,
  "ceid" BIGINT,
  "cename" VARCHAR,
  "typeofagency" VARCHAR,
  "typeoforg" VARCHAR,
  "esc" BIGINT,
  "tdaregion" BIGINT,
  "siteid" BIGINT,
  "sitename" VARCHAR,
  "countydistrictcode" DOUBLE,
  "cecounty" VARCHAR,
  "sitecounty" VARCHAR,
  "claimdate" TIMESTAMP,
  "enrollmentqty" BIGINT,
  "freeeligqty" BIGINT,
  "redceligqty" BIGINT,
  "paideligqty" BIGINT,
  "breakfastdays" BIGINT,
  "breakfasttotal" BIGINT,
  "breakfastadp" DOUBLE,
  "breakfastservedfree" BIGINT,
  "breakfastservedredc" BIGINT,
  "breakfastservedpaid" BIGINT,
  "lunchdays" BIGINT,
  "lunchtotal" BIGINT,
  "lunchadp" DOUBLE,
  "lunchservedfree" BIGINT,
  "lunchservedredc" BIGINT,
  "lunchservedpaid" BIGINT,
  "snackdays" BIGINT,
  "snacktotal" BIGINT,
  "snackadp" DOUBLE,
  "snacksservedfree" BIGINT,
  "snacksservedredc" BIGINT,
  "snacksservedpaid" BIGINT,
  "milkdays" BIGINT,
  "milktotal" BIGINT,
  "milkadp" DOUBLE,
  "milkservedfree" BIGINT,
  "milkservedreduced" BIGINT,
  "milkservedpaid" BIGINT,
  "breakfastreimbursement" DOUBLE,
  "lunchreimbursement" DOUBLE,
  "snackreimbursement" DOUBLE,
  "milkreimbursement" DOUBLE,
  "totalreimbursement" DOUBLE,
  "totalmeals_snacks" BIGINT
);