Dataset: Crime Incidents In The Last 30 Days

About this Dataset

Crime Incidents In The Last 30 Days

The dataset contains a subset of locations and attributes of incidents reported in the ASAP (Analytical Services Application) crime report database by the District of Columbia Metropolitan Police Department (MPD). Visit https://crimecards.dc.gov for more information. This data is shared via an automated process where addresses are geocoded to the District's Master Address Repository and assigned to the appropriate street block. Block locations for some crime points could not be automatically assigned resulting in 0,0 for x,y coordinates. These can be interactively assigned using the MAR Geocoder.

On February 1 2020, the methodology of geography assignments of crime data was modified to increase accuracy. From January 1 2020 going forward, all crime data will have Ward, ANC, SMD, BID, Neighborhood Cluster, Voting Precinct, Block Group and Census Tract values calculated prior to, rather than after, anonymization to the block level. This change impacts approximately one percent of Ward assignments.
Organization: District of Columbia
Last updated: 2024-04-30T18:21:43.282703
Tags: assault, burglary, cdw, crime, district-of-columbia, feeds, homicide, mpd, robbery, safety, theft, washington-dc

Tables

Table 1

@usgov.district_of_columbia_crime_incidents_in_the_last_30_days.table_1

210.02 KB
2168 rows
25 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "ccn" BIGINT,
  "report_dat" TIMESTAMP,
  "shift" VARCHAR,
  "method" VARCHAR,
  "offense" VARCHAR,
  "block" VARCHAR,
  "xblock" DOUBLE,
  "yblock" DOUBLE,
  "ward" BIGINT,
  "anc" VARCHAR,
  "district" DOUBLE,
  "psa" DOUBLE,
  "neighborhood_cluster" VARCHAR,
  "block_group" VARCHAR,
  "census_tract" BIGINT,
  "voting_precinct" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "bid" VARCHAR,
  "start_date" TIMESTAMP,
  "end_date" TIMESTAMP,
  "objectid" BIGINT,
  "octo_record_id" VARCHAR
);