2010 - 2016 School Safety Report by US Government | Demographics and Population Studies

About this Dataset

2010 - 2016 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:04:51.141238
Tags: lifelong-learning, nypd, report, safety, school

Tables

Table 1

@usgov.city_of_new_york_2010_2016_school_safety_report.table_1

374.07 KB
6310 rows
34 columns


CREATE TABLE table_1 (
  "school_year" VARCHAR,
  "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" BIGINT,
  "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,
  "borough_name" VARCHAR,
  "postcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);