crash_reports
3 rows where "datetime" is on date 2019-04-18, intersection = 0 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-18
Time:
10:08
Address:
2058 COMMONWEALTH AVE
Speed
limit:
5
Violation
cited:
yes
Narrative:
The owner of MV#1 states that he returned to his unoccupied MV to find a note from a witness stating they observed another MV strike his MV while they were attempting to park in the parking spot to the left of MV#1. Witness identified MV#2 as Ma Reg 1705XY, a Honda CRV. Witness states he observed an older W/M operating Ma. Reg. 1705XY (MV#2) attempt to park in a parking spot while striking MV#1 and then quickly exit the spot. Witness feels confident operator of MV#2 knew he struck MV#1. I then spoke with operator/owner of MV#2 who admitted he was operating MV#2 during minor crash, but didn't think it was significant so he left the area. Operator #2 cited for leaving the scene of a MV crash.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3471049
Longitude:
-71.2463773
Location:
Case
number:
Date:
2019-04-18
Time:
12:22
Address:
81 OAK ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 04/18/209 at approximately 1222 hours I responded to 81 Oak Street for a motor vehicle accident involving Newton Fire Ladder 2. At the time of the accident the weather was cloudy and road conditions were dry. Oak Street is a public way in the city of Newton. Upon arrival I spoke with the operator of MV1 who stated while trying to manuever through oncoming traffic on Oak Street heading southboud MV1 struck MV2's drivers side mirror while MV2 was parked. MV1 reported no damage and reported no injuries. MV2 reiterated the same events and reported very minor damage to the drivers side mirror. No injuries were reported. Several pictures were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3098704
Longitude:
-71.2208998
Location:
Case
number:
Date:
2019-04-18
Time:
14:00
Address:
37 ELM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 04/18/2019 at approximately 1400 hours I responded to 37 Elm Street for a single vehicle accident with City of Newton property damage. At the time of the accident the weather was cloudy and the road conditions were dry. Elm Street is a public way in the city of Newton. The operator of MV1 identified as Silton Barrett (S17437114) stated he parked his UHAUL van in front of 37 Elm Street to make a delivery. While attempting to pull MV1 back into the traffic lane he struck a fire hydrant knocking it over and completely detaching it from the base on the ground. MV1 sustained minor front end damage and was able to leave the scene. Several photographs were taken and submitted to the IT Bureau. City of Newton was notified for the property damage.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3512239
Longitude:
-71.23108
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);