CACFP - Meal Count Measure Dataset - 2018-2019

This dataset is derived from published 202018-2019 Child and Adult Care Food Program (CACFP) meal reimbursement data for the purpose of providing visualizations for the TDA Data Overview story.<p>

This dataset reports the number of breakfasts, lunches, suppers and snacks served by Child and Adult Care Food Program (CACFP) participants for this program year. Data displayed is a snapshot of approved monthly claims from all sub-program operators of CACFP. Please refer to the original Meal Reimbursement datasets for the most detailed and updated data. <p>

The CACFP program year starts October 1 and ends September 30. Participants have 60 days to file claims. <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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"texas-gov/cacfp-meal-count-measure-dataset-20182019-xawa-edfn\".\"cacfp_meal_count_measure_dataset_20182019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.