crash_reports
3 rows where dcc contains "Unknown", intersection = 0 and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-22
Time:
21:07
Address:
300 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 operator states he was driving around the Newton Corner Rotary and approached the merge at the beginning of the bridge to change lanes to head towards Waltham/Watertown, when MV2 collided with his vehicle. Damage was observed on the front passenger door. No injuries reported. MV2 operator states she was driving on Washington St and approached the merge at the beginning of the bridge to change lanes and head onto the Mass Pike W-Bound, when MV1 collided with her vehicle. Damage was observed on the front drivers side bumper. MV2 operator reported having whiplash but signed a medical refusal and was not transported to the hospital. I then cleared without further incident. The main crash factor was due to the weather being a heavy rain storm at night. It should be noted there is a yield sign facing MV1s incoming direction.
Keywords:
Crash, Hospital, Night, Rain
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3567319
Longitude:
-71.1859798
Location:
Case
number:
Date:
2019-11-07
Time:
18:06
Address:
326 FULLER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The OP. of MV#1 states while travelling eastbound on Fuller Street near #326, the curb suddenly extended out without warning. She struck the curb and sustained two flat tires and unknown axle damage. The OP. of MV#1 states there are no signs or reflective painting to show motorists that the curb has extended out into the roadway. This and the rain was the contributing factor to her accident. She states she will file a complaint with Newton City Hall about this.
Keywords:
Crash, Rain
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3360988
Longitude:
-71.2354486
Location:
Case
number:
Date:
2020-10-13
Time:
12:15
Address:
697 WASHINGTON STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday October 13, 2020 at approx 1323 hours I went to the area of Anthony Rd at Anthony Cir for a report of a past hit/run that occurred at approx. 1215 hours in the westbound lane of 697 Washington Street. Upon arrival I met the operator of v1 Ms. OLGA KHOLODENKO, she stated she was traveling westbound in the left lane of Washington Street around the Whole foods area which is 697 Washington Street. She stated while traveling a red truck with a red trailer was on her right side traveling along side her, and while traveling the trailer had "swung" into her passenger side of her vehicle. She stated the truck/trailer kept traveling and she followed the trailer and took pictures while driving. She then went home and called her insurance company with the picture of the registration plate and they gave her the information which brought them at Anthony Rd at Anthony Cir, where the registered owner lived. The truck / trailer was not at the location. The trailer is MA trailer reg # C39390 a 2013 Brav trailer color red registered to CIRO CARBONE AND SONS INC 12 ANTHONY CIR NEWTON MA. Her vehicle is a 2020 Kia utility color white MA reg. 6ZG351. I observed some red transferred paint on her passenger side from the rear door to the front door. I advised them of process and I would look into the trailer. I was able to find the truck/trailer on California St at Dalby Street. I looked around the trailer and observed a minor scratch on the driver side of the trailer near the front of the trailer. I contacted the owner who due to the heavy rain all day sent home his employees. I will update oper 2 statement when I talk to him. At this time it appears with the trailer scratch being minor a reasonable person would have not known. Update: Monday October 19, 2020 I spoke with the oper of v2 via phone, he stated he was on Washington Street near Whole Foods traveling westbound with the truck/trailer. He stated he was traveling in the right travel lane. He stated the truck/ trailer was always in the proper slow lane and didn't know about the contact until I notified him. I advised him of the crash process.
Keywords:
Crash, Phone, Pictures, Rain
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3529253
Longitude:
-71.2021966
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);