NYPD Arrest Data (Year to Date)

November 2021 Civic Difficulty 2/5 CSV 3.8 MB 115,299 rows × 19 cols 0 downloads
  • nypd
  • crime
  • arrests
  • geographic
  • demographics

115,299 year-to-date NYPD arrest records with offence code, borough, precinct, age group, sex, and race fields. Supports precinct-level offence mapping, demographic-breakdown studies, and month-over-month trend dashboards.

Source: NYC Open Data · opendata.cityofnewyork.us · Public domain

Challenge brief


slug: 2021-11-nypd-arrest-data-year-to-date title: NYPD Arrest Data (Year to Date) year: 2021 month: 11 source: authored authored_at: 2026-04-19 needs_leon_review: true

NYPD Arrest Data (Year to Date) - Challenge Brief

Challenge period: November 2021 Dataset: Reconstructed brief based on the shipped data file for the November 2021 DataDNA challenge.

About the data

The primary data table for this challenge carries the following columns:

  • ARREST_KEY
  • ARREST_DATE
  • PD_CD
  • PD_DESC
  • KY_CD
  • OFNS_DESC
  • LAW_CODE
  • LAW_CAT_CD
  • ARREST_BORO
  • ARREST_PRECINCT
  • JURISDICTION_CODE
  • AGE_GROUP
  • PERP_SEX
  • PERP_RACE
  • X_COORD_CD
  • Y_COORD_CD
  • Latitude
  • Longitude
  • New Georeferenced Column,,,

Suggested analytical angles

  • Which precincts and offence categories dominate the year-to-date totals?
  • How do arrest patterns vary by age group, sex, and race?
  • Which boroughs show the sharpest month-over-month movement?
  • What is the balance of felony versus misdemeanour arrests across NYC?

What great submissions did

This brief was reconstructed from the dataset contents in 2026 as part of the Playground audit. The original November 2021 challenge brief was not preserved as a separate file in the source archive, so the analytical angles above are inferred from the column list. See the corresponding /challenges/ entry on datadna.onyxdata.co.uk for examples of how participants approached the data.

Editorial note

_This stub was authored by Claude on 2026-04-19 for Leon's review. Refine the suggested angles and confirm factual accuracy before setting brief_status = leon_reviewed in the audit log._

Browse open challenges