School Nutrition Programs – Food Service Management Company (FSMC) Information – Program Year 2024-2025
City of Austin
@usgov.city_of_austin_school_nutrition_programs_food_service__5d7b3c3e
City of Austin
@usgov.city_of_austin_school_nutrition_programs_food_service__5d7b3c3e
CREATE TABLE table_1 (
"programyear" VARCHAR,
"reporttype" VARCHAR,
"ceid" BIGINT,
"cename" VARCHAR,
"typeofagency" VARCHAR,
"typeoforg" VARCHAR,
"countydistrictcode" DOUBLE,
"cecounty" VARCHAR,
"esc" BIGINT,
"tdaregion" BIGINT,
"fsmcmanaged" VARCHAR,
"fsmcname" VARCHAR,
"initialyear" DOUBLE,
"finalyear" DOUBLE,
"numberofrenewalyears" DOUBLE,
"effectivedate" TIMESTAMP,
"enddate" TIMESTAMP,
"terminateddate" TIMESTAMP,
"procurementtype" VARCHAR,
"cestreetaddressline1" VARCHAR,
"cestreetaddressline2" VARCHAR,
"cestreetaddresscity" VARCHAR,
"cestreetaddressstate" VARCHAR,
"cestreetaddresszipcode" VARCHAR,
"cemailingaddressline1" VARCHAR,
"cemailingaddressline2" VARCHAR,
"cemailingaddresscity" VARCHAR,
"cemailingaddressstate" VARCHAR,
"cemailingaddresszipcode" VARCHAR,
"superintendentsalutation" VARCHAR,
"superintendentfirstname" VARCHAR,
"superintendentlastname" VARCHAR,
"superintendenttitleposition" VARCHAR,
"superintendentemail" VARCHAR,
"superintendentphone" BIGINT,
"childnutdirsalutation" VARCHAR,
"childnutdirfirstname" VARCHAR,
"childnutdirlastname" VARCHAR,
"childnutdirtitleposition" VARCHAR,
"childnutdiremail" VARCHAR,
"childnutdirphone" BIGINT
);
Anyone who has the link will be able to view this.