crash_reports
2 rows where intersection = 0 and "retrieved" is on date 2021-10-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-17
Time:
08:49
Address:
100 ELM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday September 17th, 2021 at approximately 0849 hours I responded to the area of the Elm Street municipal lot for a motor vehicle accident involving a city owned vehicle. At the time of the accident the weather was cloudy and the road surface was dry. Elm Street is a public way owned and maintained by the City of Newton. Upon arrival I spoke with the operator of the City of Newton Parks and Recreation truck, identified as Benjamin Langkopf (S08711384). Benjamin stated his vehicle (MA REG; M3732A) was parked on the side of the road on Elm Street when a Ryder box truck pulled into the parking space in front of him and sideswiped his front drivers side area with the trucks rear passenger side. No injuries were reported and the city vehicle sustained minor damage. Photographs of the damage were taken and submitted to the IT Bureau. The operator of the Ryder Rental truck was identified as Hykeem Duane Wilkey (S76520284). Hykeem stated he was operating a Ryder Rental box truck (MA CON REG; T40779) and attempted to pull into a parking space on the street when his rear passenger side struck the front drivers side of the city vehicle. No damage was reported and the operator had no injuries.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3493902
Longitude:
-71.2292085
Location:
Case
number:
Date:
2021-10-25
Time:
08:32
Address:
100 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On October 25th, 2021 at approximately 08:32 hours while working N491 I responded to a report of a MV crash in the area of Walnut St near Minot Place. On my arrival I located both involved vehicles near #100 Walnut St, The School Administration Building. Vehicle #1 was a blue 2015 Prius, Ma reg.945-AM3, operated by a William Aldridge. He stated he was first stopped N/B at the intersection of Walnut St @ Watertown St in the right turn only lane. The light turned green and realized he wanted to go straight so he continued heading N/B on Walnut St . However as he went straight he cut off vehicle #2 who was in the lane to his left who then honked his horn at him. Vehicle #1 then stopped ahead of vehicle #2 a short distance down the road. Vehicle #2 then drove around vehicle #1 who was still stopped. Vehicle #2 after going around vehicle #1 had to stop almost immediately due to a pedestrian crossing the street. Vehicle #1 at the same time proceeded forward behind vehicle #2 but then rear ended vehicle #2 after it stopped for the pedestrian. Vehicle #2 was a 2021 grey Toyota Highlander, Ma reg. 447AB8, operated by a Rizwan Khan. He stated he was stopped for the light N/B on Walnut St @ the intersection of Watertown St. He was in the lane for straight ahead traffic. As the light turned green vehicle #1 cut over into his lane ahead of him causing him to almost hit him. He then admitted beeping his horn at vehicle #1. Thats when vehicle #1 suddenly stopped in front of him. After vehicle #1 didn't move he decided to go around him. As he passed him there was a pedestrian crossing the street. He then stopped his vehicle so the person could cross. His vehicle was then rear ended by vehicle #1.
Keywords:
Crash, Ped, School
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3569892
Longitude:
-71.2094134
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);