crash_reports
5 rows where dcc = "["Swerving"]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-02
Time:
10:34
Address:
99 FLORENCE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was travelling northbound on Florence St when he was struck from behind by MV#2. MV#1 sustained moderate damages to its rear end. There were no reported injuries to the operator of MV#1. The operator of MV#2 stated he was travelling southbound on Florence St and could not stop in time (due to the snowy road conditions) and struck MV#1. MV#2 sustained minor front end damages. There were no reported injuries to the operator of MV#2.
Keywords:
Moderate, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3178158
Longitude:
-71.1775763
Location:
Case
number:
Date:
2019-03-11
Time:
08:18
Address:
300 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
WHILE PULLING INTO THE PARKING AREA OF #300 BOYLSTON ST, MV#1 SLID ON ICE AND STRUCK A PARKED MV#2 (REAR ). MV#2 WAS PARKED (OCCUPIED) IN FRONT OF #300 BOYLSTON ST, WHEN MV#1 SLID INTO THE REAR OF THE VEHICLE. MV#1 WAS TOWED WITH MODERATE FRONT END DAMAGE.
Keywords:
Ice, Moderate
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3185796
Longitude:
-71.179849
Location:
Case
number:
Date:
2019-05-05
Time:
05:18
Address:
23 NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was travelling southbound on Nahanton St. The operator of vehicle 1 lost control to the vehicle, due to the wet road conditions, and struck the telephone pole (#6/4) in front of 23 Nahanton St. There was no damage to the telephone pole. There was moderate damage to the front of vehicle 1. I observed air bag deployment to the front and passenger side of the vehicle. No one was injured, and the vehicle was towed by Tody's to their lot.
Keywords:
Moderate
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3003054
Longitude:
-71.1890156
Location:
Case
number:
Date:
2020-01-18
Time:
14:09
Address:
145 LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
The owner of MV#1 stated that her MV was parked and unoccupied in front of #145 Lexington St when it was struck by MV#2. The operator of MV#2 stated that he was traveling south on Lexington St when either a cat or squirrel ran in front of his MV and he tried to avoid animal by turning right and struck MV#1, which was parked and unoccupied. MV#2 then rolled over after striking MV#1. No injuries, both MV's towed.
Keywords:
[]
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3557274
Longitude:
-71.2418991
Location:
Case
number:
Date:
2020-01-18
Time:
19:53
Address:
CHESTNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV 1 was traveling north on Chestnut St when she slid into the curb striking a USPS post mail box and stop sign. The operator of MV 1 lost control of the vehicle due to inclimate weather and slid into the side of the road striking the objects. The operator was not injured by the crash. Pictures of the mailbox and stop sign were taken and passed into the Newton Police IT department. The vehicle was towed due to it being disabled on a public way. A towed motor vehicle inventory sheet was filled out and filed. Postal police was notified of the downed box.
Keywords:
Crash, Pictures
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3307093
Longitude:
-71.2247899
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);