crash_reports
4 rows where "datetime" is on date 2019-08-08, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-08
Time:
10:10
Address:
32 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator was travelling on Commonwealth Ave E/B in the area of #32. #1 operator was distracted by his ringing cell phone on the front seat floor. While reaching down to retrieve it, #1 rear ended Mv#2 (postal truck) that was parked near the side of the road while operator was conducting mail business inside the truck. No injuries reported by #1 or #2. #1 sustained front end damage that required tow service by Tody's. #2 did not require a tow.
Keywords:
Bus, Distracted, Phone
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3394216
Longitude:
-71.16794
Location:
Case
number:
Date:
2019-08-08
Time:
11:22
Address:
677 WINCHESTER ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Owner of vehicle 1 was informed by Marina Feldman that she witnessed vehicle 2 back into vehicle 1 while it was parked in the lot of 677 Winchester St. Operator of vehicle 2 stated that he was unaware that he hit vehicle 1.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.2982975
Longitude:
-71.2033801
Location:
Case
number:
Date:
2019-08-08
Time:
13:35
Address:
20 AUSTIN ST
Speed
limit:
0
Violation
cited:
no
Narrative:
The owner of MV#1 stated he came out to his vehicle and found a note that someone had struck it. There was damage on his passenger rear door of MV#1. I spoke with the operator of MV#2 who stated that MV#1 was parked too close to her vehicle and she opened her drivers door and struck the passenger side door of MV#1.
Keywords:
[]
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3502776
Longitude:
-71.2075314
Location:
Case
number:
Date:
2019-08-08
Time:
20:25
Address:
719 WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Thursday, August 8th 2019, at approximately 8:25pm, I, Officer Brooks, was parked in front of 719 Washington street facing westbound. I looked into my side view mirror to pull into traffic and observed MV1 (MA REG 118GL4) parked behind me with the driver's side door open. The operator was leaning into the car to retrieve an item, and then stood up and turned around to close the door. I observed MV2(IN REG VWI565) traveling westbound, at what I estimated to be 45 miles per hour. MV2 struck the open door of MV1, narrowly missing operator #1. MV1 sustained major damage to the driver's side door and was towed by Tody's. MV2 had heavy damage to the passenger side front end. The operator of MV2 was placed under arrest for Operating under the influence of alcohol after investigation. MV2 was towed by Tody's. There were no injuries as a result of the accident.
Keywords:
Alcohol, Crash
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3527843
Longitude:
-71.2030088
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);