2015 - 16 School Safety Report by US Government | Demographics and Population Studies

About this Dataset

2015 - 16 School Safety Report

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.
Organization: City of New York
Last updated: 2020-11-10T17:00:37.756742

Tables

Table 1

@usgov.city_of_new_york_2015_16_school_safety_report.table_1

179.47 KB
2070 rows
24 columns


CREATE TABLE table_1 (
  "id" DOUBLE,
  "building_code" VARCHAR,
  "dbn" VARCHAR,
  "location_name" VARCHAR,
  "location_code" VARCHAR,
  "address" VARCHAR,
  "borough" VARCHAR,
  "geographical_district_code" DOUBLE,
  "register" VARCHAR,
  "building_name" VARCHAR,
  "n__schools" DOUBLE,
  "schools_in_building" VARCHAR,
  "major_n" VARCHAR,
  "oth_n" VARCHAR,
  "nocrim_n" VARCHAR,
  "prop_n" VARCHAR,
  "vio_n" VARCHAR,
  "engroupa" VARCHAR,
  "rangea" VARCHAR,
  "avgofmajor_n" VARCHAR,
  "avgofoth_n" VARCHAR,
  "avgofnocrim_n" VARCHAR,
  "avgofprop_n" VARCHAR,
  "avgofvio_n" VARCHAR
);