crash_reports
2 rows where date = "2021-11-13"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-13
Time:
11:12
Address:
5 CHARLESBANK RD
Speed
limit:
30
Violation
cited:
no
Narrative:
MV 1 was traveling west on Charlesbank Rd. MV 2 was parked in a parking lot off the road in front of 5 Charlesbank Rd. As MV 1 approached the driveway of 5 Charlesbank Rd. MV 2 pulled out of the parking lot cutting in front of MV 1. MV1 crashed into MV 2. MV 1 sustained damage to its front end but was able to drive away from the scene. MV 2 sustained damage to its dirver side front end that disabled the vehicle. MV 2 was towed from the scene by Tody's. There were no injuries reported.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3583317
Longitude:
-71.1762055
Location:
Case
number:
Date:
2021-11-13
Time:
22:11
Address:
BEACON ST & HAMMOND POND PKWY
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was stopped facing Westbound on Beacon St. at the red light when MV2 struck her vehicle. Operator of MV1 stated once her vehicle was struck by MV2, her vehicle spun around and came to a stop facing Northbound on Beacon St. Operator of MV2 stated he was traveling Northbound on Hammond Pond Parkway and attempted to take a left turn to travel Westbound on Beacon St, however lost control of his vehicle and collided with MV1.It should be noted based on my preliminary investigation roadside with each operator on scene, it appears the operator of MV2 veered off the roadway and left his lane of travel colliding with MV1. Operator of MV1 signed a patient refusal on scene for neck pain. No injuries reported from the operator of MV2. MV1 sustained heavy left and front end damage. MV2 sustained front windshield damage along with heavy front end damage. Both vehicles were towed on scene by Tody's towing. A towed motor vehicle form was filled out for both vehicles and placed on file.
Keywords:
[]
Dcc:
Improper turn, Lane departure
Report
url:
Image
url:
Latitude:
42.3321327
Longitude:
-71.1812114
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);