crash_reports
2 rows where dcc = "["Visibility obstructed", "Inattention"]", keywords contains "Moderate" and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-11-20
Time:
13:16
Address:
HOVEY ST & WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 WAS TRAVELING WEST ON WASHINGTON STREET APPROACHING THE RED LIGHT AT CHURCH STREET WHEN HIS VEHICLE WAS STRUCK BY MV 2 WHO WAS TURNING LEFT OUT OF HOVEY STREET ONTO WASHINGTON STREET (EASTBOUND) . MV 1 HAD FRONT END DAMAGE BY THE RIGHT FROM TIRE, NO INJURIES WERE REPORTED AND MV WAS TOWED FROM THE SCENE BY TODYS. OPERATOR OF MV 2 STATED THAT HE WAS ON HOVEY STREET BY WASHINGTON ST, STOPPED AT THE STOP SIGN. A TRUCK WAS IN THE CLOSEST TRAVEL LANE TO HIM AND WAIVED HIM ON TO TURN LEFT. AS MV 2 TURNED LEFT HE COULD NOT SEE MV 1 TRAVELING IN THE OUTER MOST LANE, AND HIS VEHICLE STRUCK MV 1 ON THE PASSENGER FRONT SIDE. MV 2 HAD MODERATE FRONT END DAMAGE AND NO INJURIES REPORTED.
Keywords:
Moderate
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3560067
Longitude:
-71.1898424
Location:
Case
number:
Date:
2022-04-02
Time:
18:55
Address:
COLLEGE RD & COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 stated he was traveling Eastbound on Commonwealth Ave. when MV2 turned left from College Rd. and collided with his vehicle. Operator of MV1 further stated he attempted to swerve out of the way from impact, however did not have time. Operator of MV2 stated he stopped at the stop sign on College Rd. facing Northbound and attempted to turn left to go Westbound on Commonwealth Ave. Operator of MV2 further stated as he was turning left, the sun was in his eyes which obstructed his view and collided with MV1. No injuries. MV1 sustained heavy drivers side damage including the left front fender. MV2 sustained heavy drivers side door damage and moderate drivers side passenger door damage. MV2 drivers window was broken. Tody's towing responded and towed both vehicles involved. A towed motor vehicle form was filled out for both and placed on file.
Keywords:
Crash, Moderate, Solar
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3371845
Longitude:
-71.1722129
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);