home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

1 row where "datetime" is on date 2019-01-03 and keywords contains "Ems"

✎ 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

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 325.801ms