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.
This dataset has the following 34 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| School Year | school_year | text | 2013-14 2014-15 2015-16 view top 100 | |
| Building Code | building_code | text | X450 X475 M460 X410 X405 view top 100 | |
| DBN | dbn | text | 75R025 10X056 19K364 05M362 75M501 view top 100 | |
| Location Name | location_name | text | the name by which the organization is known. For a learning community, it is the official title of the school. | New Visions Charter High School for the Humanities P.S. 253 P.S. 212 New Visions Charter High School for Advanced Math P.S. 207 view top 100 |
| Location Code | location_code | text | a unique identifier that can include schools, administrative offices, learning communities, etc. When the Learning_Community_Name = ‘School’, the Location_Code is a combination of the borough code and the school number. | X695 K648 K503 K077 K403 view top 100 |
| Address | address | text | the school’s address (building number and street name). | 1980 LAFAYETTE AVENUE 99 TERRACE VIEW AVENUE 40 IRVING PLACE 240 EAST 172 STREET 3000 EAST TREMONT AVENUE view top 100 |
| Borough | borough | text | NYC Boro the location is situated in | K X M Q R view top 100 |
| Geographical District Code | geographical_district_code | text | the school’s geographical district as defined by the NYC Department of Education. | 2 10 9 31 11 view top 100 |
| Register | register | text | Number of students on register | N/A 496 255 383 504 view top 100 |
| Building Name | building_name | text | the official name of the building a school is located in | 1980 LAFAYETTE AVENUE CONSOLIDATED LOCATION 99 TERRACE VIEW AVENUE CONSOLIDATED LOCATION 40 IRVING PLACE CONSOLIDATED LOCATION 240 EAST 172 STREET CONSOLIDATED LOCATION 800 EAST GUN HILL ROAD CONSOLIDATED LOCATION view top 100 |
| # Schools | schools | text | number of schools in in the building | 1 2 3 4 5 view top 100 |
| Schools in Building | schools_in_building | text | names of the schools in the buildings | Bronx High School for Writing and Communication Ar | Bronx Lab School | High School of Computers and Technology | Bronx Academy of Health Careers | High School for Contemporary Arts | Bronx Aerospace High School | EVANDER CHILDS EVENING H.S. |800 EAST GUN HILL ROAD CONSOLIDATED LOCATION Renaissance High School for Musical Theater & Tech | Pelham Lab High School | Schuylerville Preparatory High School | Bronx River High School | Herbert H. Lehman High School. | Herbert H. Lehman Yabc | Westchester Square Academy | 3000 EAST TREMONT AVENUE CONSOLIDATED LOCATION Academy for College Preparation and Career Explora | Academy of Hospitality and Tourism | Erasmus Yabc | High School for Youth and Community Development at | High School for Service & Learning at Erasmus | Science, Technology and Research Early College Hig | 911 FLATBUSH AVENUE CONSOLIDATED LOCATION James Baldwin School, The: A School for Expedition | MANHATTAN BUSINESS ACADEMY | Landmark High School | Quest to Learn | Hudson High School of Learning Technologies | Humanities Preparatory Academy | 351 WEST 18 STREET CONSOLIDATED LOCATION Manhattan Theatre Lab High School | High School for Arts, Imagination and Inquiry | Urban Assembly School for Media Studies, The | High School for Law, Advocacy and Community Justic | High School of Arts and Technology | Manhattan / Hunter Science High School | 122 AMSTERDAM AVENUE CONSOLIDATED LOCATION view top 100 |
| Major N | major_n | text | number of major crimes | N/A 0 1 2 3 view top 100 |
| Oth N | oth_n | text | number of other crimes | N/A 0 1 2 3 view top 100 |
| NoCrim N | nocrim_n | text | number of non-criminal crimes | N/A 0 1 2 3 view top 100 |
| Prop N | prop_n | text | number of property crimes | N/A 0 1 2 3 view top 100 |
| Vio N | vio_n | text | number of violent crimes | N/A 0 1 2 3 view top 100 |
| ENGroupA | engroupa | text | group name that the building population falls under | 3C 4C 2C 5C 6C view top 100 |
| RangeA | rangea | text | building population | 251-500 501-750 1-250 751-1000 1001-1250 view top 100 |
| AvgOfMajor N | avgofmajor_n | text | average of major crimes for all buildings that have the same EnGroupA/Range A | N/A #N/A 0.27 0.33 0.31 view top 100 |
| AvgOfOth N | avgofoth_n | text | average of other crimes for all buildings that have the same EnGroupA/Range A | N/A #N/A 1.11 1.71 1.32 view top 100 |
| AvgOfNoCrim N | avgofnocrim_n | text | average of non-criminal crimes for all buildings that have the same EnGroupA/Range A | N/A #N/A 1.76 1.82 1.74 view top 100 |
| AvgOfProp N | avgofprop_n | text | average of property crimes for all buildings that have the same EnGroupA/Range A | N/A #N/A 0.83 0.79 0.75 view top 100 |
| AvgOfVio N | avgofvio_n | text | average of violent crimes for all buildings that have the same EnGroupA/Range A | N/A #N/A 0.75 0.59 0.51 view top 100 |
| Borough Name | borough_name | text | BROOKLYN BRONX MANHATTAN QUEENS STATEN IS view top 100 | |
| Postcode | postcode | number | 10456 10457 11207 11212 11221 view top 100 | |
| Latitude | latitude | number | 40.82229 40.877105 40.735494 40.840422 40.875953 view top 100 | |
| Longitude | longitude | number | -73.856167 -73.912256 -73.987659 -73.91091 -73.838545 view top 100 | |
| Community Board | community_board | number | 3 1 12 4 5 view top 100 | |
| Council District | community_council | number | 17 8 36 16 42 view top 100 | |
| Census Tract | census_tract | number | 16 409 135 291 39 view top 100 | |
| BIN | bin | number | 2022205 1064532 1017828 2007806 2057045 view top 100 | |
| BBL | bbl | number | 2036040039 1022150080 2051410150 1008720057 2028170002 view top 100 | |
| NTA | nta | text | East Concourse-Concourse Village Stuyvesant Heights Brownsville Crown Heights North East New York view top 100 |