crash_reports
7 rows where dcc_code = "[12]" and speed_limit = 15
This data as json, CSV (advanced)
Suggested facets: hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-12
Time:
16:15
Address:
2020 COMMONWEALTH AVE
Speed
limit:
15
Violation
cited:
no
Narrative:
MV#1 was parked unoccupied in a parking spot in the parking lot of 2020 Commonwealth Ave. Operator of MV#2 stated she pulled in and attempted to go around MV#2 when she heard a sound. Operator of MV#2 stated she got out of the car and looked at MV#1 and did not see any damage so she thought maybe she hit something else or drove over something. She then parked in another spot in the shared parking lot. I was able to see paint transfer and damage on both vehicles that confirmed a crash had occurred. Operator of MV#2 was apologetic and stated she had only had her license for two months. Both vehicles were able to be driven from the scene and both parties were advised an accident report would be on file.
Keywords:
Crash
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3470314
Longitude:
-71.2439642
Location:
Case
number:
Date:
2019-09-29
Time:
14:48
Address:
199 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The witness stated she was parked in the lot of 199 Boylston St and saw vehicle 1 parked in front of her. Vehicle 2 tried to pull in next to vehicle 1 and struck the rear right bumper of vehicle 1. Both vehicles sustained minor damage and there were no injuries.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
Case
number:
Date:
2019-10-12
Time:
13:38
Address:
175 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Owner of vehicle 1 stated that he return to his vehicle and noticed damage to the rear passenger side bumper. He checked vehicle 2 parked next to vehicle 1 and noticed damage to vehicle 2's front driver side bumper. I checked both vehicles and the damage appears to be consistent. I was unable to locate the owner of vehicle 2. Several calls were made to his residence, with negative results. Both vehicles sustained minor damage and there were no injuries.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3216347
Longitude:
-71.1749764
Location:
Case
number:
Date:
2020-01-29
Time:
12:01
Address:
160 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The owner of Operator 1 stated that she parked vehicle 1 in the garage of 160 Boylston St last night. When she returned to her vehicle this morning she noticed that the front driverside fender and bumper was damaged. At this time there in no information on vehicle 2. Vehicle 1 sustained minor damage.
Keywords:
Night
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3195309
Longitude:
-71.1736296
Location:
Case
number:
Date:
2020-10-20
Time:
13:16
Address:
1000 COMMONWEALTH AVE
Speed
limit:
15
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was travelling northbound on the driveway of 1000 Commonwealth Ave (Newton City Hall's front entrance on the Commonwealth Ave's side) when she sneezed and veered off her travel lane striking MV#2. MV#1 sustained minor damage to its passsenger's side rear bumper. There were no reported injuries to the operator of MV#1. MV#2 was parked and unoccupied on 1000 Commonwealth Ave (Newton City Hall's front entrance on the Commonwealth Ave's side) when it was struck by MV#1. MV#2 sustained heavy front end damages with its front bumper ripped off.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3374309
Longitude:
-71.2088565
Location:
Case
number:
Date:
2021-07-19
Time:
18:44
Address:
75 ADAMS ST
Speed
limit:
15
Violation
cited:
no
Narrative:
MV1 was unoccupied and parked legally in a parking space belonging to 75 Adams St (Nonantum Boxing Club ) when MV2, operated by Robert David Rauh, hit MV1. MV2 was pulling out of a parking spot in the same lot when he miscalculated the turn and damaged MV1 rear driver's side bumper. Minor damage was observed on MV2 passenger side bumper. No injuries and both vehicles were safe to drive.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3611837
Longitude:
-71.2044707
Location:
Case
number:
Date:
2021-08-26
Time:
10:30
Address:
111 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Mv#1 was travelling straight ahead on Needham St W/B in the area of #111. The Mv was being safely guided through this area under construction by detail Officers. While the Mv was passing through this area, an excavator digging in the street began moving which startled the Mv operator. As a result, the operator jerked her Mv to the right at which time the front passenger side bumper scraped a water pipe resting on the birm. The front passenger side bumper sustained minor scrape damage.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3137683
Longitude:
-71.212198
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);






