crash_reports
6 rows where "retrieved" is on date 2020-12-27 and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-10-28
Time:
08:30
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The owner of MV#1 stated she came out of work at NWH at 0730hrs and noticed the passenger front of her vehicle was damaged. She stated that she parked her vehicle in the that space at 2330hrs the night before. I observed significant damage to the passenger front of the vehicle. It should be noted that I did not observe and parts on the ground or any debris indicating that the accident occurred in that location. The headlight was totally shattered out and there were missing parts from vehicle. There was also a fluid trail that appeared to be leaking from the front passenger side. This trail indicated that the vehicle was driven and backed in to the parking space after the collision took place. Based on my training and experience I do not believe that vehicle was struck in that location as a hit and run. There were no cameras in the area. The owner requested her own tow for the vehicle. I submitted a photo of the claimed hit and run scene to the IT bureau and it was attached to this accident report.
Keywords:
Crash, Night, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Case
number:
Date:
2020-11-02
Time:
07:29
Address:
90 CRAFTS ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Monday 11/2/2020 at approx 0700hrs, while operating cruiser 504 and assigned N494, I was located at 90 Crafts St in Newton. While backing up my cruiser to turn around I struck a solid cement block, cracking the driver side tail-light and scratching the paint around it. It should be noted there was no signs of damage to the cement block. Photos were taken and submitted.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3551007
Longitude:
-71.2037235
Location:
Case
number:
Date:
2020-11-04
Time:
08:17
Address:
89 NEEDHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of veh #1 stated she was driving due West in the underground parking garage of #89 Needham St-The Avalon Apts when veh #2 backed out of her parking spot. The operator of veh #1 stated veh #2 backed up too fast and struck the front passenger side quarter of her vehicle. Veh #1 sustained moderate damage and was towed by Tody's Towing. The operator of veh #2 stated she looked both ways before backing out of her parking spot and started turning when veh #1 drove into her vehicle . Operator of veh #2 stated veh #1 came out of no where. Minor damage to veh #2 rear bumper (drivers side and middle of bumper).
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3144942
Longitude:
-71.2121484
Location:
Case
number:
Date:
2020-11-25
Time:
15:01
Address:
259 CENTRE ST
Speed
limit:
10
Violation
cited:
no
Narrative:
Operator 1 stated that he was parked in a designated parking space in the lot of 259 Centre street when he viewed mv#2 backing up and getting close to mv#1. Operator #1 stated that he beeped his horn to alert mv#2. Mv#2 then struck the front passenger side of mv#1. Operator of mv#2 stated that he was backing up and did not realize that mv#1 was still parked there, he had believed the vehicle had moved. Mv#2 struck mV#1 with the rear of the passenger side. No injuries. Minor damage and paint transfer. All vehicle could be driven from the scene. Photos taken.
Keywords:
Pictures
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3589894
Longitude:
-71.1853954
Location:
Case
number:
Date:
2020-12-02
Time:
09:02
Address:
1250 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 12-2-20 AT APPROX. 0902HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE HIT AND RUN. UPON ARRIVAL AT 1250 WASHINGTON ST. I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES HE WAS IN THE DUNKIN DONUTS AT 1250 WASHINGTON ST. HE STATES A FELLOW PATRON CAME IN AND STATED THE OWNERS CAR HAD BEEN HIT BY ANOTHER VEHICLE BACKING IN THE LOT. OWNER STATES AS HE CAME OUT THE VEHICLE WAS DRIVING AWAY AND HE WAS ABLE TO GET THE PLATE NUMBER ( MA REG : 5945YE ). VEHICLE #1 HAD A LEFT REAR BUMPER DENT.OWNER REPORTED NO INJURY. OWNER ADVISED TO CONTACT HIS INSURANCE COMPANY. A REGISTRY CHECK OF THE PLATE OF THE VEHICLE THAT LEFT THE SCENE CAME BACK AS THE OWNER BEING ( AUTOMATIC LAUNDRY COMPANY, 45 BORDER ST., NEWTON, MA. ). I WENT OVER TO 45 BORDER AND SPOKE TO ( SCOTT SCARPATO , 45 BORDER ST., NEWTON, MA. DOB: 1-22 -91). HE STATED THAT THEY DO OWN THE VEHICLE. HE BELIEVES IT WAS DRIVEN BY HIS GRANDFATHER ( SALVATORE SCARPATO ). HE STATED HIS GRANDFATHER IS ELDERLY AND PROBABLY DID NOT REALIZE HE HIT THE VEHICLE. HE STATED HE WOULD CONTACT HIS GRANDFATHER. HE FURTHER STATED THE COMPANY WILL PAY FOR ANY DAMAGES. I WAS UNABLE TO CONTACT SALVATORE SCARPATO AT THE TIME OF THIS REPORT. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3491465
Longitude:
-71.2248445
Location:
Case
number:
Date:
2020-12-03
Time:
14:26
Address:
1231 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
ON 12-23-20 AT APPROX. 1426HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR EHICLE ACIENT. UPON ARRIVL AT 1231 WASHINGTON I SPOKE TO THE COMPLAINANT ( MARK DONATO, 1231 WASHINGTON ST., NEWTON,MA. DOB: 9-5-57 ). COMP. WORKS FOR HERITAGE CORPORATION. HE SHOWED ME THE REAR LOT OF 1231 WASHINGTON ST. WHERE HE HAD A LARGE HEAVY DUMPTRUCK. BELOQW THE REAR OF THE TRUCK WAS GLASS AND DEBRIS FROM A PAST ACCIDENT. COMP. SHOWED ME VIDEO FOOTAGE FROM 11-30-20 AT 2150HRS. IN THE VIDEO I VIEWED AND SUV IN THE REAR LOT IDLEING. THE SUV ABRUPTLY BACKS IN TO THE PARKED DUMPTRUCK AND THEN QUICKLY SPEEDS AWAY. VEHILE #1 HAS NO VISIBLE DAMAGE. UNABLE TO ASSESS THE DAMAGE TO VEHICLE #2 ADVISED COMP. TO CONTACT HIS INSURANCE COMPANY.
Keywords:
Crash, Speed
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3494843
Longitude:
-71.2239375
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);