Crashes In DC

District of Columbia

@usgov.district_of_columbia_crashes_in_dc

Table List

1 table(50.87 MB)

Table 1

@usgov.district_of_columbia_crashes_in_dc.table_1

50.87 MB
329669 rows
66 columns

x X	y Y	crimeid CRIMEID	ccn CCN	reportdate REPORTDATE	routeid ROUTEID	measure MEASURE	offset OFFSET	streetsegid STREETSEGID	roadwaysegid ROADWAYSEGID	fromdate FROMDATE	address ADDRESS	latitude LATITUDE	longitude LONGITUDE	xcoord XCOORD	ycoord YCOORD	ward WARD	eventid EVENTID	mar_address MAR ADDRESS	mar_score MAR SCORE	majorinjuries_driver MAJORINJURIES DRIVER	minorinjuries_driver MINORINJURIES DRIVER	total_vehicles TOTAL VEHICLES	nearestintrouteid NEARESTINTROUTEID	nearestintstreetname NEARESTINTSTREETNAME	offintersection OFFINTERSECTION	intapproachdirection INTAPPROACHDIRECTION	locationerror LOCATIONERROR	minorinjuriespassenger MINORINJURIESPASSENGER	mar_id MAR ID	blockkey BLOCKKEY	subblockkey SUBBLOCKKEY	corridorid CORRIDORID	nearestintkey NEARESTINTKEY	objectid OBJECTID
-8573400.22168375	4716653.61633392	23439698	10127857	Thu Sep 02 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	11076242	348.65	22.1	9506	10229	Sat Sep 04 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	300 RITTENHOUSE STREET NE	38.964753	-77.016164	398599.103	144093.557	Ward 4	{670D4DE2-7BE1-463B-80CC-F86561F25F0C}	300 RITTENHOUSE STREET NW	85			3	11000302	3RD ST NW	0.22	East			249197	6142d11c1ff026cd0698dec35360c7d5	e8b2016c5aac28903842ad7b9b5c9195	11076242_1	a2fd232ecea758dba435c76a5eb1571d	339122218
-8574267.40542859	4715164.73998293	23440847	10129344	Fri Sep 24 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	11000802	3966.93	0.03	9113	9635	Tue Sep 07 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	5308 8TH ST NW	38.954552	-77.023952	397923.873	142961.314	Ward 4	{0DDDB72D-6D3D-440E-A6D3-A00BE7347AD6}	5308 8TH STREET NW	100			2	11048422	INGRAHAM ST NW	40.45	North			254706	97e55937c305cfd948a16bf3778dfb8a	97e55937c305cfd948a16bf3778dfb8a	11000802_5	013d4fdbd6fb5997012c9d8e54f2bb2f	339122219
-8572455.50371939	4697443.69749201	23443744	10130508	Thu Sep 09 2010 10:45:00 GMT+0000 (Coordinated Universal Time)	15081252	6718.67	0.02	7836	16653	Thu Sep 09 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	SOUTH CAPITOL ST. SW	38.83065	-77.007676	399333.53	129206.954	Ward 8	{582E739C-D181-45D1-B887-1C7842174D99}	SOUTH CAPITOL SHOPPING CENTER	87.03			1	47045552	Alley-47045552	28.23	South			312984	2a949ddea23d4c7faf519d57e32c159d	a022aa6e2701e20759934e2d8f5c86c5	15081252_1	cc6e64720242a039e49d10a8256af807	339122220
-8577255.16311428	4707893.20765613	23443752	10131144	Fri Sep 10 2010 13:42:00 GMT+0000 (Coordinated Universal Time)	11053492	3319.89	19.1	-9	27520	Mon Sep 06 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	2300 L STREET NW	38.903565	-77.050792	395594.315	137302.2	Ward 2	{CDFB4C1D-C162-4A38-ADEC-E156860EC83E}	2308 L STREET NW	88			2	11002402	24TH ST NW	53.96	East			242347	d0d83b2a537b53a53ee91684d64ed4bc	b101025692e701d31f2e12533aaff19a	11053492_4	37d75a5c902ca0eb98ee2e87a4fda211	339807741
-8575302.84754143	4708557.63985712	23443763	10131450	Fri Sep 10 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	11075462	2175.55	0.03	5855	17765	Fri Sep 10 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	1400 BLOCK OF RHODE ISLAND AVE NW	38.908382	-77.033254	397115.731	137836.248	Ward 2	{263D3C30-AD3C-42BF-B69A-5A0167BFE023}	RHODE ISLAND AVENUE NW FROM 14TH STREET NW TO 15TH STREET NW	100	1		2	0	0 Intersecting RouteID Not Found		East			806822	b7fde3e52c71a521ea0262e6c3b0867d	2140c70182ab9c07e42e9506620d7161	11075462_2	0	339807742
-8569382.55719491	4709817.57330451	23443786	10130689	Sat Sep 11 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	12064672	2743.28	0.06	11347	13349	Thu Sep 09 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	1600 BLOCK NEW YORK AVENUE NE	38.917189	-76.980071	401728.26	138813.546	Ward 5	{E21EF003-4C6D-44B7-BE40-9FE581F75562}	NEW YORK AVENUE NE FROM 16TH STREET NE TO MONTANA AVENUE NE	100			2	0	0 Intersecting RouteID Not Found		East	db646f4084ea2f9a6f902586c43360d1 Blockkey ERROR. db646f4084ea2f9a6f902586c43360d1 Blockkey ERROR. N	1	813203	db646f4084ea2f9a6f902586c43360d1	3b5ecafcffbfcabcfe1d7bd07d42fa88	15048463_1	0	339807743
-8575663.02976542	4710356.3795796	23444498	10131677	Sat Sep 11 2010 14:30:00 GMT+0000 (Coordinated Universal Time)	11001602	2361.93	35.78	7914	8781	Fri Sep 10 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	2400 16TH ST. NW	38.920955	-77.036902	396799.878	139232.045	Ward 1	{7248D58C-B6D3-4FC9-9D63-FEBFECBBA2D6}	2400 16TH STREET NW	100			2	11026392	CRESCENT PL NW	1.1	South			235817	cdbee02001b638c8dbb70b6b08ff3ed3	cdbee02001b638c8dbb70b6b08ff3ed3	11001602_2	8578410cf7dc8df762598876b089c766	339807744
-8574251.28031401	4712650.59548983	23445721	10132388	Sun Sep 12 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	11064222	3312.71	0.05	11918	12257	Sun Sep 12 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	3700 BLK NEW HAMPSHIRE AVENUE NW	38.936987	-77.023808	397935.909	141011.391	Ward 4	{BF575F21-D07C-4C2F-813C-85873F2D899C}	NEW HAMPSHIRE AVENUE NW FROM ROCK CREEK CHURCH ROAD NW TO QUINCY STREET NW	100		1	3	11040042	GEORGIA AVE NW	84.53	Northeast			813833	70fb9fefac8fcf8fd806d16d251f4503	648deb72300cf3a88416a15c83dfd010	11064222_5	7ef29e9c2fb92a905f314f5ef8724e7e	339807745
-8574910.05354501	4712146.88282838	23446005	10132965	Mon Sep 13 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	11001302	4099.62	0.03	7359	8006	Fri Sep 10 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	3500 BLOCK 13TH STREET, NW	38.933467	-77.029725	397422.721	140620.84	Ward 1	{72D490D4-4732-4C06-8B64-1CA98F23B4BD}	13TH STREET NW FROM MONROE STREET NW TO OTIS PLACE NW	100	1		2	0	0 Intersecting RouteID Not Found		East			808594	ece8680106e7e3d91486afa9dfc876b8	0188b11aea88a42ce1c1e00c9388dd85	11001302_2	0	339807746
-8574382.69748393	4708166.26831458	23446050	10132140	Sun Sep 12 2010 05:15:00 GMT+0000 (Coordinated Universal Time)	11057852	1252.32	0.01	2165	5806	Sun Sep 12 2010 04:00:00 GMT+0000 (Coordinated Universal Time)	900 BLOCK OF M STREET, NW	38.905646	-77.024988	397832.62	137532.338	Ward 2	{89D4A624-885C-47DE-BAA2-373EBA7A9146}	M STREET NW FROM 9TH STREET NW TO 10TH STREET NW	100			3	11000902	9TH ST NW	86.35	West			802453	c5f92ce2d159267b2da57575f4deca1a	3159e5a2cb282bbd8e7b585503e04a63	11057852_2	47f907bdd457af3840909060bcedb5fd	339807747


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "crimeid" BIGINT,
  "ccn" VARCHAR,
  "reportdate" TIMESTAMP,
  "routeid" VARCHAR,
  "measure" DOUBLE,
  "offset" DOUBLE,
  "streetsegid" DOUBLE,
  "roadwaysegid" DOUBLE,
  "fromdate" TIMESTAMP,
  "todate" VARCHAR,
  "address" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "ward" VARCHAR,
  "eventid" VARCHAR,
  "mar_address" VARCHAR,
  "mar_score" DOUBLE,
  "majorinjuries_bicyclist" BIGINT,
  "minorinjuries_bicyclist" BIGINT,
  "unknowninjuries_bicyclist" BIGINT,
  "fatal_bicyclist" BIGINT,
  "majorinjuries_driver" BIGINT,
  "minorinjuries_driver" BIGINT,
  "unknowninjuries_driver" BIGINT,
  "fatal_driver" BIGINT,
  "majorinjuries_pedestrian" BIGINT,
  "minorinjuries_pedestrian" BIGINT,
  "unknowninjuries_pedestrian" BIGINT,
  "fatal_pedestrian" BIGINT,
  "total_vehicles" BIGINT,
  "total_bicycles" BIGINT,
  "total_pedestrians" BIGINT,
  "pedestriansimpaired" BIGINT,
  "bicyclistsimpaired" BIGINT,
  "driversimpaired" BIGINT,
  "total_taxis" BIGINT,
  "total_government" BIGINT,
  "speeding_involved" BIGINT,
  "nearestintrouteid" VARCHAR,
  "nearestintstreetname" VARCHAR,
  "offintersection" DOUBLE,
  "intapproachdirection" VARCHAR,
  "locationerror" VARCHAR,
  "lastupdatedate" TIMESTAMP,
  "mpdlatitude" DOUBLE,
  "mpdlongitude" DOUBLE,
  "mpdgeox" DOUBLE,
  "mpdgeoy" DOUBLE,
  "fatalpassenger" BIGINT,
  "majorinjuriespassenger" BIGINT,
  "minorinjuriespassenger" BIGINT,
  "unknowninjuriespassenger" BIGINT,
  "mar_id" BIGINT,
  "blockkey" VARCHAR,
  "subblockkey" VARCHAR,
  "corridorid" VARCHAR,
  "nearestintkey" VARCHAR,
  "majorinjuriesother" DOUBLE,
  "minorinjuriesother" DOUBLE,
  "unknowninjuriesother" DOUBLE,
  "fatalother" DOUBLE,
  "objectid" BIGINT
);