crash_reports
3 rows where "datetime" is on date 2019-01-20, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: hit_run, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-01-20
Time:
01:33
Address:
282 WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 01/20/2019, while assigned to N492, I, Officer Conary, responded to 282 Watertown Street, for a report of a past hit and run. Upon arrival, I was met by SILVA, Jordana, who explained to me that the car was parked out front at approximately 2130 hours and when she went outside she saw the damage to the left side. MV1 was parked westbound on Watertown Street on the side of the road. There was damage to the left front side panel. The car was not towed at this time but SILVA was advised to call if needed. No further incident to report at this time.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3610851
Longitude:
-71.1979732
Location:
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:
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);