2017 - 2018 Schools NYPD Crime Data Report
2017 - 2018 Schools NYPD Crime Data Report
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Dormant
- Says it updates
- Historical data
- Actually updates about every
- —
- Publisher last updated the data
- Apr 29, 2019
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Apr 29, 2019, 10:04 AM
- Rows in our copy
- 1,919
- Rows at the source
- 1,919
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
The publisher has not provided a data dictionary.
1 of 30 columns carry a concept; 0 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
building_name | Building Name | The publisher describes this column nowhere. | Not bound | Text | building_name | text | — | |
schools | # Schools | The publisher describes this column nowhere. | Not bound | Number | schools | numeric | — | |
register | Register | The publisher describes this column nowhere. | Not bound | Text | register | text | — | |
borough | Borough | The publisher describes this column nowhere. | boroughdeclared | Text | borough | text | — | |
engroupa | ENGroupA | The publisher describes this column nowhere. | Not bound | Text | engroupa | text | — | |
geographical_district_code | Geographical District Code | The publisher describes this column nowhere. | Not bound | Number | geographical_district_code | numeric | — | |
geocoded_column | New Georeferenced Column | The publisher describes this column nowhere. | Not bound | Point | geocoded_column | text | — | |
location_code | Location Code | The publisher describes this column nowhere. | Not bound | Text | location_code | text | — | |
location_name | Location Name | The publisher describes this column nowhere. | Not bound | Text | location_name | text | — | |
building_code | Building Code | The publisher describes this column nowhere. | Not bound | Text | building_code | text | — | |
avgofmajor_n | AvgOfMajor N | The publisher describes this column nowhere. | Not bound | Text | avgofmajor_n | text | — | |
avgofoth_n | AvgOfOth N | The publisher describes this column nowhere. | Not bound | Text | avgofoth_n | text | — | |
:@computed_region_f5dn_yrer | Community Districts | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_f5dn_yrer | numeric | — | |
:@computed_region_92fq_4b7q | City Council Districts | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_92fq_4b7q | numeric | — | |
:@computed_region_efsh_h5xi | Zip Codes | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_efsh_h5xi | numeric | — | |
avgofnocrim_n | AvgOfNoCrim N | The publisher describes this column nowhere. | Not bound | Text | avgofnocrim_n | text | — | |
:@computed_region_yeji_bk3q | Borough Boundaries | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_yeji_bk3q | numeric | — | |
avgofprop_n | AvgOfProp N | The publisher describes this column nowhere. | Not bound | Text | avgofprop_n | text | — | |
nocrim_n | NoCrim N | The publisher describes this column nowhere. | Not bound | Text | nocrim_n | text | — | |
dbn | DBN | The publisher describes this column nowhere. | Not bound | Text | dbn | text | — | |
major_n | Major N | The publisher describes this column nowhere. | Not bound | Text | major_n | text | — | |
schools_in_building | Schools in Building | The publisher describes this column nowhere. | Not bound | Text | schools_in_building | text | — | |
vio_n | Vio N | The publisher describes this column nowhere. | Not bound | Text | vio_n | text | — | |
address | Address | The publisher describes this column nowhere. | Not bound | Text | address | text | — | |
rangea | RangeA | The publisher describes this column nowhere. | Not bound | Text | rangea | text | — | |
id | ID | The publisher describes this column nowhere. | Not bound | Number | id | numeric | — | |
:@computed_region_sbqj_enih | Police Precincts | The publisher describes this column nowhere. | Not bound | Number | :@computed_region_sbqj_enih | numeric | — | |
prop_n | Prop N | The publisher describes this column nowhere. | Not bound | Text | prop_n | text | — | |
avgofvio_n | AvgOfVio N | The publisher describes this column nowhere. | Not bound | Text | avgofvio_n | text | — | |
oth_n | Oth N | The publisher describes this column nowhere. | Not bound | Text | oth_n | text | — |
Download
This file was produced on Aug 26, 2026, 10:28 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/kwvk-z7i9
- Version
- Content hash:
f1e3bc592ee64e0250f8242183cc68b05eae642e37d7a7ce6cb4eebdd61dd1e5 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Apr 29, 2019, 10:04 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 25, 2026, 10:15 PM | full_replace | success | 1,919 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.72 |