crash_reports
4 rows where intersection = 1, keywords contains "Crash" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-17
Time:
15:57
Address:
HARTMAN RD & MEADOWBROOK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was stopped at the stop sign on Meadowbrook Rd, travelling southbound. Vehicle 2 was making a right turn onto Meadowbrook Rd from Hartman Rd. Vehicle 2 struck vehicle 1 on the drivers side, causing moderate damage. Vehicle 2 had minor damage to the front left bumper. No one was injured due to the accident. Tody's towed vehicle 1 to their lot.
Keywords:
Crash, Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3078062
Longitude:
-71.191447
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:
Case
number:
Date:
2020-12-21
Time:
17:43
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On December 21, 2020 at approximately 17:43 hours I responded to a two vehicle crash with air bag deployment on Chestnut St. @ Boylston St. Upon arrival all occupents were out of the vehicles and reported no injuries. Operator of MV1 was traveling Northbound on Chestnut St when the operator of MV2 attempted to cross Chestnut St from Boylston St and MV1 struck the passanger side of MV2. The operator of MV2 claimed that he stopped at the stop sign and thought that the roadway was clear to pass but was struck by MV1. MV1 did not have a stop sign at the location of the crash and therefore had the right away. MV1 was towed from the scene by Tody's, MV2 conacted a private tow from the scene.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Case
number:
Date:
2020-12-21
Time:
16:48
Address:
HOMER ST & ASHTON AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv 1 stated she was stopped at the stop sign on Ashton Ave. MV 1 was heading southbound and proceeded onto Homer St. to follow through to Pleasant St. Mv1 thought she had enough distance from Mv 2. Mv 1 then got hit on her driver side door by Mv 2. Mv 2 stated she was driving westbound on Homer St. when Mv 1 pulled out too fast from Ashton ave and caused the accident. No injuries were reported. No tows were needed.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3349479
Longitude:
-71.2016431
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);