crash_reports
2 rows where "datetime" is on date 2021-09-13, intersection = 0 and keywords contains "Crash"
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-13
Time:
17:32
Address:
225 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
On September 13, 2021 at approximately 17:32 hours I responded to the parking lot of Bloomingdales, 225 Boylston St for a report of a hit and run. I spoke with the operator of MV1 who said that she was traveling northbound on the parking lot roadway off of Boylston St by Bloomingdales Men's Store. MV1 was stopped at the stop sign when she observed what she believes to be a newer Mercedes SUV turn right onto the roadway and crash into the rear of her vehicle. MV1 exited her vehicle to try and get the driver's attention but the operator continued driving away. The operator of MV1 said that an MBTA bus was at the bus stop and saw the incident but was gone on my arrival. I was unable to locate any cameras in the area facing the crash location.
Keywords:
Bus, Crash
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3213504
Longitude:
-71.177129
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);