Crime Incidents In 2024

District of Columbia

@usgov.district_of_columbia_crime_incidents_in_2024

Table List

1 table(2.02 MB)

Table 1

@usgov.district_of_columbia_crime_incidents_in_2024.table_1

2.02 MB
29287 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
405841.841499999	134205.6072	24021823	Sun Feb 11 2024 21:48:38 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	4600 - 4699 BLOCK OF EASY PLACE SE	405841.841539374	134205.607161974	7	7E	6	604	Cluster 33	007707 2	7707	Precinct 106	38.8756607285	-76.9326770885		Sat Feb 03 2024 14:00:00 GMT+0000 (Coordinated Universal Time)	Sat Feb 03 2024 18:00:00 GMT+0000 (Coordinated Universal Time)	711716179
399581.509999998	129706.920000002	5094764	Mon Sep 30 2024 04:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	HOMICIDE	100 - 146 BLOCK OF WAYNE PLACE SE	399581.51	129706.92	8	8D	7	707	Cluster 39	009803 3	9803	Precinct 124	38.835153937	-77.0048200518		Mon Jul 18 2005 08:40:00 GMT+0000 (Coordinated Universal Time)	Mon Sep 30 2024 13:30:00 GMT+0000 (Coordinated Universal Time)	711718366
400040.609999999	129046.472100001	18060158	Tue Jul 30 2024 04:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	GUN	HOMICIDE	400 - 599 BLOCK OF CHESAPEAKE STREET SE	400040.610045991	129046.472149186	8	8E	7	706	Cluster 39	009802 2	9802	Precinct 125	38.8292044165	-76.9995323037		Sun Apr 15 2018 16:07:00 GMT+0000 (Coordinated Universal Time)	Sun Apr 15 2018 17:34:56 GMT+0000 (Coordinated Universal Time)	711735582
399333.630000003	129224.32	23176298	Sat Feb 24 2024 05:00:00 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	OTHERS	HOMICIDE	4000 - 4098 BLOCK OF SOUTH CAPITOL STREET	399333.63	129224.32	8	8D	7	708	Cluster 39	009807 1	9807	Precinct 124	38.8308063012	-77.0076745977		Fri Nov 03 2023 18:45:00 GMT+0000 (Coordinated Universal Time)	Fri Nov 03 2023 18:45:00 GMT+0000 (Coordinated Universal Time)	711741844
404689.009999998	135000.84	24000194	Mon Jan 01 2024 11:50:13 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	OTHERS	THEFT/OTHER	4000 - 4099 BLOCK OF E STREET SE	404689.01	135000.84	7	7F	6	603	Cluster 32	007703 2	7703	Precinct 103	38.882831399	-76.9459571922		Mon Jan 01 2024 10:54:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 2024 11:40:00 GMT+0000 (Coordinated Universal Time)	711743519
404131.289999999	135546.489999998	24000237	Mon Jan 01 2024 18:34:30 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT F/AUTO	3600 - 3699 BLOCK OF B STREET SE	404131.29	135546.49	7	7F	6	603	Cluster 32	007703 3	7703	Precinct 107	38.8877496193	-76.9523818676		Mon Jan 01 2024 13:55:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 2024 15:48:00 GMT+0000 (Coordinated Universal Time)	711743520
397162.060000002	140182.43	24000423	Mon Jan 01 2024 22:05:01 GMT+0000 (Coordinated Universal Time)	EVENING	OTHERS	THEFT/OTHER	3100 - 3299 BLOCK OF 14TH STREET NW	397162.06	140182.43	1	1A	3	302	Cluster 2	002802 1	2802	Precinct 39	38.9295168861	-77.0327298633		Mon Jan 01 2024 20:52:00 GMT+0000 (Coordinated Universal Time)	Mon Jan 01 2024 21:30:00 GMT+0000 (Coordinated Universal Time)	711743521
400383.644599997	134411.385299999	24000746	Tue Jan 02 2024 15:27:36 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT/OTHER	700 - 799 BLOCK OF L STREET SE	400383.644606309	134411.385274164	8	8F	1	106	Cluster 27	007203 2	7203	Precinct 131	38.8775337805	-76.9955786635	CAPITOL RIVERFRONT	Tue Jan 02 2024 14:30:00 GMT+0000 (Coordinated Universal Time)	Tue Jan 02 2024 14:40:00 GMT+0000 (Coordinated Universal Time)	711743522
400489.770000003	128759.199999999	24001136	Wed Jan 03 2024 06:50:44 GMT+0000 (Coordinated Universal Time)	MIDNIGHT	OTHERS	THEFT/OTHER	700 - 860 BLOCK OF SOUTHERN AVENUE SE	400489.77	128759.2	8	8E	7	706	Cluster 39	009811 2	9811	Precinct 125	38.8266163993	-76.9943596393		Sat Dec 30 2023 17:06:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 31 2023 17:00:00 GMT+0000 (Coordinated Universal Time)	711743523
397833.869999997	138551.890000001	23101994	Wed Feb 07 2024 18:11:44 GMT+0000 (Coordinated Universal Time)	DAY	OTHERS	THEFT F/AUTO	900 - 999 BLOCK OF WESTMINSTER STREET NW	397833.87	138551.89	1	1B	3	305	Cluster 3	004402 2	4402	Precinct 137	38.9148303703	-77.0249767573		Sun Jun 25 2023 07:34:00 GMT+0000 (Coordinated Universal Time)	Sun Jun 25 2023 08:09:00 GMT+0000 (Coordinated Universal Time)	711743632


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