Readme
Updated 4 months ago
‧ Indexed 3 hours ago
NYPD Arrest Data (Year to Date)
This is a breakdown of every arrest effected in NYC by the NYPD during the current year.
This data is manually extracted every quarter and reviewed by the Office of Management Analysis and Planning.
Each record represents an arrest effected in NYC by the NYPD and includes information about the type of crime, the location and time of enforcement.
In addition, information related to suspect demographics is also included.
This data can be used by the public to explore the nature of police enforcement activity.
Please refer to the attached data footnotes for additional information about this dataset.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| PD_DESC | pd_desc | pd_desc | Text | Description of internal classification corresponding with PD code (more granular than Offense Description) |
| KY_CD | ky_cd | ky_cd | Number | Three digit internal classification code (more general category than PD code) |
| Latitude | latitude | latitude | Number | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) |
| City Council Districts | :@computed_region_92fq_4b7q | :@computed_region_92fq_4b7q | Number | |
| ARREST_KEY | arrest_key | arrest_key | Text | Randomly generated persistent ID for each arrest |
| LAW_CODE | law_code | law_code | Text | Law code charges corresponding to the NYS Penal Law, VTL and other various local laws |
| X_COORD_CD | x_coord_cd | x_coord_cd | Number | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) |
| Y_COORD_CD | y_coord_cd | y_coord_cd | Number | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) |
| LAW_CAT_CD | law_cat_cd | law_cat_cd | Text | Level of offense: felony, misdemeanor, violation |
| PERP_SEX | perp_sex | perp_sex | Text | Perpetrator’s sex description |
| Community Districts | :@computed_region_f5dn_yrer | :@computed_region_f5dn_yrer | Number | |
| JURISDICTION_CODE | jurisdiction_code | jurisdiction_code | Number | Jurisdiction responsible for arrest. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 and more represent non NYPD jurisdictions |
| PERP_RACE | perp_race | perp_race | Text | Perpetrator’s race description |
| Police Precincts | :@computed_region_sbqj_enih | :@computed_region_sbqj_enih | Number | |
| Zip Codes | :@computed_region_efsh_h5xi | :@computed_region_efsh_h5xi | Number | |
| ARREST_BORO | arrest_boro | arrest_boro | Text | Borough of arrest. B(Bronx), S(Staten Island), K(Brooklyn), M(Manhattan), Q(Queens) |
| AGE_GROUP | age_group | age_group | Text | Perpetrator’s age within a category |
| PD_CD | pd_cd | pd_cd | Number | Three digit internal classification code (more granular than Key Code) |
| New Georeferenced Column | geocoded_column | geocoded_column | Point | |
| OFNS_DESC | ofns_desc | ofns_desc | Text | Description of internal classification corresponding with KY code (more general category than PD description) |
| ARREST_PRECINCT | arrest_precinct | arrest_precinct | Number | Precinct where the arrest occurred |
| Longitude | longitude | longitude | Number | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) |
| ARREST_DATE | arrest_date | arrest_date | Calendar date | Exact date of arrest for the reported event |
| Borough Boundaries | :@computed_region_yeji_bk3q | :@computed_region_yeji_bk3q | Number |
Upstream Metadata