crash_reports
1 row where "datetime" is on date 2019-04-07, dcc contains "Reckless driving" and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-07
Time:
20:42
Address:
WASHINGTON ST & CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 04/07/2019, at 2042 hrs, I responded to the area of Washington St at Centre St for a H&R MVA. Upon arrival, MV1 was pulled over in front of 317 Washington St. Its front bumper and undercarriage guard had been ripped off. The operator stated that as he was proceeding through a green light at the end of Mass Pike exit 17 onto Washington St (WB), a dark colored Jeep ran the red light on Centre St (NB) and struck his front end. The Jeep then proceeded down Centre St towards Watertown. A witnesses to the accident, Adam Nussenbaum, was traveling behind MV1 and corroborated the story. No further description of the vehicle or driver which fled was obtained except that it would have passenger side damage. Watertown PD was notified and a canvass of the area yielded negative results. I was unable to locate any cameras in the area of the accident. No injuries were reported and the vehicle was able to be driven from the scene.
Keywords:
Crash
Dcc:
Signs/Signals, Reckless driving
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);