crash_reports
2 rows where dcc = "["Wrong way"]" and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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:
            
        Case
                number:
            
            
            Date:
            2020-05-26
            
            Time:
            13:19
            
            Address:
            FRANKLIN ST & WAVERLEY AVE
            
            Speed
                limit:
            30
            
            Violation
                cited:
            yes
            
            Narrative:
            Operator 1 stated he was driving northbound in the southbound lane on Waverly Ave due to construction in the northbound lane. Operator 1 stated as he approached the intersection of Franklin St he was confused on which side of the cones he should be on and crossed over the marked lanes and past the cones and subsequently drove into a 2ft X 2Ft X 8 inch deep construction hole. Operator 1 stated he sustained no injuries and was checked out by medic 3 in which he signed a patient refusal. MV1 sustained minor damage, scuffs, to the right side leather saddle bag. The northbound lane was coned off for more than a block due to a Feeney Brothers construction detail with Officer Edrehi manning the post. A backhoe, a bobcat and a generator all occupied the northbound lane that was clearly blocked off. Officer Edrehi stated that due to Feeney Brother construction detail Waverly Ave was diverted to 1 way traffic travelling northbound in the southbound lane. Officer Edrehi stated he observed Operator 1 following multiple vehicle and as he approached the intersection of Franklin St Operator 1 crossed over the marked lanes and past the cones and at a low speed fell into the construction hole. Due to the statements provided I issued Operator 1 MA Uniform Citation T1269531 for C89 S4A Marked Lanes violation (warning). Operator 1 was assisted in lifitng his motorcycle and drove off without further issues.
            
            Keywords:
            Citation, Speed
            
            Dcc:
            Wrong way
            
            Report
                url:
            
            
            Image
                url:
            
            
            Latitude:
            42.3492419
            
            Longitude:
            -71.1804564
            
            
            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);

