Child And Adult Care Food Programs (CACFP) – Centers – Site-Level Contact And Program Participation – Program Year 2022-2023
City of Austin
@usgov.city_of_austin_child_and_adult_care_food_programs_cacf_d956947d
City of Austin
@usgov.city_of_austin_child_and_adult_care_food_programs_cacf_d956947d
CREATE TABLE table_1 (
"cesiteid" VARCHAR,
"programyear" VARCHAR,
"reporttype" VARCHAR,
"ceid" BIGINT,
"cename" VARCHAR,
"dbaname" VARCHAR,
"typeofagency" VARCHAR,
"typeoforg" VARCHAR,
"esc" BIGINT,
"tdaregion" BIGINT,
"cestatus" VARCHAR,
"applicationeffectivedate" TIMESTAMP,
"ceapplicationcycle" VARCHAR,
"ceterminationstatus" VARCHAR,
"ceterminatedasofdate" TIMESTAMP,
"siteid" BIGINT,
"sitename" VARCHAR,
"sitestatus" VARCHAR,
"siteterminationstatus" VARCHAR,
"siteterminatedasofdate" TIMESTAMP,
"countydistrictcode" VARCHAR,
"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,
"sitecontactemail" VARCHAR,
"sitecontactphone" DOUBLE,
"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,
"geolocdata" VARCHAR
);
Anyone who has the link will be able to view this.