crash_reports
3 rows where date = "2019-07-31" and dcc = "["Unknown"]"
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-31
Time:
08:52
Address:
DEXTER RD & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was turning left(east) onto Dexter Rd from Walnut St. As he made the turn he side swiped MV2 who was inching out from Dexter near the center line(not marked). Oper MV1 stated that he was watching MV2 as he turned onto Dexter Rd. He stated that he did not see her stop at the stop sign and she was moving forward at the time of the collision. She was very near the middle of Dexter Rd and was almost past the crosswalk. Operator MV2 stated that she stopped at the stop sign and began inching forward past the crosswalk to see southbound on Walnut St so she could safely turn right(north) onto Walnut St. She did not see MV1 turning onto Dexter Rd. I asked her if she was injured and she stated she was shaken up and she has a past spinal/disk injury. I requested a BLS to evaluate her at the scene(signed refusal) I spoke with witness Gabrielle Wachman 857-204-4144. He was stopped southbound on Walnut St at Dexter St due to traffic. He observed the City truck which was behind him turn left onto Dexter and strike MV2. . He did not see if MV2 stopped at the stop sign. He only saw that she was moving forward past the crosswalk at the time of the MVA. I took pictures of the scene and TOT IT.
Keywords:
Crosswalk, Pictures
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3420288
Longitude:
-71.2065141
Location:
Case
number:
Date:
2019-07-31
Time:
15:06
Address:
ADAMS ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator 1 stated he was coming out of Jackson Rd onto Washington St and attempting to turn right onto Adams St. He saw vehicle two sitting in the right turn/straight lane and not moving. cars had begun to proceed through the intersection and go passed vehicle two, so he assumed vehicle 2 was parked or disabled and drove around him on the left in order to make a right hand turn. When he started to turn, vehicle 2 proceeded straight through the intersection striking vehicle 1. Operator of vehicle 2 stated he looked up and saw a green light so he proceeded straight, striking vehicle 1 as it was turning in front of him. there were no injurys and no vehicles were towed.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3548522
Longitude:
-71.1956673
Location:
Case
number:
Date:
2019-07-31
Time:
06:57
Address:
HARVARD ST & NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of Vehicle #1 stated that he proceeded through a green light, prior to his vehicle being struck on the passenger side by Vehicle #2. As a result of the collision, his vehicle then struck a traffic light. Operator #1 was transported to Newton-Wellesley Hospital by Medic-1, and his vehicle was towed by Tody's Towing Co. The operator of Vehicle #2 stated that he wasn't sure if his light was green prior to the collision with Vehicle #1. He declined medical attention, and his vehicle was towed by Tody's Towing Co. It should be noted that Operator #2 was unable to produce a Driver's License, and a routine query showed no status, thus he was issued a criminal app.
Keywords:
Hospital
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.351149
Longitude:
-71.201654
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);