crash_reports
4 rows where "datetime" is on date 2019-07-18, intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-18
Time:
08:05
Address:
275 GROVE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was in the left hand turn lane on Grove St (north) in front of #275 Grove St. When her arrow to turn left turned green she proceeded to turn when her MV was struck by MV#2. The operator of MV#2 stated that she was traveling south on Grove St in front of #275 when she noticed she had a red light at the last minute and attempted to stop, but entered the intersection and struck MV#1. A witness walking in front of #275 Grove St stated she observed MV#2 go through her red light and strike MV#1 as she was turning into parking area. Operator #2 cited for failure to comply w/red light.
Keywords:
Citation, Walk
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3388685
Longitude:
-71.2527116
Location:
Case
number:
Date:
2019-07-18
Time:
11:24
Address:
85 BORDER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/18/2019 Gladys Bisono came into NPD Headquarters to report a past-hit and run. Bisono states that between 1500hrs on 7/13/2019 and 1100hrs on 7/14/2019 her leased vehicle (Vehicle 1) was parked and unoccupied on the eastbound side of Border St near 85 Border St. During this time frame an unknown vehicle (Vehicle 2) struck vehicle 1. As a result of the impact Vehicle 1 sustained damage to its front end and front bumper. Vehicle 2 left the scene with out leaving any identifying information. No injuries were reported. No vehicles were towed. Bisono has since reported the crash to her insurance company who advised her to file a police report. At this time the identity of Vehicle 2 and its operator is unknown. Border St is a public way in the city of Newton.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3484567
Longitude:
-71.2330765
Location:
Case
number:
Date:
2019-07-18
Time:
13:34
Address:
251 ADAMS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR #1 STATED SHE WAS TRAVELLING N/B ON ADAMS ST JUST PASSED MIDDLE ST WHEN SHE HAD TO GO AROUND A PARKED UPS TRUCK. HOWEVER DUE TO ANOTHER VEHICLE COMING FROM THE OPPOSITE DIRECTION(S/B) SHE HAD TO MOVE OVER A LITTLE TO THE RIGHT TO AVOID THE ONCOMING VEHICLE, WHICH CAUSED HER TO SIDE SWIPE THE PARKED UPS TRUCK. THE UPS DRIVER WAS WITH THE TRUCK AT THE TIME OF THE CRASH. BOTH PARTIES HAD ALREADY EXCHANGED INFORMATION AND PHOTOGRAPHED THE DAMAGES TO THE VEHICLES. UPS SUPERVISOR WAS ALSO ON SCENE PRIOR TO MY ARRIVAL.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3568505
Longitude:
-71.1986229
Location:
Case
number:
Date:
2019-07-18
Time:
21:33
Address:
163 LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 was parked on the street in front of 163 Lexington St. Operator of MV#2 stated she was emotional and distracted and did not see the car parked in the road. MV#1 sustained major damage to the left side and back. MV#2 sustained major damage to the right side. The area does not have a functioning street light. Operator of MV#2 declined medical attention. Both cars were towed by David from Todys.
Keywords:
Distracted
Dcc:
Emotional
Report
url:
Image
url:
Latitude:
42.3552534
Longitude:
-71.2426722
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);