crash_reports
3 rows where keywords contains "Snow" and speed_limit = 10
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-04
Time:
08:32
Address:
25 CHESTNUT ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV1 was backing into a snow covered parking space at 25 Chestnut St. The lot had not been plowed yet. As he was backing, the rear of the truck fishtailed slightly and struck parked MV2(city MV). There was a scratch to the drivers side mirror of MV2. The rear drivers tail light and quarter panel were damaged on MV1. I took pictures as did oper MV1. I transferred my pictures to IT.
Keywords:
Pictures, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3488353
Longitude:
-71.2257494
Location:
Case
number:
Date:
2019-03-12
Time:
15:49
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The OP. of MV#1 states she has been having issues with controlling her right leg recently and went to Newton-Wellesley Hospital today to precisely see her doctor about it. As she was pulling up to stop for the Valet, her leg hit the gas pedal instead of the brakes. She steered around pedestrians, went up on the curb, through a frozen snow mound before managing to stop on a roadway towards the other hospital buildings. The OP. of MV#1 understands that she shouldn't be driving for the time being. Immediate Threat Form was faxed to the Driver Control Unit.
Keywords:
Hospital, Ped, Snow
Dcc:
Physical impairment
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
Case
number:
Date:
2022-02-02
Time:
08:31
Address:
0 PELHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Wednesday, February 2, 2022, while assigned to Traffic unit N525, I responded to the Pelham Street Municipal Lot for a report of a motor vehicle crash involving a City of Newton owned truck. The weather at the time of the crash was overcast. The road surface was wet from melting snow in the area. The Pelham Street Municipal Lot is maintained by the City of Newton. I spoke with the operator of MV1, Mr. Florestal Jackson (S57770573). Mr. Jackson is an employee of the City of Newton DPW and was assisting with snow removal in the Pelham Street Municipal Lot. Mr. Jackson stated while operating a City of Newton owned 2012 Ford F350 (MA MVN: M86781), he was backing in the lot when the rear of his vehicle crashed into the rear passenger trunk area of a parked 2016 Toyota Rav 4 (MA: 1JRD33). Mr. Jackson reported no injuries. The owner of MV2, Ms. Angela Davitoria (S30231275) stated she was sitting in her parked vehicle in parking spot #2224 when MV1 backed into her. Ms. Davitoria reported no injuries. Photos were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures, Snow
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3310575
Longitude:
-71.1962947
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);