crash_reports
2 rows where "datetime" is on date 2019-07-25 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-25
Time:
09:09
Address:
792 BEACON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of Motor Vehicle #1 was sitting in his vehicle parked at a metered spot facing Westbound on Beacon Street. Operator of motor vehicle #1 stated that he felt the vehicle move and walked outside and noticed that the rear break light was smashed. Operator of Motor vehicle #1 stated that he stopped a Toyota Camry that he thought struck the vehicle however there was no damage to camry and the operator stated that he did not hit his vehicle. Operator of motor vehicle #1 stated he was unable to locate the vehicle that struck his car. I canvassed the surrounding businesses and all businesses had negative results for cameras outside that would be able to capture the hit and run.
Keywords:
Bus, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3301226
Longitude:
-71.1933552
Location:
Case
number:
Date:
2019-07-25
Time:
16:23
Address:
444 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
At approximately 1620HRs on Thursday, July, 25, 2019, I was dispatched to 444 Washington St. in reference to a truck vs tree motor vehicle crash. Upon arrival, I noted MV1 (MA Vet: 22098) had partially left the roadway and came to rest when it struck a city tree on the sidewalk. Additionally, I noted MV1 struck MV2 (MA Pass: 5CN826), which was parked on the road in front of the tree/aforementioned address. MV1 sustained damage to its front clip and was leaking fluids. MV2 sustained damage to its right rear bumper/quarter panel area. Upon speaking with the operator of MV1, an employee of Tony's Auto Services, he stated that he was test riding the vehicle after they made repairs to its power steering system. He stated that as he traveled eastbound on Watertown St. at approx 30MPH, the vehicle's brakes failed and he guided MV1 towards the tree in an attempt to stop it without injuring anyone. Todys Services took custody of MV1. Newton Fire cleaned up the leaking fluids and the operator of MV1 signed a patient refusal with Newton Medics. Newton Dispatch notified the city to see if they wished to inspect the tree which was still freestanding and appeared to only suffer minor damage. Tony's Auto Services notified the owner of MV1 and I notified the owner of MV2 of the crash. I submitted a picture of the tree to IT to be attached to this report. I cleared without further incident.
Keywords:
Crash, Fire, Pictures, Tree
Dcc:
Defective equipment
Report
url:
Image
url:
Latitude:
42.3588636
Longitude:
-71.2033801
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);

