crash_reports
2 rows where dcc = "["Too fast for conditions"]", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-17
Time:
10:58
Address:
1874 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated he was travelling Westbound on Washington St. The road conditions at that time was covered in Slush and ice. Operator #1 stated as he was rounding a slight bend in the Rd. His vehicle continued to slide to the left and into oncoming Eastbound traffic. Vehicle #1 Then collided with vehicle #2. Operator of vehicle #2 stated he was traveling Eastbound on Washington St. when vehicle #1 slid into his travel lane, striking his vehicle head on. He stated vehicle #2 then Struck vehicle #3 which had been driving eastbound to his right. Operator of Vehicle #3 stated he was travelling Eastbound when his vehicle was struck by Vehicle #2 which caused his vehicle to spin out of control and into the Westbound travel lane where his vehicle struck Vehicle #4. Vehicle #3 then struck the fence owned by the Woodland Golf Club. Operator #4 stated she was travelling Westbound when vehicle #3 spun out of control and struck her vehicle. Operator stated she attempted to stop but was unable to due to the poor Rd. conditions.
Keywords:
Ice
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3352873
Longitude:
-71.2420805
Location:
Case
number:
Date:
2019-12-30
Time:
10:03
Address:
268 DEDHAM ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 12/30/19 I responded to a single vehicle crash on Dedham St. outside of #268. The operator stated she was traveling due North on Dedham St at 25mph when she lost control of her vehicle due to icy conditions. Tracing back the vehicles tires marks in the slush, the car appeared to cross the double yellow lines near Brush Hill Rd and then back to the correct lane sideways before striking the curb, then a city tree in front of #268 Dedham St. There were multiple air bag deployments in the vehicle. Ambulance #1 arrived on scene and transported the operator due to a complaint of right chest pain from the seatbelt. N523 Traffic Officer Wilson arrived on scene and took pictures of the damage to the city tree. The vehicle was towed by Tody's Towing and the operator was mailed Mass. citation # T2013422 for Ch90/sec17-Speeding (too fast for conditions).
Keywords:
Citation, Crash, Ems, Ice, Pictures, Tree
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3109112
Longitude:
-71.202243
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);