2010 - 2016 School Safety Report

qybk-bjjcEducation34 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

B85.8 / 100

From a 500-row sample across 34 columns.

completeness98/ 25% weight

consistency84/ 20% weight

accuracy95/ 20% weight

timeliness38/ 15% weight

usability100/ 20% weight

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

Related datasets

2006 - 2012 School Demographics and Accountability Snapshot0.39
joins ondbn
2019 - 2020 School Locations0.38
joins onlocation_codelongitudecensus_tract+4
Universal Pre-K (UPK) School Locations0.38
joins onboroughbinlongitude+7
2013 - 2018 Demographic Snapshot School0.38
joins ondbn
2017 - 2018 School Locations0.37

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

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

Columns

34 queryable · 34 profiled

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

Field	Type	Description	Null	Values
`school_year`	categorical	—	0%	`2013-142014-152015-16`of 3
`building_code`	text	—	0%	`X450X475M460`
`dbn`	text	—	16%	`10X05605M36219K364`
`location_name`	text	the name by which the organization is known. For a learning community, it is the official title of the school.	0%	`New Visions Charter High…P.S. 212P.S. 253`

Query this from your own app

GET /api/datasets/qybk-bjjc
GET /api/datasets/qybk-bjjc/quality
GET /api/datasets/qybk-bjjc/related
GET /api/columns?dataset=qybk-bjjc