home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where keywords contains "Crash" and "retrieved" is on date 2021-02-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
2100000128
Date:
2021-02-17
Time:
09:43
Address:
CENTRE ST & BOYLSTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On Wednesday February 17th, 2021 I responded to the intersection of Boylston Street and Centre Street for a motor vehicle accident involving a city vehicle. At the time of the accident the weather was sunny and the road conditions were dry. Boylston Street and Centre Street are both public ways in the city of Newton. Upon arrival I was met with Sgt. Dempsey who was working a paid city of newton detail at the intersection. Sgt. Dempsey stated the DPW workers were set up in the intersection and a motor vehicle in traffic struck the drivers side corner of the trailer that was parked causing minor damage. No one was operating the trailer at the time of the accident. (cid:31)(cid:31)(cid:31)The operator of the MV involved was identified as Elizabeth Schmidt Scheuber (NHL13233764). She stated she was attempting to go around the trailer and struck the back corner with her vehicle causing moderate damage to her vehicle, NH REG 4199866. The vehicle sustained a flat front passenger tire and passenger side panel damage. Pictures of both vehicles were taken and submitted to the IT Bureau. Elizabeth reported no injuries and was escorted to her appointment which was a block away. Elizabeth parked the vehicle in a valid parking spot and will make arraignments with her son who is also the owner of the vehicle.
Keywords:
Crash, Moderate, Pictures, Solar
Dcc:
Unknown
Report url:
report
Image url:
image
Latitude:
42.3196217
Longitude:
-71.2064795
Location:
Boylston St & Centre St, Newton, MA 02461, USA
Case number:
2100000135
Date:
2021-02-19
Time:
20:39
Address:
EAST SIDE PKWY & NEWTONVILLE AVE
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling westbound on Newtonville Ave, approaching the left onto East Side Pkwy. As he was making a slight left onto East Side Pkwy his MV slid up onto the curb and struck the East Side Pkwy and Newtonville Ave street sign. The MV went up onto the snow embankment. Due to the MV being stuck on the embankment, I requested Tody's. MV1 had damage to the front bumper. The medal street sign was also under the vehicle. Unknown of the damage under neath the vehicle. The operator of MV1 was not injured. A City Of Newton Street sign was damaged due to the accident. Photos were taken and will be added to the report.
Keywords:
Crash, Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3526188
Longitude:
-71.1975363
Location:
East Side Pkwy & Newtonville Ave, Newton, MA 02458, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 1038.866ms