crash_reports
3 rows where date = "2019-05-05" and violation_cited = 0
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-05
Time:
05:18
Address:
23 NAHANTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was travelling southbound on Nahanton St. The operator of vehicle 1 lost control to the vehicle, due to the wet road conditions, and struck the telephone pole (#6/4) in front of 23 Nahanton St. There was no damage to the telephone pole. There was moderate damage to the front of vehicle 1. I observed air bag deployment to the front and passenger side of the vehicle. No one was injured, and the vehicle was towed by Tody's to their lot.
Keywords:
Moderate
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3003054
Longitude:
-71.1890156
Location:
Case
number:
Date:
2019-05-05
Time:
16:09
Address:
WASHINGTON ST & HOVEY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of V1 stated he was attempting to turn left off of Hovey Street on to Washington Street (Eastbound) . Opr of V1 states the first lane of travel let him start to turn. As he started to make the turn and look to see if the next westbound lane would stop, he made contact with V2. Opr stated he was not injured. V1 was not towed. Opr of V2 stated he was traveling on Washington Street (Westbound). Opr stated at this time a red vehicle was turning off a side street and made contact with him. Opr stated him and his son were not injured. V2 was not towed.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3560067
Longitude:
-71.1898424
Location:
Case
number:
Date:
2019-05-05
Time:
21:05
Address:
BEACON ST & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was travelling WB on Beacon St when MV2 cut across his lane of travel causing him to strike the passenger side of MV2. MV2 was attempting to turn NB onto Walnut St from Beacon when he was struck by MV1. Operator 2 states he believed he had enough time to make it across the intersection and believes MV1 was speeding. Operator 1 states he was operating at the speed limit (30MPH) and MV2 cut in front of him. Both parties had the green light at the intersection. No injuries reported by any party. Parent of operator 2 signed a patient refusal based upon the operators age. Both vehicles were towed due to air bag deployment. MV1 sustained minor damage to the front end. MV2 sustained moderate damage to the passenger side.
Keywords:
Moderate, Speed
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
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);