2019 - 2020 School Locations

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "system_code" VARCHAR,
  "location_code" VARCHAR,
  "location_name" VARCHAR,
  "beds" BIGINT,
  "managed_by_name" VARCHAR,
  "location_type_description" VARCHAR,
  "location_category_description" VARCHAR,
  "grades_text" VARCHAR,
  "grades_final_text" VARCHAR,
  "open_date" TIMESTAMP,
  "status_descriptions" VARCHAR,
  "primary_building_code" VARCHAR,
  "primary_address_line_1" VARCHAR,
  "state_code" VARCHAR,
  "x_coordinate" VARCHAR,
  "y_coordinate" VARCHAR,
  "longitude" VARCHAR,
  "latitude" VARCHAR,
  "community_district" VARCHAR,
  "council_district" VARCHAR,
  "census_tract" VARCHAR,
  "borough_block_lot" VARCHAR,
  "nta" VARCHAR,
  "nta_name" VARCHAR,
  "principal_name" VARCHAR,
  "principal_title" VARCHAR,
  "principal_phone_number" VARCHAR,
  "fax_number" VARCHAR,
  "geographical_district_code" BIGINT,
  "administrative_district_code" BIGINT,
  "administrative_district_name" VARCHAR,
  "community_school_sup_name" VARCHAR,
  "tier_3_support_location_name" VARCHAR,
  "tier_3_support_leader_name" VARCHAR,
  "tier_2_support_location_name" VARCHAR,
  "highschool_network_location_code" VARCHAR,
  "highschool_network_name" VARCHAR,
  "highschool_network_superintendent" VARCHAR,
  "community_district_1" VARCHAR,
  "police_precinct" VARCHAR
);