crash_reports
1 row where "datetime" is on date 2019-09-04, intersection = 0 and keywords contains "Solar"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-09-04
Time:
10:25
Address:
84 PAUL ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday, September 4th, 2019 while assigned to Traffic unit N526, I responded to 84 Paul Street, Newton for a report of a motor vehicle crash involving a City of Newton DPW vehicle. The weather at the time of the accident was clear and sunny. The road surface was dry. Paul Street is a public way maintained by the City of Newton. I met with the operator of MV1, Newton Associate Engineer John Daghlian. Daghlian stated he was operating Newton DPW Nissan Leaf (MA M99257) attempting to parallel park on Paul Street in an open space. Daghlian stated as he pulled forward into the space his front end made contact with the bumper of MV2 which was parked info of MV1 unoccupied. Both vehicles sustained very minor damage. No injuries were reported by the occupants of MV1. I spoke with the owner of MV2, Naomi Singer (2019 BMW 330XI, MA: 8SP372). She stated she was inside her dentist appointment when the accident occurred and was notified by Daghlian. Pictures of both vehicles were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3264298
Longitude:
-71.1973785
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);