Child and Adult Care Food Programs (CACFP) – Child Care Centers – Meal Reimbursement – Program Year 2017-2018
data.texas.gov | Last Updated 31 Mar 2023<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 our <a href=http://www.SquareMeals.org target="_blank">website</a>.</b></i><br> <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 Dataset</b><br> This data set contains claims information for <b>meal reimbursement for sites participating as Child Care Centers in CACFP for program year 2017-2018.</b> The CACFP program year begins October 1 and ends September 30. <p> <b>This dataset only includes claims submitted by CACFP sites operating as Child Care Centers.</b> Sites can participate in multiple CACFP sub-programs. For reimbursement data on CACFP participants operating as Day Care Homes, Adult Day Care Centers, At-Risk child care centers, Head Start centers, emergency shelters, or centers providing care for students outside school hours, please refer to the corresponding “Child and Adult Care Food Programs (CACFP) – Meal Reimbursement” dataset for that sub-program available on the State of Texas Open Data Portal. <p> An overview of <b>all CACFP data available</b> on the Texas Open Data Portal can be found at our <b><a href=https://data.texas.gov/stories/s/iekx-7mdi target="_blank">TDA Data Overview - Child and Adult Care Food 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>About Dataset Updates</b><br> TDA aims to post new program year data by December 15 of the active program year. <b>Participants have 60 days to file monthly reimbursement claims.</b> 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 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.
This dataset has the following 61 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
ProgramYear | programyear | text | A program year for Child and Adult Care Food Programs (CACFP) is defined as October 1 of one year through September 30 of the following year. | 2017-2018 view top 100 |
ReportType | reporttype | text | Type of information being reported in the dataset | CACFPCHILDCARECENTERCLAIMS view top 100 |
CEID | ceid | text | Unique number assigned to Contracting Entity (CE) to identify organization as a CACFP sponsor | 02328 01804 02107 02058 03256 view top 100 |
CEName | cename | text | Contracting Entity (CE) name | FP ASSISTANCE ADVANCE CHILD CARE, INC COASTAL CHILD NUTRITION SERVICES CHILD FOOD PROGRAM OF TEXAS INC SOL CARE SERVICES, INC view top 100 |
CECounty | cecounty | text | County in which the Contracting Entity (CE) is located | HARRIS KAUFMAN HIDALGO DALLAS ANGELINA view top 100 |
ESC | esc | text | Educational Service Center (ESC) region | 10 4 1 11 7 view top 100 |
TDARegion | tdaregion | text | Texas Department of Agriculture (TDA) service region | 2 3 5 1 4 view top 100 |
TypeOfAgency | typeofagency | text | Type 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 | Private Non Profit Organization For Profit Organization Educational Institution Military Installation Government Agency view top 100 |
TypeOfCACFPCentersOrg | typeofcacfpcentersorg | text | Type of organization the Contracting Entity (CE) operates as. Data displayed as: Independent Center/Sponsor of Affiliated & Unaffiliated Sites/Sponsor of Affiliated Sites/Sponsor of Unaffiliated Sites/(blank) | Sponsor of Unaffiliated Sites Sponsor of Affiliated & Unaffiliated Sites Independent Center Sponsor of Affiliated Sites view top 100 |
SiteID | siteid | text | Number assigned to identify site within CE | 1001 0001 1002 1003 1004 view top 100 |
SiteName | sitename | text | Site name | KINDERCARE LEARNING CENTER Kids Kingdom JACK & JILL DAY CARE DISCOVERY WORLD LEARNING CENTER Bright Beginnings Learning Center view top 100 |
SiteCounty | sitecounty | text | County in which the site is located | HARRIS HIDALGO DALLAS KAUFMAN BEXAR view top 100 |
Affiliation | affiliation | text | Affiliation refers to the relationship the site has with its CE sponsor. Affiliated sites are part of the Contracting Entity (CE) organization. Unaffiliated sites are not part of the Contracting Entity (CE) organization. Data displayed as: Affiliated/Unaffiliated | UNAFFILIATED AFFILIATED view top 100 |
ClaimDate | claimdate | calendar_date | Month and year for which meals were reported by the site for reimbursement. | 2018-09-01T00:00:00.000 2018-08-01T00:00:00.000 2018-04-01T00:00:00.000 2018-05-01T00:00:00.000 2018-02-01T00:00:00.000 view top 100 |
EnrollmentQty | enrollmentqty | number | Number of participants enrolled at site for claim month | 51 54 42 49 36 view top 100 |
FreeEligQty | freeeligqty | number | Number of participants enrolled at site approved for free meals for claim month | 27 28 24 29 31 view top 100 |
RedcEligQty | redceligqty | number | Number of participants enrolled at site at site approved for reduced price meals for claim month | 0 3 2 4 1 view top 100 |
PaidEligQty | paideligqty | number | Number of participants enrolled at site not approved for free or reduced price meals for claim month | 0 1 2 3 5 view top 100 |
BreakfastDays | breakfastdays | number | Number of days breakfast meals served at site for claim month | 21 20 22 19 23 view top 100 |
BreakfastTotal | breakfasttotal | number | Number of breakfast meals served at site for the claim month | 0 1 2 4 5 view top 100 |
BreakfastADP | breakfastadp | number | Average Daily Participation (ADP) for breakfast. Calculated as the number of breakfast meals served at the site in claim month divided by the number of breakfast service days at the site in claim month. | 0 0.05 2 18 0.1 view top 100 |
BreakfastServedFree | breakfastservedfree | number | Number of free breakfast meals served at site for claim month | 0 1 58 3 153 view top 100 |
BreakfastServedRedc | breakfastservedredc | number | Number of reduced price breakfast meals served at site for claim month | 0 1 2 7 5 view top 100 |
BreakfastServedPaid | breakfastservedpaid | number | Number of paid breakfast meals served at site for claim month | 0 1 2 3 5 view top 100 |
AMSnackDays | amsnackdays | number | Number of days morning snacks were served at site for claim month | 21 0 22 20 19 view top 100 |
AMSnackTotal | amsnacktotal | number | Number of morning snacks served at site for the claim month | 0 2 1 35 3 view top 100 |
AMSnackADP | amsnackadp | number | Average Daily Participation (ADP) for morning snacks. Calculated as the number of morning snacks served at site in claim month divided by number of morning snack service days at the site in claim month | 0 2 0.05 4 13 view top 100 |
AMSnackServedFree | amsnackservedfree | number | Number of free morning snacks served at site in claim month | 0 1 2 68 9 view top 100 |
AMSnackServedRedc | amsnackservedredc | number | Number of reduced price morning snacks served at site in claim month | 0 4 3 1 5 view top 100 |
AMSnackServedPaid | amsnackservedpaid | number | Number of paid morning snacks served at site in claim month | 0 2 1 3 5 view top 100 |
LunchDays | lunchdays | number | Number of days lunch was served at site for claim month | 21 20 22 19 23 view top 100 |
LunchTotal | lunchtotal | number | Number of lunch meals served at site for claim month | 0 490 704 721 553 view top 100 |
LunchADP | lunchadp | number | Average Daily Participation (ADP) for lunch. Calculated as the number of lunch meals served at the site in claim month divided by the number of lunch service days at the site in claim month. | 0 27 18 30 31 view top 100 |
LunchServedFree | lunchservedfree | number | Number of free lunch meals served at site for claim month | 0 237 252 378 270 view top 100 |
LunchServedRedc | lunchservedredc | number | Number of reduced price lunch meals served at site for claim month | 0 11 9 10 8 view top 100 |
LunchServedPaid | lunchservedpaid | number | Number of paid lunch meals served at site for claim month | 0 11 13 15 12 view top 100 |
PMSnackDays | pmsnackdays | number | Number of days afternoon snacks served at site for claim month | 21 20 22 19 23 view top 100 |
PMSnackTotal | pmsnacktotal | number | Number of afternoon snacks served at site for the claim month | 0 575 525 597 900 view top 100 |
PMSnackADP | pmsnackadp | number | Average Daily Participation (ADP) for afternoon snacks. Calculated as the number of afternoon snack served at site in claim month divided by number of afternoon snack service days at the site in claim month | 0 25 30 45 46 view top 100 |
PMSnackServedFree | pmsnackservedfree | number | Number of free afternoon snacks served at site in claim month | 0 210 429 306 293 view top 100 |
PMSnackServedRedc | pmsnackservedredc | number | Number of reduced price afternoon snacks served at site in claim month | 0 15 16 30 14 view top 100 |
PMSnackServedPaid | pmsnackservedpaid | number | Number of paid afternoon snacks served at site in claim month | 0 17 16 18 19 view top 100 |
SupperDays | supperdays | number | Number of days supper meals served at site for claim month | 21 20 22 19 23 view top 100 |
SupperTotal | suppertotal | number | Number of supper meals served at site in the claim month | 0 633 512 419 575 view top 100 |
SupperADP | supperadp | number | Average Daily Participation (ADP) for supper meals. Calculated as the number of supper meals served at site in claim month divided by number of site supper service days for site in claim month | 0 32 34 18 29 view top 100 |
SupperServedFree | supperservedfree | number | Number of free supper meals served at site in claim month | 0 260 320 275 190 view top 100 |
SupperServedRedc | supperservedredc | number | Number of reduced price supper meals served at site in claim month | 0 15 12 16 17 view top 100 |
SupperServedPaid | supperservedpaid | number | Number of paid supper meals served at site in claim month | 0 16 18 17 19 view top 100 |
NTSnackDays | ntsnackdays | number | Number of days evening snacks served at site for claim month | 0 26 21 22 25 view top 100 |
NTSnackTotal | ntsnacktotal | number | Number of evening snacks served at site for the claim month | 0 1 2 16 6 view top 100 |
NTSnackADP | ntsnackadp | number | Average Daily Participation (ADP) for evening snacks. Calculated as the number of evening snack meals served at site in claim month divided by number of evening snack service days at site in claim month | 0 0.05 0.04 0.1 2.81 view top 100 |
NTSnackServedFree | ntsnackservedfree | number | Number of free evening snacks served at site in claim month | 0 1 16 8 3 view top 100 |
NTSnackServedRedc | ntsnackservedredc | number | Number of reduced price evening snacks served at site in claim month | 0 2 1 3 5 view top 100 |
NTSnackServedPaid | ntsnackservedpaid | number | Number of paid evening snacks served at site in claim month | 0 1 2 4 3 view top 100 |
BreakfastReimbursement | breakfastreimbursement | number | Total breakfast meal reimbursement for claim month | 0.3000 2.0500 5.5500 0.3100 1.7500 view top 100 |
SnackAMReimbursement | snackamreimbursement | number | Total morning snack reimbursement for claim month | 0.0800 0.9600 1.8400 36.1600 1.0400 view top 100 |
LunchReimbursement | lunchreimbursement | number | Total lunch meal reimbursement for claim month | 699.4250 1523.5000 522.8375 225.0625 765.2125 view top 100 |
SnackPMReimbursement | snackpmreimbursement | number | Total afternoon snack reimbursement for claim month | 525.3600 638.0000 389.8400 284.2400 524.4800 view top 100 |
SupperReimbursement | supperreimbursement | number | Total supper meal reimbursement for claim month | 0.5425 1.0850 1229.1875 945.2625 1416.1625 view top 100 |
SnackNTReimbursement | snackntreimbursement | number | Total evening snack reimbursement for claim month | 0.0800 0.9600 0.1600 0.8800 7.2000 view top 100 |
TotalReimbursement | totalreimbursement | number | Total federal meal reimbursement for site for claim month | 2130.7650 0 3244.7950 5220.7250 1866.0975 view top 100 |