Name: 2019 School Food Report LL215
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2019 School Food Report LL215

Local Law 215 report list all food items currently in school foods system and identifies meal types, student meal participation by borough, district and school.
Organization: City of New York
Last updated: 2022-03-08T00:22:27.807087

Tables

Table 1

@usgov.city_of_new_york_2019_school_food_report_ll215.table_1

141.06 kB
2,622 rows
24 columns

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) FY18,
  "breakfast_in_classroom_adp_where_available_see_key_tab_fy19" DOUBLE  -- Breakfast In Classroom ADP (where Available - See "Key" Tab) FY19,
  "breakfast_before_bell_y_breakfast_before_bell_in_any_p_7bb1c00c" VARCHAR  -- Breakfast Before Bell (Y = Breakfast Before Bell In Any Part Of DBN) FY18,
  "breakfast_before_bell_y_breakfast_before_bell_in_any_p_3d72393c" VARCHAR  -- Breakfast Before Bell (Y = Breakfast Before Bell In Any Part Of DBN) FY19,
  "breakfast_in_classroom_offered_y_bic_in_any_part_of_dbn_fy18" VARCHAR  -- Breakfast In Classroom Offered (Y = BIC In Any Part Of DBN) FY18,
  "breakfast_in_classroom_offered_y_bic_in_any_part_of_dbn_fy19" VARCHAR  -- Breakfast In Classroom Offered (Y = BIC In Any Part Of DBN) FY19,
  "grab_go_offered_y_g_g_in_any_part_of_dbn_fy18" VARCHAR  -- Grab & Go Offered (Y = G&G In Any Part Of DBN) FY18,
  "grab_go_offered_y_g_g_in_any_part_of_dbn_fy19" VARCHAR  -- Grab & Go Offered (Y = G&G In Any Part Of DBN) FY19,
  "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) FY18,
  "salad_bar_y_salad_bar_offered_in_building_fy19" VARCHAR  -- Salad Bar (Y = Salad Bar Offered In Building) FY19,
  "snacks_adp_fy18" DOUBLE,
  "snacks_adp_fy19" DOUBLE,
  "suppers_adp_fy18" DOUBLE,
  "suppers_adp_fy19" DOUBLE
);