Traffic Violations In Maryland County

Complete set of traffic violation events from 2012 - 2018

@kaggle.rounak041993_traffic_violations_in_maryland_county

Table List

1 table(51.99 MB)

Traffic Violations

@kaggle.rounak041993_traffic_violations_in_maryland_county.traffic_violations

51.99 MB
1292399 rows
35 columns

date_of_stop Date Of Stop	time_of_stop Time Of Stop	agency Agency	subagency SubAgency	description Description	location Location	latitude Latitude	longitude Longitude	accident Accident	belts Belts	personal_injury Personal Injury	property_damage Property Damage	fatal Fatal	commercial_license Commercial License	hazmat HAZMAT	commercial_vehicle Commercial Vehicle	alcohol Alcohol	work_zone Work Zone	state State	vehicletype VehicleType	year Year	make Make	model Model	color Color	violation_type Violation Type	charge Charge	article Article	contributed_to_accident Contributed To Accident	race Race	gender Gender	driver_city Driver City	driver_state Driver State	dl_state DL State	arrest_type Arrest Type	geolocation Geolocation
Tue Sep 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	17:11:00	MCP	3rd district, Silver Spring	DRIVING VEHICLE ON HIGHWAY WITH SUSPENDED REGISTRATION	8804 FLOWER AVE			No	No	No	No	No	No	No	No	No	No	MD	02 - Automobile	2008	FORD	4S	BLACK	Citation	13-401(h)	Transportation Article	No	BLACK	M	TAKOMA PARK	MD	MD	A - Marked Patrol	nan
Tue Aug 29 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	10:19:00	MCP	2nd district, Bethesda	DRIVER FAILURE TO OBEY PROPERLY PLACED TRAFFIC CONTROL DEVICE INSTRUCTIONS	WISCONSIN AVE@ ELM ST	38.981725	-77.0927566666667	No	No	No	No	No	No	No	No	No	No	VA	02 - Automobile	2001	TOYOTA	COROLLA	GREEN	Citation	21-201(a1)	Transportation Article	No	WHITE	F	FAIRFAX STATION	VA	VA	A - Marked Patrol	(38.981725, -77.0927566666667)
Mon Dec 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	12:52:00	MCP	6th district, Gaithersburg / Montgomery Village	FAILURE STOP AND YIELD AT THRU HWY	CHRISTOPHER AVE/MONTGOMERY VILLAGE AVE	39.1628883333333	-77.2290883333333	No	No	No	Yes	No	No	No	No	No	No	MD	02 - Automobile	2001	HONDA	ACCORD	SILVER	Citation	21-403(b)	Transportation Article	No	BLACK	F	UPPER MARLBORO	MD	MD	A - Marked Patrol	(39.1628883333333, -77.2290883333333)
Tue Aug 29 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	09:22:00	MCP	3rd district, Silver Spring	FAILURE YIELD RIGHT OF WAY ON U TURN	CHERRY HILL RD./CALVERTON BLVD.	39.056975	-76.9546333333333	No	No	No	Yes	No	No	No	No	No	No	MD	02 - Automobile	1998	DODG	DAKOTA	WHITE	Citation	21-402(b)	Transportation Article	No	BLACK	M	FORT WASHINGTON	MD	MD	A - Marked Patrol	(39.056975, -76.9546333333333)
Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	23:41:00	MCP	6th district, Gaithersburg / Montgomery Village	FAILURE OF DR. TO MAKE LANE CHANGE TO AVAIL. LANE NOT IMMED. ADJ. TO STOPPED EMERG. VEH,	355 @ SOUTH WESTLAND DRIVE			No	No	No	No	No	No	No	No	No	No	MD	02 - Automobile	2015	MINI COOPER	2S	WHITE	Citation	21-405(e1)	Transportation Article	No	WHITE	M	GAITHERSBURG	MD	MD	A - Marked Patrol	nan
Tue Aug 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	00:55:00	MCP	2nd district, Bethesda	NEGLIGENT DRIVING VEHICLE IN CARELESS AND IMPRUDENT MANNER ENDANGERING PROPERTY, LIFE AND PERSON	CONNECTICUT/CHEVY CHASE LAKE			No	No	No	No	No	No	No	No	No	No	MD	02 - Automobile	2013	HYUNDAI	ELANTRA	GRAY	Citation	21-901.1(b)	Transportation Article	No	WHITE	F	SILVER SPRING	MD	MD	A - Marked Patrol	nan
Tue Oct 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13:23:00	MCP	4th district, Wheaton	DRIVING VEHICLE ON HIGHWAY WITH SUSPENDED REGISTRATION	GEORGIA AVE / BEL PRE RD	39.0933833333333	-77.0795516666667	No	No	No	No	No	No	No	No	No	No	MD	02 - Automobile	1993	FORD	PICKUP	BLACK	Citation	13-401(h)	Transportation Article	No	HISPANIC	M	BELTSVILLE	MD	MD	A - Marked Patrol	(39.0933833333333, -77.0795516666667)
Fri Apr 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	00:38:00	MCP	1st district, Rockville	DRIVER FAIL TO STOP AT FLASHING RED TRAFFIC SIGNAL STOP LINE	EB MONTROSE PKWY/EAST JEFFERSON ST			No	No	No	No	No	No	No	No	No	No	VA	02 - Automobile	2003	DODGE	SPRINTER	WHITE	Citation	21-204(b)	Transportation Article	No	HISPANIC	M	SILVER SPRING	MD	MD	A - Marked Patrol	nan
Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	23:41:00	MCP	6th district, Gaithersburg / Montgomery Village	FAILURE OF INDIVIDUAL DRIVING ON HIGHWAY TO DISPLAY LICENSE TO UNIFORMED POLICE ON DEMAND	355 @ SOUTH WESTLAND DRIVE			No	No	No	No	No	No	No	No	No	No	MD	02 - Automobile	2015	MINI COOPER	2S	WHITE	Citation	16-112(c)	Transportation Article	No	WHITE	M	GAITHERSBURG	MD	MD	A - Marked Patrol	nan
Mon Aug 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	23:41:00	MCP	6th district, Gaithersburg / Montgomery Village	DRIVING VEHICLE ON HIGHWAY WITH AN EXPIRED LICENSE	355 @ SOUTH WESTLAND DRIVE			No	No	No	No	No	No	No	No	No	No	MD	02 - Automobile	2015	MINI COOPER	2S	WHITE	Citation	16-115(g)	Transportation Article	No	WHITE	M	GAITHERSBURG	MD	MD	A - Marked Patrol	nan


CREATE TABLE traffic_violations (
  "date_of_stop" TIMESTAMP,
  "time_of_stop" VARCHAR,
  "agency" VARCHAR,
  "subagency" VARCHAR,
  "description" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "accident" VARCHAR,
  "belts" VARCHAR,
  "personal_injury" VARCHAR,
  "property_damage" VARCHAR,
  "fatal" VARCHAR,
  "commercial_license" VARCHAR,
  "hazmat" VARCHAR,
  "commercial_vehicle" VARCHAR,
  "alcohol" VARCHAR,
  "work_zone" VARCHAR,
  "state" VARCHAR,
  "vehicletype" VARCHAR,
  "year" DOUBLE,
  "make" VARCHAR,
  "model" VARCHAR,
  "color" VARCHAR,
  "violation_type" VARCHAR,
  "charge" VARCHAR,
  "article" VARCHAR,
  "contributed_to_accident" VARCHAR,
  "race" VARCHAR,
  "gender" VARCHAR,
  "driver_city" VARCHAR,
  "driver_state" VARCHAR,
  "dl_state" VARCHAR,
  "arrest_type" VARCHAR,
  "geolocation" VARCHAR
);