2016 - 2017 School Safety Report

rear-wh5iEducation42 columns

Since 1998, the New York City Police Department (NYPD) has been tasked with the collection and maintenance of crime data for incidents that occur in New York City public schools. The NYPD has provided this data to the New York City Department of Education (DOE). The DOE has compiled this data by schools and locations for the information of our parents and students, our teachers and staff, and the general public. In some instances, several Department of Education learning communities co-exist within a single building. In other instances, a single school has locations in several different buildings. In either of these instances, the data presented here is aggregated by building location rather than by school, since safety is always a building-wide issue. We use “consolidated locations” throughout the presentation of the data to indicate the numbers of incidents in buildings that include more than one learning community.

View on NYC Open Data

Quality

B82.6 / 100

From a 500-row sample across 38 columns.

completeness91/ 25% weight

consistency78/ 20% weight

accuracy94/ 20% weight

timeliness37/ 15% weight

usability100/ 20% weight

· Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

2010 - 2016 School Safety Report0.69
joins onprop_navgofvio_npostcode+26
2017 - 2018 School Locations0.39
joins on:@computed_region_efsh_h5xicensus_tract:@computed_region_f5dn_yrer+8
Borough Enrollment Offices0.37
joins on:@computed_region_efsh_h5xicensus_tract:@computed_region_f5dn_yrer+11
2019 - 2020 School Locations

Geography

Mappable — Socrata point column `geocode`.

Open on the map →

Sample rows

school_year	location_name	location_code	borough	geographical_district_code	register	schools	nypd_site_code	nypd_site_name	schools_in_building	major_n	oth_n
2016 - 17	PASSAGES ACADEMY AT BELMONT(BN)	X695	K	7	618	1	211	PS 077K	Brooklyn College Academy	0	0
2016 - 17

Columns

33 queryable · 32 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`school_year`	text	—	0%	`2016 - 17`of 1
`location_name`	text	—	0%	`10 East 15th StreetÂ P.S. 93 - BRONXP.S. 212`
`location_code`	text	—	0%	`M868Q003M164`
`borough`	categorical	—	0%	`KXM`of 6
`geographical_district_code`	text	—

Query this from your own app

GET /api/datasets/rear-wh5i
GET /api/datasets/rear-wh5i/quality
GET /api/datasets/rear-wh5i/related
GET /api/columns?dataset=rear-wh5i