From a 500-row sample across 13 columns.
incident_keyincident_keyoccur_timelocation_descboro+10occur_timelocation_descboro+10Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| incident_key | occur_date | occur_time | boro | loc_of_occur_desc | precinct | jurisdiction_code | loc_classfctn_desc | location_desc | x_coord_cd | y_coord_cd | latitude |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 212200405 | 2020-04-20T00:00:00.000 | 19:36:00 | BROOKLYN | OUTSIDE | 79 | 2 | HOUSING | MULTI DWELL - PUBLIC HOUS | 1000301 | 192923 | -73.94211757 |
| 139554478 |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
incident_key | text | Randomly generated persistent ID for each incident | — | — |
occur_date | datetime | Exact date of the shooting incident | — | — |
occur_time | text | Exact time of the shooting incident | — | — |
boro | text | Borough where the shooting incident occurred | — | — |
loc_of_occur_desc | text | Flag indicating where incident occurred | — | — |
precinct | numeric | Precinct where the shooting incident occurred | — |
GET /api/datasets/5ucz-vwe8 GET /api/datasets/5ucz-vwe8/quality GET /api/datasets/5ucz-vwe8/related GET /api/columns?dataset=5ucz-vwe8
y_coord_cdlatitudeloc_of_occur_desc+3y_coord_cdlatitudeloc_of_occur_desc+3latitudelongitude| 2014-11-07T00:00:00.000 |
| 03:20:00 |
| BRONX |
| INSIDE |
| 42 |
| 0 |
| DWELLING |
| PVT HOUSE |
| 1012185 |
| 241494 |
| -73.89905912 |
| 167619814 | 2017-08-01T00:00:00.000 | 00:35:00 | BRONX | OUTSIDE | 47 | 2 | HOUSING | MULTI DWELL - PUBLIC HOUS | 1030360 | 261043 | -73.83324993 |
| 212516311 | 2020-04-29T00:00:00.000 | 15:30:00 | BRONX | OUTSIDE | 46 | 0 | STREET | — | 1009085 | 248078 | -73.91023649 |
| 270150948 | 2023-06-20T00:00:00.000 | 23:41:00 | QUEENS | OUTSIDE | 108 | 0 | STREET | — | 1004925 | 209948 | -73.92539 |
| 167754133 | 2017-08-04T00:00:00.000 | 00:30:00 | BROOKLYN | OUTSIDE | 70 | 0 | STREET | — | 993205 | 175595 | -73.96773051 |
| 212640530 | 2020-05-02T00:00:00.000 | 19:50:00 | QUEENS | OUTSIDE | 114 | 0 | STREET | — | 1009645 | 213978 | -73.90834136 |
| 300261481 | 2025-01-29T00:00:00.000 | 13:30:00 | QUEENS | OUTSIDE | 114 | 0 | HOUSING | MULTI DWELL - PUBLIC HOUS | 1002916 | 221441 | -73.93260812 |
| 167835442 | 2017-08-06T00:00:00.000 | 04:33:00 | MANHATTAN | OUTSIDE | 32 | 0 | STREET | — | 999981 | 234730 | -73.94317377 |
| 139601978 | 2014-11-10T00:00:00.000 | 08:33:00 | BRONX | OUTSIDE | 52 | 0 | STREET | — | 1013985 | 256643 | -73.89248769 |
Showing 12 of 13 columns. All of them are listed below.
| — |
jurisdiction_code | numeric | "Jurisdiction where the shooting incident occurred. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD Codes 3 and above represent non NYPD jurisdictions" | — | — |
loc_classfctn_desc | text | Category describing type of location | — | — |
location_desc | text | Category for specific type of location of the shooting incident | — | — |
x_coord_cd | numeric | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | — | — |
y_coord_cd | numeric | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | — | — |
latitude | numeric | Midblock Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | — | — |
longitude | numeric | Midblock Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | — | — |