Crime Incidents In 2022

District of Columbia

@usgov.district_of_columbia_crime_incidents_in_2022

Table List

1 table(1.79 MB)

Table 1

@usgov.district_of_columbia_crime_incidents_in_2022.table_1

1.79 MB
27163 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
404097	135820	13160143	Tue Mar 01 2022 05:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	HOMICIDE	3652 - 3701 BLOCK OF MINNESOTA AVENUE NE	404097	135820	7	7F	6	603	Cluster 32	009603 3	9603	Precinct 102	38.8902136604	-76.9527754705		Wed Nov 06 2013 18:07:00 GMT+0000 (Coordinated Universal Time)	Wed Nov 06 2013 18:07:00 GMT+0000 (Coordinated Universal Time)	721564655
402876	141106	8007762	Mon Jun 20 2022 17:20:04 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	MOTOR VEHICLE THEFT	BUNKER HILL ROAD NE AND RANDOLPH STREET NE	402876	141106	5	5B	5	503	Cluster 24	009400 1	9400	Precinct 69	38.9378365598	-76.9668273215		Mon Jun 20 2022 04:00:00 GMT+0000 (Coordinated Universal Time)		721564659
397594	144050	4000307	Wed Mar 23 2022 20:11:08 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	6100 - 6199 BLOCK OF GEORGIA AVENUE NW	397594	144050	4	4A	4	402	Cluster 17	001804 2	1804	Precinct 60	38.9643583252	-77.0277618794		Fri Mar 18 2022 04:00:00 GMT+0000 (Coordinated Universal Time)		721564660
401480	136535	17097719	Mon Feb 28 2022 05:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	HOMICIDE	1500 - 1599 BLOCK OF F STREET NE	401480	136535	6	6A	5	507	Cluster 25	007901 3	7901	Precinct 81	38.8966629446	-76.9829390726		Fri Jun 09 2017 04:20:00 GMT+0000 (Coordinated Universal Time)	Fri Jun 09 2017 04:30:32 GMT+0000 (Coordinated Universal Time)	721564777
397496	136885	22036998	Thu Mar 17 2022 13:19:38 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT/OTHER	1200 - 1299 BLOCK OF H STREET NW	397496	136885	2	2C	2	209	Cluster 8	005802 1	5802	Precinct 129	38.8998135505	-77.0288665199	DOWNTOWN	Thu Mar 17 2022 05:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 17 2022 05:01:00 GMT+0000 (Coordinated Universal Time)	721586432
397746	137450	22037098	Fri Mar 18 2022 12:25:53 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT/OTHER	1100 - 1199 BLOCK OF 10TH STREET NW	397746	137450	2	2G	3	307	Cluster 8	004902 3	4902	Precinct 129	38.9049039473	-77.0259863335		Thu Mar 17 2022 16:04:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 17 2022 16:05:00 GMT+0000 (Coordinated Universal Time)	721586433
397171	137408	22037767	Fri Mar 18 2022 23:18:46 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	1100 - 1199 BLOCK OF VERMONT AVENUE NW	397171	137408	2	2C	2	207	Cluster 8	010100 1	10100	Precinct 17	38.904523934	-77.0326153266	DOWNTOWN	Fri Mar 18 2022 22:01:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 18 2022 22:28:00 GMT+0000 (Coordinated Universal Time)	721586434
397799	141494	22038198	Sat Mar 19 2022 20:08:09 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	4100 - 4199 BLOCK OF GEORGIA AVENUE NW	397799	141494	4	4C	4	404	Cluster 18	002503 1	2503	Precinct 47	38.9413337274	-77.0253882636		Sat Mar 19 2022 19:37:00 GMT+0000 (Coordinated Universal Time)	Sat Mar 19 2022 20:00:00 GMT+0000 (Coordinated Universal Time)	721586435
398273	134400	22039334	Tue Mar 22 2022 01:03:50 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	1000 - 1199 BLOCK OF 6TH STREET SW	398273	134400	6	6D	1	105	Cluster 9	010201 1	10201	Precinct 142	38.8774296052	-77.0199028919	SOUTHWEST	Mon Mar 21 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 21 2022 23:45:00 GMT+0000 (Coordinated Universal Time)	721586436
397198	143908	22039608	Tue Mar 22 2022 15:35:54 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT F/AUTO	1328 - 1399 BLOCK OF PEABODY STREET NW	397198	143908	4	4A	4	402	Cluster 17	001804 3	1804	Precinct 60	38.9630779796	-77.0323305856		Sun Mar 20 2022 17:45:00 GMT+0000 (Coordinated Universal Time)	Sun Mar 20 2022 20:05:00 GMT+0000 (Coordinated Universal Time)	721586437


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
);