2016 DOE High School Directory

CREATE TABLE table_1 (
  "dbn" VARCHAR,
  "school_name" VARCHAR,
  "borough" VARCHAR,
  "building_code" VARCHAR,
  "shared_space" VARCHAR,
  "phone_number" VARCHAR,
  "fax_number" VARCHAR,
  "school_email" VARCHAR,
  "grade_span_min" DOUBLE,
  "grade_span_max" BIGINT,
  "expgrade_span_min" DOUBLE,
  "expgrade_span_max" DOUBLE,
  "year_at_scale" DOUBLE,
  "bus" VARCHAR,
  "subway" VARCHAR,
  "primary_address_line_1" VARCHAR,
  "city" VARCHAR,
  "state_code" VARCHAR,
  "postcode" BIGINT,
  "website" VARCHAR,
  "total_students" BIGINT,
  "campus_name" VARCHAR,
  "school_type" VARCHAR,
  "overview_paragraph" VARCHAR,
  "program_highlights" VARCHAR,
  "language_classes" VARCHAR,
  "advancedplacement_courses" VARCHAR,
  "diplomaendorsements" VARCHAR,
  "extracurricular_activities" VARCHAR,
  "psal_sports_boys" VARCHAR,
  "psal_sports_girls" VARCHAR,
  "psal_sports_coed" VARCHAR,
  "school_sports" VARCHAR,
  "partner_cbo" VARCHAR,
  "partner_hospital" VARCHAR,
  "partner_highered" VARCHAR,
  "partner_cultural" VARCHAR,
  "partner_nonprofit" VARCHAR,
  "partner_corporate" VARCHAR,
  "partner_financial" VARCHAR,
  "partner_other" VARCHAR,
  "addtl_info1" VARCHAR,
  "addtl_info2" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "se_services" VARCHAR,
  "ell_programs" VARCHAR,
  "school_accessibility_description" VARCHAR,
  "number_programs" BIGINT,
  "priority01" VARCHAR,
  "priority02" VARCHAR,
  "priority03" VARCHAR,
  "priority04" VARCHAR,
  "priority05" VARCHAR,
  "priority06" VARCHAR,
  "priority07" VARCHAR,
  "priority08" VARCHAR,
  "priority09" VARCHAR,
  "priority10" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);