crash_reports
5 rows where "datetime" is on date 2019-05-15 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-15
Time:
09:48
Address:
400 CENTRE ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Oper #1 stated she was stopped in traffic at 400 Centre Street waiting to turn onto Park Street when she was rear ended by vehicle # 2. Vehicle # 2 stated he rear ended vehicle # 1. No tows. No injuries.
Keywords:
[]
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3559661
Longitude:
-71.18448
Location:
Case
number:
Date:
2019-05-15
Time:
12:27
Address:
35 PULSIFER ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 5-15-19 AT APPROX. 1227HRS. WHILE WORKING N492 I TOOK A REPORT FOR HIT AND RUN MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 35 PULSIFER I SPOKE TO THE OWNER OF VEHICLE #1. OWNER STATES HE WAS PARKED IN FRONT OF 35 PULSIFER AND WHEN HE RETURNED TO HIS CAR HE NOTICED A DENT ON THE LEFT FRONT FENDER. THERE WAS NOTE WITH A PHONE NUMBER ATTACHED TO HIS WINDSHIELD. WHEN HE CALLED THE NUMBER HE GOT NO RESPONSE. OWNER DOES NO KNOW WHO HIT HIS VEHICLE. OWNER WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. VEHICLE #1 HAS MINOR FRONT END BUMPER DAMAGE. OWNER TOOK PICTURES OF THE DAMAGE.
Keywords:
Crash, Phone, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3465437
Longitude:
-71.2053061
Location:
Case
number:
Date:
2019-05-15
Time:
14:55
Address:
490 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
M?V 1 was stopped in traffic when it was rear ended by M?V 2.
Keywords:
[]
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3320728
Longitude:
-71.1797817
Location:
Case
number:
Date:
2019-05-15
Time:
15:29
Address:
17 PELHAM ST
Speed
limit:
10
Violation
cited:
no
Narrative:
MV#1 was parked in the Pelham St parking lot in front of Ms Heffernan Dry Cleaner. MV#1 was struck by an unknown MV#2. Operator of MV#1 observed the damage at approximately 1520 hrs. Operator of MV#1 stated that she had parked there at approximately 1207 hrs, and did not return to her vehicle prior of 1520 hrs. A search was done for cameras facing the accident location, and none were found. No vehicles towed. No injuries occurred.
Keywords:
Crash
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.331301
Longitude:
-71.1953461
Location:
Case
number:
Date:
2019-05-15
Time:
19:49
Address:
109 ADAMS ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On 05/15/2019, while assigned to N494, I, Officer Conary, responded to a MVA at 109 Adam Street, a public way in the City of Newton. Upon arrival, I observed a utility pole broken in half, wires hanging in the street, and also a transformer on the ground. Fire and medics responded. Other police units were able to block the street from traffic. I spoke to witness, HARRIS, who stated that she was traveling Southbound on Adam Street when she saw MV1 in the wrong lane traveling toward her at a high rate of speed. HARRIS stated that MV1 then turned into the utility pole located outside of 109. MV1 took out the pole, side swiped MV2 and then hit MV3 head on. Operator of MV1 stated that he was traveling Northbound on Adam Street when he sneezed. At this point, he said his eyes were off the road and the next thing he could remember was being in the parking lot of 109 Adam Street after the accident. There was significant damage to the front of MV1 with airbag deployment. Operator of MV1 was checked out by the medics for a head injury and signed a refusal. Operator of MV1 was asked if he had consumed any alcohol or taken any medication today and he declined. Officer Spinney (N491) asked if he was willing to do a Field Sobriety Test, and he stated yes. Operator of MV1 did not show any signs of intoxication. Operator of MV2 stated that he had parked his car outside of 109 Adam Street and was sitting in the driver seat when he was hit by MV1 and also the utility pole. Operator of MV2 was able to exit his car. He was evaluated by the medics and signed a refusal. MV2 has significant damage to the right side and windshield. MV3 was parked in the lot of 109 Adam Street facing Southbound. MV1 hit MV3 head on. There was significant damage to MV3 front end. The electric meter attached to 109 Adam Street was ripped off the house. There are no signs of damage to the house to report at this time. MV1 was towed by Tody's. Eversource arrived on scene. Operator of MV1 was issued a citation for marked lanes violation. Pictures were taken of the scene and will be submitted to IT.
Keywords:
Airbag, Alcohol, Citation, Crash, Fire, Pictures, Speed
Dcc:
Wrong way
Report
url:
Image
url:
Latitude:
42.3604346
Longitude:
-71.2033917
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);