crash_reports
4 rows where "date" is on date 2019-05-17, intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-17
Time:
13:00
Address:
876 BEACON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1, a City of Newton contracted school bus, was parked on the side of the road. MV2 was driving east past the school bus and misjudged how close his trailer(Ma Reg D43490) was and struck MV1. There were no students on the bus. I took pictures and TOT IT. Operator MV2 was unlicensed and cited with Ma Citation T1269943 for 90/10. 2 licensed operators showed up and too possession of MV2.
Keywords:
Bus, Citation, Pictures, School
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3299504
Longitude:
-71.197161
Location:
Case
number:
Date:
2019-05-17
Time:
15:01
Address:
275 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of V1 stated she was stopped in traffic waiting for vehicles to start moving that were ahead at the traffic light. Opr stated when she looked up she saw V2 driving towards her and made contact with her vehicle. Opr of V1 stated she did not see V2 turning and it was too late to stop or move out of the way. Opr of V2 stated she was taking a left hand turn into the parking lot. Opr stated the first lane of traffic let her take the left. As she was completing the turn she made contact with V1 in the second lane of southbound traffic. There were no injuries. V1 suffered damage to the front left part of her vehicle. V2 suffered damage to the front of her vehicle.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.358572
Longitude:
-71.185233
Location:
Case
number:
Date:
2019-05-17
Time:
19:24
Address:
165 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Vehicle 1 parked in the parking lot at approximately 1830 hours, and the owner was shopping inside of Stop and Shop. When she returned at 1930 hours, she noticed that the left rear of the vehicle had a dent in it. It appeared that vehicle 2 backed into vehicle 1, and fled the scene. I spoke with the manager of Stop and Shop, and asked if I could view the surveillance footage of the accident. She stated that loss prevention needed to view it first, and that they would contact us after reviewing it.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2019-05-17
Time:
19:18
Address:
184 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 stated they were traveling straight when vehicle 2 turned on their blinker at the last second and took a left and cut across 2 lanes of traffic into the driveway of 184 Washington st. Vehicle 2 stated she was attempting pull into a driveway to figure out how to get back to her residence when vehicle 1 hit the rear left side of her car.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3562958
Longitude:
-71.1817752
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);