crash_reports
2 rows where intersection = 0, keywords contains "Moderate" and "retrieved" is on date 2021-05-24
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-05-17
Time:
21:39
Address:
82 HOMER ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
Operator 1 of MV 1 was traveling EB on Homer St. Operator 1 crossed the double yellow line, across the roadway and struck parked MV2. Upon further investigation (see incident #21021174) operator 1 was charged with c90s24 OUI Liquor, c90s24 Negligent Operation of a MV and c89s4A Marked Lanes Violation. Operator 1 was transported to the NWH for his minor injuries. MA Citation T2012681 to be mailed to Operator 1. Major damage to MV1 and was towed by todys towing. MV2 was parked on the side of the road at 85 Homer St when MV1 collided with the front of MV2. Moderate damage to MV2. MV2 was towed by Todys towing.
Keywords:
Citation, Moderate
Dcc:
Reckless driving, Other improper action
Report
url:
Image
url:
Latitude:
42.3353343
Longitude:
-71.1968129
Location:
Case
number:
Date:
2021-05-20
Time:
18:32
Address:
140 BRANDEIS RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator 1 of MV 1 was pulling out of the parking lot of 140 Brandeis Rd attempting to take a left (w/b ). Operator1 looked right (e/b) and a vehicle let her out of the lot. As Operator1 was pulling out of the lot MV2 collided with the front of her vehicle. Moderate damage to MV1, towed by todys. No injuries to Operator1. Operator 2 of MV 2 was traveling e/b on Brandeis rd by #140. Operator 2 said he saw a vehicle pull out of the lot to take a left and could not stop in time. Operator 2 believes that operator 1 only looked right and did not look left as they were pulling out of the parking lot. Minor damage to MV2. No injuries to operator 2.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3135234
Longitude:
-71.1865424
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);