crash_reports
2 rows where intersection = 0, keywords contains "Pictures" and "retrieved" is on date 2021-09-17
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-13
Time:
16:59
Address:
885 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 09/13/2021, while assigned to N494, I, Officer Conary, and Officer Kane (N492), responded to 885 Centre Street for a report of a single motor vehicle accident with airbag deployment. Upon arrival, I observed MV1 up on the curb with significant damage to the front and front right side. Operator of MV1 explained to me that he just got out of work and was driving Northbound on Centre Street when he fell asleep. Next thing he knew he was off the roadway. He explained to me that he had an early morning at work, and this hasn't happened before. Medics arrived on scene and he signed a patient refusal. Tody's towed MV1. The City of Newton was notified because the crosswalk sign was taken down during the accident. There was also damage to a City tree. Pictures were taken and submitted to IT to be uploaded accordingly.
Keywords:
Airbag, Crash, Crosswalk, Pictures, Tree
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3433232
Longitude:
-71.1938657
Location:
Case
number:
Date:
2021-09-14
Time:
10:48
Address:
82 LINCOLN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday, September 14, 2021, while assigned to Traffic unit N525, I responded to 82 Lincoln Street, Newton for a report of a motor vehicle crash involving a City of Newton owned vehicle. The weather at the time of the crash was clear and sunny. The road surface was dry. Lincoln Street is a public way maintained by the City of Newton. The operator of MV1, Maureen Doucette, stated she was operating a City of Newton owned 2015 Ford Focus (MA MVN: MP1308) on Lincoln Street (E). Ms. Doucette was operating this vehicle in her official capacity of a Newton Parking Control Officer. Ms. Doucette stated as she was traveling past 82 Lincoln Street, MV2 attempted to exit their parking spot on the right side of the road and merge into MV1's travel lane. MV2's front driver side bumper/fender area crashed into the middle passenger side of MV2. The operator of MV1 reported no injuries. The operator of MV2, Nancy Greenwald, stated her 2012 Honda Accord (MA: 2EGT90) was parked in a parking spot in front of 82 Lincoln Street. Ms. Greenwald stated while operating her vehicle she attempted to merge onto Lincoln Street (E) from her parking spot. Ms. Greenwald stated as she made her left turn into traffic, the front driver side of her vehicle crashed into the passenger side of MV2 as it passed by. Ms. Greenwald reported no injuries. I observed minor damage to the front driver side bumper/fender area. Photos were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Crash, Pictures, Solar
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3206985
Longitude:
-71.2092278
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);