crash_reports
3 rows where "datetime" is on date 2019-01-21 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: intersection, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-01-21
Time:
03:05
Address:
17 CHARLES RIVER TER
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/21/19 I was working N498 when I responded to 17 Charles River Ter for a report of a Cab that had struck a wall. Upon arrival I met with Pema Jigmey and Miriam Jost. Jost stated that Pema who was driving for Metro Cab (or Photo Cab) picked her up at the airport and brought her home. Once at her home 17 Charles River Ter, she asked him to back into the driveway due to the snow and ice conditions. While backing up in the driveway of 17 Charles River Ter the vehicle struck the residencet causing damage. Pema stated the same thing but believed Jost was half to blame due to the fact she asked him to be dropped in the driveway. I informed Pema that he drove the vehicle into the house and so was at fault. The house only appeared to suffer minor cosmetic damages but could not be accurately examined. Pema and Jost exchanged information in the hopes of settling the damages without insurance. Both parties were satisfied and provided a report number. Both parties stated they were uninjured and refused medical attention.
Keywords:
Ice, Pictures, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3040378
Longitude:
-71.2110958
Location:
Case
number:
Date:
2019-01-21
Time:
12:46
Address:
2000 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to the area 2000 Washington Street Newton -Wellesley - Hospital for a two motor vehicle crash on the 3rd floor of the parking garage. Upon arrival I met with the operator of vehicle one, she stated she was pulling into a parking spot and applied the brakes but due to the ice on the roadway and slope of the roadway her vehicle slid into the rear of vehicle two which was parked. Vehicle two was unoccupied, and dispatch tried to get in contact with the owner to advise them. I also left a message with NWH in case the owner comes back in. No injuries and I advised of the process. Later in the day the owner vehicle two came to NPD, I gave him vehicle one inforamtion and advised him of the process.
Keywords:
Crash, Hospital, Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3310819
Longitude:
-71.2462149
Location:
Case
number:
Date:
2019-01-21
Time:
20:12
Address:
CENTRE ST & HYDE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated he was traveling Northbound on Centre St. at the intersection of Hyde Ave. when a vehicle in front of him braked. When he stepped on his brakes to slow down, MV1 skidded on ice off to the right into the "Speed Limit 25" sign, knocking it over. Tody's responded and pulled the vehicle off of the sign and the vehicle was able to be driven from the scene safetly. No injuries were reported. Photos of the sign were submitted to the IT bureau to be attatched to this report.
Keywords:
Ice, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3497298
Longitude:
-71.1869015
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);