crash_reports
3 rows where dcc contains "Over-steering", intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-13
Time:
17:55
Address:
1136 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated that she was traveling southbound on Chestnut street when she lost control of her vehicle causing the vehicle to jump the curb and run over a city speed limit sign breaking it at the base. The city was notified of the broken sign and pictures were taken and placed in ITs mailbox to be attached to the report. The vehicle sustained a right rear flat tire and was towed by AAA. All parties reported no injuries and signed a patient refusal.
Keywords:
Pictures, Speed
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3103168
Longitude:
-71.2238119
Location:
Case
number:
Date:
2021-07-03
Time:
13:51
Address:
300 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Witnesses #1 and #2 (anonymous) stated that Vehicle #1 was parked in a parking space behind Pressed Cafe. Vehicle #2 was parked to the right of Vehicle #1. Vehicle #2 attempted to back up out of their space, overcorrected, and backed into Vehicle #1. Witnesses stated Vehicle #2 drove away at a high rate of speed. Vehicle #1 suffered minor damage to the right rear side of the vehicle. Unknown damage to Vehicle #2. Witnesses followed the vehicle and provided me with a picture of the license plate. They were unable to describe the driver. I was able to locate the owner of Vehicle #1 and notify him of the damage. I responded to the address listed for Vehicle #2 with negative results. Report forwarded to Traffic Bureau for follow up with Vehicle #2. Traffic Bureau update (Officer Gaudet): On Tuesday, July 6, 2021, I made contact with the registered owner of MV2, Ms. Irina Mazo via telephone. Ms. Mazo stated she was away for the weekend but her daughter, Olga Rapoport, had the vehicle. I apprised Ms. Mazo about the crash involving her vehicle. Ms. Mazo stated she would contact her daughter and have her call me. A short time later, I received a call from Ms. Rapoport. Ms. Rapoport stated she was operating MA: 4LD211 at the time of the reported crash. Ms. Rapoport stated her rear passenger side bumber area crashed into MV1 as she was backing out of a parking spot. Ms. Rapoport stated she left the area with out stopping to assess the damage to MV1, or to attempt to make contact with the owner of MV1. I asked Ms. Rapoport why she did not stop. Ms. Rapoport stated she did not have an excuse. Ms. Rapoport stated there is no damage to her vehicle. Ms. Rapoport was advised and will be mailed Massachusetts Uniform Citation (061166AB) for Chapter 90, Section 24 (Leaving the Scene of Property Damage).
Keywords:
Citation, Crash, Pictures, Speed
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3077228
Longitude:
-71.2144721
Location:
Case
number:
Date:
2021-10-07
Time:
13:45
Address:
77 PAUL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 stated he was traveling westbound on Paul St around the tight corner and another vehicle was coming his direction at a high rate of speed. He tried to swerve out of the way but his shoe got caught and he accelerated through the fence. The operator was not hurt and the vehicle was towed by Todys. Sagar Mohan stated he and his son were in the park at the time of the accident and they saw a red sedan going east bound at a high rated of speed with no concern to thee narrowness of the street and the tight turn. They stated it looked like operator 1 was trying to avoid a collision when he swerved into the fence. Unit 523 took several digital images of the fence and parks and rec were notified.
Keywords:
Crash, Speed
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.326731
Longitude:
-71.1972
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);