crash_reports
1 row where intersection = 0, keywords contains "Fire" and "retrieved" is on date 2021-06-02
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-05-27
Time:
16:10
Address:
206 ELLIOT ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 was stopped in front of 206 Elliot St. waiting to turn left onto Cottage St. when MV2 struck the rear end of his vehicle. I asked the operator of MV2 if he was following MV1 too close which he stated "no" that he had looked away for a second and when he looked back up he noticed that MV1 was stopped and that was when he tried to stop and struck the back of MV1. Newton Fire Department was on scene and witnessed the incident. Both operators did not want medical attention. Operator of MV2 was given a written warning for improper operation 90/12 (Citation #2014395). Operator of MV2 was not given a citation for following too close, due to admitting that he was not close, but had looked away from where he was driving. MV1 was operable and was able to leave the scene. MV2 sustained heavy front end damage and was towed away by Tody's Towing Service.
Keywords:
Citation, Fire
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3128292
Longitude:
-71.2174434
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);