crash_reports
2 rows where date = "2021-07-01", "datetime" is on date 2021-07-01 and "retrieved" is on date 2021-07-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
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:
Image
url:
Latitude:
42.3549582
Longitude:
-71.1952442
Location:
Case
number:
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:
Image
url:
Latitude:
42.3396949
Longitude:
-71.2397808
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);