crash_reports
3 rows where "datetime" is on date 2019-12-02 and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-02
Time:
10:23
Address:
100 HAMMOND STREET
Speed
limit:
30
Violation
cited:
no
Narrative:
Op MV#1 was traveling north on Hammond Street when MV#1 slid in the slush and collided with a tree on the side of the road. -I observed the damage to the tree at the intersection of Hammond and Hammondswood. I observed the damage to the middle center of MV#1. I saw small wood fragments and sap in the hood, bumper and license plate of MV#1. I observed the slush on the road and on the surrounding ground. -OpMV#1 did not report injuries at the scene and declined further medical care. MV#1 was towed from the scene by Toddy's Towing . 1 photo of the damaged tree was taken by Ofc. Crowe and sent to the IT Bureau for upload.
Keywords:
Pictures, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3353334
Longitude:
-71.1772035
Location:
Case
number:
Date:
2019-12-02
Time:
16:20
Address:
853 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV 1 was traveling Westbound on Beacon St when MV 2 pulled out of the driveway of 853 Beacon St and struck his right rear side. MV 2 was traveling Southbound entering traffic from the 853 Beacon St driveway when she struck the right side of MV 1. The operator of MV 2 suffered minor back injury and was transported by Cataldo Ambulance to Newton Wellesley.
Keywords:
Ems
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3304045
Longitude:
-71.1960787
Location:
Case
number:
Date:
2019-12-02
Time:
22:24
Address:
WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 stated he was traveling Eastbound on Washington St. when MV2 turned left in front of his vehicle colliding with him. Operator of MV2 stated he was traveling in the right hand land on Washington St. traveling Eastbound when he attempted to make a U-turn to travel Westbound onto Washington St. Operator of MV2 stated he first attempted to change lanes, however collided with MV1. No injuries. MV1 sustained minor damage to the right front end. MV2 sustained moderate damage to the left front end. Todys responded and towed MV2. A towed motor vehicle form was filled out in regards and placed on file.
Keywords:
Moderate
Dcc:
Over-steering, Inattention
Report
url:
Image
url:
Latitude:
42.3498391
Longitude:
-71.2179998
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);