crash_reports
3 rows where "datetime" is on date 2019-01-20 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-20
Time:
08:19
Address:
82 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to the area of 82 Charlesbank Rd for a report of a DMV. Upon arrival on scene I met with the operator of vehicle one Mr. Frank. He stated he was traveling south on St. James and turning right onto Charlesbank Rd. He further stated as he turned right the vehicle was uncontrollable and continued straight due to the decline and icy roadway and struck the island curb on Charlesbank Rd. Due to the heavy damage to the left side and front the vehicle was towed by Tody's towing of 1354 Washington Street 617-527-0013. Tody's towing arrived on scene and towed the vehicle to their tow lot. I transported Mr. Frank to his residence.
Keywords:
Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.358498
Longitude:
-71.1798723
Location:
Case
number:
Date:
2019-01-20
Time:
09:55
Address:
503 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to 503 Watertown Street for report of a mva hit/run with property damage. Upon arrival I met with the owner of 503 Watertown Street Ms. Antonietta Tempesta she stated through he daughter in law Ms. Tiz Acuri at approx. 0830 hours she noticed fresh tire impressions on the roadway leading onto the sidewalk and into her fence that was damaged. She also stated the MA registration plate # 5DT664 was on the fence. I ran the the plate which came back to a 2003 Ford pickup color white to Kyle Butler of 84 Auburndale Ave Newton MA. Officer Boyle in unit 493 went to the residence and spoke with Kyle's uncle to call NPD. I advised Ms. Acuri of the process. Mr. Butler called NPD I spoke with him on the phone. He stated he was driving west on Watertown Street and due to the icy roadway his truck slid to the right onto the sidewalk and into what he thought was a snow bank. I gave all parties each others information and advised them. I gave the uncle Kyles reg plate.
Keywords:
Ice, Phone, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3578253
Longitude:
-71.2059094
Location:
Case
number:
Date:
2019-01-20
Time:
14:00
Address:
ST JAMES ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date/time I responded to Washington Street at St. James for a two motor vehicle crash. Upon arrival with the operator of vehicle one stated he was stopped at the red traffic signal and was struck from behind. I spoke with the operator of vehicle two who stated that she was traveling on Washington Street she applied her brakes to slow for the red traffic signal. She stated when she applied her brakes due to the decline icy roadway her vehicle slid into vehicle one. Passenger in vehicle two stated the same as operator two. Due to the damage on vehicle two was towed by Tody's towing of 1354 Washington Street 617-527-0013 to their tow lot. No injuries all parties advised.
Keywords:
Crash, Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3566437
Longitude:
-71.1820463
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);