Crime Incidents In 2023

District of Columbia

@usgov.district_of_columbia_crime_incidents_in_2023

Table List

1 table(2.44 MB)

Table 1

@usgov.district_of_columbia_crime_incidents_in_2023.table_1

2.44 MB
34235 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
399080.390000001	138386.609999999	13190595	Wed Nov 22 2023 01:03:22 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT F/AUTO	1 - 99 BLOCK OF RANDOLPH PLACE NW	399080.39	138386.61	5	5E	3	308	Cluster 21	003302 2	3302	Precinct 19	38.9133436609	-77.0106034249		Tue Nov 21 2023 15:00:00 GMT+0000 (Coordinated Universal Time)	Tue Nov 21 2023 15:30:00 GMT+0000 (Coordinated Universal Time)	721564658
398358	138519	13016901	Wed Feb 01 2023 00:01:54 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	1800 - 1838 BLOCK OF 5TH STREET NW	398358	138519	2	2G	3	306	Cluster 3	004801 2	4801	Precinct 21	38.9145352217	-77.0189331506		Thu Jan 26 2023 01:09:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 26 2023 01:32:00 GMT+0000 (Coordinated Universal Time)	721564668
401616	137261	13069963	Tue Feb 14 2023 05:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	HOMICIDE	1000 - 1099 BLOCK OF BLADENSBURG ROAD NE	401616	137261	5	5D	5	506	Cluster 23	008802 1	8802	Precinct 77	38.9032027733	-76.9813696038		Sat May 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat May 25 2013 01:00:00 GMT+0000 (Coordinated Universal Time)	721564670
399778	137532	5008224	Sat Apr 15 2023 00:01:51 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	201 - 299 BLOCK OF M STREET NE	399778	137532	6	6C	5	501	Cluster 25	010602 4	10602	Precinct 144	38.905645494	-77.0025594614	NOMA	Fri Apr 14 2023 23:14:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 14 2023 23:30:00 GMT+0000 (Coordinated Universal Time)	721583011
399819	128990	23000479	Mon Jan 02 2023 01:08:40 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	SEX ABUSE	4000 - 4399 BLOCK OF 3RD STREET SE	399819	128990	8	8D	7	708	Cluster 39	009810 1	9810	Precinct 125	38.8286956714	-77.0020845193		Sun Jan 01 2023 03:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 01 2023 04:00:00 GMT+0000 (Coordinated Universal Time)	721586801
404997	134537	23000858	Mon Jan 02 2023 21:05:18 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	MOTOR VEHICLE THEFT	4200 - 4299 BLOCK OF H STREET SE	404997	134537	7	7E	6	605	Cluster 33	007707 1	7707	Precinct 106	38.8786512522	-76.9424108516		Mon Jan 02 2023 19:44:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 02 2023 20:47:00 GMT+0000 (Coordinated Universal Time)	721586802
405884	134671	23001186	Tue Jan 03 2023 12:40:43 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT F/AUTO	4900 - 4971 BLOCK OF BENNING ROAD SE	405884	134671	7	7E	6	604	Cluster 33	007707 3	7707	Precinct 106	38.8798528882	-76.9321872595		Tue Jan 03 2023 12:18:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 03 2023 12:40:00 GMT+0000 (Coordinated Universal Time)	721586803
396459	138822	23001317	Tue Jan 03 2023 18:16:26 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT/OTHER	1731 - 1785 BLOCK OF FLORIDA AVENUE NW	396459	138822	1	1C	3	303	Cluster 1	003801 2	3801	Precinct 24	38.9172591466	-77.0408312112	ADAMS MORGAN	Tue Jan 03 2023 17:08:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 03 2023 17:15:00 GMT+0000 (Coordinated Universal Time)	721586804
397700	138792	23001693	Wed Jan 04 2023 17:09:36 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	MOTOR VEHICLE THEFT	1000 - 1099 BLOCK OF U STREET NW	397700	138792	1	1B	3	305	Cluster 3	004401 3	4401	Precinct 22	38.9169930207	-77.0265211617		Wed Jan 04 2023 04:10:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 04 2023 09:10:00 GMT+0000 (Coordinated Universal Time)	721586805
400232	135255	23002017	Wed Jan 04 2023 22:18:54 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	600 - 669 BLOCK OF PENNSYLVANIA AVENUE SE	400232	135255	6	6B	1	107	Cluster 26	006500 1	6500	Precinct 89	38.8851334424	-76.9973260165	CAPITOL HILL	Wed Jan 04 2023 19:51:00 GMT+0000 (Coordinated Universal Time)	Wed Jan 04 2023 21:07:00 GMT+0000 (Coordinated Universal Time)	721586806


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" TIMESTAMP,
  "end_date" TIMESTAMP,
  "objectid" BIGINT,
  "octo_record_id" VARCHAR
);