2015 - 16 School Safety Report

44t3-dj6xEducation24 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

B84.7 / 100

From a 500-row sample across 24 columns.

completeness97/ 25% weight

consistency92/ 20% weight

accuracy92/ 20% weight

timeliness38/ 15% weight

usability90/ 20% weight

· No obvious temporal column — limits time-series joins
· Has geographic keys — joinable to other NYC datasets

Related datasets

2010 - 2016 School Safety Report0.67
joins onregistervio_naddress+20
2019-20 School Quality Guide High Schools0.36
joins ondbn
2007 - 2008 School Progress Reports - All Schools0.35
joins ondbn
2014-15 to 2017-19 NYC Regents Exam Results - Public0.34
iZone School List0.34
joins onaddress

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

id	building_code	dbn	location_name	location_code	address	borough	geographical_district_code	register	schools	schools_in_building	major_n
1	K001	15K001	P.S. 001 The Bergen	K001	309 47 STREET	K	15	1280	1	P.S. 001 The Bergen	0
2	K002

Columns

24 queryable · 24 profiled

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

Field	Type	Description	Null	Values
`id`	integer	—	0%	`234`
`building_code`	text	—	0%	`X450X425M460`
`dbn`	text	—	16%	`10X05684K64875K077`
`location_name`	text	—	0%	`New Visions Charter High…P.S. 056 Norwood HeightsP.S. 253`
`location_code`	text	—

Query this from your own app

GET /api/datasets/44t3-dj6x
GET /api/datasets/44t3-dj6x/quality
GET /api/datasets/44t3-dj6x/related
GET /api/columns?dataset=44t3-dj6x