crash_reports
2 rows where dcc contains "Visibility obstructed" and latitude = "42.3560067"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-05-05
Time:
16:09
Address:
WASHINGTON ST & HOVEY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of V1 stated he was attempting to turn left off of Hovey Street on to Washington Street (Eastbound) . Opr of V1 states the first lane of travel let him start to turn. As he started to make the turn and look to see if the next westbound lane would stop, he made contact with V2. Opr stated he was not injured. V1 was not towed. Opr of V2 stated he was traveling on Washington Street (Westbound). Opr stated at this time a red vehicle was turning off a side street and made contact with him. Opr stated him and his son were not injured. V2 was not towed.
Keywords:
[]
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3560067
Longitude:
-71.1898424
Location:
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:
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);