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