2012 - 2013 School Locations

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "ats_system_code" VARCHAR,
  "location_code" VARCHAR,
  "location_name" VARCHAR,
  "beds_number" BIGINT,
  "managed_by_name" VARCHAR,
  "location_type_description" VARCHAR,
  "location_category_description" VARCHAR,
  "grades_text" VARCHAR,
  "grades_final_text" VARCHAR,
  "open_date" VARCHAR,
  "status_descriptions" VARCHAR,
  "primary_building_code" VARCHAR,
  "primary_address_line_1" VARCHAR,
  "state_code" VARCHAR,
  "x_coordinate" VARCHAR,
  "y_coordinate" VARCHAR,
  "community_district" BIGINT,
  "council_district" BIGINT,
  "census_tract" VARCHAR,
  "borough_block_lot" BIGINT,
  "nta" VARCHAR,
  "nta_name" VARCHAR,
  "principal_name" VARCHAR,
  "principal_title" VARCHAR,
  "principal_phone_number" VARCHAR,
  "fax_number" VARCHAR,
  "geographical_district_code" BIGINT,
  "admin_district_location_code" VARCHAR,
  "administrative_district_name" VARCHAR,
  "community_school_sup_name" VARCHAR,
  "field_support_center_name" VARCHAR,
  "field_support_center_leader_name" VARCHAR,
  "school_support_team_name" VARCHAR,
  "school_support_team_leader_name" VARCHAR,
  "highschool_network_location_code" VARCHAR,
  "highschool_network_name" VARCHAR,
  "highschool_network_superintendent" VARCHAR,
  "location_1" VARCHAR
);