Name: Average SAT Scores For NYC Public Schools
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Average SAT Scores For NYC Public Schools

Content

This dataset consists of a row for every accredited high school in New York City with its department ID number, school name, borough, building code, street address, latitude/longitude coordinates, phone number, start and end times, student enrollment with race breakdown, and average scores on each SAT test section for the 2014-2015 school year.

Acknowledgements

The high school data was compiled and published by the New York City Department of Education, and the SAT score averages and testing rates were provided by the College Board.

Inspiration

Which public high school's students received the highest overall SAT score? Highest score for each section? Which borough has the highest performing schools? Do schools with lower student enrollment perform better?

Tables

Scores

@kaggle.nycopendata_high_schools.scores

57.31 kB
435 rows
22 columns

CREATE TABLE scores (
  "school_id" VARCHAR,
  "school_name" VARCHAR,
  "borough" VARCHAR,
  "building_code" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "phone_number" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "student_enrollment" DOUBLE,
  "percent_white" VARCHAR,
  "percent_black" VARCHAR,
  "percent_hispanic" VARCHAR,
  "percent_asian" VARCHAR,
  "average_score_sat_math" DOUBLE  -- Average Score (SAT Math),
  "average_score_sat_reading" DOUBLE  -- Average Score (SAT Reading),
  "average_score_sat_writing" DOUBLE  -- Average Score (SAT Writing),
  "percent_tested" VARCHAR
);