From a 500-row sample across 26 columns.
loc_classfctn_desc:@computed_region_f5dn_yrerloc_of_occur_desc+23:@computed_region_f5dn_yrer:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+9:@computed_region_f5dn_yrer:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+10Mappable — 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 298699604 | 2024-12-31T00:00:00.000 | 19:16:00 | BROOKLYN | OUTSIDE | 69 | 0 | STREET | (null) | false | 25-44 | M |
| 298699604 |
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% | 282117921173354054263503175 |
occur_date | datetime | Exact date of the shooting incident | 0% | 2020-07-05T00:00:00.0002011-09-04T00:00:00.0002020-07-26T00:00:00.000 |
occur_time | text | Exact time of the shooting incident | 0% | 23:30:0000:30:0021:00:00 |
boro | categorical | Borough where the shooting incident occurred | 0% | BROOKLYNBRONX |
GET /api/datasets/833y-fsy8 GET /api/datasets/833y-fsy8/quality GET /api/datasets/833y-fsy8/related GET /api/columns?dataset=833y-fsy8
:@computed_region_f5dn_yrer:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+7:@computed_region_f5dn_yrer:@computed_region_92fq_4b7q:@computed_region_sbqj_enih+7loc_classfctn_descloc_of_occur_descboro+10:@computed_region_f5dn_yrerloc_of_occur_descvic_race+11:@computed_region_f5dn_yrerloc_of_occur_descvic_race+12| 2024-12-31T00:00:00.000 |
| 19:16:00 |
| BROOKLYN |
| OUTSIDE |
| 69 |
| 0 |
| STREET |
| (null) |
| false |
| 25-44 |
| M |
| 298672094 | 2024-12-30T00:00:00.000 | 12:15:00 | BRONX | OUTSIDE | 52 | 0 | STREET | (null) | false | 45-64 | M |
| 298672096 | 2024-12-30T00:00:00.000 | 16:45:00 | BRONX | OUTSIDE | 47 | 0 | STREET | (null) | false | (null) | (null) |
| 298672096 | 2024-12-30T00:00:00.000 | 16:45:00 | BRONX | OUTSIDE | 47 | 0 | STREET | (null) | false | (null) | (null) |
| 298672095 | 2024-12-30T00:00:00.000 | 20:32:00 | BRONX | INSIDE | 41 | 0 | DWELLING | MULTI DWELL - APT BUILD | true | 18-24 | M |
| 298672096 | 2024-12-30T00:00:00.000 | 16:45:00 | BRONX | OUTSIDE | 47 | 0 | STREET | (null) | false | (null) | (null) |
| 298672097 | 2024-12-30T00:00:00.000 | 18:48:00 | BROOKLYN | OUTSIDE | 60 | 2 | HOUSING | MULTI DWELL - PUBLIC HOUS | false | 25-44 | M |
| 298628070 | 2024-12-29T00:00:00.000 | 16:21:00 | BRONX | OUTSIDE | 43 | 0 | STREET | (null) | false | 18-24 | M |
| 298628071 | 2024-12-29T00:00:00.000 | 17:24:00 | MANHATTAN | OUTSIDE | 23 | 0 | STREET | (null) | false | (null) | (null) |
Showing 12 of 26 columns. All of them are listed below.
QUEENSloc_of_occur_desc | categorical | — | 86% | OUTSIDEINSIDEof 2 |
precinct | integer | Precinct where the shooting incident occurred | 0% | 757367 |
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 | — | 86% | STREETHOUSINGDWELLINGof 10 |
location_desc | text | Location of the shooting incident | 50% | MULTI DWELL - PUBLIC HOU…MULTI DWELL - APT BUILD(null) |
statistical_murder_flag | boolean | Shooting resulted in the victim’s death which would be counted as a murder | 0% | FalseTrueof 2 |
perp_age_group | categorical | Perpetrator’s age within a category | 31% | 18-2425-44UNKNOWNof 12 |
perp_sex | categorical | Perpetrator’s sex description | 31% | M(null)Uof 4 |
perp_race | categorical | Perpetrator’s race description | 31% | BLACKWHITE HISPANICUNKNOWNof 8 |
vic_age_group | categorical | Victim’s age within a category | 0% | 25-4418-24<18of 7 |
vic_sex | categorical | Victim’s sex description | 0% | MFUof 3 |
vic_race | categorical | Victim’s race description | 0% | BLACKWHITE HISPANICBLACK HISPANICof 7 |
x_coord_cd | coordinate | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 1017119.4375000000000001008276.0000000000000001026387.000000000000000 |
y_coord_cd | coordinate | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 183909.343750000000000183623.000000000000000262634.000000000000000 |
latitude | float | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 40.67141260500005740.88745131300004240.670655072000045 |
longitude | float | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | -73.881510144999936-73.847607786999959-73.913390919999983 |
geocoded_column | coordinate | Longitude and Latitude Coordinates for mapping | 0% | {'coordinates': [-73.881…{'coordinates': [-73.913…{'coordinates': [-73.847… |