crash_reports
1 row where "datetime" is on date 2019-01-03 and street1 = "NORTH CENTRE STREET"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date)
Case
number:
Date:
2019-01-03
Time:
18:53
Address:
CENTRE STREET & WASHINGTON STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
On 01/03/2019, while assigned to N494, I, Officer Conary was on a call for a DMV at 400 Centre Street ( Washington Street side) when I was flagged down by MV1. I approached MV1 and the operator stated that he was just hit by a blue Subaru that continued East on Washington Street toward Boston. At this time, I notified dispatch and N491 searched the area for MV2. Operator of MV1 stated that he was driving in the rotary traveling Eastbound when MV2 entered the rotary off Centre St and entered his lane hitting MV1 on the side. MV1 stated the MV2 continued to drive off. There was minor damage to MV1 rear right bumper. Operator and passenger were offered and declined medical attention. N491 checked the area with negative results. MV1 was able to be driven from scene. I had the far right lane closed for the DMV at the time of the mva. No further incident to report.
Keywords:
[]
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3557988
Longitude:
-71.1865324
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);