Traffic Violations

Montgomery County of Maryland

@usgov.montgomery_county_of_maryland_traffic_violations

Table List

1 table(165.75 MB)

Table 1

@usgov.montgomery_county_of_maryland_traffic_violations.table_1

165.75 MB
2004890 rows
43 columns

seqid SeqID	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	search_conducted Search Conducted	search_disposition Search Disposition	search_outcome Search Outcome	search_reason Search Reason	search_reason_for_stop Search Reason For Stop	search_type Search Type	search_arrest_reason Search Arrest Reason	state State	vehicletype VehicleType	year Year	make Make	model Model	color Color	violation_type Violation Type	charge Charge	article Article	race Race	gender Gender	driver_city Driver City	driver_state Driver State	dl_state DL State	arrest_type Arrest Type	geolocation Geolocation
52282e8c-f2e1-4bb5-8509-2d5e4f8da8ca	Mon May 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	23:11:00	MCP	3rd District, Silver Spring	OPERATING UNREGISTERED MOTOR VEHICLE ON HIGHWAY	BRIGGS CHANEY RD @ COLUMIBA PIKE			No	No	No	No	No	No	No	No	No	No	No		Citation		17-107(a1)			MD	02 - Automobile	2007	CHEV	CRUZ	BLACK	Citation	13-401(b1)	Transportation Article	WHITE	M	GAITHERSBURG	MD	MD	A - Marked Patrol	(0.0, 0.0)
9be35886-e00c-49c2-8f27-2f6307696a17	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	00:20:00	MCP	6th District, Gaithersburg / Montgomery Village	FAILURE TO DISPLAY REGISTRATION CARD UPON DEMAND BY POLICE OFFICER	GEORGIA AVE / WEISMAN RD	39.0529625	-77.0513041666667	No	No	No	No	No	No	No	No	No	No	No		Citation		13-411(f)			MD	02 - Automobile	2013	TOYOTA	COROLLA	RED	Citation	13-409(b)	Transportation Article	HISPANIC	M	SILVER SPRING	MD	MD	A - Marked Patrol	(39.0529625, -77.0513041666667)
9be35886-e00c-49c2-8f27-2f6307696a17	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	00:20:00	MCP	6th District, Gaithersburg / Montgomery Village	DISPLAYING EXPIRED REGISTRATION PLATE ISSUED BY ANY STATE	GEORGIA AVE / WEISMAN RD	39.0529625	-77.0513041666667	No	No	No	No	No	No	No	No	No	No	No		Citation		13-411(f)			MD	02 - Automobile	2013	TOYOTA	COROLLA	RED	Citation	13-411(f)	Transportation Article	HISPANIC	M	SILVER SPRING	MD	MD	A - Marked Patrol	(39.0529625, -77.0513041666667)
4d37fa99-0df3-4a56-9ba6-692bce894a34	Sun Nov 26 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	09:16:00	MCP	4th District, Wheaton	DRIVING VEHICLE WHILE UNDER THE INFLUENCE OF ALCOHOL	3803 WELLER RD	39.0583783333333	-77.0496516666667	No	No	No	Yes	No	No	No	No	No	No	Yes	Property Only	Arrest	Incident to Arrest	20-103(b)	Both	Stop	MD	02 - Automobile	2004	TOYOTA	HB	SILVER	Citation	21-902(a1i)	Transportation Article	HISPANIC	M	SILVER SPRING	MD	MD	A - Marked Patrol	(39.0583783333333, -77.0496516666667)
3a723e9a-5dc0-4bc3-9bd9-4555d6ce0e49	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	05:45:00	MCP	4th District, Wheaton	RECKLESS DRIVING VEHICLE IN WANTON AND WILLFUL DISREGARD FOR SAFETY OF PERSONS AND PROPERTY	OLNEY LAYTONSVILLE RD @ FIELDCREST RD			No	No	No	No	No	No	No	No	No	No								MD	02 - Automobile	2022	MITSUBISHI	ECLIPSE CROSS	BLACK	Citation	21-901.1(a)	Transportation Article	WHITE	M	GAITHERSBURG	MD	MD	A - Marked Patrol	(0.0, 0.0)
3a723e9a-5dc0-4bc3-9bd9-4555d6ce0e49	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	05:45:00	MCP	4th District, Wheaton	DRIVER FAILURE TO OBEY PROPERLY PLACED TRAFFIC CONTROL DEVICE INSTRUCTIONS	OLNEY LAYTONSVILLE RD @ FIELDCREST RD			No	No	No	No	No	No	No	No	No	No								MD	02 - Automobile	2022	MITSUBISHI	ECLIPSE CROSS	BLACK	Citation	21-201(a1)	Transportation Article	WHITE	M	GAITHERSBURG	MD	MD	A - Marked Patrol	(0.0, 0.0)
66273a8e-980e-413e-8928-56447e3be407	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	01:21:00	MCP	2nd District, Bethesda	EXCEEDING POSTED MAXIMUM SPEED LIMIT: 44 MPH IN A POSTED 35 MPH ZONE	S/B GEORGIA AVENUE @ DENNIS AVENUE			No	No	No	No	No	No	No	No	No	No	No		Citation		21-801.1			MD	02 - Automobile	2010	NISSAN	CP	BLACK	Citation	21-801.1	Transportation Article	HISPANIC	F	SILVER SPRING	MD	MD	B - Unmarked Patrol	(0.0, 0.0)
78cdf309-9fe8-46de-892e-19e9b1bafacd	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	03:22:00	MCP	2nd District, Bethesda	DRIVER FAILURE TO STOP AT STEADY CIRCULAR RED SIGNAL	16 TH STREET @ GEORGIA AVENUE			No	No	No	No	No	No	No	No	No	No	No		Citation		21-202(h1)			MD	02 - Automobile	2021	TOY	CAMRY	WHITE	Citation	21-202(h1)	Transportation Article	BLACK	M	JESSUP	MD	MD	B - Unmarked Patrol	(0.0, 0.0)
78cdf309-9fe8-46de-892e-19e9b1bafacd	Sat Nov 25 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	03:22:00	MCP	2nd District, Bethesda	PERSON DRIVING MOTOR VEHICLE ON HIGHWAY OR PUBLIC USE PROPERTY ON SUSPENDED LICENSE AND PRIVILEGE	16 TH STREET @ GEORGIA AVENUE			No	No	No	No	No	No	No	No	No	No	No		Citation		21-202(h1)			MD	02 - Automobile	2021	TOY	CAMRY	WHITE	Citation	16-303(c)	Transportation Article	BLACK	M	JESSUP	MD	MD	B - Unmarked Patrol	(0.0, 0.0)
1e24ec33-6a13-483f-9fea-0c2cdc5b2a14	Fri Nov 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	23:25:00	MCP	2nd District, Bethesda	FAILURE OF INDIVIDUAL DRIVING ON HIGHWAY TO DISPLAY LICENSE TO UNIFORMED POLICE ON DEMAND	UNIVERSITY BLVD W & VEIRS MILL RD	39.0419323833333	-77.0587989666667	No	No	No	No	No	No	No	No	No	No	No		Citation		64*			MD	02 - Automobile	2013	HYUN	ELANTA	SILVER	Citation	16-112(c)	Transportation Article	HISPANIC	M	SILVER SPRING	MD	MD	A - Marked Patrol	(39.0419323833333, -77.0587989666667)


CREATE TABLE table_1 (
  "seqid" VARCHAR,
  "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,
  "search_conducted" VARCHAR,
  "search_disposition" VARCHAR,
  "search_outcome" VARCHAR,
  "search_reason" VARCHAR,
  "search_reason_for_stop" VARCHAR,
  "search_type" VARCHAR,
  "search_arrest_reason" VARCHAR,
  "state" VARCHAR,
  "vehicletype" VARCHAR,
  "year" DOUBLE,
  "make" VARCHAR,
  "model" VARCHAR,
  "color" VARCHAR,
  "violation_type" VARCHAR,
  "charge" VARCHAR,
  "article" VARCHAR,
  "contributed_to_accident" BOOLEAN,
  "race" VARCHAR,
  "gender" VARCHAR,
  "driver_city" VARCHAR,
  "driver_state" VARCHAR,
  "dl_state" VARCHAR,
  "arrest_type" VARCHAR,
  "geolocation" VARCHAR
);