crash_reports
2 rows where dcc = "["Speeding", "Reckless driving"]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-04-23
Time:
16:23
Address:
23 EVERGREEN AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
The OP. of MV#1 was unable to give me a statement due to a possible head injury. He kept repeating "where's my car" and "what happened?" Witness#1 (Mr. Regan) states he was travelling westbound on Auburn St. when MV#1 went to the oncoming traffic lane and passed him on the left at a high rate of speed. He estimates the speed at 70mph. He saw MV#1 hit the speed bump on Auburn St., possibly losing control, and then onto Evergreen Ave. with a large cloud of dust. Witness#2(Mr. Weishaus) was on his balcony and observed MV#1 travel at a high speed of rate on Auburn St. He estimates the speed at 100mph. He observed MV#1 go up Evergreen Ave., launch into the air and crashed. Witness#3(Mr. Litvak) states he was on his porch and heard a loud sound of a motor engine approaching. MV#1 then crashed into his retainer wall and flew through some trees before landing on his neighbor's yard. Based on witness statements and the accident scene, it appears that MV#1 went off the roadway and struck a retainer wall at #15 Evergreen Ave, launched into the air and struck parked MV#2 in the process, went through some trees that flipped the car around before landing on the property of #23 Evergreen Ave. The OP. of MV#1 was ejected from the vehicle at some point in time. Pictures were taken of the accident scene.
Keywords:
Crash, Pictures, Speed, Tree
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.3439816
Longitude:
-71.2586746
Location:
Case
number:
Date:
2020-06-11
Time:
20:59
Address:
92 NORTH ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Thursday, June 11th 2020, at approximately 9pm, I, Officer Brooks, responded to 92 North street for a report of a car into a utility pole. Upon my arrival I observed MV1(MA REG 1HRN55) on the side of the road with heavy damage to the majority of the vehicle. I spoke with the operator who stated that he was traveling northbound on North street when his steering wheel stopped functioning as he approached a bend in the road. The operator stated he left the roadway striking a utility pole, and rolling his car at least 3 times. The operator was complaining of leg pain and dizziness and was transported to NWH by Cataldo for further evaluation. MV1 was towed by Tody's and an inventory form was filed. Eversource was notified for significant damage to the utility pole. Pictures were taken and submitted to the IT bureau.
Keywords:
Pictures
Dcc:
Speeding, Reckless driving
Report
url:
Image
url:
Latitude:
42.362283
Longitude:
-71.217976
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);