crash_reports
1 row where "date" is on date 2019-04-12 and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-12
Time:
22:26
Address:
WASHINGTON ST & CENTRE ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Friday 4/12/2019 at approx 2226hrs, while assigned N-494, I responded to the intersection of Washington St and Centre St (public way)for a 2 vehicle MVA. Upon arrival all parties stated they were uninjured. Operator of MV1 stated that he was in the Left Turn Only lane onto Washington St. He immediately stopped when he noticed a car to his left collide with his trailer. Operator of MV2 states that he was also in the Left Turn Only lane onto Washington St. and that MV1 came over from Left Turn/Straight lane on his right. Given that both operators stated that their vehicles had not been moved from where the collision occurred it is evident that MV2 was in the Left Turn Only lane onto I-90 and attempted to change lanes. It should be noted that the crash diagram is accurate to what I observed on scene. Operator of MV2 was cited for marked lanes MGL c89s 4C citation #T1268551 No damage visible to MV1. MV2 had passenger side paint damage.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
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);