Average SAT Scores For NYC Public Schools

Name, location, enrollment, and scores for 2014-2015 school year

@kaggle.nycopendata_high_schools

Table List

1 table(55.97 KB)

Scores

@kaggle.nycopendata_high_schools.scores

55.97 KB
435 rows
22 columns

school_id School ID	school_name School Name	borough Borough	building_code Building Code	street_address Street Address	city City	state State	zip_code Zip Code	latitude Latitude	longitude Longitude	phone_number Phone Number	start_time Start Time	end_time End Time	student_enrollment Student Enrollment	percent_white Percent White	percent_black Percent Black	percent_hispanic Percent Hispanic	percent_asian Percent Asian	average_score_sat_math Average Score (SAT Math)	average_score_sat_reading Average Score (SAT Reading)	average_score_sat_writing Average Score (SAT Writing)	percent_tested Percent Tested
02M260	Clinton School Writers and Artists	Manhattan	M933	425 West 33rd Street	Manhattan	NY	10001	40.75321	-73.99786	212-695-9114	nan	nan		nan	nan	nan	nan				nan
06M211	Inwood Early College for Health and Information Technologies	Manhattan	M052	650 Academy Street	Manhattan	NY	10002	40.86605	-73.92486	718-935-3660	8:30 AM	3:00 PM	87	3.4%	21.8%	67.8%	4.6%				nan
01M539	New Explorations into Science, Technology and Math High School	Manhattan	M022	111 Columbia Street	Manhattan	NY	10002	40.71873	-73.97943	212-677-5190	8:15 AM	4:00 PM	1735	28.6%	13.3%	18.0%	38.5%	657	601	601	91.0%
02M294	Essex Street Academy	Manhattan	M445	350 Grand Street	Manhattan	NY	10002	40.71687	-73.98953	212-475-4773	8:00 AM	2:45 PM	358	11.7%	38.5%	41.3%	5.9%	395	411	387	78.9%
02M308	Lower Manhattan Arts Academy	Manhattan	M445	350 Grand Street	Manhattan	NY	10002	40.71687	-73.98953	212-505-0143	8:30 AM	3:00 PM	383	3.1%	28.2%	56.9%	8.6%	418	428	415	65.1%
02M545	High School for Dual Language and Asian Studies	Manhattan	M445	350 Grand Street	Manhattan	NY	10002	40.71687	-73.98953	212-475-4097	8:00 AM	3:35 PM	416	1.7%	3.1%	5.5%	88.9%	613	453	463	95.9%
01M292	Henry Street School for International Studies	Manhattan	M056	220 Henry Street	Manhattan	NY	10002	40.71376	-73.98526	212-406-9411	8:30 AM	3:30 PM	255	3.9%	24.4%	56.6%	13.2%	410	406	381	59.7%
01M696	Bard High School Early College	Manhattan	M097	525 East Houston Street	Manhattan	NY	10002	40.71896	-73.97607	212-995-8479	9:00 AM	3:50 PM	545	45.3%	17.2%	18.7%	17.1%	634	641	639	70.8%
02M305	Urban Assembly Academy of Government and Law	Manhattan	M445	350 Grand Street	Manhattan	NY	10002	40.71687	-73.98953	212-505-0745	8:32 AM	3:45 PM	329	2.7%	41.9%	49.2%	5.8%	389	395	381	80.8%
01M509	Marta Valle High School	Manhattan	M025	145 Stanton Street	Manhattan	NY	10002	40.72057	-73.98567	212-473-8152	8:00 AM	3:30 PM	363	2.5%	39.9%	51.2%	5.8%	438	413	394	35.6%


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_reading" DOUBLE,
  "average_score_sat_writing" DOUBLE,
  "percent_tested" VARCHAR
);