2019 School Food Report LL215
City of New York
@usgov.city_of_new_york_2019_school_food_report_ll215
City of New York
@usgov.city_of_new_york_2019_school_food_report_ll215
CREATE TABLE table_1 (
"borough" VARCHAR,
"district" BIGINT,
"building_code" VARCHAR,
"dbn" VARCHAR,
"school_name" VARCHAR,
"schoolfood_code" BIGINT,
"breakfast_before_bell_adp_fy18" DOUBLE,
"breakfast_before_bell_adp_fy19" DOUBLE,
"breakfast_in_classroom_adp_where_available_see_key_tab_fy18" DOUBLE,
"breakfast_in_classroom_adp_where_available_see_key_tab_fy19" DOUBLE,
"breakfast_before_bell_y_breakfast_before_bell_in_any_p_7bb1c00c" VARCHAR,
"breakfast_before_bell_y_breakfast_before_bell_in_any_p_3d72393c" VARCHAR,
"breakfast_in_classroom_offered_y_bic_in_any_part_of_dbn_fy18" VARCHAR,
"breakfast_in_classroom_offered_y_bic_in_any_part_of_dbn_fy19" VARCHAR,
"grab_go_offered_y_g_g_in_any_part_of_dbn_fy18" VARCHAR,
"grab_go_offered_y_g_g_in_any_part_of_dbn_fy19" VARCHAR,
"lunches_adp_fy18" DOUBLE,
"lunches_adp_fy19" DOUBLE,
"salad_bar_y_salad_bar_offered_in_building_fy18" VARCHAR,
"salad_bar_y_salad_bar_offered_in_building_fy19" VARCHAR,
"snacks_adp_fy18" DOUBLE,
"snacks_adp_fy19" DOUBLE,
"suppers_adp_fy18" DOUBLE,
"suppers_adp_fy19" DOUBLE
);
Anyone who has the link will be able to view this.