Washington Crimes Dataset

March 2025 Civic Difficulty 5/5 PDF · TXT · XLSX 2.4 MB 3,867 rows × 29 cols 0 downloads
  • crime
  • washington-dc
  • geographic
  • offences
  • civic

3,867 Washington DC crime reports with offence group, ward, neighbourhood cluster, police service area, shift, method, and timestamps. Supports ward-level offence density, method-distribution analysis, and report-time studies.

Source: opendata.dc.gov · opendata.dc.gov · DC Open Data (public domain)

Challenge brief

slug: 2025-03-washington-crimes title: Washington Crimes Dataset year: 2025 month: 03 source: authored authored_at: 2026-04-19 needs_leon_review: true

Washington Crimes Dataset - Challenge Brief

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

About the data

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

  • ANC
  • LATITUDE
  • BLOCK
  • offensegroup
  • location
  • sector
  • YBLOCK
  • METHOD
  • CCN
  • END_DATE
  • LONGITUDE
  • offense-text
  • NEIGHBORHOOD_CLUSTER
  • SHIFT
  • PSA
  • CENSUS_TRACT
  • WARD
  • BID
  • OCTO_RECORD_ID
  • DISTRICT
  • XBLOCK
  • YEAR
  • REPORT_DAT
  • ucr-rank
  • offensekey
  • ...and 4 more columns

Suggested analytical angles

  • Which wards and police service areas have the highest offence density?
  • How does offence type distribute across shift and method?
  • Which neighbourhood clusters show the sharpest year-over-year moves?
  • How do reporting times compare with start/end timestamps?

What great submissions did

This brief was reconstructed from the dataset contents in 2026 as part of the Playground audit. The original March 2025 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._

This dataset was the subject of the DataDNA March 2025 community challenge. The original scoring and leaderboard pre-date the current submission system and are not available for display.

Browse open challenges