crash_reports
2 rows where "datetime" is on date 2019-12-17, keywords contains "Rain" and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-12-17
Time:
13:58
Address:
OLDE FIELD RD & BOYLSTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1(MA reg.8TX383) was traveling eastbound on Boylston Street when she attempted to turn right onto Olde Field Road. MV1 began to slide due to the heavy slush from rain and snow fall. MV1 struck the stop sign on the east side corner. The street sign was knocked over and MV1 had minor damage to the front drivers side bumper No one was injured, damage was minimal and dispatch notified DPW of the damage to the stop sign. Photos were not taken.
Keywords:
Pictures, Rain, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3188446
Longitude:
-71.192125
Location:
Case
number:
Date:
2019-12-17
Time:
14:47
Address:
717 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date and time I responded to 717 Centre St for a report of a crash involving two vehicles. The weather was snowy / rainy/ sleeting, and the roadway was a mixture of ice/ snow. Upon arrival on scene I spoke with the operator of V1 Ms. Howe, she stated she was traveling south on Centre St when V2 stopped abruptly. Ms. Howes stated she applied the brakes and her vehicle would nt stop due to the icy roadway and she had contact with V2. I then spoke with the operator of V2, Ms. Nunnally stated that a vehicle had abruptly pulled out of the driveway of 717 Centre St. She stated she applied her brakes immediately to avoid contact and pulled to the right. She stated when she stopped she felt rear impact from V2. Both parties had no injuries at this time. V2 was towed by Todys towing to 1354 Washington Street Newton. Ms. Howe removed valuables from the vehicle. At this time it appears the icy roadway was a contributing factor of the crash.
Keywords:
Crash, Ice, Rain, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.347321
Longitude:
-71.1892941
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);