Crime Incidents In 2025

District of Columbia

@usgov.district_of_columbia_crime_incidents_in_2025

Table List

1 table(590.11 KB)

Table 1

@usgov.district_of_columbia_crime_incidents_in_2025.table_1

590.11 KB
7340 rows
25 columns

x X	y Y	ccn CCN	report_dat REPORT DAT	shift SHIFT	method METHOD	offense OFFENSE	block BLOCK	xblock XBLOCK	yblock YBLOCK	ward WARD	anc ANC	district DISTRICT	psa PSA	neighborhood_cluster NEIGHBORHOOD CLUSTER	block_group BLOCK GROUP	census_tract CENSUS TRACT	voting_precinct VOTING PRECINCT	latitude LATITUDE	longitude LONGITUDE	bid BID	start_date START DATE	end_date END DATE	objectid OBJECTID
396169.170000002	137710.199999999	25018239	Sat Feb 08 2025 02:53:15 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT F/AUTO	1900 - 1999 BLOCK OF N STREET NW	396169.17	137710.2	2	2B	2	208	Cluster 6	010700 2	10700	Precinct 17	38.9072424615	-77.0441670329	GOLDEN TRIANGLE	2025/02/07 02:20:00+00	Fri Feb 07 2025 05:00:00 GMT+0000 (Coordinated Universal Time)	713452485
400588.465000004	129470.042399999	5131706	Wed Feb 05 2025 05:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	HOMICIDE	800 - 899 BLOCK OF XENIA STREET SE	400588.464990499	129470.042357579	8	8E	7	706	Cluster 39	009801 1	9801	Precinct 121	38.8330199372	-76.9932224259		2005/09/27 07:25:00+00	Tue Sep 27 2005 07:26:00 GMT+0000 (Coordinated Universal Time)	713454111
396744.979999997	137186.27	25016220	Mon Feb 03 2025 11:57:53 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	ASSAULT W/DANGEROUS WEAPON	1600 - 1699 BLOCK OF K STREET NW	396744.98	137186.27	2	2C	2	207	Cluster 6	010700 1	10700	Precinct 17	38.9025250378	-77.0375258276	GOLDEN TRIANGLE	2025/02/03 09:56:00+00	Mon Feb 03 2025 11:12:00 GMT+0000 (Coordinated Universal Time)	713752886
396738.719999999	141908.579999998	25016336	Mon Feb 03 2025 16:14:06 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	MOTOR VEHICLE THEFT	1600 - 1699 BLOCK OF ALLISON STREET NW	396738.72	141908.58	4	4E	4	404	Cluster 18	002600 2	2600	Precinct 48	38.9450650863	-77.0376204323		2025/02/03 05:30:00+00		713752887
397627.509999998	146359.84	25017594	Thu Feb 06 2025 16:23:02 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT F/AUTO	7800 - 7899 BLOCK OF EASTERN AVENUE NW	397627.51	146359.84	4	4A	4	401	Cluster 16	001600 1	1600	Precinct 62	38.9851659857	-77.0273832155		2025/02/05 21:27:00+00	Wed Feb 05 2025 23:55:00 GMT+0000 (Coordinated Universal Time)	713752888
393070.630000003	142276.379999999	25017596	Wed Feb 05 2025 23:39:00 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	4500 - 4537 BLOCK OF WISCONSIN AVENUE NW	393070.63	142276.38	3	3E	2	202	Cluster 11	001004 2	1004	Precinct 31	38.9483570552	-77.0799373128		2025/02/05 21:28:00+00	Wed Feb 05 2025 22:48:00 GMT+0000 (Coordinated Universal Time)	713752889
401911.109999999	140690.670000002	25018172	Fri Feb 07 2025 02:57:54 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	1800 - 1999 BLOCK OF NEWTON STREET NE	401911.11	140690.67	5	5B	5	504	Cluster 22	009400 2	9400	Precinct 69	38.9340977719	-76.977957819		2025/01/31 16:00:00+00	Sat Feb 01 2025 17:00:00 GMT+0000 (Coordinated Universal Time)	713752890
397265.719999999	144563.09	25018302	Fri Feb 07 2025 13:15:40 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	MOTOR VEHICLE THEFT	1300 - 1399 BLOCK OF UNDERWOOD STREET NW	397265.72	144563.09	4	4A	4	402	Cluster 17	001804 1	1804	Precinct 61	38.9689794046	-77.031551818		2025/02/07 03:30:00+00	Fri Feb 07 2025 12:24:00 GMT+0000 (Coordinated Universal Time)	713752891
401936.82	130715.374200001	25018445	Fri Feb 07 2025 18:17:07 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT/OTHER	3500 - 3599 BLOCK OF 18TH STREET SE	401936.81999975	130715.374230735	8	8E	7	704	Cluster 38	007409 3	7409	Precinct 116	38.8442365147	-76.9776894058		2025/02/06 18:12:00+00	Fri Feb 07 2025 18:13:00 GMT+0000 (Coordinated Universal Time)	713752892
406429.170000002	136659.239999998	25018755	Sat Feb 08 2025 09:25:37 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	ASSAULT W/DANGEROUS WEAPON	600 - 699 BLOCK OF DIVISION AVENUE NE	406429.17	136659.24	7	7C	6	602	Cluster 31	007804 2	7804	Precinct 97	38.8977598792	-76.9258856077		2025/02/08 04:22:00+00	Sat Feb 08 2025 06:32:00 GMT+0000 (Coordinated Universal Time)	713752893


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" DOUBLE,
  "anc" VARCHAR,
  "district" DOUBLE,
  "psa" DOUBLE,
  "neighborhood_cluster" VARCHAR,
  "block_group" VARCHAR,
  "census_tract" DOUBLE,
  "voting_precinct" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "bid" VARCHAR,
  "start_date" VARCHAR,
  "end_date" TIMESTAMP,
  "objectid" BIGINT,
  "octo_record_id" VARCHAR
);