crash_reports
2 rows where dcc = "["Other improper action"]", speed_limit = 15 and violation_cited = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-05-10
Time:
12:27
Address:
300 NEEDHAM ST
Speed
limit:
15
Violation
cited:
no
Narrative:
Operator of veh#1 stated he was parked inside the lot of #300 Needham St. in a parking spot. When he attempted to back out, he forgot this vehicle was in drive when he gave it gas. He then struck some bushes and a metal fence surrounding the property. The operator then panicked and drove home. Once at home he realized he should go back to the scene and was on his way back when the Police contacted his father. The operator and father showed up on scene and gave me the proper information. I gave the operator of verbal warning for leaving the scene and advised him that if he had not come back on scene there would have been a criminal citation issued. He and his father thanked me and left without any further issues. I called the Property Manager- Paul (978) 884-3045 for this building and left a message asking him to call me back with the owners information.
Keywords:
Bus, Citation
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3077228
Longitude:
-71.2144721
Location:
Case
number:
Date:
2022-05-18
Time:
09:35
Address:
845 WASHINGTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The owner Vehicle #1 stated that he observed fresh damage to the rear of his vehicle. After viewing video he saw that it wa involved in a collision with a vehicle bearing MA Reg. 7MLK30 as it was backing out of a parking space. I was able to contact the operator of Vehicle #2. He stated that as he was backing out of a parking space he sneezed and was not sure if he made contact with Vehicle #1. When he checked the vehicle, he stated that he did not observe any damage. He was informed of Mr. William's claims, and agreed to cooperate.
Keywords:
[]
Dcc:
Other improper action
Report
url:
Image
url:
Latitude:
42.3516966
Longitude:
-71.2078404
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);