From a 500-row sample across 26 columns.
borolocation_descx_coord_cd+23borolongitude:@computed_region_92fq_4b7q+7x_coord_cdlongitude:@computed_region_92fq_4b7q+9Mappable — Socrata point column `geocoded_column`.
Open on the map →| incident_key | occur_date | occur_time | boro | loc_of_occur_desc | precinct | jurisdiction_code | loc_classfctn_desc | location_desc | statistical_murder_flag | perp_age_group | perp_sex |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 308408221 | 2025-06-20T00:00:00.000 | 19:06:00 | QUEENS | OUTSIDE | 104 | 0 | STREET | (null) | N | 25-44 | M |
| 306062049 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
incident_key | text | Randomly generated persistent ID for each arrest | 0% | 311327863311757222309605579 |
occur_date | datetime | Exact date of the shooting incident | 0% | 2025-08-17T00:00:00.0002025-08-23T00:00:00.0002025-09-01T00:00:00.000 |
occur_time | text | Exact time of the shooting incident | 0% | 03:27:0014:30:0019:27:00 |
boro | categorical | Borough where the shooting incident occurred | 0% | BRONXBROOKLYN |
GET /api/datasets/98wc-x49t GET /api/datasets/98wc-x49t/quality GET /api/datasets/98wc-x49t/related GET /api/columns?dataset=98wc-x49t
x_coord_cdlongitude:@computed_region_92fq_4b7q+10borolocation_descx_coord_cd+10borolongitude:@computed_region_92fq_4b7q+7x_coord_cdvic_sexlongitude+11x_coord_cdvic_sexlongitude+12| 2025-05-08T00:00:00.000 |
| 00:25:00 |
| BRONX |
| OUTSIDE |
| 47 |
| 2 |
| HOUSING |
| MULTI DWELL - PUBLIC HOUS |
| N |
| (null) |
| (null) |
| 312202110 | 2025-09-01T00:00:00.000 | 19:34:00 | BRONX | OUTSIDE | 49 | 0 | STREET | (null) | N | 18-24 | M |
| 312957372 | 2025-09-15T00:00:00.000 | 17:32:00 | MANHATTAN | OUTSIDE | 25 | 0 | STREET | (null) | N | 18-24 | M |
| 311949658 | 2025-08-26T00:00:00.000 | 15:30:00 | BRONX | OUTSIDE | 48 | 0 | STREET | (null) | N | 25-44 | M |
| 311757222 | 2025-08-23T00:00:00.000 | 19:27:00 | BRONX | OUTSIDE | 47 | 0 | PLAYGROUND | (null) | Y | 18-24 | M |
| 301565779 | 2025-02-23T00:00:00.000 | 23:41:00 | BRONX | INSIDE | 43 | 0 | DWELLING | MULTI DWELL - APT BUILD | N | 18-24 | M |
| 312521185 | 2025-09-07T00:00:00.000 | 19:15:00 | BRONX | OUTSIDE | 42 | 0 | STREET | (null) | N | (null) | (null) |
| 307528851 | 2025-06-04T00:00:00.000 | 02:52:00 | BROOKLYN | OUTSIDE | 71 | 0 | STREET | (null) | N | 25-44 | M |
| 305412877 | 2025-04-27T00:00:00.000 | 07:11:00 | QUEENS | OUTSIDE | 109 | 0 | STREET | (null) | N | 25-44 | M |
Showing 12 of 26 columns. All of them are listed below.
MANHATTANloc_of_occur_desc | categorical | — | 0% | OUTSIDEINSIDEof 2 |
precinct | integer | Precinct where the shooting incident occurred | 0% | 754744 |
jurisdiction_code | categorical | Jurisdiction where the shooting incident occurred. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions | 0% | 021of 3 |
loc_classfctn_desc | categorical | — | 0% | STREETHOUSINGCOMMERCIALof 8 |
location_desc | categorical | Location of the shooting incident | 0% | (null)MULTI DWELL - PUBLIC HOU…MULTI DWELL - APT BUILDof 15 |
statistical_murder_flag | categorical | Shooting resulted in the victim’s death which would be counted as a murder | 0% | NYof 2 |
perp_age_group | categorical | Perpetrator’s age within a category | 0% | (null)25-4418-24of 6 |
perp_sex | categorical | Perpetrator’s sex description | 0% | M(null)Fof 3 |
perp_race | categorical | Perpetrator’s race description | 0% | BLACK(null)WHITE HISPANICof 6 |
vic_age_group | categorical | Victim’s age within a category | 0% | 25-4418-24<18of 6 |
vic_sex | categorical | Victim’s sex description | 0% | MFIof 3 |
vic_race | categorical | Victim’s race description | 0% | BLACKWHITE HISPANICBLACK HISPANICof 7 |
x_coord_cd | integer | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 9956001028261997853 |
y_coord_cd | integer | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 182496257789230889 |
latitude | float | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 40.6675940.874135870.0 |
longitude | float | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | -73.959087-73.840860670.0 |
geocoded_column | coordinate | — | 0% | {'coordinates': [-73.959…{'coordinates': [-73.840…{'coordinates': [0.0, 0.… |