Child And Adult Care Food Programs (CACFP) – Centers – Site-Level Contact And Program Participation – Program Year 2018-2019
City of Austin
@usgov.city_of_austin_child_and_adult_care_food_programs_cacf_22ddb3d9
City of Austin
@usgov.city_of_austin_child_and_adult_care_food_programs_cacf_22ddb3d9
CREATE TABLE table_1 (
"programyear" VARCHAR,
"reporttype" VARCHAR,
"ceid" BIGINT,
"cename" VARCHAR,
"typeofagency" VARCHAR,
"typeofceorg" VARCHAR,
"esc" BIGINT,
"tdaregion" BIGINT,
"cestatus" VARCHAR,
"ceterminationstatus" VARCHAR,
"ceterminatedasofdate" VARCHAR,
"ceapplicationcycle" VARCHAR,
"siteid" BIGINT,
"sitename" VARCHAR,
"sitestatus" VARCHAR,
"siteterminationstatus" VARCHAR,
"siteterminatedasofdate" VARCHAR,
"countydistrictcode" DOUBLE,
"cecounty" VARCHAR,
"sitecounty" VARCHAR,
"cestreetaddressline1" VARCHAR,
"cestreetaddressline2" VARCHAR,
"cestreetaddresscity" VARCHAR,
"cestreetaddressstate" VARCHAR,
"cestreetaddresszipcode" VARCHAR,
"cemailingaddressline1" VARCHAR,
"cemailingaddressline2" VARCHAR,
"cemailingaddresscity" VARCHAR,
"cemailingaddressstate" VARCHAR,
"cemailingaddresszipcode" VARCHAR,
"sitestreetaddressline1" VARCHAR,
"sitestreetaddressline2" VARCHAR,
"sitestreetaddresscity" VARCHAR,
"sitestreetaddressstate" VARCHAR,
"sitestreetaddresszipcode" VARCHAR,
"sitemailingaddressline1" VARCHAR,
"sitemailingaddressline2" VARCHAR,
"sitemailingaddresscity" VARCHAR,
"sitemailingaddressstate" VARCHAR,
"sitemailingaddresszipcode" VARCHAR,
"ceadministratorsalutation" VARCHAR,
"ceadministratorfirstname" VARCHAR,
"ceadministratorlastname" VARCHAR,
"ceadministratortitleposition" VARCHAR,
"ceadministratoremail" VARCHAR,
"ceadministratorphone" BIGINT,
"sitecontactsalutation" VARCHAR,
"sitecontactfirstname" VARCHAR,
"sitecontactlastname" VARCHAR,
"sitecontacttitleposition" VARCHAR,
"sitecontactphone" BIGINT,
"taxstatus" VARCHAR,
"taxstatusdescription" VARCHAR,
"siteaffiliation" VARCHAR,
"adultdaycare" VARCHAR,
"childcare" VARCHAR,
"outsideschoolhours" VARCHAR,
"emergencyshelter" VARCHAR,
"headstart" VARCHAR,
"at_riskafterschoolcarecenter" VARCHAR,
"at_riskonly" VARCHAR,
"sitelicensenumber" VARCHAR,
"sitelicensecapacity" DOUBLE,
"freeeligibleenrolled" DOUBLE,
"reducedpriceeligibleenrolled" DOUBLE,
"paideligibleenrolled" DOUBLE,
"totalparticipantsenrolled" DOUBLE,
"agerangeofparticipants" VARCHAR,
"mealpreparationmethod" VARCHAR,
"mealservicemethod" VARCHAR,
"foodservicecontract" VARCHAR,
"foodservicevendorname" VARCHAR,
"georeference" VARCHAR,
"applicationeffectivedate" TIMESTAMP
);
Anyone who has the link will be able to view this.