Child And Adult Care Food Programs (CACFP) – Adult Day Care Centers – Meal Reimbursement – Program Year 2017-2018
City of Austin
@usgov.city_of_austin_child_and_adult_care_food_programs_cacf_54453b3f
City of Austin
@usgov.city_of_austin_child_and_adult_care_food_programs_cacf_54453b3f
CREATE TABLE table_1 (
"odprecid" VARCHAR,
"programyear" VARCHAR,
"reporttype" VARCHAR,
"ceid" BIGINT,
"cename" VARCHAR,
"cecounty" VARCHAR,
"esc" BIGINT,
"tdaregion" BIGINT,
"typeofagency" VARCHAR,
"typeofcacfpcentersorg" VARCHAR,
"siteid" BIGINT,
"sitename" VARCHAR,
"sitecounty" VARCHAR,
"affiliation" VARCHAR,
"claimdate" TIMESTAMP,
"enrollmentqty" BIGINT,
"freeeligqty" BIGINT,
"redceligqty" DOUBLE,
"paideligqty" DOUBLE,
"breakfastdays" DOUBLE,
"breakfasttotal" DOUBLE,
"breakfastadp" DOUBLE,
"breakfastservedfree" DOUBLE,
"breakfastservedredc" DOUBLE,
"breakfastservedpaid" DOUBLE,
"amsnackdays" DOUBLE,
"amsnacktotal" DOUBLE,
"amsnackadp" DOUBLE,
"amsnackservedfree" DOUBLE,
"amsnackservedredc" DOUBLE,
"amsnackservedpaid" DOUBLE,
"lunchdays" BIGINT,
"lunchtotal" BIGINT,
"lunchadp" DOUBLE,
"lunchservedfree" BIGINT,
"lunchservedredc" BIGINT,
"lunchservedpaid" BIGINT,
"pmsnackdays" DOUBLE,
"pmsnacktotal" DOUBLE,
"pmsnackadp" DOUBLE,
"pmsnackservedfree" DOUBLE,
"pmsnackservedredc" DOUBLE,
"pmsnackservedpaid" DOUBLE,
"supperdays" DOUBLE,
"suppertotal" DOUBLE,
"supperadp" DOUBLE,
"supperservedfree" DOUBLE,
"supperservedredc" DOUBLE,
"supperservedpaid" DOUBLE,
"ntsnackdays" VARCHAR,
"ntsnacktotal" VARCHAR,
"ntsnackadp" BIGINT,
"ntsnackservedfree" VARCHAR,
"ntsnackservedredc" VARCHAR,
"ntsnackservedpaid" VARCHAR,
"totalsnacks" BIGINT,
"totalmealssnacks" BIGINT,
"breakfastreimbursement" DOUBLE,
"snackamreimbursement" DOUBLE,
"lunchreimbursement" DOUBLE,
"snackpmreimbursement" DOUBLE,
"supperreimbursement" DOUBLE,
"snackntreimbursement" VARCHAR,
"totalreimbursement" DOUBLE
);
Anyone who has the link will be able to view this.