crash_reports
1 row where "datetime" is on date 2019-01-04, dcc contains "Unknown" and keywords contains "Walk"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-04
Time:
10:51
Address:
54 NEEDHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 01/04/19 I responded outside of #54 Needham St for a two vehicle crash. Veh #1 was a delivery box van who was driving due North on Needham St. The operator of veh #1 stated he was attempting to take a left into #55 Needham St. when veh #2 came from behind him on his left and he struck veh #2 as he turned. The operator of veh # 1 was taken by Ambulance #1 to Newton-Wellesley Hospital for an evaluation after complaining of pain in his chest area. The passenger of veh #1 stated everything happened "so fast" he didn't see what transpired. Moderate damage to veh #1. The operator of veh #2 stated he was traveling due North on Needham St. and was behind veh #1 for a long stretch of the road. The operator of veh # 2 stated veh #1 put his right directional on three different times but didn't turn. He stated veh #1 had his right directional on and was in the right lane when he went to pass him. Veh #1 then turned into his rear passenger side as he passed. Moderate damage to veh # 2. The operator of veh #2 stated the operator of veh #1 was walking around and yelling about the accident for a period of time and then eventually grabbed his chest and fell to the ground complaining of pain. From the result of my investigation it appears as if veh # 1 attempted to turn from the wrong lane and veh # 2 was passing in the "suicide lane", also wrong lane. There will be no citations issued at this time as both operators were given verbal warnings.
Keywords:
Citation, Crash, Ems, Hospital, Moderate, Walk
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3155185
Longitude:
-71.209922
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);