home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2021-07-01 and "retrieved" is on date 2021-07-04

✎ 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:
2100000482
Date:
2021-07-01
Time:
18:19
Address:
JACKSON RD & WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
On 7/1/2021, at 1830 hrs, I spoke with REGAN, AMY in the lobby of NPD HQ regarding a past motor vehicle hit and run accident. Ms. Regan reports; at 1800 hrs this afternoon, she was traveling eastbound on Washington St. and was yielding to oncoming traffic as she attempted to turn northbound onto Jackson Rd. when her Honda CR-V was struck from behind by a construction Front Loader. The operator, described as a thin, white male, with a beard, grey hat and Irish accent, motioned for Ms. Regan to pull over onto Jackson Rd. which she assumed was to exchange information. As Ms. Regan pulled onto Jackson Rd. the operator of the Front Loader continued eastbound on Washington St. towards the Massachusetts Turn Pike rotary. I observed damage to the rear bumper and tailgate of Ms. Regan's Honda CR-V, but the vehicle is operable. I provided Ms. Regan a report number and instructions on how to obtain a copy of this report.
Keywords:
Crash
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.3549582
Longitude:
-71.1952442
Location:
Jackson Rd & Washington St, Newton, MA 02458, USA
Case number:
2100000483
Date:
2021-07-01
Time:
20:15
Address:
WASHINGTON ST & HOPE ST
Speed limit:
35
Violation cited:
no
Narrative:
MV1 operator stated he was fully stopped in the right lane of Washington St (public way) at Hope St. MV1 operator said he then attempted to make a U-turn from the right lane onto Washington St westbound. MV1 operator stated he did not observe MV2 in the left lane of Washington St eastbound and struck MV2's passenger side with the front end and driver side of MV1. MV1 operator stated he and none of his passengers were injured at this time. MV1 sustained minor front end and driver side damage, no tow required. MV2 operator said he was traveling on Washington St eastbound in the left lane. MV2 operator stated he saw MV1 attempt a U-turn from the right lane of Washington St eastbound to the westbound side. MV2 operator said he did not have time to stop. MV2 operator stated he was not injured at this time. MV2 sustained passenger side damage, no tow required.
Keywords:
[]
Dcc:
Improper turn
Report url:
report
Image url:
image
Latitude:
42.3396949
Longitude:
-71.2397808
Location:
Hope St & Washington St, Newton, MA 02466, 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 2163.67ms