About this Dataset

Traffic Violations

This dataset contains traffic violation information from all electronic traffic violations issued in the County. Any information that can be used to uniquely identify the vehicle, the vehicle owner or the officer issuing the violation will not be published. Update Frequency: Daily
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:02.272013
Tags: accident, car, electronic-issued, injury, stop, traffic, vehicle, violations

Tables

Table 1

@usgov.montgomery_county_of_maryland_traffic_violations.table_1

173.8 MB
2,004,890 rows
43 columns

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