crash_reports
2 rows where date = "2022-06-18" and "retrieved" is on date 2022-06-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-06-18
Time:
17:07
Address:
33 AUSTIN ST
Speed
limit:
15
Violation
cited:
no
Narrative:
MV1 (MA Reg TRMII) was parked in the parking lot of 33 Austin St. facing Westbound when it was struck by an unknown vehicle (MV2) between 1500 and 1530 hrs. No information was left by MV2. MV1 sustained minor damage to the right rear door. MV1 was driven safely from the scene. No vehicle was towed due to this accident, there were no injuries and no witnesses at this time.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3498004
Longitude:
-71.2087985
Location:
Case
number:
Date:
2022-06-18
Time:
21:06
Address:
CENTRE STREET & GARDEN STREET
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 06/18/2022, while assigned to N494, I, Officer Conary, and Officer Sohn (N492), responded to an MVA at Centre Street at Garden Street. Upon arrival, I met with Operator of MV1 who explained to me that they were traveling Northbound on Centre Street, when a truck in front of them began to slow down in traffic. Operator of MV1 said that they began to slow down too and then was struck in the rear by MV2. Operator of MV1's dog, that was in the back seat, jumped out of the car and ran down the street. Operator of MV1 was able to get the dog and claimed that it was hit by the car. I observed the dog and it was energetic and was moving around without visible issues. I spoke to Operator of MV2 who explained to me that they were traveling Northbound on Centre Street when MV1 stopped in front of them. Operator of MV2 was unable to stop in time. They did not know whether or not they hit a dog during the accident. MV1 was unregistered and non renewable. Operator of MV1 was handed MA Citation T2014292. Both vehicles were towed from scene. There is damage to MV1 rear, and MV2 front end. A MV inventory form was completed for MV1. Both operators signed patient refusals. I advised Operator of MV1 to bring their dog to the vet.
Keywords:
Citation, Crash
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3456852
Longitude:
-71.2484271
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);