Open Data DC

Explore the interactive ERD

Column	Type	Keys
`crime_id`	String	PK
`address`	String
`bicyclists_impaired`	Int
`ccn`	String
`drivers_impaired`	Int
`event_id`	String
`fatal_bicyclist`	Int
`fatal_driver`	Int
`fatal_passenger`	Int
`fatal_pedestrian`	Int
`from_date`	Instant
`geometry_type`	String
`id`	Long
`int_approach_direction`	String
`last_update_date`	Instant
`latitude`	Double
`location_error`	String
`longitude`	Double
`major_injuries_bicyclist`	Int
`major_injuries_driver`	Int
`major_injuries_passenger`	Int
`major_injuries_pedestrian`	Int
`mar_address`	String
`mar_id`	Int
`mar_score`	Double
`measure`	Double
`minor_injuries_bicyclist`	Int
`minor_injuries_driver`	Int
`minor_injuries_passenger`	Int
`minor_injuries_pedestrian`	Int
`mpd_latitude`	Double
`mpd_longitude`	Double
`mpdgeox`	Double
`mpdgeoy`	Double
`nearest_int_route_id`	String
`nearest_int_street_name`	String
`offintersection`	Double
`offsets`	Double
`pedestrians_impaired`	Int
`report_date`	Instant
`roadways_egid`	Int
`route_id`	String
`speeding_involved`	Int
`streets_egid`	Int
`to_date`	Instant
`total_bicycles`	Int
`total_government`	Int
`total_pedestrians`	Int
`total_taxis`	Int
`total_vehicles`	Int
`type`	String
`unknown_injuries_bicyclist`	Int
`unknown_injuries_driver`	Int
`unknown_injuries_passenger`	Int
`unknown_injuries_pedestrian`	Int
`ward`	String
`x_coord`	Double
`y_coord`	Double