crash_reports

1 row where "datetime" is on date 2019-11-05, dcc = "["Reckless driving"]" and intersection = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900001140

Date:

2019-11-05

Time:

15:29

Address:

WALTHAM ST & WEBSTER ST

Speed limit:

25

Violation cited:

yes

Narrative:

MV1 operator stated he was parked on Waltham St by Webster St facing southbound. MV1 operator said MV2 drove down Waltham St southbound when it sideswiped his MV damaging his driver's side mirror. MV1 and MV2 operators exchanged information. MV2 operator was found to have a driver's license status of suspended. MV2 operator was charged with MGL Ch 90 Sec 23, Operating After Suspension subsequent. MV2 operator left before my arrival after exchanging information. MA Uniform Citation # T2079791 was mailed to his address provided by the RMV.

Keywords:

Citation

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.3507094

Longitude:

-71.2264305

Location:

Webster St & Waltham St, Newton, MA 02465, USA

CREATE TABLE "crash_reports" (
   [case_number] TEXT PRIMARY KEY,
   [datetime] TEXT,
   [date] TEXT,
   [time] TEXT,
   [address] INTEGER,
   [street1] TEXT,
   [street2] TEXT,
   [intersection] INTEGER,
   [speed_limit] INTEGER,
   [hit_run] INTEGER,
   [violation_cited] INTEGER,
   [narrative] TEXT,
   [keywords] TEXT,
   [dcc] TEXT,
   [dcc_code] TEXT,
   [report_url] TEXT,
   [image_url] TEXT
, [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);