crash_reports
2 rows where "datetime" is on date 2019-01-16, intersection = 0 and "retrieved" is on date 2020-10-06
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-16
Time:
15:27
Address:
611 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Wednesday, January 16th 2019, at approximately 3:30pm, I, Officer Brooks, responded to a single car MVA in the area of 611 Watertown street. Upon my arrival Cataldo medics were treating the operator of MV1(MA REG 159EF6) for a diabetic issue. I spoke with a witness to the accident who did not wish to leave their information. The witness stated they were traveling westbound on Watertown street behind MV1, when it suddenly left the roadway to the right, striking the curb, before returning to the roadway and stopping. The witness stated that MV1 nearly missed a fire hydrant and a utility pole on the sidewalk. MV1 had a flat front passenger side tire, and minor scrapes on the body. I spoke with the medics who were still treating the operator for her diabetic issue. I observed the operator was in and out of consciousness, and unable to speak about the accident. It took several minutes for the operator to regain her consciousness, however she was still not able to answer simple questions coherently and was transported to Newton Wellesley hospital for further evaluation. MV1 was towed from the scene by Tody's, and an inventory form was filed and submitted. The area the crash occured was a high pedestrian traffic area, and both an elementary and middle school are within walking distance of the accident. An immediate threat form was filled out and filed for the operator of MV1.
Keywords:
Crash, Fire, Hospital, Ped, School, Walk
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3557666
Longitude:
-71.2105273
Location:
Case
number:
Date:
2019-01-16
Time:
15:09
Address:
74 BRIDGE ST
Speed
limit:
20
Violation
cited:
no
Narrative:
The owner of Vehicle #1 stated that she witnessed the rear driver's side of her bumper get damaged by a FedEx truck was reversing into the parking lot at 74 Bridge St. The plate she offered me did not come back. I have spoken to a manager at the FedEx corporate office named Dan Grouts. His information was given to Ms. DaFonseca to resolve this matter.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3631871
Longitude:
-71.2025523
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);