crash_reports
3 rows where date = "2020-12-18" and "retrieved" is on date 2021-01-08
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:
2020-12-18
Time:
02:22
Address:
COMMONWEALTH AVE & OLD COLONY RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Based on observations and statements made, the following occurred. M/V#1 was travelling west on Commonwealth Ave. and attempted to turn left onto Old Colony Rd. Due to the icy conditions of the road, and speed too fast for conditions, M/V#1 only angled slightly to the left, and slid into a snowbank, and the curb on Commonwealth Ave. knocking down a city light pole. The vehicle was towed by Tody's.
Keywords:
Ice, Snow, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3371123
Longitude:
-71.1724493
Location:
Case
number:
Date:
2020-12-18
Time:
11:13
Address:
HYDE ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#2 operator stated he was travelling on Walnut St S/B and braked for Mv#1 that was slowing ahead of him preparing to turn left on Hyde St. Mv#2 stated his truck slid over a snow patch which caused him to rear end Mv#1. The plow from Mv#2 struck the rear end of #1. Operator of Mv#2 was not injured. Mv#1 operator stated she was slowing on Walnut St S/B preparing to turn left when she was rear ended by Mv #2. Operator was not injured. Operator stated she does not have a license due to license paperwork issues. Operator produced a MA license which when queried expired on 5/7/18. Mv#1 rear seat juvenile passenger was picked up by his father on scene. Father refused evaluation for his son. A MA licensed operator arrived on scene to drive #1 from the scene. #1 operator was issued citation #T2080651 in hand for 90/10 unlicensed operation. Walnut St is a public way.
Keywords:
Citation, Snow
Dcc:
Swerving, Other improper action
Report
url:
Image
url:
Latitude:
42.3258015
Longitude:
-71.2065359
Location:
Case
number:
Date:
2020-12-18
Time:
16:52
Address:
WATERTOWN ST & HAWTHORNE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Friday, December 18th 2020, at approximately 4:52pm, I, Officer Brooks, responded to a 2 car MVA that happened at the intersection of Watertown street and Hawthorne street. Upon my arrival I spoke with the operator of MV1(MA REG 5CK522) who stated she was traveling westbound on Watertown street, when she was struck on her driver's side door by MV2(MA REG268WC6), which had been attempting to merge onto Watertown street from Hawthorne street. MV1 sustained damage to the driver's side door. I spoke with the operator of MV2 who stated she was stopped at the stop sign at the intersection of Hawthorne street and Watertown street, and believed she had looked both ways before turning left and heading westbound on Watertown street. The operator stated she never saw MV1 before she struck it. MV2 had damage to the passenger side front end and headlight assembly. Both operators were provided a crash report number and sent on their way.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3593322
Longitude:
-71.203305
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);