crash_reports
5 rows where "datetime" is on date 2019-05-28 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-28
Time:
07:45
Address:
1778 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was stopped in traffic east bound on Commonwealth Ave(#1778) when MV#2 rear ended his MV. The operator of MV#2 stated that she was also traveling east on Commonwealth Ave directly behind MV#1. Operator stated she is not familiar with MV#2 and attempted to stop MV but that brake didn't respond as quickly as she expected it to. MV#2 then rear ended MV#1. No injuries and MV#2 was towed by Todys.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.341427
Longitude:
-71.239602
Location:
Case
number:
Date:
2019-05-28
Time:
08:39
Address:
697 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one stated that while driving west bound near 697 Washington St her vehicle's passenger side mirror struck vehicle's two driver's side mirror. Operator of vehicle one stated that a large truck that was driving next to her vehicle west bound that was coming close to her vehicle. Vehicle two was parked unoccupied in front of 697 Washington St. Vehicle's one's passenger mirror was damaged and vehicle's two was not damaged. Neither vehicle required a tow and operator of vehicle one stated that she was not injured. I took photos of both vehicles and forward the disk to the NPD's IT Bureau.
Keywords:
Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3529253
Longitude:
-71.2021966
Location:
Case
number:
Date:
2019-05-28
Time:
13:12
Address:
149 OAK ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Based on statements and observations the following occurred: Mv#1 was travelling straight ahead on Oak St S/B and rear ended Mv#2 that was stopped in traffic at #149 Oak St. #1 operator wasn't paying attention to traffic stopped ahead of him, as a result wasn't able to stop in time, and rear ended #2. No injuries reported. #1 sustained significant front end damage. It was towed by Tody's. #2 appeared to sustain moderate rear end damage. #2 did not require towing and was driven away by the operator.
Keywords:
Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3079714
Longitude:
-71.2189042
Location:
Case
number:
Date:
2019-05-28
Time:
15:07
Address:
1045 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states he was stopped in traffic westbound, in the area of 1045 Beacon St. He states suddenly he was struck from behind by MV2. The vehicles seperated briefly and MV2 struck the back of MV1 again. Operator of MV2 stated she was driving at a slow rate of speed, behind MV1. She states she tried to stop her car but it was not responding. She attempted to downshift her car and put it in park, but instead it lunged forward into MV1 multiple times. No injuries were reported on scene. MV2 was towed by Todys. The passenger of MV2 had already left the scene prior to my arrival. I was able to speak to his father via phone who stated he was uninjured and did not need medical treatment.
Keywords:
Phone, Speed
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3308483
Longitude:
-71.2049812
Location:
Case
number:
Date:
2019-05-28
Time:
21:58
Address:
330 ELLIOT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was parked eastbound at 330 Elliot St when it was struck by MV3 in the rear left corner. MV1 was pushed forward into the rear of MV2. Both vehicles were unoccupied. Reporting party stated MV3 was possibly a dark colored SUV, unknown registration, that fled the scene eastbound on Elliot. Officers checked the surrounding area for a dark colored SUV with front end damage with negative results. MV1 sustained heavy damage to the left rear corner and was towed from the scene by Tody's. MV2 sustained very minor damage to the rear end. Towed motor vehicle inventory form was filled out and submitted.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3127458
Longitude:
-71.2231738
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);