crash_reports
1 row where address = "0 PELHAM ST" 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:
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);