crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-01-28
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-01-25
Time:
12:58
Address:
COMMONWEALTH AVE & AUBURN ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV#1 stated that she was traveling north on Commonwealth Ave and as she traveled through the green light at the intersection at Auburn St she observed MV#2 traveling towards her from Auburn St and then struck her MV pushing it into a utility pole. The operator of MV#2 stated that he was traveling east on Auburn St and as he approached the intersection of Commonwealth Ave thought he had a green light and traveled into the intersection when crash occurred with MV#1. Two independent witnesses both stated to me that MV#2 traveled through a red light on Auburn St causing the crash. Both MV's towed from the scene and operator #1 transported to NWH with what appeared to be a minor leg injury. Operator #2 refused medical attention at the scene for what appeared to be a minor hand injury. Operator #2 cited for failure to comply with a red light.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3445236
Longitude:
-71.2586295
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);