home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-01-03 and keywords contains "Moderate"

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000008
Date:
2019-01-03
Time:
07:26
Address:
BOYLSTON ST & ELLIS ST
Speed limit:
25
Violation cited:
yes
Narrative:
On 01/03/19 at 07:26 hours, I responded to a two car motor vehicle accident at Boylston Street and Ellis Street with one reported minor injury (headache). Operator of MV # 1 states she was exiting the Boylston Street (RT 9EB) off ramp at Ellis Street when she states that she came to a stop for the stop sign. She then inched out and thought it was clear to proceed straight through and struck MV # 2 on both passenger side doors. Operator also stated that she did not think traffic would be allowed to come from the left of her. She was advised that there is a sign below the stop sign that states that the oncoming traffic does not stop. Operator was issued MA Uniform Citation T1441046 for Ch. 89/9 Stop Sign Violation. MV # 1 sustained front end damage to the entire front but was still driveable and the operator reported no injuries. Operator of MV # 2 states she was operating straight through the Boylston Street overpass (SB) on to Ellis Street when she states that MV # 1 never stopped for the stop sign. MV # 1 then proceeded out and struck her vehicle on the passenger side. MV # 2 sustained moderate damage to both passenger side doors and was towed by Tody's towing. The operator complained of a headache but signed a patient refusal with Cataldo Ambulance One.
Keywords:
Citation, Crash, Ems, Moderate
Dcc:
Signs/Signals
Report url:
report
Image url:
image
Latitude:
42.3167943
Longitude:
-71.2269407
Location:
Ellis St & Boylston St, Newton, MA 02464, USA
Case number:
1900000013
Date:
2019-01-03
Time:
18:15
Address:
CHESTNUT TER & COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling westbound on Commonwealth Ave. when MV2 pulled onto Commonwealth Ave from Chestnut Terrace onto Comm. Ave. As MV2 was pulling onto Comm. Ave the vehicle struck the driver side front and rear door. The Operator of MV2 stated she was taking a right onto Comm. Ave from Chestnut Terrace and hit MV1 with the front driver side bumper. MV1 had moderate damage to the driver side front and rear door. MV2 had minor damage to the driver side front bumper. Both operators and passengers did not suffer any injuries and both vehicles did not need to be towed. Operator of MV2 was cited for Ch. 90/10 Unlicensed Operation (T1440967), see incident #19000357. The owner of MV2 arrived on scene and drove the vehicle home.
Keywords:
Citation, Moderate
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3361982
Longitude:
-71.1899502
Location:
Commonwealth Avenue & Chestnut Terrace, Newton, MA 02459, 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 344.923ms