crash_reports
2 rows where "datetime" is on date 2019-10-25, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-10-25
Time:
14:43
Address:
1321 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
The operator of MV1 (MA: 249AB2) stated he was operating his vehicle Westbound through the parking lot behind 1321 Washington Street, Newton. The operator stated he was attempting to pull over to the right side of the roadway to allow a vehicle traveling Eastbound through the parking lot by him. In doing so, MV1's passenger side door area made contact with the front crash guard of Newton Police cruiser N506 ( MA MVN: MP506B). I observed minor damage to the passenger side door area of MV1 and minor damage to the front crash guard of MV2. No injuries reported. Photos were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3494467
Longitude:
-71.2276058
Location:
Case
number:
Date:
2019-10-25
Time:
18:47
Address:
574 AUBURN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On October 25, 2019 at approx. 1847 hours, I responded to 574 Auburn St for a report of a MVA. Upon arrival, I spoke with MV1 operator who stated he was travelling Westbound on Auburn St when his vehicles front axle suddenly broke causing the vehicle's front right wheel to turn outboard thus causing the MV to drive right. MV1 then collided with MV2 which was parked outside of 574 Auburn St. MV1 was towed by AAA. No injuries reported. Around 2130 hours, Mike Woods called the police station to receive information regarding the crash and MV2. He was updated and informed me that he would also be calling AAA for his vehicle.
Keywords:
Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3435858
Longitude:
-71.257393
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);