crash_reports
4 rows where date = "2019-01-23"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, violation_cited, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array), dcc_code (array)
Case
number:
Date:
2019-01-23
Time:
06:50
Address:
COMMONWEALTH AVE & TEMPLE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The OP. of MV#1 states while travelling westbound on Commonwealth Ave., MV#2 suddenly came out of the side and they collided together. The OP. of MV#2 states he was on Temple Street waiting to cross Commonwealth Ave to continue on Temple Street. He did not see any oncoming vehicles and drove forward, but collided with MV#1. The OP. of MV#2 only had an El Salvador drivers license that expired in 2009. He states he has lived in the U.S. for a long time and is in the process of getting his legal status from marrying a U.S. citizen. Commonwealth Ave and Temple Street are both public ways in the City of Newton.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3392936
Longitude:
-71.233645
Location:
Case
number:
Date:
2019-01-23
Time:
07:24
Address:
TREMONT ST & WAVERLY RD
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was stopped at a red light north on Tremont St at Waverly Ave. MV2 was stopped behind MV1. MV2 reached for something and her foot slipped off the gas and she bumped the rear of MV1. All parties agreed that it was a tap from behind and that there was no damage to either MV. However, there were 2 special needs students on the van that go to NNHS. Amb1 responded and obtained refusals from both parents who responded to the scene. I took pictures of both MVs and TOT IT.
Keywords:
Pictures
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3540073
Longitude:
-71.1790101
Location:
Case
number:
Date:
2019-01-23
Time:
14:07
Address:
165 NEEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Leary was crossing Needham St southbound at the corner of the property between Stop and Shop and Jiffy Lube. She states that she was 1/4 of the way across the street when she was struck by MV1. The left side of her body(arm, hip) struck the right side of the MV. She fell to the ground. MV1 states that he was pulling out of the Stop and Shop driveway to turn right onto Needham St. He saw the pedestrian next to the snow bank on the right side of the driveway as he approached the end of the driveway. When he got to the end he did not see her anymore and assumed she had continued walking west on Needham St. He then turned right and felt the collision and then he saw her. He immediately pulled into the Jiffy Lube lot to check on her. I took pictures of the scene and the MV. They were TOT IT. After further investigation, on 2/7 the operator was cited for 90/14 failure to stop for pedestrian. I spoke with Kenneth via phone and advised him of the update. The citation was mailed to him. I am charging for 90/14 failure to stop for a pedestrian. On Wednesday February 6, the operator information of this report was ammended to show the correct operator information.
Keywords:
Citation, Ped, Phone, Pictures, Snow, Walk
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3121478
Longitude:
-71.2138224
Location:
Case
number:
Date:
2019-01-23
Time:
16:32
Address:
WASHINGTON ST & STANTON AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
At approximately 1630 HRs on Wednesday, January 23, 2019, I was dispatched to the intersection of Washington St. and Stanton Ave. Upon arrival, both parties had pulled into 160 Stanton Ave. and began to exchange paperwork. I spoke with the operator of MV1 (MA Pass: 166AW2), who stated that as she traveled Eastbound on Washington St. she was cut off by MV2, who was attempting to cross over Washington St. and enter Stanton Ave., causing her vehicle to collide with MV2. I spoke with the operator of MV2 (MA Pass: 822EZ4) who stated that she was stopped at the intersection and made a left hand turn in an attempt to enter Stanton Ave Southbound, believing she had enough time to safely do so, it was at this point that her vehicle and MV1 collided. I observed damage to MV1's front right bumper area and damage to MV2's right rear door area. Both parties stated that they were uninjured and I cleared without incident.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3344348
Longitude:
-71.2439056
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);