home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Lane departure", "Inattention"]", intersection = 0 and keywords contains "Hospital"

✎ 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:
2100000320
Date:
2021-05-07
Time:
12:45
Address:
497 CENTRE ST
Speed limit:
25
Violation cited:
yes
Narrative:
On Friday, May 7, 2021, while assigned to Traffic unit N525, I responded to the area of Colby Road for a report of a 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. I spoke with Mr. Michael Sanford from the City of Newton Water Department. Mr. Sanford stated his City of Newton owned vehicle (2013 Ford F-250 (MA MVN: M88493) was parked unoccupied (S) in front of 497 Centre Street, Newton. Mr. Sanford stated his emergency lights were on while he was marking out a service. Mr. Sanford stated he then observed a white 2005 Ford Ecowagon (MA CON: L61558) travel past his vehicle South on Centre Street and make contact with his driver side door mirror. Mr. Sanford stated the vehicle continued down Centre Street and he followed it to Rochester Road where is came to a stop. I observed damage to the driver door mirror. I spoke with the operator of MV2, Ms. Jerrie Spencer (S12241050). Ms. Spencer stated she knew she made contact with MV1's driver door mirror, but was trying to make it to her appointment at the Faulkner Hospital and that is why she did not immediately pull over. I observed damage to the front passenger side door mirror. Ms. Spencer was provided with Massachusetts Uniform Citation 994181AA for Chapter 89, Section 4A (Marked Lanes Violation). Centre Street is a public way maintained by the City of Newton. Photos were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Citation, Crash, Hospital, Pictures, Solar
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3538928
Longitude:
-71.1867646
Location:
497 Centre St, Newton, MA 02458, USA
Case number:
2100000650
Date:
2021-08-31
Time:
12:39
Address:
2014 WASHINGTON ST
Speed limit:
5
Violation cited:
no
Narrative:
Operator of Motor Vehicle #1 stated that he was traveling Northbound toward the exit of the main entrance of Newton Wellesley Hospital. The operator stated that there was a truck parked in the fire lane on the right side which caused him to slightly cross over the other side of the road. The operator then stated that the road was on a bend and realized that motor vehicle #2 was approaching on the opposite side of the road and was not stopping. The operator stated that he realized that motor vehicle #2 was not going to fit and stopped the vehicle. operator of Motor Vehicle #1 stated that Motor vehicle #2 drove into his vehicle causing minor damage. Operator of Motor Vehicle #2 stated she was driving Southbound on the main entrance road of Newton Wellesley towards the Emergency entrance and realized that the rear end of the 18 wheeler was in her lane and she was trying to veer to the right to avoid the truck however was unable to. Motor vehicle # 2 sustained minor damage to the front drivers side pillar and drivers side mirror.
Keywords:
Fire, Hospital
Dcc:
Lane departure, Inattention
Report url:
report
Image url:
image
Latitude:
42.3306338
Longitude:
-71.2464373
Location:
2014 Washington St, Newton, MA 02462, 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 250.234ms