crash_reports
2 rows where date = "2021-01-25" 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:
07:30
Address:
297 DERBY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated he was sitting in his parked vehicle when MV2 struck the rear driver side of his vehicle. Operator of MV2 stated she was traveling eastbound on Derby St. when she struck the rear of MV1 with the passenger side of her vehicle. Operator of MV2 stated the glare from the sun played a part in the accident. All operators refused medical treatment. MV1 sustained major damage to the rear, driver side bumper. MV2 sustained major damage to the front passenger side bumper. Operator of MV2 stated she will call for a private tow, MV2 was operable and moved to a legal parking spot. MV1 was parked legally on Derby Street.
Keywords:
Crash, Glare, Solar
Dcc:
Glare, Inattention
Report
url:
Image
url:
Latitude:
42.3607095
Longitude:
-71.2358895
Location:
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);