crash_reports
4 rows where dcc = "[]", intersection = 0 and "retrieved" is on date 2022-06-08
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2022-05-27
Time:
17:46
Address:
340 RIVER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 said she was parked in the parking lot of 340 River Street. Operator of MV1 said MV2 was parked next to her backed up and hit the building of 340 River Street. Operator of MV1 said after MV2 struck the building MV2 drove forward and struck the rear of MV1. Operator of MV1 said that the operator of MV2 exited the vehicle and said that there was no damage and that he did not have time for this. Operator of MV1 said MV2 sped out of the parking lot taking a right heading eastbound on River Street. Operator of MV1 said it was a dark color Toyota that's registration began with a 7. Operator of MV1 described the operator as a young white male with dark curly hair and was wearing a light colored sweatshirt. There was a small scratch on the rear bumper of MV1. According to Operator of MV1 there should be damage done to the right side of the front bumper as well as the rear bumper of MV2. There were no injuries and MV1 was able to drive away from the scene. I spoke to the employee of River Side Street Food Mart (340 River Street). The employee stated they have camera's that face the parking lot but he does not know how to use the cameras. The employee said his boss knows how to use the camera's but he was not working tonight. I provided the employee with the Newton Police's phone number and advised him to call if his boss can send us the video footage to see if we can see the license plate of MV2.
Keywords:
Phone
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3575474
Longitude:
-71.239428
Location:
Case
number:
Date:
2022-05-27
Time:
22:14
Address:
313 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was taking a left onto Washington Street. MV2 was in the left turn only lane and when the light turned green, MV1 continued to take a left while MV2 attempted to go straight, hitting MV1 on the driver side bumper. The operator and passenger were not injured. There was damage to the rear driver side bumper.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3572261
Longitude:
-71.1865249
Location:
Case
number:
Date:
2022-05-29
Time:
20:59
Address:
29 MIDDLE ST
Speed
limit:
20
Violation
cited:
no
Narrative:
The owner of MV1 stated he parked his vehicle on Middle Street at 0530 hrs today. When he returned this evening, he observed damage to the front driver side of his vehicle. I checked the area for cameras that may have captured the vehicle that struck MV1, yielding negative results.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3573896
Longitude:
-71.197616
Location:
Case
number:
Date:
2022-06-03
Time:
09:32
Address:
355 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
OWNER OF MV 1 STATED THAT SHE HAD LEGALLY PARKED HER VEHICLE ON WASHINGTON ST AROUND 11:30 PM AND WHEN SHE ARRIVED AT HER CAR THIS MORNING, SHE NOTICED THAT IT HAD BEEN STRUCK AND HAD DAMAGE TO ITS DRIVERS SIDE AND BUMPER. THERE WERE NO WITNESSES TO THE ACCIDENT AND NO CAMERAS IN THE IMMEDIATE AREA THAT MAY HAVE CAPTURED THE ACCIDENT.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3568016
Longitude:
-71.188041
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);