crash_reports
2 rows where dcc_code = "[]", keywords contains "Snow" and "retrieved" is on date 2020-12-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2020-11-01
Time:
17:35
Address:
15 ROGERS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/30/2020 owners of vehicle one and vehicle two stated they parked their car on opposite side of their residence of 15 Rogers St. Both owners of the vehicle stated they went away for the weekend. On todays date 11/01/2020 both parties returned home to notice their vehicles to be damaged. Over the weekend there was snow that needed to be removed and due to my training experience and the bright yellow paint transfer and how high the damage was to both vehicles, it is believed to be a plow. Vehicle one had significant damage to the front passenger side wheel well and passenger door. Vehicle two had a long deep scratch from the passenger side front door to the rear door. Both vehicles showed bright yellow paint transfer onto the cars.
Keywords:
Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.349483
Longitude:
-71.1746739
Location:
Case
number:
Date:
2020-12-16
Time:
23:47
Address:
80 CHARLESBANK RD
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was travelling Eastbound on Charlesbank Rd when a vehicle approaching from the opposite direction had fish tailed around the bend of the road. MV1 turned their wheel to the right to avoid the on coming vehicle. Due to the slippery road surface from an on going snow storm MV1 slid into a concrete median divider causing damage to the driver side tire in front of 86 Charlesbank Rd. The vehicle was towed from the scene by Shlager Towing. The driver of the vehicle did not want to seek medical attention. There appeared to be no damage to the median. Due to the vehicle being owned by the City of Boston photographs of the vehicle and the scene were taken and sent to the IT Bureau to be attached to this crash report.
Keywords:
Crash, Pictures, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3585654
Longitude:
-71.1797224
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);